Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: TNS listener
Your problem is in both the listener.ora (there shouldn't have been a period
in the global_dbname. It should have been <db_name>.<db_domain> where domain
usually equals world)
and in your tnsnames.ora on the server.
You don't need to use ps, instead you should use lsnrctl. Either use the
status subcommand or the services subcommand. If it starts complaining about
a password, that's in the listener.ora.
All this and similar info is also to be found on technet.oracle.com. It's
free!
Hth,
Sybrand Bakker, Oracle DBA
kev <kevin.porter_at_fast.no> wrote in message
news:378613CC.6EF3D8F9_at_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,
>
> - Kev
>
Received on Fri Jul 09 1999 - 12:45:48 CDT