Hi Network gurus,
problem is yesterday powergone. now i trying to connect ot my database. it is giving error No Listen... How to start my Listener...
before i did't the task..
please need step to start listner...
Printable View
Hi Network gurus,
problem is yesterday powergone. now i trying to connect ot my database. it is giving error No Listen... How to start my Listener...
before i did't the task..
please need step to start listner...
Platform???
Unix:
lsnrctl start
NT:
Start the listener service.
hi,
When i ping to my server it shows the alive.
but trying to start the listerner it is giving the error:
TNSLSNR for Solaris: Version 8.0.5.0.0 - Production
NL-00280: error creating log stream /export/home0/oradata/d01/app/oravis/product/805/network/log/listener.log
NL-00278: cannot open log file
SNL-00016: snlfohd: error opening file
Solaris Error: 13: Permission denied
what should i do...
Does the path /export/home0/oradata/d01/app/oravis/product/805/network/log/ exist and is it writable by the oracle account?
Is there a corrupt listener.log file in there if so you may want to rename it and try the process again
A temporary fix will be to either disable logging or to move the log to a new destination using the set options in lsnrctl
eg
Code:$ lsnrctl
LSNRCTL for Solaris: Version 9.2.0.3.0 - Production on 06-AUG-2003 09:00:21
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> set log_status off
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=itdev)(PORT=1521)))
LISTENER parameter "log_status" set to OFF
The command completed successfully
file exists and has error msgs. what should i do now..shall i rename the file ...
What are the errors?
check it out
System parameter file is /export/home0/oradata/d01/app/oravis/product/805/network/admin/listener.ora
Log messages written to /export/home0/oradata/d01/app/oravis/product/805/network/log/listener.log
Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=7)(KEY=PNPKEY))
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=13)(HOST=10.21.0.21)(PORT=1521))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
17-MAR-03 22:33:25 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=muso001)(USER=oravis))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LIST ENER)(VER
SION=134238208)) * status * 0
TNSLSNR for Solaris: Version 8.0.5.0.0 - Production on 17-MAR-03 22:39:50
(c) Copyright 1997 Oracle Corporation. All rights reserved.
System parameter file is /export/home0/oradata/d01/app/oravis/product/805/network/admin/listener.ora
Log messages written to /export/home0/oradata/d01/app/oravis/product/805/network/log/listener.log
Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=8)(KEY=PNPKEY))
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=13)(HOST=10.21.0.21)(PORT=1521))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
17-MAR-03 22:39:50 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=muso001)(USER=oravis))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LIST ENER)(VER
SION=134238208)) * status * 0
17-MAR-03 22:56:58 * ping * 0
17-MAR-03 23:05:34 * (CONNECT_DATA=(SERVICE_NAME=vis)(CID=(PROGRAM=C:\Program Files\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=VAYU)(USER
=administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.21.0.65)(PORT=3515)) * establish * vis * 12514
TNS-12514: Message 12514 not found; product=NETWORK; facility=TNS
17-MAR-03 23:06:13 * ping * 0
17-MAR-03 23:08:24 * (CONNECT_DATA=(SERVICE_NAME=vis)(CID=(PROGRAM=C:\Program Files\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=VAYU)(USER
=administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.21.0.65)(PORT=3525)) * establish * vis * 12514
TNS-12514: Message 12514 not found; product=NETWORK; facility=TNS
17-MAR-03 23:08:36 * (CONNECT_DATA=(SERVICE_NAME=vis)(CID=(PROGRAM=C:\Program Files\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=VAYU)(USER
=administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.21.0.65)(PORT=3527)) * establish * vis * 12514
TNS-12514: Message 12514 not found; product=NETWORK; facility=TNS
17-MAR-03 23:09:09 * (CONNECT_DATA=(SERVICE_NAME=vis)(CID=(PROGRAM=C:\Program Files\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=VAYU)(USER
=administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.21.0.65)(PORT=3529)) * establish * vis * 12514
TNS-12514: Message 12514 not found; product=NETWORK; facility=TNS
19-MAR-03 16:21:27 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=muso001)(USER=oravis))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LIST ENER)(VER
SION=134238208)) * status * 0
19-MAR-03 16:22:07 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=muso001)(USER=oravis))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LI STENER)(V
ERSION=134238208)) * services * 0
19-MAR-03 16:22:22 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=muso001)(USER=oravis))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LIST ENER)(VER
SION=134238208)) * status * 0
24-MAR-03 15:49:51 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client
09-MAY-03 20:14:20 * (CONNECT_DATA=(SERVICE_NAME=vis)(CID=(PROGRAM=C:\Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=HYPA-MUMWS
)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.21.0.91)(PORT=1079)) * establish * vis * 12514
TNS-12514: Message 12514 not found; product=NETWORK; facility=TNS
You do not have the right permissions! As JOVERY suggested: path /export/home0/oradata/d01/app/oravis/product/805/network/log/ is not proabbly writable by the oracle account.
As which OS user are you starting the listener?
solaris
even i am trying to status off it is giving errors..
LSNRCTL> set log_status off
Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
TNS-12224: TNS:no listener
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Solaris Error: 146: Connection refused
Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=muso001
TNS-12224: TNS:no listener
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Solaris Error: 146: Connection refused
how can solve