-
Listener
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...
HTML
-
Platform???
Unix:
lsnrctl start
NT:
Start the listener service.
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!
-
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...
HTML
-
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
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!
-
file exists and has error msgs. what should i do now..shall i rename the file ...
HTML
-
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!
-
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
HTML
-
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?
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
-
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: TNSrotocol 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: TNSrotocol adapter error
TNS-00511: No listener
Solaris Error: 146: Connection refused
how can solve
HTML
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
|