| Problem Connecting to Database [message #59264] |
Thu, 06 November 2003 22:33  |
Sujit Sarkar
Messages: 40
Registered: September 2003
|
Member |
|
|
Hi Friends,
My Self is Sujit working as a DBA.
I am having a Problem starting Database.
I am having Windows 2000 Advanced Server running Oracle 9i.
I am logging into OS as Administrator user who is in ORA_DBA group.
I am trying to connect as SYSDBA user by giving CONNECT / AS SYSDBA but it is giving message "Insufficient Privileges".
My Sqlnet.ora file configuration as follows
SQLNET.AUTHENTICATION_SERVICES=(NTS)
NAMES.DIRECTORY_PATH=(TNSNAMES)
There is Password file created for SYSDBA user in ORACLE_HOME/database directory and in the init.ora file REMOTE_LOGIN_PASSWORD=EXCLUSIVE set.
when i am connecting as sys by giving SYS/<PASSWORD> AS SYSDBA it is connected fine.
I have read in the Documentation if the OS user is in ORA_DBA group
and if in the sqlnet.ora file SQLNET.AUTHENTICATION_SERVICES=(NTS) then
without giving password of sys one can connect to Oracle Database.
My Problem is why It is not working CONNECT / AS SYSDBA
Is it due to Window 2000 Advanced Server where NTS does not work or Some other problem is there .
Pls. help me
Your help is greatly Appreciated
Thanx in Advance
Sujit
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
