PUBLIC USER on a physical standby database
Date: Tue, 22 May 2012 13:08:18 +0000
Message-ID: <CAEB1E9676D6974BB011E94E3836F8B403D9ECD0_at_NORIGMBCRP01.Corp.Acxiom.net>
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Robertson Lee - lerobe
Sent: 15 May 2012 12:26
To: oracle-l_at_freelists.org
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.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 22 2012 - 08:08:18 CDT