Re: public username on logical standby database
- From: Antony Raj <ca_raj@xxxxxxxxx>
- To: "sundarmahadevan82@xxxxxxxxx" <sundarmahadevan82@xxxxxxxxx>, "Oracle-L@xxxxxxxxxxxxx" <Oracle-L@xxxxxxxxxxxxx>
- Date: Wed, 29 Feb 2012 11:25:19 -0800 (PST)
Oracle uses a PUBLIC user to ship archived redo logs.This user is authenticated
by the password in the password file (orapwXXXXX)
You can see the following line in the alert log file..
"Redo Shipping Client Connected as PUBLIC"
________________________________
From: sundar mahadevan <sundarmahadevan82@xxxxxxxxx>
To: Oracle-L@xxxxxxxxxxxxx
Sent: Wednesday, February 29, 2012 10:32 AM
Subject: public username on logical standby database
Hi Folks,
Greetings. When i query my logical standby database, i find username
"public" in v$session. the schemaname is public, program is
oracle@primaryboxname (TNS V1-V3) and status is inactive. Any ideas? I am
on 11.2 SLES 6 both primary and logical standby. Is it part of the logical
standby processes?
query: select * from v$session where username is not null and username <>
'SYS'
thanks for your help.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts: