Hello,
I have 8i and 9i running on my development server in two seperate oracle homes. I am attempting to use the DBUA to upgrade a 8i to a 9i db. When I select the instance and attempt to connect via the DBUA I get the ORA-12560 TNS protocol adapter error.
I have set the oracle home to point to 9i,
I am a little unsure as to how my 9i TNS names/listener should be set up and whether this is the cause of the error?
Should I have an entry for the 8i db that is to be upgraded in the 9i listener/TNS? or does the upgrade do this?
The 8i listener is called LISTENER and I have given the 9i version a different name.
Any help most welcome......
We are doing this upgrade on a windows 2000 server using terminal services....might this be the issue?