Domain name changes causing error
I am getting the same error message, which is ORA-01034. But I guess this error is due to domain name changes in my company. For example, I used to login to xyz domain in W2K but now I am logging in to domain ABC. And the database is in my hard disk. Many people have told me I have to reinstall Oracle8i, but I am looking for another solution.
The ORA-1034 error message indicates that your database is not up and
running. The most obvious course of action is to start your database.
This should fix your problem.
If your company changed domain names, but you did not change any of
your network configuration files (SQLNET.ORA, LISTENER.ORA,
TNSNAMES.ORA), then Oracle has no way of knowing of this domain name
change. However, Oracle doesn't care either. It should still work fine
with the old domain names.
This was first published in January 2004