Hi all,
OK, I've gone and done it again (messed up). I hope someone can help guide me out of this, I thought I was doing OK. I'll try to be concise and yet provide enough details. Thank you in advance for wading through this. I've searched this forum and others, I'm not the first with this pair of ORA errors, but the other threads did not help me resolve this. I will be cross posting this to other forums, but not to different discussion areas here.
Two questions:
1. What did I do wrong, what should I have done before running/after running patch set? (I have the Oracle documentation for the patch, but I got confused/lost in all the info on clusters & the like.)
2. What can I do to recover? (Other than scrape completely and start over, that I seem to be able to accomplish.)
I have a production system now running 10.2.0.5 on Windows Server 32. I created a dump and was rehosting to a new server to test upgrade of 3rd party application that sits over Oracle (PTC's Windchill) The new server is running server 2003 64-bit. I had Oracle 10.2.0.4 installed from a previous Windchill upgrade trial. I was applying the 10.2.0.5 patch set to the new server before importing the dump but now it throws the following errors when I attempt to login to sqlplus as system/<pwd>@sid:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
How I got here:
a. Before starting I was able to login to SQL*Plus, 10.2.0.4.0 as system/<pwd>@sid. I dropped the PTC Windchill database user with cascade, successful.
b. In Window's Services I stopped OracleServiceWIND, Oracle_HomeTNSListener and OracleDBConsloewind. These were the only Oracle services running.
c. Ran Setup from Patch downloaded from Oracle to start OUI. Ora-Home identified, patch set successfully installed. Log file for installActions repors "The installation of Oracle Database 10g Release 2 Patch Set 4 was successful." Log file written reports same.
d. Opened a command window and attempted sql*plus login as system, failed with errors noted above.
e. Checked in Window's Services, all Oracle services were started. Ran >netstat -abnp tcp, tnslistener.exe showed listening on port 1521. Oracle Net Configuration Assistant show Listener configured on port 1521
f. Connected: sys as sysdba, reported "Connected to an idle instance." sql>exit
g. Ran >lsnrctl status, reports version correct, listener.ora, ~.log. Service "wind" has 1 instance. Instance "wind", stauts UNKNOWN, has 1 handler for this service....
h. logged in sys as sysdba, reported "Connected to an idle instance. " Ran >startup open; output reported:
Oracle instance started.
Total System Global Area
Fixed Size
Variable Size
...blah blah...
Database Mounted.
ORA-01092: ORACLE instance terminated. Disconnect forced
I'm at a loss. Windows services appears to have all my Oracle services running. But, I cannot log into SQL*Plus as the system/pwd@sid which I've always done as a test before importing the dump. Any thoughts, suggestions?
Thank you so much for your time and help from a neophyte.
Sincerely,
tom