DomainKey-Signature:a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type;
  b=RgQi0zucDG7X5icYor8tSy4vm3qRc3diOp3EMNQ8ILVoD2RcVas2ImWQ5fC0WNfyzNw5nOd8mT/j1hUs9TGqfSeux7oMiiIDuvGnsX/hJDx29r+frFt/zXulR2OZDvrKOKx9Hxk5FnyCulIH6x69IOaHOHe2zQ5lzSfccpmuELY=;
References: <CADmQEr5zuO0s-ZV690zB9h1hdRBv6YjHK1u5E0uEM_Lf6PEGMQ@mail.gmail.com>
Message-ID: <1330543519.20861.YahooMailNeo@web36807.mail.mud.yahoo.com>
Date: Wed, 29 Feb 2012 11:25:19 -0800 (PST)
From: Antony Raj <ca_raj@yahoo.com>
Subject: Re: public username on logical standby database
To: "sundarmahadevan82@gmail.com" <sundarmahadevan82@gmail.com>,
  "Oracle-L@freelists.org" <Oracle-L@freelists.org>
In-Reply-To: <CADmQEr5zuO0s-ZV690zB9h1hdRBv6YjHK1u5E0uEM_Lf6PEGMQ@mail.gmail.com>
MIME-Version: 1.0
Content-type: text/plain
Content-Transfer-Encoding: 8bit
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: ca_raj@yahoo.com

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@gmail.com>
To: Oracle-L@freelists.org 
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.


--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l