PUBLIC USER on a physical standby database

From: Robertson Lee - lerobe <>
Date: Tue, 22 May 2012 13:08:18 +0000
Message-ID: <>


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 ??



-----Original Message-----

From: [] On Behalf Of Robertson Lee - lerobe Sent: 15 May 2012 12:26
Subject: Golden Gate


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


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.


-- Received on Tue May 22 2012 - 08:08:18 CDT

Original text of this message