DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    May 2001

    DBUA - ORA-12560 TNS protocol adapter error


    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?
    Last edited by muckley; 07-15-2003 at 06:51 AM.

  2. #2
    Join Date
    Oct 2000
    Saskatoon, SK, Canada
    1. Set the oracle home to 9i and Oracle SID
    2. If you still encounter the error, then check the logs
    3. Also in Win2K, you must be local administrator/domain administrator

    Please let us know.


    Life is a journey, not a destination!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.