Hi gurus

I have 2 instanse having same oracle home but independent database. I am trying to have a listener first I tried with one listener file with different listener and then I tried with independent listener file with different name (started after renaming the listener.ora file) but I am getting the below result and I am unable to connect from windows client machine my tnsnames is working fine that I know notice that result and tell me what is wrong or give me different example if possible


FIRST listener dev

# cat listdev.ora
# LISTENER.ORA Configuration File:/oracle/app/product/8.1.5/network/admin/li
er.ora
# Generated by Oracle Net8 Assistant

DEV=
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROCPROD))
(ADDRESS = (PROTOCOL = TCP)(HOST = appdev)(PORT = 1521))
)

#STARTUP_WAIT_TIME_LISTENER = 0
#CONNECT_TIMEOUT_LISTENER = 10
#TRACE_LEVEL_LISTENER = 0

SID_LIST_DEV=
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME=DEV)
(SID_NAME=DEV)
(ORACLE_HOME = /oracle/app/product/8.1.5)
)
(SID_DESC =
(SID_NAME=PLSExtProc)
(ORACLE_HOME = /oracle/app/product/8.1.5)
(PROGRAM =extproc)
)

)

SECOND LISTENER DEV2

# LISTENER.ORA Configuration File:/oracle/app/product/8.1.5/network/admin/list
er.ora
# Generated by Oracle Net8 Assistant


DEV2=

(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
(ADDRESS = (PROTOCOL = TCP)(HOST = appdev)(PORT = 1599))
)

#STARTUP_WAIT_TIME_LISTENER = 0
#CONNECT_TIMEOUT_LISTENER = 10
#TRACE_LEVEL_LISTENER = 0

SID_LIST_DEV2=
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME=DEV2)
(SID_NAME=DEV2)
(ORACLE_HOME = /oracle/app/product/8.1.5)
)


(SID_DESC =
(SID_NAME=PLSExt2)
(ORACLE_HOME = /oracle/app/product/8.1.5)
(PROGRAM =extproc)
)
)
#

LSNRCTL> start dev (before starting dev2)
Starting /oracle/app/product/8.1.5/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 8.1.5.0.0 - Production
System parameter file is /oracle/app/product/8.1.5/network/admin/listener.ora
Log messages written to /oracle/app/product/8.1.5/network/log/dev.log
Listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCPROD))
Listening on: (ADDRESS=(PROTOCOL=TCP)(HOST=appdev)(PORT=1521))

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCPROD))
STATUS of the LISTENER
------------------------
Alias dev
Version TNSLSNR for Solaris: Version 8.1.5.0.0 - Production
Start Date 26-JAN-02 16:21:12
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /oracle/app/product/8.1.5/network/admin/listener.ora
Listener Log File /oracle/app/product/8.1.5/network/log/dev.log
Services Summary...
DEV has 1 service handler(s)
PLSExtProc has 1 service handler(s)
The command completed successfully
-------------------------------------------------------------------------------

$ lsnrctl start dev2

LSNRCTL for Solaris: Version 8.1.5.0.0 - Production on 26-JAN-02 16:20:48

(c) Copyright 1998 Oracle Corporation. All rights reserved.

Starting /oracle/app/product/8.1.5/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 8.1.5.0.0 - Production
System parameter file is /oracle/app/product/8.1.5/network/admin/listener.ora
Log messages written to /oracle/app/product/8.1.5/network/log/dev2.log
Listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC2))
Listening on: (ADDRESS=(PROTOCOL=TCP)(HOST=appdev)(PORT=1599))

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC2))
STATUS of the LISTENER
------------------------
Alias dev2
Version TNSLSNR for Solaris: Version 8.1.5.0.0 - Production
Start Date 26-JAN-02 16:20:48
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /oracle/app/product/8.1.5/network/admin/listener.ora
Listener Log File /oracle/app/product/8.1.5/network/log/dev2.log
Services Summary...
DEV2 has 1 service handler(s)
PLSExt2 has 1 service handler(s)
The command completed successfully

$ lsnrctl status dev

LSNRCTL for Solaris: Version 8.1.5.0.0 - Production on 26-JAN-02 16:40:46

(c) Copyright 1998 Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.198.10)(PORT=15
1))(CONNECT_DATA=(SID=dev)))
STATUS of the LISTENER
------------------------
Alias dev
Version TNSLSNR for Solaris: Version 8.1.5.0.0 - Production
Start Date 26-JAN-02 16:21:12
Uptime 0 days 0 hr. 19 min. 34 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /oracle/app/product/8.1.5/network/admin/listener.ora
Listener Log File /oracle/app/product/8.1.5/network/log/dev.log
Services Summary...
DEV has 3 service handler(s)
PLSExtProc has 1 service handler(s)
dev2 has 2 service handler(s)
The command completed successfully

---------------------------------
$ lsnrctl services dev

LSNRCTL for Solaris: Version 8.1.5.0.0 - Production on 26-JAN-02 16:42:10

(c) Copyright 1998 Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.198.10)(PORT=152
1))(CONNECT_DATA=(SID=dev)))
Services Summary...
DEV has 3 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
DISPATCHER established:0 refused:0 current:0 max:254 state:ready
D000
(ADDRESS=(PROTOCOL=tcp)(HOST=appdev)(PORT=44905))
Presentation: oracle.aurora.server.SGiopServer
PLSExtProc has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
dev2 has 2 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
DISPATCHER established:0 refused:0 current:0 max:254 state:ready
D000
(ADDRESS=(PROTOCOL=tcp)(HOST=appdev)(PORT=44956))
Presentation: oracle.aurora.server.SGiopServer
The command completed successfully
$ lsnrctl services dev2

LSNRCTL for Solaris: Version 8.1.5.0.0 - Production on 26-JAN-02 16:42:23

(c) Copyright 1998 Oracle Corporation. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC2))
Services Summary...
DEV2 has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
PLSExt2 has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
The command completed successfully