ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 18

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

  1. #1
    Join Date
    Feb 2005
    Posts
    11

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

    Recently our company moved an Oracle 9i db on a Linux Redhat 8.0 box
    from one domain to another.

    We've always had access to this box via Toad(or any other tool) from
    our office or anywhere outside the network when it was on it's
    original
    domain. Since we moved the box to it's new domain, we have only been
    able to see the box from within the physical network itself. No
    connections from outside have been successful yet.

    We changed the global db_domain to the correct value, and the
    listener
    to the new instance name (changed the instance name to reflect the
    new
    domain.)

    When we do a tnsping on the box from the outside we get an OK
    returned.
    When I try to connect through Toad from the outside I get ORA-12514:
    TNS: Listener could not resolve Service_Name given in connect
    descriptor. I made sure my tnsnames.ora file reflected the new
    service
    name and host too.

    db <-- inside = OK
    db <--firewall <-- outside NOT OK

    One other thing is that the db instance used to be named something different as you can see commented out below.

    If you have any ideas or suggestions they would be much appr**eciated.

    # LISTENER.ORA Network Configuration File:/usr/oracle/network/admin/listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rocky.admissions.mvk.edu)(PORT = 1521))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /usr/oracle)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = rocky.ROCKY)
    (ORACLE_HOME = /usr/oracle)
    (SID_NAME = rocky)
    )
    )


    # SQLNET.ORA Network Configuration File: /usr/oracle/network/admin/sqlnet.ora
    # Generated by Oracle configuration tools.

    NAMES.DEFAULT_DOMAIN = admissions.mvk.edu

    NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)


    # TNSNAMES.ORA Network Configuration File: /usr/oracle/network/admin/tnsnames.ora
    # Generated by Oracle configuration tools.

    #ROCKY.ROCKY =
    # (DESCRIPTION =
    # (ADDRESS_LIST =
    # (ADDRESS = (PROTOCOL = TCP)(HOST = rocky.admissions.mvk.edu)(PORT = 1521))
    # )
    # (CONNECT_DATA =
    # (SERVER = DEDICATED)
    # (SID = rocky)
    # )
    # )

    ROCKY.ADMISSIONS.MVK.EDU =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rocky.admissions.mvk.edu)(PORT = 1521))
    )
    (CONNECT DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = rocky.rocky)
    )
    )

    #OEMREP.RESEARCH.MVK.EDU =
    # (DESCRIPTION =
    # (ADDRESS_LIST =
    # (ADDRESS = (PROTOCOL = TCP)(HOST = rocky.admissions.mvk.edu)(PORT = 1521))
    # )
    # (CONNECT_DATA =
    # (SERVER = DEDICATED)
    # (SERVICE_NAME = OEMREP.research)
    # )
    # )

    EXTPROC_CONNECTION_DATA.ADMISSIONS.MVK.EDU =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

    INST1_HTTP.ROCKY.ADMISSIONS.MVK.EDU =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rocky.admissions.mvk.edu)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = SHARED)
    (SERVICE_NAME = MODOSE)
    (PRESENTATION = http://HRService)
    )
    )

  2. #2
    Join Date
    Feb 2005
    Posts
    11

    Client Files

    # SQLNET.ORA Network Configuration File: c:\oracle\ora90\network\admin\sqlnet.ora
    # Generated by Oracle configuration tools.

    NAMES.DEFAULT_DOMAIN = admissionpros.com

    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)


    # TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.

    ROCKY.ADMISSIONPROS.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 152.10.23.196)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = rocky.rocky)
    )
    )

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    change the default domain and the service name, they point to .com not to the new one

  4. #4
    Join Date
    Feb 2005
    Posts
    11
    I did change this and yet I get the same results.

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    post the new files

  6. #6
    Join Date
    Feb 2005
    Posts
    11
    # TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.

    ADMISSIONPROS.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 152.10.23.196)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = rocky.rocky)
    )
    )


    # SQLNET.ORA Network Configuration File: c:\oracle\ora90\network\admin\sqlnet.ora
    # Generated by Oracle configuration tools.

    NAMES.DEFAULT_DOMAIN = admissionpros.com

    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    look at your tnsnames file now, you took the work rocky out.

    also your service is rocky.rocky - is that correct?

  8. #8
    Join Date
    Feb 2005
    Posts
    11
    ok, maybe im confused by your instructions then. You said
    change the default domain and the service name, they point to .com not to the new one
    So, I removed ROCKY from ROCKY.ADMISSIONPROS.COM in the client tnsnames.ora to match the default domain in sqlnet.ora. Yes rocky.rocky is correct.

  9. #9
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    in the server tnsnames.ora you have

    ROCKY.ADMISSIONS.MVK.EDU

    and sqlnet.ora

    NAMES.DEFAULT_DOMAIN = admissions.mvk.edu

    in the client you had tnsnames.ora

    ROCKY.ADMISSIONPROS.COM

    and sqlnet.ora

    NAMES.DEFAULT_DOMAIN = admissionpros.com

    See they don't match up.


    Change the client to be ROCKY.ADMISSIONS.MVK.EDU and NAMES.DEFAULT_DOMAIN = admissions.mvk.edu

    (or just copy the entry from the server)

  10. #10
    Join Date
    Feb 2005
    Posts
    11
    # SQLNET.ORA Network Configuration File: c:\oracle\ora90\network\admin\sqlnet.ora
    # Generated by Oracle configuration tools.

    NAMES.DEFAULT_DOMAIN = ADMISSIONS.MVC.EDU
    # i tried both above and below
    # NAMES.DEFAULT_DOMAIN = ROCKY.ADMISSIONS.MVC.EDU

    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

    # TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.

    ROCKY.ADMISSIONS.MVC.EDU =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 152.10.23.196)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = rocky.rocky)
    )
    )

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