TNSNames or SQLNet or Listener
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: TNSNames or SQLNet or Listener

  1. #1
    Join Date
    Oct 2000
    Posts
    449

    TNSNames or SQLNet or Listener

    Hello Guys:

    If I am connecting to a remote database unless I use the it will not connect. Can anyone please give me some clues..

    On my local machine: tnsnames.ora
    PCDW.world=
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.242.27)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.242.27)(PORT = 1526))
    )
    (CONNECT_DATA =
    (SID = pcdw)
    )
    )

    SQLPLUS Session: (after removing the .world in tnsnames.ora)
    SQL> connect pecdm/pecdm@pcdw
    ERROR:
    ORA-12154: TNS:could not resolve service name

    Warning: You are no longer connected to ORACLE.
    SQL> connect pecdm/pecdm@pcdw.world
    Connected.

    PCDW.world is a remote oracle 8i instance on an Win 2000 Adv Svr.

    -----------

    # SQLNET.ORA Network Configuration File: D:\Oracle\Ora8i\network\admin\sqlnet.ora
    # Generated by Oracle configuration tools.

    NAMES.DEFAULT_DOMAIN = prenhall.com

    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

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

    # LISTENER.ORA Network Configuration File: D:\Oracle\Ora8i\network\admin\listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = unemana_nt)(PORT = 1521))
    )
    )
    (DESCRIPTION =
    (PROTOCOL_STACK =
    (PRESENTATION = GIOP)
    (SESSION = RAW)
    )
    (ADDRESS = (PROTOCOL = TCP)(HOST = unemana_nt)(PORT = 2481))
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = D:\Oracle\Ora8i)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = bits)
    (ORACLE_HOME = D:\Oracle\Ora8i)
    (SID_NAME = bits)
    )
    )

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

    The above attached tnsnames.ora, sqlnet.ora and listener.ora are the files from the local database instance i have on..

    Thx, ST2000

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    As you are using names.default_domain in sqlnet.ora, your tnsnames.ora listing for the SID you want must contain SID.NAMES.DEFAULT_DOMAIN instead of SID.

    Instead of...

    PCDW.world=
    (DESCRIPTION =
    (ADDRESS_LIST =
    ...


    you need

    PCDW.PRENHALL.COM=
    (DESCRIPTION =
    (ADDRESS_LIST =
    ...

    because you have
    # SQLNET.ORA Network Configuration File: D:\Oracle\Ora8i\network\admin\sqlnet.ora
    # Generated by Oracle configuration tools.

    NAMES.DEFAULT_DOMAIN = prenhall.com

  3. #3
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    510
    Something is goofy here. Your listener is listening to instance 'bits' Your tnsnames should mention SID as bits.

    Secondly, if your default domain is prenhall.com, GLOBAL_DBNAME in listner.ora should be bits.prenhall.com.

    If you are able to connect to pecdm/pecdm@pcdw.world, you are connecting to something else, not the instance referred to by your listener.ora file.

    Check your files again.
    Last edited by kris109; 03-24-2003 at 04:59 PM.
    Remember the Golden Rule - He who has the gold makes the rules!
    ===================
    Kris109
    Ph.D., OCP 8i, 9i, 10g, 11g DBA

  4. #4
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by kris109
    Something is goofy here. Your listener is listening to instance 'bits' Your tnsnames should mention SID as bits.

    Secondly, if your default domain is prenhall.com, GLOBAL_DBNAME in listner.ora should be bits.prenhall.com.

    If you are able to connect to pecdm/pecdm@pcdw.world, you are connecting to something else, not the instance referred to by your listener.ora file.

    Check your files again.
    Kris:

    Jus see wat St2000 has posted...

    Hello Guys:

    If I am connecting to a remote database unless I use the it will not connect. Can anyone please give me some clues..
    ..
    ..
    ..
    The above attached tnsnames.ora, sqlnet.ora and listener.ora are the files from the local database instance i have on..
    He is connecting to remote DB...and he says hez posting Local DB listener....which dosent make sense...

    Wat Stecal said is absolutely correct....

    Either make
    NAMES.DEFAULT_DOMAIN = world

    or change in TNS names file as suggested by stecal...

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  5. #5
    Join Date
    Oct 2000
    Posts
    449
    Thanks for all the input guys..

    The db_links and global_name were different. Once we updated the global_name to xxx.world, it got solved..

    Thanks, ST2000

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