Re: howto connect as / with sqlplus

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Wed, 07 Feb 2007 18:06:05 +0100
Message-ID: <45CA06FD.70808@arcor.de>

DA Morgan schrieb:
> Bruintje Beer wrote:

>> Hi,
>>
>> How can I logon to sqlplus using
>>
>> sqlplus /
>>
>> thanks
>>
>> John

>
> 1. Be physically on the server.
> 2. Be a member of the operating system DBA group.
> 3. In SQL*Plus, in the User Name location, type / as sysdba

I don't think, the question was about "/ as sysdba". To OP:
To connect with / you have possibilities 1) user identified globally (by means of LDAP) - no need to be on the server (connect string can be leaved if you set TWO_TASK/LOCAL variables) 2) user identified externally - should be locally on server 3) user identified externally as 'certificate DN' - no need to be local on server.

You can look up some examples nicely explained by Fabrizio Magni: http://nextre.it/oracledocs/certificates01.html http://nextre.it/oracledocs/certificates02.html

Best regards

Maxim Received on Wed Feb 07 2007 - 11:06:05 CST