| problem with starting up Oracle. [message #64049] |
Wed, 08 December 2004 23:18  |
Thang ngo Van
Messages: 4
Registered: December 2004
|
Junior Member |
|
|
i has just installed Oracle 8i. i haven't got any warning or error during installation.
After restart my computer. my oracle instance didnt auto - start. then i connected by user sys as sysdba to startup my instance. but i got an error message " ora-12638 credential retrieval failed".
if i commented "SQLNET.AUTHENTICATION_SERVICE=(NTS)" . above error didnt appear but i cant startup my instance. although i used :
sqlplus /nolog
connect / as sysdba
err : insuficiant previliege
or i used :
sqlplus /nolog
connect internal
it asked password. but i dont know what is password here?
please help me as soosn as possible.
Thanks.
|
|
|
|
| Re: problem with starting up Oracle. [message #64053 is a reply to message #64049] |
Thu, 09 December 2004 01:28  |
Nino
Messages: 6
Registered: November 2004
|
Junior Member |
|
|
Hi all,
I guess that you are able to log in with the slash instead of the oracle username only when the currently used account of the OS you are logged in is in the administrative oracle group (sysdba,sysoper), else sysdba credentials are denied. thats probably your case. I work with a passwordfile instead. There are some other things to know about gaining administrative acces to the dabatase with sysdba credentials. The dbadmin reference of the oracle documentation Chapter 1 'The Oracle Database Administrator' describes it.
..but try this:
orapwd file='passwordfile' passwd=password
this creates the passwordfile in the default $ORACLE_HOME/dbs (on unices) or %ORACLE_HOME%database (on windows)
and then set the remote_login_passwordfile=shared of your init.ora. I don't remember if an instance restart is necessary.
set your oracle_sid and then
sqlplus "sys as sysdba"
it should work. Let me know....
Cheers
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
