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

Thread: DBA Studio and TNS errors?

  1. #1
    Join Date
    Oct 2001
    Posts
    59
    ORA - 12154 TNS: Could not resolve service name DBA Studio

    I downloaded Personal Oracle 8.1.7 and extracted it to c drive on this windows 2000 pantium 4. I used the Database configuration Assistant to set up a database. I have checked my listener.ora and sqlnet.ora as well as tnsnames.ora - all seems fine. When I go into DBA Studio I cannot coonect to my database without having the TNS error.

    I can connect system/manager in sqlplus ok.

    pinged my machine ok.
    net start showed me that listnere is running.

    When I run tnsping service_name I get TNS - 03505 Failed to resolve service_name.

    I have substituted the host with the actual ip address - no difference.

    What is going on ??????

    Help!!!!!!!!

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Check the file name tnsnames.ora and make sure that it had been configured properly...

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Oct 2001
    Posts
    59

    Dba studio ORA - 12154 - help!!!

    I have sorted the connection problem via sqlplus but still not via Dba Studio.

    All I did to rid the error TNS - 03505 Failed to resolve service_name is : - I went into Net 8 assitant and created a service. This then created a tnsnames.ora in the network/admin directory for oracle with
    AWGCDP1 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = UKP-WNXY3XG69G2.mag.co.uk)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = awgcdp1.mag.co.uk)
    )

    this was the old one

    AWGCDP1.MAG.CO.UK =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = UKP-WNXY3XG69G2)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = awgcdp1)
    )
    )

  4. #4
    Join Date
    Oct 2001
    Posts
    59

    Smile Resolved at last!!!!


    This led to success .........


    AWGCDP1.mag.co.uk =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = UKP-WNXY3XG69G2.mag.co.uk)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = awgcdp1.mag.co.uk)
    )
    )

    Thanks all!!!

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