-
big problem with listener
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
-
Use net8 utility to test the IMM1.
and/or do connect user/pwd@IMM1
Last edited by Tarry; 11-26-2002 at 11:11 AM.
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
-
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
-
Can you post the details of your tnsnames file as well.
Regards
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
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
-
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
-
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?
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|