Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

CONNECT INTERNAL Prompting for Password

SOLVED
Go to solution
Scott Buckingham
Regular Advisor

CONNECT INTERNAL Prompting for Password

Sounds simple enough, but all attempts to fix have failed. Please read on.

Yesterday, our database server went down and a cold reboot was the result (HP-9000, K360, HP-UX 11.00). We have both Oracle 7 and 8 on this box and the one instance of 7 came back and our test instance of Oracle 8.1.7 did too. However, our production instance (also 8.1.7) did not. In fact, we cannot do a CONNECT INTERNAL as we are prompted for a password. We enter the SYS password, but when a STARTUP is issued, we get 'insufficient privileges'. I suspected a bad password file so I thought I would rebuild it using orapwd. However, when I execute this command, I get: 'opw-00001 unable to open password file'. Any ideas?
Long time dabbler, first time Admin / DBA
4 REPLIES
Steve Steel
Honored Contributor

Re: CONNECT INTERNAL Prompting for Password

Hi


check

$ORACLE_HOME/dbs/orapw$ORACLE_SID


Permissions on the orapwd command


Steve Steel
If you want truly to understand something, try to change it. (Kurt Lewin)
Scott Buckingham
Regular Advisor

Re: CONNECT INTERNAL Prompting for Password

That's part of the problem; I'm trying to recreate the password file and I can't. The original file had permission settings of (I've sinced renamed it):

-rwSr----- oracle dba orapwSID

The SQLNET.ORA file contains the line:

SQLNET.AUTHENTICATION_SERVICES=(NTS)

and my initSID.ora file contains:

remote_login_passwordfile = EXCLUSIVE




Long time dabbler, first time Admin / DBA
Massimo Bianchi
Honored Contributor
Solution

Re: CONNECT INTERNAL Prompting for Password

Try commenting the entry of sqlnet.authentication.

NTS should be for use on WINDOWS, afaik....

Are you sure you are logging in as the owner of the oracle executable ? It is the onle one allowed to login with internal, without password...

Massimo

Scott Buckingham
Regular Advisor

Re: CONNECT INTERNAL Prompting for Password

Thank you! That was it! I forgot that I added the authentication line to the sqlnet.ora file a while back for "preferred credentials". I only applied this for one user and not the other.
Long time dabbler, first time Admin / DBA