Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005
    Posts
    2

    Unanswered: 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
    2

    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)
    )
    )

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •