last night one of the dbas here changed system's password on an oracle 18.104.22.168 database running on NT. The problem is that when the machine is bounced, the database comes up unavailable. The wierd thing is that when you go into services, the oracle service is started. any ideas???
It is possible for the services to be running, but the database not started. You can restart it manually be going into server manager (svrmgr30, I believe the command is for 8.0 on NT), logging in as SYS or INTERNAL, and doing a 'startup open'.
I am not sure what you need to do to get it starting up automatically again, tho.
Check the sid thats server is defaulted to currently. By checking registry ORACLE_SID entry or typing in set @ the prompt you can see whether the sid is defaulted to the database you wanted to start automatically.
...password file is not corrupted because I can manually connect internal
I found some stuff on metalink though that should correct the problem (once they get pcanywhere going again.)
in case you want to know, I believe the solution will be:
Go to the OracleHome\Database directory
Locate the strtSID.cmd file
Highlight this file, click on the right button
Change the "-usrpwd oracle" parameter to "-usrpwd /"
(without the quotes!)
Save the file