RE: Oracle standby strange behavior

From: Yuval Arnon <Yuval.Arnon_at_wwfent.com>
Date: Wed, 30 Jan 2002 11:56:26 -0800
Message-ID: <F001.00401051.20020130115252@fatcity.com>

Vadim,
Thanks
for the input but I already made sure all arc files have been transferred and applied and that an 'alter system switch logfile' was executed prior to that.

Yuval.

-----Original Message-----From: Vadim Gorbounov [mailto:vgorbounov_at_simplyengineering.com]Sent: Wednesday, January 30, 2002 2:26 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle standby strange behavior
 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

On production
SQL> alter system
switch logfile;
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 [<A
 href="mailto:sorr_at_rightnow.com">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 > > > -----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 > *********************************** > > > >
 > > 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 href="http://www.orafaq.com" target=_blank>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. > ___________________________________________________________________________ > > -- > Please see the official ORACLE-L FAQ: <A href="http://www.orafaq.com" target=_blank>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 href="http://auctions.yahoo.com" target=_blank>http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: <A href="http://www.orafaq.com" target=_blank>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 href="http://www.orafaq.com" target=_blank>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 href="http://www.orafaq.com" target=_blank>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:56:26 CST