big problem with listener

[raf]

hi,
I've installed oracle 8.1.7 server with 2 istances
IMM1
IMM2
IMM2 run correctly, but when I started IMM1 I get this error:
ORA-12541:TNS:NO LISTENER

If I stop and restart the listener IMM1 run correctly again, but when I change connect IMM1 run down again.

I run this query:
SELECT SID, SERIAL#, USERNAME, STATUS
FROM V$SESSION

when IMM1 is up the STATUS is INACTIVE

listener.ora:

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = srvimm)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = imm1)
(ORACLE_HOME = C:\oracle\ora81)
(SID_NAME = imm1)
)
(SID_DESC =
(GLOBAL_DBNAME = imm2)
(ORACLE_HOME = C:\oracle\ora81)
(SID_NAME = imm2)
)
)

The status of listener is:

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=srvimm)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Produc
tion
Start Date 22-NOV-2002 12:43:58
Uptime 0 days 2 hr. 55 min. 12 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\listener.log
Services Summary...
PLSExtProc has 1 service handler(s)
imm1 has 1 service handler(s)
imm1 has 2 service handler(s)
imm2 has 1 service handler(s)
imm2 has 3 service handler(s)
The command completed successfully

Someone could help me???

Thanks
Raf

[Tarry]

Use net8 utility to test the IMM1.
and/or do connect user/pwd@IMM1

[raf]

I tested IMM1 with net8 but I get same error ORA-12541 but if I stop and restart listener IMM1 run correctly with net8

Regards
Raf

[jovery]

Can you post the details of your tnsnames file as well.

Regards

[raf]

tnsnames.ora:

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = srvimm)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = imm2)
(PRESENTATION = http://admin)
)
)


EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

IMM2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = srvimm)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = imm2)
)
)

IMM1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = srvimm)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = imm1)
)
)

Regards
Raf

[raf]

sqlnet.ora

Fatal NI connect error 12541, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=srvimm)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=imm1)(CID=( PROGRAM=C:\Programmi\Quest Software\TOAD\TOAD.exe)))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - Production
Time: 26-NOV-2002 09:25:24
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12541
TNS-12541: TNS:no listener
ns secondary err code: 12560
nt main err code: 511
TNS-00511: No listener
nt secondary err code: 61
nt OS err code: 0

[Calvin_Qiu]

Do you mean that you get TNS-12541 whenever you connect to IMM2? What is the status of the LISTENER after failure? What appear in $ORACLE_HOME\network\log\listener.log?

[raf]

listener.log

Il file dei parametri di sistema è C:\oracle\ora81\network\admin\listener.ora
Messaggi di log registrati in C:\oracle\ora81\network\log\listener.log
Informazioni di traccia registrate in C:\oracle\ora81\network\trace\listener.trc
Il livello di traccia attuale è 0

Ascolto su: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srvimm)(PORT=1521)))
Ascolto su: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
26-NOV-2002 17:54:35 * service_register * imm2 * 0
26-NOV-2002 17:54:35 * service_register * imm1 * 0
26-NOV-2002 17:54:38 * (CONNECT_DATA=(SERVICE_NAME=imm2)(CID=(PROGRAM=C:\Programmi\ACAD2000\acad.exe)(HOST=A_ROB)(USER=afm1 ))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.50.97)(PORT=1582)) * establish * imm2 * 0
26-NOV-2002 17:54:43 * (CONNECT_DATA=(SERVICE_NAME=imm2)(CID=(PROGRAM=C:\Programmi\ACAD2000\acad.exe)(HOST=A_ROB)(USER=afm1 ))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.50.97)(PORT=1584)) * establish * imm2 * 0
26-NOV-2002 17:54:59 * (CONNECT_DATA=(SERVICE_NAME=imm1)(CID=(PROGRAM=C:\Programmi\ACAD2000\acad.exe)(HOST=A_ROB)(USER=afm1 ))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.50.97)(PORT=1588)) * establish * imm1 * 0

TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Production on 26-NOV-2002 17:55:09

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

Il file dei parametri di sistema è C:\oracle\ora81\network\admin\listener.ora
Messaggi di log registrati in C:\oracle\ora81\network\log\listener.log
Informazioni di traccia registrate in C:\oracle\ora81\network\trace\listener.trc
Il livello di traccia attuale è 0

Ascolto su: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srvimm)(PORT=1521)))
Ascolto su: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
26-NOV-2002 17:55:17 * (CONNECT_DATA=(SERVICE_NAME=imm1)(CID=(PROGRAM=C:\Programmi\ACAD2000\acad.exe)(HOST=A_ROB)(USER=afm1 ))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.50.97)(PORT=1590)) * establish * imm1 * 0
26-NOV-2002 17:55:21 * (CONNECT_DATA=(SERVICE_NAME=imm1)(CID=(PROGRAM=C:\Programmi\ACAD2000\acad.exe)(HOST=A_ROB)(USER=afm1 ))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.50.97)(PORT=1592)) * establish * imm1 * 0
26-NOV-2002 17:56:09 * service_register * imm1 * 0
26-NOV-2002 17:56:09 * service_register * imm2 * 0

TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Production on 26-NOV-2002 17:57:58

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

Il file dei parametri di sistema è C:\oracle\ora81\network\admin\listener.ora
Messaggi di log registrati in C:\oracle\ora81\network\log\listener.log
Informazioni di traccia registrate in C:\oracle\ora81\network\trace\listener.trc
Il livello di traccia attuale è 0

Ascolto su: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srvimm)(PORT=1521)))
Ascolto su: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
26-NOV-2002 17:58:09 * (CONNECT_DATA=(SERVICE_NAME=imm2)(CID=(PROGRAM=C:\Programmi\ACAD2000\acad.exe)(HOST=A_ROB)(USER=afm1 ))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.50.97)(PORT=1601)) * establish * imm2 * 0
26-NOV-2002 17:58:29 * (CONNECT_DATA=(SERVICE_NAME=imm1)(CID=(PROGRAM=C:\Programmi\ACAD2000\acad.exe)(HOST=A_ROB)(USER=afm1 ))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.50.97)(PORT=1603)) * establish * imm1 * 0
26-NOV-2002 17:58:33 * (CONNECT_DATA=(SERVICE_NAME=imm1)(CID=(PROGRAM=C:\Programmi\ACAD2000\acad.exe)(HOST=A_ROB)(USER=afm1 ))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.50.97)(PORT=1605)) * establish * imm1 * 0
26-NOV-2002 17:58:58 * service_register * imm2 * 0
26-NOV-2002 17:58:58 * service_register * imm1 * 0
26-NOV-2002 18:00:08 * (CONNECT_DATA=(SERVICE_NAME=imm2)(CID=(PROGRAM=C:\Programmi\Quest Software\TOAD\TOAD.exe)(HOST=A_MAXIM)(USER=afm1))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.51.13)(PORT=3994)) * establish * imm2 * 0
26-NOV-2002 18:00:21 * (CONNECT_DATA=(SERVICE_NAME=imm2)(CID=(PROGRAM=C:\Programmi\Quest Software\TOAD\TOAD.exe)(HOST=A_MAXIM)(USER=afm1))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.51.13)(PORT=3996)) * establish * imm2 * 0
26-NOV-2002 18:02:03 * (CONNECT_DATA=(SERVICE_NAME=imm2)(CID=(PROGRAM=C:\Programmi\Quest Software\TOAD\TOAD.exe)(HOST=A_MAXIM)(USER=afm1))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.51.13)(PORT=4000)) * establish * imm2 * 0
26-NOV-2002 18:09:00 * service_update * imm2 * 0
26-NOV-2002 18:09:01 * service_update * imm1 * 0
27-NOV-2002 09:16:36 * (CONNECT_DATA=(SERVICE_NAME=imm2)(CID=(PROGRAM=C:\oracle\ora81\bin\SQLPLUSW.EXE)(HOST=SRVIMM)(USER=A dministrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.49.247)(PORT=1531)) * establish * imm2 * 0
27-NOV-2002 09:22:41 * service_update * imm2 * 0
27-NOV-2002 09:24:05 * (CONNECT_DATA=(SERVICE_NAME=imm2)(CID=(PROGRAM=C:\Programmi\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=A_DA N)(USER=afm1))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.50.66)(PORT=4417)) * establish * imm2 * 0
27-NOV-2002 09:24:16 * (CONNECT_DATA=(SERVICE_NAME=imm2)(CID=(PROGRAM=C:\Programmi\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=A_DA N)(USER=afm1))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.50.66)(PORT=4419)) * establish * imm2 * 0
27-NOV-2002 09:25:01 * (CONNECT_DATA=(SERVICE_NAME=imm2)(CID=(PROGRAM=C:\Programmi\Quest Software\SQL Navigator 3\sqlnav3.exe)(HOST=A_DAN)(USER=afm1))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.50.66)(PORT=4421)) * establish * imm2 * 0
27-NOV-2002 09:32:43 * service_update * imm2 * 0



Regards
Raf