RE: Oracle standby strange behavior

From: Vadim Gorbounov <vgorbounov_at_simplyengineering.com>
Date: Wed, 30 Jan 2002 11:29:17 -0800
Message-ID: <F001.00400F27.20020130112550@fatcity.com>

Hi, Yuval.
Did you make sure, you've got
latest data transferred and applied?
I bet, these two tables have
largest OBJECT_ID in the original DB.

Before you activate standby,
do
1. On
production
SQL> alter system
switch logfile;

2. Transfer all archived logs
to standby and make sure they are applied.
Hopefully, no more
problem.

Vadim

-----Original Message-----From: Yuval Arnon [mailto:Yuval.Arnon_at_wwfent.com]Sent: Wednesday, January 30, 2002 1:41 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle standby strange behavior
 Hi, I ran into a strange behavior of a standby database. On the primary db I have an application schema and a query schema. All tables from the appl schema have public synonyms and a grant select to public. User query is created with connect and resource roles. Once I switch over to the standby db , and put it in read only mode, and then connect to the query user, I can not perform a select against 2 of the 35 tables. I get object OBJECT_NAME does not exist.
 I can connect to the system user on the standby database and I have no problem selecting from all the tables. Any idea what am I missing??
 Yuval.
 -----Original Message----- From: Orr, Steve [mailto:sorr_at_rightnow.com]
 Sent: Wednesday, January 30, 2002 12:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: Performance Tuning Rachel IS kind but her words are also true and I think this was her main focus in this case. ;-) My Alomari book was for v7 and was good but is now dated... Is it up to date for 8i/9i?
 -----Original Message----- Sent:
 Wednesday, January 30, 2002 10:11 AM To: Multiple recipients of list ORACLE-L
 Rachel, Thank you so much for you kind words and the very interesting comparison.. :)

Kirti -----Original Message----- Sent: Wednesday, January 30, 2002 9:50 AM To: Multiple recipients of list ORACLE-L I would perhaps suggest Oracle Performance Tuning 101 instead of Rich's book (if you had to make a choice).

the 101 book conforms most closely to Oracle's current thinking on performance tuning

"SARKAR, Samir" <Samir.SARKAR_at_nottingham.sema.slb.com> wrote: > Practically, u should get two books to have a full grasp on Oracle > Performance > Tuning : > > 1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec > 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari
> > If u r in an exceptionally
high development environment where u have > lots of > SQL tuning to do, > consider buying the SQL High Performance Tuning by Don Burleson. > Otherwise, > the > above two books should suffice for both production and development > databases. > > Samir > > Samir Sarkar > Oracle DBA - Lennon Team > SchlumbergerSema > Email : samir.sarkar_at_nottingham.sema.slb.com > samir.sarkar_at_sema.co.uk > Phone : +44 (0) 115 - 957 6217 > EPABX : +44 (0) 115 - 957 6418 Ext. 76217 > Fax : +44 (0) 115 - 957 6018
> > <FONT
size=2>> -----Original Message----- > Sent: 30 January 2002 10:25 > To: Multiple recipients of list ORACLE-L > > > Hi Everyone > > I am interested in purchasing some exceptionally good book on Oracle > Performance Tuning. Can anyone suggest me some very good book on > Oracle > Tunning worth purchasing > > > Binay Kumar > Oracle Cerified DBA > > London > >
> >
- > Binay Kumar > Focus 3 -Technical Support > P & O Nedllyod > London > 0044 207 441 1648 >
- >
 > > <FONT
 size=2>>
 
 > > The contents of this e-mail
 are confidential to the ordinary user > of the e-mail address to which it was addressed and may also be > privileged. If you are not the addressee of this e-mail you should > not copy, forward, disclose or otherwise use it or any part of it > in any form whatsoever. If you have received this e-mail in error > please notify us by telephone or e-mail the sender by replying to > this message, and then delete this e-mail and other copies of it > from your computer system. Thank you.
 > > We reserve the right to
 monitor all e-mail communications through > our network. > > -- > Please see the official ORACLE-L FAQ: <A target=_blank href="http://www.orafaq.com">http://www.orafaq.com > -- > Author: > INET: BINAY.KUMAR_at_ponl.com > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists >
 > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > ___________________________________________________________________________ > This email is confidential and intended solely for the use of the > individual to whom it is addressed. Any views or opinions presented > are > solely those of the author and do not necessarily represent those of > SchlumbergerSema. > If you are not the intended recipient, be advised that you have > received this > email in error and that any use, dissemination, forwarding, printing, > or > copying of this email is strictly prohibited. > > If you have received this email in error please notify the > SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. > ___________________________________________________________________________
 > > -- <FONT
 size=2>> Please see the official ORACLE-L FAQ: <A target=_blank href="http://www.orafaq.com">http://www.orafaq.com > -- > Author: SARKAR, Samir > INET: Samir.SARKAR_at_nottingham.sema.slb.com > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists >
 > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing).
 Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! <A target=_blank href="http://auctions.yahoo.com">http://auctions.yahoo.com
 - Please see the official ORACLE-L FAQ: <A target=_blank href="http://www.orafaq.com">http://www.orafaq.com -- Author: Rachel Carmichael INET: wisernet100_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
 - Please see the official ORACLE-L FAQ: <A target=_blank href="http://www.orafaq.com">http://www.orafaq.com -- Author: Deshpande, Kirti INET: kirti.deshpande_at_verizon.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
 - Please see the official ORACLE-L FAQ: <A target=_blank href="http://www.orafaq.com">http://www.orafaq.com -- Author: Orr, Steve INET: sorr_at_rightnow.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

Received on Wed Jan 30 2002 - 13:29:17 CST