Instance Shutdown Incorrectly - Cannot restart

[SpiritOfLennon]

Hi,
We have an Oracle 8i database on a windows 2000 server. Over the weekend our IT department decided to move the server to another site and shut down the server without stopping the database and then relocated the server and gave it a new IP address. Now I cannot get the instance to start. When I go in through DBA studio as sysdba and try and restart it comes up with an exclamation mark.
I have subsequently tried opening up a DOS box and trying to go in via svrmgrl. However it just gives me a ora-12560 error message. I'v tried setting ORACLE_SID and ORACLE_HOME from the prompt, again with no joy. I've checked out listener.ora and tnsnames.ora and they appear to be okay with the new IP address. Can anyone provide any suggestions as to what may be the issue?
Thanks in advance.

SOL


SOL
I'm only guessing but my guess work generally works for me.

 

[KenCunningham]

Hi SOL. Are there any clues in the alert log for the database? As you probably know the ORA-12560 error indicates some sort of TNS problem, but these can sometimes be red herrings. I take it the listener service is started? Sounds to me like your IT Department needs some serious butt-kicked instructions in terms of 'what to do when moving a server'.

 

[SpiritOfLennon]

Thanks Ken we solved the problem. The problem was actually being caused not by the server but by the fact that connecting to the server using remote desktop won't allow you to restart the instance, which I didn't know being a unix boy.


SOL
I'm only guessing but my guess work generally works for me.