I disabled all the listeners in the services and stopped Listener3.
Then I changed the listener file under Oracle Home and this is how it looks after the change

LISTENER3 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = aminocha)(PORT = 1400))
(ADDRESS = (PROTOCOL = TCP)(HOST = aminocha)(PORT = 1521))
)
)
)


SID_LIST_LISTENER3 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = Orcl8i)
(ORACLE_HOME = c:\oracle\ora81)
(SID_NAME = ORCL8i)
)
(SID_DESC =
(GLOBAL_DBNAME = aminocha)
(ORACLE_HOME = c:\ora805)
(SID_NAME = ORCL)
)

)


As you can see that now it points to both the instances.
I started the listener using the following command

C:\>lsnrctl start listener3

LSNRCTL for 32-bit Windows: Version 8.1.7.0.0 - Production on 30-APR-2001 10:23:
16

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

Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Production
System parameter file is C:\oracle\ora81\network\admin\listener.ora
Log messages written to C:\oracle\ora81\network\log\listener3.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=aminocha.herold.com)(POR
T=1400)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=aminocha.herold.com)(POR
T=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=aminocha)(PORT=1400)))
STATUS of the LISTENER
------------------------
Alias listener3
Version TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Produc
tion
Start Date 30-APR-2001 10:23:20
Uptime 0 days 0 hr. 0 min. 2 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File C:\oracle\ora81\network\admin\listener.ora
Listener Log File C:\oracle\ora81\network\log\listener3.log
Services Summary...
ORCL8i has 1 service handler(s)
ORCL has 1 service handler(s)
The command completed successfully


But still it does not allow me to connect to the orcl8i database using sqlplusw.

Thanks
Anurag



[Edited by anuragmin on 04-30-2001 at 10:30 AM]