Listener

[seshib]

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...

[jovery]

Platform???

Unix:

lsnrctl start


NT:

Start the listener service.

[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...

[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

$ 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

[seshib]

file exists and has error msgs. what should i do now..shall i rename the file ...

[jovery]

What are the errors?

[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

[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?

[seshib]

solaris

[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

[julian]

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.

[seshib]

can i have the syntax plese

[pando]

start with some user in DBA group

also.... FYI this is not a school

[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...

[pando]

Why you dont hire some knowledgeble person to do the job?

[seshib]

pandu,

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

try to understand me

[julian]

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?

[pando]

I thought I have already told you an option? Start the listener with some user in DBA group

[seshib]

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

that's y ....if you can help...please

[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?

[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

[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

------

[seshib]

pando i have su permissions...

[julian]

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 ...

[julian]

Run those two at the prompt:

whoami
cat /etc/passwd

And post the ouput of course

[seshib]

yes i did

[julian]

Originally posted by seshib
yes i did

You did what?

[seshib]

i run those scripts


is it possible to come in chat seshi_bby in yahoo msg...

[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 ?

[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..;)

[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.....

[abhaysk]

Originally posted by seshib
The listener supports no services
The command completed successfully

[jovery]

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

Is the database itself running?

[SANJAY_G]

OMG..
Sesahib,
Post your server ip and user password. Somebody will telnet and fix it. :D :D

[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..

[SANJAY_G]

su - oracle
#check whether ORACLE_SID is set, if not set it to your SID.
svrmgrl
connect internal
startup

[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

[marist89]

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?

[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?

[marist89]

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

[leviathan]

Hahaha

or is it??

I mean, come on, I'm not the brightest guy nor have the most DBA experience in here but I could probably figure this out. Oh well, sure hope this is a prank.

[jovery]

Originally posted by leviathan
Oh well, sure hope this is a prank.

The sad thing is it probably isn't :rolleyes: