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

Thread: Unable to connect

  1. #1
    Join Date
    Apr 2001
    Posts
    55

    Exclamation

    I am trying to connect to my server however I get the following error:-

    ORA-12203: TNS:unable to connect to destination

    I can log onto the server using SQLPlus with the same SQL-Net Alias owever using another application I am unable to connect.

    I've checked my tnsnames.ora and as far as i can tell everything is OK

    Please Help
    Thankyou
    Hummy

  2. #2
    Join Date
    Jan 2001
    Posts
    3,134

    Talking

    In my vast Oracle experience (all 6 weeks) whenever I had this problem I had to specify the entire connect string.
    instance.oracledb.mycompany.com
    Hope this helps.
    MH

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Try doing tnsping and confirm that your connection to the host reaches. Use the same application user name and password and try connecting to the instance through sqlplus.

    Check your tnsnames.ora and sqlnet.ora files to see there are no decrepsencies in the parameters... Make sure the service name defined in the tnsnames.ora was what used in establishing the connection. Confirm that the listener for that service is up and running. In the tnsnames.ora, if the CONNECT_DATA(service...), try changing it to CONNECT_DATA(SID=instance name on the db server)

    Hope these might help you to trouble shoot things
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Aug 2000
    Location
    Straham NH
    Posts
    73
    I just had the same error. I was working with WinNT and 8.1.7.1

    The following thread was who I fixed my error:
    http://www.dbasupport.com/forums/sho...threadid=13557

    Gary

  5. #5
    Join Date
    Apr 2001
    Posts
    55
    I tried the tnsping and it was working fine, however from the client machine
    there was TNS-12541: TNS:no listener

    Then I thought may be the proxy server is the problem, unsinstalled the proxy
    on the server, then the server get the No listener message too.

    I reinstalled the proxy and still have no access to the database from the Server
    and the client machine.

  6. #6
    Join Date
    Dec 2000
    Posts
    138
    check the sqlnet.ora for the names.default_domain sometimes it creates problem if u have a different db_domain in the initSID.ora.

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