DBUA - ORA-12560 TNS protocol adapter error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: DBUA - ORA-12560 TNS protocol adapter error

  1. #1
    Join Date
    May 2001
    Posts
    25

    DBUA - ORA-12560 TNS protocol adapter error

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

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

    Please let us know.

    Sam
    Thanx
    Sam



    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