Oracle 9i Instance and database creation from the command line in WIN NT 2000
Hi,
Has anyone done this using Windows Authentication (the user is an admin and in the ORA_DBA group)?
I used oradim to create an instance and did not specify any password. Instance was created but it gave me a TNS-12156 : TNS Protocol Error while connecting "connect /as sysdba".
When I specify a password and connect as sys, everything is fine, but I am wondering how I can make it work using WINNT Authentication.
Thanks for your help,
Sumesh
Software/Hardware used:
Software/Hardware used:
ASKED:
March 11, 2005 2:05 PM
UPDATED:
March 15, 2005 11:43 AM
Answer Wiki:
First, Windows Authentication is only used if you are connected locally on the server. If you are connected remotely, it will use the password file.
If you are issueing the command in a command prompt window, try setting oracle_sid to you SID name before connecting
oracle_sid=SID.
What version of Oracle are you running?
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
