Hi,

I've already have that problem before... please do a few checks which
could help you:

1) Ensure that you're logging in the OS as a user which is in the DBA
group(ORA_DBA Windows and oinstall on linux).

2) Ensure that you've correctly set ORACLE_HOME and ORACLE_SID environment
variables

export ORACLE_SID=testdb (Windows)
or
set ORACLE_SID=testdb (Linux)

3) Ensure that your SQLNET.ORA has this entry:

SQLNET.AUTHENTICATION_SERVICES= (NTS)

4) If using Windows, check if register entries (using regedit) are set
correctly.

5) Then you should be able to log in using

conn / as sysdba

HTH,

Juliano

> Hi all,
>
> I have four databases on the same server, does anyone know how to
> configure OS authentication to connect as sysdba? At the moment, am
> connecting as follows:
>
> sqlplus "[Email Address Removed] /as sysdba"
> sqlplus "sys/[Email Address Removed] /as sysdba"
>
> The first option will prompt for the SYS password. Since am logged into
> the box anyway and the databases are on the same machine, I want to use OS
> authentication instead. Is it as simple as doing a create user with the
> OPS$ appended to the OS USER?
>
>
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>



Oracle LazyDBA home page