DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Ora-12203 Tns:unable To Connect To Destination

  1. #1
    Join Date
    Apr 2002
    Posts
    36

    Ora-12203 Tns:unable To Connect To Destination

    Hi,


    I have installed oracle 8i (SID = ORACLE) in the home "oracle/ora81", and the oracle dev6i in the home "oradev6i", therefore in two different oracle_homes.


    I have copied the file tnsnames.ora from oracle/ora81/network/admin TO oradev6i/net80/admin


    when I try to connect to database from forms builder with the sid "ORACLE" I have the followong message :

    ORA-12203 TNS:UNABLE TO CONNECT TO DESTINATION

    what's the problem please ?

    thanks..

  2. #2
    Join Date
    Dec 2000
    Posts
    138
    The format of the tnsnames in the database version varies from the one provided with 6i. dont copy it from the DB Home. you'll find a sample in your dev6i home, copy that to the dev6i/network/admin dir and modify the tcp sample provided in the sample.

    If you find it difficult, use the Net Easy configuration for your dev6i home.

    HTH.
    -dharma

  3. #3
    Join Date
    Apr 2002
    Posts
    36
    it doesn'y work dharma!!!

    but , I have found another thing, when I start SQL*plus (witch come with oracle8i) and host string = Oracle ( sid with which my database is started) , it does't work also!!!

    but, when I start sql with no host string, it works!!!

    can you explain !

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