Re: public username on logical standby database
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_at_gmail.com> To: Oracle-L_at_freelists.org
Sent: Wednesday, February 29, 2012 10:32 AM Subject: public username on logical standby database
Greetings. When i query my logical standby database, i find username "public" in v$session. the schemaname is public, program is oracle_at_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.