Results 1 to 5 of 5

Thread: TNS Problem!

  1. #1
    Join Date
    Aug 2002
    Posts
    3

    Unanswered: TNS Problem!

    After I successfully installed Ora9i (9.2), I can't connect to the DB on the network. Here is the problem:

    When I try to connect using TOAD or SQLPLus, I get the following message:

    TNS: Could not resolve service name.

    Ok, my tnsnames.ora file is in the proper directory, however I checked TOAD SQL*Net Help and it does say:
    ---------
    Oracle Root
    Oracle_Home = C:\ORACLE\ORA92
    C:\ORACLE\ORA92\BIN is in system PATH
    C:\ORACLE\ORA92\BIN does exist
    Client dll found oci.dll
    oci.dll version: 9.2.0.1.0
    C:\oracle\ora92\Network\Admin\tnsnames.ora found .
    Oracle Root is valid
    HOME0
    Home name = OraHome92
    Oracle_Home = C:\ORACLE\ORA92
    C:\ORACLE\ORA92\BIN is in system PATH
    C:\ORACLE\ORA92\BIN does exist
    Client dll found oci.dll
    oci.dll version: 9.2.0.1.0
    C:\oracle\ora92\Network\Admin\tnsnames.ora found .
    HOME0 is valid
    -------------

    So, the file is found. The next thing could the entry in the TNS file. Well, it is a simple single entry file as:

    # Production Datamart
    PWDM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS =
    (PROTOCOL = TCP)
    (Host = capleorap.xyz.com)
    (Port = 1521)
    )
    )
    (CONNECT_DATA = (SID = pwdm) (SERVER = SHARED)
    )
    )
    #

    ---------------------

    I pinged 'capleorap.xyz.com' and i got the reply.

    So, what else I should check, or correct to make it work? (Note that the same file used to work when I had Ora8 client. Now, I have removed that and copied the file back to the new Ora92 folder as above.

    Thanks for the help .....

  2. #2
    Join Date
    Jun 2002
    Location
    Indianapolis
    Posts
    21
    In the tnsnames.ora file, try replacing SID with SERVICE_NAME.


    # Production Datamart
    PWDM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS =
    (PROTOCOL = TCP)
    (Host = capleorap.xyz.com)
    (Port = 1521)
    )
    )
    (CONNECT_DATA = (SERVICE_NAME = pwdm) (SERVER = SHARED)
    )
    )
    #

  3. #3
    Join Date
    Aug 2002
    Posts
    1
    and your server should have $ORACLE_HOME/netowrk/admin/listener.ora correct configured

  4. #4
    Join Date
    May 2002
    Posts
    34
    If you still having problem connecting to your database...
    Do you have sqlnet.ora file under your TNS_ADMIN?
    Check for parameter names.default_domain = <some domain> and comment it out. Or try to follow your net_service_name with ".":
    sqplus user/pass@PWDM.
    I don't know about Oracle9i, but I had similar problem in 8i and it helped.
    Let me know if it worked.

    BTW is there Oracle Names in 9i?

    Peter S.

  5. #5
    Join Date
    Aug 2002
    Posts
    3

    thanks

    The conenction is fine now. All I did was re-configured the TNS fiel with the 9i Net Config. utility.

Posting Permissions

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