Listener

Printable View

Show 40 post(s) from this thread on one page

08-06-2003, 03:23 AM
seshib

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...
08-06-2003, 03:42 AM
jovery

Platform???

Unix:

lsnrctl start

NT:

Start the listener service.
08-06-2003, 03:47 AM
seshib

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...
08-06-2003, 04:01 AM
jovery

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
08-06-2003, 04:29 AM
seshib

file exists and has error msgs. what should i do now..shall i rename the file ...
08-06-2003, 04:33 AM
jovery

What are the errors?
08-06-2003, 04:35 AM
seshib

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
08-06-2003, 05:13 AM
julian

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?
08-06-2003, 05:14 AM
seshib

solaris
08-06-2003, 05:15 AM
seshib

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
08-06-2003, 05:21 AM
julian

Quote:

Originally posted by seshib
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

I told you: give the write privileges to the user trying to write to that log directory. With CHMOD.
08-06-2003, 05:26 AM
seshib

can i have the syntax plese
08-06-2003, 05:37 AM
pando

start with some user in DBA group

also.... FYI this is not a school
08-06-2003, 05:40 AM
seshib

pandu,

I know this not school ,but i am never face the problem like this.. and i am new to this env...if you solution then give or simply sit
we are in tence to solve the problem...
08-06-2003, 05:46 AM
pando

Why you dont hire some knowledgeble person to do the job?
08-06-2003, 05:50 AM
seshib

pandu,

If you have capable to solve the problem let me know i am very greatful to you...really...

try to understand me
08-06-2003, 05:51 AM
julian

Quote:

Originally posted by seshib
pandu,

I know this not school ,but i am never face the problem like this.. and i am new to this env...if you solution then give or simply sit
we are in tence to solve the problem...

Well, you seem not to react to what I am telling you. And Pando is right, why don't you get someone locally to fix that for you?
08-06-2003, 05:51 AM
pando

I thought I have already told you an option? Start the listener with some user in DBA group
08-06-2003, 05:53 AM
seshib

No one is here now to fix the problem...at anycost i have to do...

that's y ....if you can help...please
08-06-2003, 05:59 AM
jovery

As Julian/Pando have said have you tried starting the listener as a user in the dba group, is the message the same? does the error still occur?
08-06-2003, 06:05 AM
pando

let me take a guess

You dont even know what we are talking about when we say dba group right? DBA groups in UNIX not dbaroups in your company (if there is any) g
08-06-2003, 06:22 AM
seshib

yes...

when i am trying to set the log_status off it gives error...

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

------
08-06-2003, 06:28 AM
seshib

pando i have su permissions...
08-06-2003, 06:38 AM
julian

Quote:

Originally posted by pando
let me take a guess

You dont even know what we are talking about when we say dba group right? DBA groups in UNIX not dbaroups in your company (if there is any) g

:-))

Probably so ...
08-06-2003, 06:41 AM
julian

Run those two at the prompt:

whoami
cat /etc/passwd

And post the ouput of course
08-06-2003, 06:54 AM
seshib

yes i did
08-06-2003, 06:56 AM
julian

Quote:

Originally posted by seshib
yes i did

You did what?
08-06-2003, 07:01 AM
seshib

i run those scripts

is it possible to come in chat seshi_bby in yahoo msg...
08-06-2003, 07:04 AM
seshib

after changing the permission of my listener.log file, i started the service it gives output like this...

Starting /export/home0/oradata/d01/app/oravis/product/805/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 8.0.5.0.0 - Production
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))

Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 8.0.5.0.0 - Production
Start Date 06-AUG-03 16:29:36
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /export/home0/oradata/d01/app/oravis/product/805/network/admin/listener.ora
Listener Log File /export/home0/oradata/d01/app/oravis/product/805/network/log/listener.log
The listener supports no services
The command completed successfully
------

when i try to connect to database it shows no listener.

why ?
08-06-2003, 07:28 AM
abhaysk

Pando, I wonder how you have patiently seen all these post :-)

Especially when he thought ur name & adressed "PANDU" :D (I liked this part of post very much)
I thought you wud jus fire him..;)
08-06-2003, 07:38 AM
seshib

thanks for your patiency...listener stated but new problem came while connecting to database it give error oracle not found...

no need to fine guys...u are all expeirnced....once i cleared this doubt then i can help those guys who face the problem..i thought u people only entertine ...not do such helps. who face problems in tense...time comes for all...

this is not for all ...this is for who feel that we are great.....
08-06-2003, 08:00 AM
abhaysk

Quote:

Originally posted by seshib
The listener supports no services
The command completed successfully
08-06-2003, 08:11 AM
jovery

Did you start the listener as a user who is a member of the dba group?

Is the database itself running?
08-06-2003, 08:21 AM
SANJAY_G

OMG..
Sesahib,
Post your server ip and user password. Somebody will telnet and fix it. :D :D
08-06-2003, 09:51 AM
seshib

hi sanjay,

I checked wiht the server with ps -ef | grep pmon...database was not started...

just i want to start the database on solaris box...why i am little bit feared is if anything goes wrong i have to answer that's y...it is very complecated database..

just give me advise...how to start the database on solaris box..
08-06-2003, 09:57 AM
SANJAY_G

Code:

su - oracle #check whether ORACLE_SID is set, if not set it to your SID. svrmgrl connect internal startup
08-06-2003, 10:03 AM
seshib

is it possible to come on chat
please

id is seshi_bby ----yahoo msgr..

i check $env

$ env
DOMAIN=xoriant.com
HOME=/export/home0/oravis
HZ=100
LD_LIBRARY_PATH=/export/home0/oradata/d01/app/oravis/product/805/lib:/usr/dt/lib:/usr/openwin/lib:/export/home0/oradata/d01/app/or
avis/product/805/ows/3.0/lib:/export/home0/oradata/d01/app/oravis/product/805/ows/3.0/omx/lib:/export/home0/oradata/d01/app/oravis
/product/805/lib
LOGNAME=oravis
MANPATH=/export/home0/oradata/d01/app/oravis/product/805/ows/3.0/omx/man:/export/home0/oradata/d01/app/oravis/product/805/ows/3.0/
omx/man
NLS_DATE_FORMAT=DD-MON-RR
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
NLS_NUMERIC_CHARACTERS=.,
NLS_SORT=binary
ORACLE_BASE=/export/home0/oradata/d01/app/oravis
ORACLE_HOME=/export/home0/oradata/d01/app/oravis/product/805
ORACLE_SID=VIS
ORAWEB_ADMIN=/export/home0/oradata/d01/app/oravis/product/805/ows/admin
ORAWEB_HOME=/export/home0/oradata/d01/app/oravis/product/805/ows/3.0
ORAWEB_SITE=website30
ORA_NLS=/export/home0/oradata/d01/app/oravis/product/805/ocommon/nls/admin/data
ORA_NLS33=/export/home0/oradata/d01/app/oravis/product/805/ocommon/nls/admin/datad2k
PATH=/export/home0/oradata/d01/app/oravis/product/805/bin:/usr/ccs/bin:/usr/sbin:/export/home0/oradata/d01/app/oravis/local/java/j
re1.1.6/bin:/export/home0/oradata/d01/app/oravis/product/805/bin:/usr/ccs/bin:/usr/sbin:/export/home0/oradata/d01/app/oravis/local
/java/jre1.1.6/bin:/usr/bin:/usr/ucb:/etc:.:/export/home0/oradata/d01/app/oravis/product/805/ows/3.0/bin:/export/home0/oradata/d01
/app/oravis/product/805/ows/3.0/bin:/export/home0/oradata/d01/app/oravis/admin/VIS/scripts
SHELL=/bin/sh
TERM=vt220
TNS_ADMIN=/export/home0/oradata/d01/app/oravis/product/805/network/admin
TZ=GMT+5
-------------

this is env setup
08-06-2003, 10:37 AM
marist89

Quote:

Originally posted by seshib
is it possible to come on chat
please

id is seshi_bby ----yahoo msgr..

Sure, I'll do it. How does US$25/min sound?
08-06-2003, 11:36 AM
stecal

Okay, game over. No one is this dense. It is Mr. Hanky jerking your chain. Funny guy, that Mr. Hanky. Or is this like Candid Camera for the Internet? Where is the camera?
08-06-2003, 11:38 AM
marist89

Ahhh, Mr. H. just trying to shake things up... Now it all makes sense...

Show 40 post(s) from this thread on one page