| Change the Auth Method? [message #58773] |
Tue, 30 September 2003 00:31  |
Anton Maleev
Messages: 3
Registered: September 2003
|
Junior Member |
|
|
Hi,
I have a database using password authentication. How do I switch to OS authentication?
I already changed REMOTE_LOGIN_PASSWORDFILE to NONE, created a new spfile, but the problem is that one cannot connect to the instance (database is shutdown) using OS auth. Instead you login as sys as sysdba and... of course you don't have the privileges to startup the database anymore ;)))
How does sqlplus (or whatever process is verifying your credentials) determine whether to use password file or not?
Best regards,
Anton
|
|
|
|
| Re: Change the Auth Method? [message #58775 is a reply to message #58773] |
Tue, 30 September 2003 03:38  |
dba2rescue
Messages: 5
Registered: September 2003
|
Junior Member |
|
|
Hi there,
The operating system user should be a part of the DBA group configured in your O/S. for eg: ORA_DBA on WIN2K or OSDBA group on UNIX etc...
only then you can follow the following procedure to startup the database:
c:> sqlplus /nolog
SQL> connect / as sysdba;
connected.
SQL> startup;
regards,
DBA2RESCUE
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
