Reboot Window, Oracle won't start right

[SaintJames]

This is the second time this happens too me. I change the password for system (successfully), and discover that something does not work right after I reboot Window.

I have 2 resolutions either restart OracleService[SID], or shutdown and startup from sqlplus which brings me into second problem in the sqlnet.ora file if I have
SQLNET.AUTHENTICATION_SERVICES= (none) I can't do a
c:>sqlpplus /nolog
>connect /as sysdba
I get an insufficient privileges error
and if I use SQLNET.AUTHENTICATION_SERVICES= (NTS), I can't connect to the database from outside the local machine.


What should I look at to get the service to start correctly after reboot?


Thank you all!

 

[oradba101]

Hi, SaintJames

Do you have the following line in your sqlnet.ora:

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

Regards,



William Chadbourne
Oracle DBA

 

[SaintJames]

I tried
SQLNET.AUTHENTICATION_SERVICES= (none)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

I still need to restart OracleService and OracleDBConsole to get the Listener to work correctly

When I use SQLNET.AUTHENTICATION_SERVICES= (none,NTS)
I get a 12638 Credential retrieval failed when connecting from another computer (different domain)