Ask the Expert

Trouble running upgrade assistant

I have Oracle8i installed on a Windows 2000 machine. I just installed Oracle9i on the same machine. I am trying to run the 9i database upgrade assistant to migrate the 8i databases to 9i. When I attempt to select an 8i database, the application tells me that it is "getting database information," then I get an ORA-12560: TNS:Protocol Adapter Error. I have checked to make sure the database services are running. Also, strangely enough, I AM able to connect to the 8i databases using both 8iDBA_Studio and 9iEnterprise_Manager just fine.

    Requires Free Membership to View

You may need to verify which ORACLE_HOME is set. It may be looking at the wrong tnsnames.ora file entry depending on if ORACLE_HOME is 8i or 9i.

This was first published in March 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: