TNS listener

From: kev <kevin.porter_at_fast.no>
Date: Fri, 09 Jul 1999 16:22:52 +0100
Message-ID: <378613CC.6EF3D8F9@fast.no>

I'm trying to logon to an Oracle db via PHP3 (don't worry, no-one else has heard of it either, it's not important for this question) on Linux. But I get thiserror message in my browser window:

"Warning: oci8_open_server: ORA-12154: TNS:could not resolve service name in /home/httpd/html/wws/java/oratest.php3 on line 6 Connection failed "

My listener.ora file looks like this:

# Installation Generated Net8 Configuration
# Version Date: Jun-17-97
# Filename: Listener.ora

LISTENER =

  (ADDRESS_LIST =
        (ADDRESS= (PROTOCOL= IPC)(KEY= ORCL))
        (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
        (ADDRESS= (PROTOCOL= TCP)(Host= blackadder)(Port= 1521))

  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME= blackadder.)
(ORACLE_HOME= /u01/app/oracle/product/8.0.5)
(SID_NAME = ORCL)

    )
    (SID_DESC =
(SID_NAME = extproc)
(ORACLE_HOME = /u01/app/oracle/product/8.0.5)
(PROGRAM = extproc)

    )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
~

Should there be '.' after the host name? Is anything else wrong with it?

From the error message, I'm assuming there is actually a listener running. What will the process name be, so I can look for it with a 'ps' command?

Thanks,

Received on Fri Jul 09 1999 - 10:22:52 CDT