| Oracle 9i Instance removal [message #62457] |
Thu, 22 July 2004 14:41  |
Tony Manning
Messages: 2
Registered: July 2004
|
Junior Member |
|
|
Hello, all!
I am attempting to remove an Oracle 9i instance from a server that has nothing else on it (HP-UX), because it was set up erroneously, then cloned onto the same box. I used the DBCA to successfully remove the first instance, but this second one does not appear in the DBCA set-up window. I know it is still there because a ps -ef|grep shows the process running. Also, sqlplus connects to an idle instance.
How do i clean up this mess? I am a relatively inexperienced DBA, so forgive my naivete....
Thanks for any help!
|
|
|
|
| Re: Oracle 9i Instance removal [message #62488 is a reply to message #62457] |
Fri, 23 July 2004 19:02  |
RR
Messages: 19
Registered: October 2001
|
Junior Member |
|
|
Have you checked the oratab file. Normally oratab file contains the SID entries that dbca can access.
Can you check your tnsnames.ora and listener.ora to validate that there are actually two instances.
To be safe shutdown the instance first through sqlplus. Once the entry goes in oratab, you should be able to see it through the dbca window
|
|
|
|
| Re: Oracle 9i Instance removal [message #62526 is a reply to message #62488] |
Mon, 26 July 2004 13:04 |
Tony Manning
Messages: 2
Registered: July 2004
|
Junior Member |
|
|
|
Thanks for the tip. I did indeed check the oratab file and found an entry with the SID listed. I removed this after deleting the instance using DBCA; lo and behold, no more indications of the old instance. The box is now clean as a whistle, verified by the SA.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
