DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Strange Problem

  1. #1
    Join Date
    Jul 2003
    Posts
    134

    Strange Problem

    I have two databases d1 and d2 on a server. I am able to connect to d1 and not d2 (from the client). I am getting TNS: Listener not found error. My TNSNAMES.ORA file is okay, I've made the right entry. I am able to ping the server (obviously becoz I can connect to d1).

    I am able to however connect from the server end to both d1 and d2.

    Could someone solve this issue for me please...

    Vipassana
    Last edited by Vipassana; 07-29-2003 at 10:25 AM.

  2. #2
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    Do you have listener defined on server for both databases?
    Check listener.ora or issue lsnrctl services?
    Toma┼ż
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

  3. #3
    Join Date
    Jul 2003
    Posts
    134
    Originally posted by TomazZ
    Do you have listener defined on server for both databases?
    Check listener.ora or issue lsnrctl services?
    I don't think I have multiple Listeners, there is only one. I'll check it anyway and confirm on that.

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    If you had made any changes on the listener after starting the listener, then you would have to reload it to get the changes take effect. In the mean time, can you do a tnsping using the tnsname of the d2 and let us know the results. It may me a typo or somthing for the d2 configuration that doesn't let you connect. Also please let us know the error tooo.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    What does "lsnrctl status" return?
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  6. #6
    Join Date
    Jul 2003
    Posts
    134
    I will get back with the specifics. But I must tell you that d2 is a repository database (created for oms). Would that make any difference?
    Last edited by Vipassana; 07-30-2003 at 07:16 AM.

  7. #7
    Join Date
    Jul 2003
    Posts
    134
    Okay Guys, here are the details:

    LSNTCTL STATUS
    ==============

    :\ora9idb\bin>lsnrctl status

    LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 30-JUL-2003 16:37:
    33

    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Produc
    tion
    Start Date 30-JUL-2003 15:22:51
    Uptime 0 days 1 hr. 14 min. 45 sec
    Trace Level off
    Security OFF
    SNMP OFF
    Listener Parameter File f:\ora9idb\network\admin\listener.ora
    Listener Log File f:\ora9idb\network\log\listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=incq246bb.idc.oracle.com)(PORT=1521)
    ))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=incq246bb.idc.oracle.com)(PORT=8080)
    )(Presentation=HTTP)(Session=RAW))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=incq246bb.idc.oracle.com)(PORT=2100)
    )(Presentation=FTP)(Session=RAW))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=incq246bb.idc.oracle.com)(PORT=8080)
    )(Presentation=HTTP)(Session=RAW))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=incq246bb.idc.oracle.com)(PORT=2100)
    )(Presentation=FTP)(Session=RAW))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=incq246bb.idc.oracle.com)(PORT=8080)
    )(Presentation=HTTP)(Session=RAW))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=incq246bb.idc.oracle.com)(PORT=2100)
    )(Presentation=FTP)(Session=RAW))
    Services Summary...
    Service "ODEMEA" has 2 instance(s).
    Instance "ODEMEA", status UNKNOWN, has 1 handler(s) for this service...
    Instance "ODEMEA", status READY, has 1 handler(s) for this service...
    Service "ODEMEAXDB" has 1 instance(s).
    Instance "ODEMEA", status READY, has 1 handler(s) for this service...
    Service "OEMREP.idc.oracle.com" has 2 instance(s).
    Instance "OEMREP", status UNKNOWN, has 1 handler(s) for this service...
    Instance "OEMREP", status READY, has 1 handler(s) for this service...
    Service "OEMREPXDB.idc.oracle.com" has 1 instance(s).
    Instance "OEMREP", status READY, has 1 handler(s) for this service...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "oem_repo" has 2 instance(s).
    Instance "oemrepo", status UNKNOWN, has 1 handler(s) for this service...
    Instance "oemrepo", status READY, has 1 handler(s) for this service...
    Service "oemrepoXDB" has 1 instance(s).
    Instance "oemrepo", status READY, has 1 handler(s) for this service...
    The command completed successfully





    TNSPING OUTPUT
    ==============


    C:\>tnsping oemrep

    TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 30-JUL-20
    03 16:57:59

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

    Used parameter files:


    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
    (HOST = incq246bb)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = oemrep)))
    OK (40 msec)







    ERROR MESSAGE
    ==============


    ERROR:
    ORA-12514: TNS:listener could not resolve SERVICE_NAME given in the connect descriptor





    OEMREP is the one I am not able to connect. This is a Repository OMS Database. I can connect using SYSTEM user from the Server, but not from the client. However, from the client, I can connect to OMS using SYSMAN on OEMREP. It falis when I connect through SQL PLUS using SYSTEM. Could someone please help.


    Sorry for lot of details in this post.

  8. #8
    Join Date
    Feb 2003
    Location
    London
    Posts
    170
    did you try tnsping from the client server. Your error message seems to look like there may be something missing in your tnsnames.ora file on the client.

  9. #9
    Join Date
    Jan 2003
    Location
    Hull, UK
    Posts
    220
    In your tnsnames.ora file, try to give IP ADDRESS instead of machinename.

    HTH

    Srini

  10. #10
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Try changing SERVICE_NAME to SID in your tnsnames.ora file for OEMREP
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

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