Re: TNS-01151 errors please help

Matt,

Ur listener.ora should look like this :-

LISTENER=
  (ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.2)(PORT=1521))
     (ADDRESS=(PROTOCOL=ipc)( KEY=test) )   )

SID_LIST_LISTENER=(SID_LIST=
(SID_DESC=(SID_NAME=test)(ORACLE_HOME=/usr/local/oracle))
)

Also, when u startup ur listener don't worry about ur tnsnames.ora, because lsnrctl is concerned about listener.ora.

Thanks
Sai Received on Wed Jun 23 1999 - 08:34:51 CDT