Hi. Are you sure you don't have your 'export' and 'set' reversed...
Linux/Windows?
-----Original Message-----
From: henry Wollman
[mailto:oracledba-ezmlmshield-x24029336.[Email address protected]
Sent: Wednesday, January 04, 2006 2:36 PM
To: LazyDBA Discussion
Subject: RE: CONNECTING as SYSDBA via OS-AUTHENTICATION ...
or
sqplus '/as sysdba'
| Henry A.L. Wollman Rejoice and be glad!
|_____________________________________________________
| Moody Bible Institute, Database Administrator, [Email address
protected]
| 820 N. LaSalle Blvd, Chicago, IL 60610 312-329-2291
|_____________________________________________________
-----Original Message-----
From: jsf [mailto:oracledba-ezmlmshield-x70852382.[Email address
protected]
Sent: Tuesday, January 03, 2006 11:13 PM
To: LazyDBA Discussion
Subject: Re: CONNECTING as SYSDBA via OS-AUTHENTICATION ...
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
>
--------
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
--------
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