URGENT : connection problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: URGENT : connection problem

  1. #1
    Join Date
    Nov 2000
    Posts
    416
    Hi Guys,

    I just created a second database in my NT machine, no problem in installtion now I try to configure SQL*Net, it is not successful. I have this error :


    SQL> connect system/manager@test
    ERROR:
    ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor


    BUT when I issue this, look it works ...why ??

    SQL> connect system/manager
    Connected.


    Also we use Oracle Name server instead of local sql*net, I added the entry to Name server and restart it as well !! No luck yet .. and I think when you use Oracle name server you only need Listener.ora .. Am I correct ?? And here is my listner file :

    # D:\ORACLE\ORA81\NETWORK\ADMIN\SQLNET.ORA Configuration File:\Oracle\Ora81\NETWORK\ADMIN\sqlnet.ora
    # Generated by Oracle Net8 Assistant

    TRACE_DIRECTORY_CLIENT = C:\temp

    TRACE_UNIQUE_CLIENT = on

    TRACE_DIRECTORY_SERVER = C:\temp

    TRACE_FILE_CLIENT = Net8trac.log

    TRACE_FILE_SERVER = net8traS.log

    TRACE_LEVEL_CLIENT = ADMIN

    TRACE_LEVEL_SERVER = ADMIN

    SQLNET.EXPIRE_TIME = 0

    NAMES.PREFERRED_SERVERS =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = tod__d01)(PORT = 1575))
    (ADDRESS = (PROTOCOL = TCP)(HOST = tod__d02)(PORT = 1575))
    )

    NAMES.DIRECTORY_PATH= (ONAMES, TNSNAMES, HOSTNAME)


    Can you rescue me from this stuck stage ... Also TNSPING works


    Z:\frank>tnsping test ( test is my instance name )

    TNS Ping Utility for 32-bit Windows: Version 8.1.5.0.0 - Production on 19-JUN-01 14:09:34

    (c) Copyright 1997 Oracle Corporation. All rights reserved.

    Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=MOON.DEV.BEMANY.COM)(PORT=1521))
    OK (120 msec)
    An ounce of prevention is worth a pound of cure

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Check your listener.ora and tnsname.ora files and confirm that they have been configured properly. Then if you are planning to connect to the database using the tnsnames, then modify the sqlnet.ora to check first into the tnsnames and then the oracle name server.

    If this doesn't work use the netassist to configure and it might solve the problem for you.


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Nov 2000
    Posts
    416
    Ok It worked Sam, Thanks man

    An ounce of prevention is worth a pound of cure

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