Manage Learn to apply best practices and optimize your operations.

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.
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 last published in March 2004

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.