I just tried to upgrade my 8.1.5 databases on a Windows NT 4.0 sp4 box to 8.1.6 using Oracle's documentation. Here's what I did.
- Took cold backups and exports
- Deinstalled 8.1.5
- Installed 8.1.6 into what used to be the 8.1.5 home (D:oracleora81)
- Tried to use the Data Migration Assistant and kept getting the message: ORacle database is already 8.1.6, which didn't seem right to me. Canceled it.
- Using svrmgrl, I connected internal and ran u0801050.sql script along with the cat* scripts.
- However, I couldn't connect because I was getting TNS-12545 errors. The tnsnames.ora and the listener.ora files have not been changed and neither has the init.ora.
- Used ORADIM to delete and recreate the instances and still couldn't connect. Now when I type SVRMGRL at the command line, I get the TNS: no protocol message.
Q. What do you suppose could be going wrong? Any tip or referral would be tremendously appreciated.
It sounds to me like things have been really balled up here. There is lots going on behind the scenes on Windows platforms with Oracle, and I'm talking about the Windows Registry. You have a very good chance that there are Registry problems. If I was in your position, then I'd wipe the machine clean of Oracle and reinstall the software. Then I'd create a new database, and then I'd import the old database. Basically, follow these steps:
- Start REGEDIT, the Registry Editor.
- Navigate to the HKEY_LOCAL_MACHINESoftware directory.
- Delete the Oracle subtree.
- Delete the ORACLE_HOME directory on disk.
- Delete the C:Program FilesOracle directory on disk.
- Reinstall the Oracle 8.1.6 software.
- Use the Database Configuration Assistant to create an empty database.
- Do a full import of your export file.
That should solve your problems!
For More Information
- What do you think about this answer? E-mail us at editor@searchDatabase.com with your feedback.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle tip to offer your fellow DBA's and developers? The best tips submitted will receive a cool prize--submit your tip today!
- Ask your technical Oracle questions--or help out your peers by answering them--in our live discussion forums.
- Ask the Experts yourself: Our Oracle gurus are waiting to answer your toughest questions.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.