PUBLIC USER on a physical standby database

From: Robertson Lee - lerobe <Lee.Robertson@xxxxxxxxxx>
To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 22 May 2012 13:08:18 +0000

Hi,

Red Hat 5.6
Oracle 11gr2

Had a problem the other day with max connections exceeded on a physical 
standby. It would appear that the PUBLIC username which as far as I know ships 
the logs over to the physical standby in a DAtaGuard set up had lots of 
historical connections still sat in the database. (showing as inactive in 
v$session)....

I managed to clear by shutting down the instance and starting the managed 
recovery again.

Checked this morning and hey ho....there are 23 inactive sessions from 
yesterday. 

Any clues as to whats going on and what I can do about, I cannot find anything 
on MOS/google etc etc ??

Regards

Lee



-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Robertson Lee - lerobe
Sent: 15 May 2012 12:26
To: oracle-l@xxxxxxxxxxxxx
Subject: Golden Gate

Hi,

Anyone out there had any experience installing and configuring this. We have a 
project beginning shortly and Golden Gate is a client requirement and I have 
never touched it before. I will do some digging myself but always nice to get 
some feedback/gotchas from those who have been there done it and got the tee 
shirt so to speak !!

FYI. It will be Red Hat 5.4 and 11gR2

TIA 

Lee
***************************************************************************
The information contained in this communication is confidential, is intended 
only for the use of the recipient named above, and may be legally privileged.

If the reader of this message is not the intended recipient, you are hereby 
notified that any dissemination, distribution or copying of this communication 
is strictly prohibited.

If you have received this communication in error, please resend this 
communication to the sender and delete the original message or any copy of it 
from your computer system.

Thank You.
****************************************************************************

--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l

PUBLIC USER on a physical standby database

Other related posts: