Ask the Expert

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.

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: