Re: public username on logical standby database

From: Antony Raj <>
Date: Wed, 29 Feb 2012 11:25:19 -0800 (PST)
Message-ID: <>

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 <> To:
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_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.


Received on Wed Feb 29 2012 - 13:25:19 CST

Original text of this message