RE: Oracle standby strange behavior

[Yuval Arnon]

Title: Oracle standby strange behavior

Hi,

FYI , the problem is an Oracle bug 1504967 described as Inconsistency between Dictionary Cache and Dictionary on Standby Database
See Metalink for Doc id 150222.1  for explanation how to workaround it.

 

Yuval.

-----Original Message-----
From: Vadim Gorbounov [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 2:26 PM
To: Multiple recipients of list ORACLE-L
Subject: 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

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:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 1:41 PM
To: Multiple recipients of list ORACLE-L
Subject: 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:[EMAIL PROTECTED]]
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" <[EMAIL PROTECTED]> 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 :  [EMAIL PROTECTED]
>             [EMAIL PROTECTED]
> 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: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: http://www.orafaq.com
> --
> Author: SARKAR, Samir
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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!
http://auctions.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: http://www.orafaq.com
--
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: http://www.orafaq.com
--
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).