unable to add job servere due to <ORA-12514: TNS:listener

dataservices administration
1

error adding job server


(E) (6502:2742270800) CON-120404: Initialization
                                                           OCI call <OCIServerAttach> for connection <servicename> failed: <ORA-12514: TNS:listener does not currently know of service
                                                           requested in connect descriptor>.

environment


rhel 5.8 64 bit
bods 64 bit
oracle 11g r 2 64 bti

$LINK_DIR path is set
source ./al_env.sh is executed

tnsnames.ora (tried both options servicename.localdomain & servicename in vain)


servicename =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = hostname.localdomain)(PORT = <port#>))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = servicename)
    )
  )

[/code]

listener.ora


# listener.ora Network Configuration File: /opt/app/oracle/product/11.2.0/db_dev/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = hostname.xxx)(PORT = <portno>))
    )
  )

ADR_BASE_LISTENER = /opt/app/oracle

sqlnet.ora


# sqlnet.ora Network Configuration File: /opt/app/oracle/product/11.2.0/db_dev/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

ADR_BASE = /opt/app/oracle

tnsping executes successfully
able to connect vis sqlplus & sqldeveloper using servicename or servicename.localdomain in correct syntax

:hb:

update: the only rpms that weren’t installed while installing oracle 11gr2 are:


rpm -Uvh unixODBC-devel-2.*
rpm -Uvh numactl-devel-*

any clues anyone

userb (BOB member since 2010-07-10)