Oracle 9i Instance and database creation from the command line in WIN NT 2000

0 pts.
Tags:
Oracle 9i
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
ASKED: March 11, 2005  2:05 PM
UPDATED: March 15, 2005  11:43 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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?

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following