| sys dba authentication [message #294605] |
Fri, 18 January 2008 03:06  |
lokeshonline
Messages: 29
Registered: April 2006
|
Junior Member |
|
|
|
I created a new service using ORADIM named "test1". Created a initTest1.ora file containing parameter remote_login_passwordfile=Exclusive. Both the init and password files are at default location. Even I have created password file, when I write sqlplus / as sysdba it connect and shows "connected to an idle instance" just like in case of OS authentication. After startup when I see "show parameter remote_login_passwordfile" it shows Exclusive. Then how it is using OS authentication?
|
|
|
|
| Re: sys dba authentication [message #294607 is a reply to message #294605] |
Fri, 18 January 2008 03:10  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
| Quote: | when I write sqlplus / as sysdba it connect and shows "connected to an idle instance" just like in case of OS authentication
|
Because you are local and in ORA_DBA OS group.
OS authentication is done BEFORE password file is checked.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
