Listener

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

------

[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" (I liked this part of post very much)
I thought you wud jus fire him..