Home » RDBMS Server » Networking and Gateways » Can not see status of the Listener
Can not see status of the Listener [message #269066] Thu, 20 September 2007 11:08 Go to next message
jroracledba
Messages: 28
Registered: August 2007
Junior Member
Hi
Gurus

While i am trying to see the status of the listener from the Client from my pc, database is laocated on server,
Oracle 10.2.0, by the command
$lsnrctl status
Message 1053 not found; No message file for product=network, facility=TNSMessage


It shows me bunch of same errors with different message #s

Any help appreciated.
Re: Can not see status of the Listener [message #269067 is a reply to message #269066] Thu, 20 September 2007 11:10 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
I suspect that ORACLE_HOME is not properly defined.
Re: Can not see status of the Listener [message #269090 is a reply to message #269066] Thu, 20 September 2007 12:33 Go to previous messageGo to next message
jroracledba
Messages: 28
Registered: August 2007
Junior Member
Here is my ORACLE_HOME:

vijaya@bolivia</home/oracle/product/10.2.0/bin>echo $ORACLE_HOME
/home/oracle/product/10.2.0

Also let me tell you that all the Utilities are resided in the
$ORACLE_HOME/bin and so as i am running lsnrctl status from this location.

Does it make any difference to the execution or errors !?



Re: Can not see status of the Listener [message #269092 is a reply to message #269066] Thu, 20 September 2007 12:37 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
>While i am trying to see the status of the listener from the Client from my pc
I suspect that ORACLE_HOME is not properly defined on your PC.
Do you have Oracle client s/w installed on your PC?
Re: Can not see status of the Listener [message #269099 is a reply to message #269066] Thu, 20 September 2007 12:42 Go to previous messageGo to next message
jroracledba
Messages: 28
Registered: August 2007
Junior Member
yes i have installed Oracle Client 10g on my laptop.
do i need to set something with it?
Re: Can not see status of the Listener [message #269156 is a reply to message #269099] Thu, 20 September 2007 21:36 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello jroracledba,

Let me understand your environment:
  • computer1 ==> server with oracle database installed and running;
  • computer2 ==> your PC... with just oracle client installed;


You did from computer2 (with just oracle client installation):
lsnrctl status


Is my understanding correct?

Considering it... I will say that "lsnrctl status" command should be ran on the database server only (computer1 as above).

At client side (computer2)... you may run "tnsping <sid>" command to check if the service is up and running. Also at client side you should have already configured service name for this <sid>... to tnsping work properly.

Regards,


mson77

Re: Can not see status of the Listener [message #269820 is a reply to message #269066] Mon, 24 September 2007 14:41 Go to previous messageGo to next message
jroracledba
Messages: 28
Registered: August 2007
Junior Member
thanks for making my understanding Clear.

i did as follow from computer 2 (client side):

vijaya@bolivia</home/oracle/product/10.2.0/bin>tnsping WFM

TNS Ping Utility for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 24-SEP-2007 15:38:06

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Message 3511 not found; No message file for product=network, facility=TNSTNS-03505: Message 3505 not found; No message file for product=network, facility=TNS


But is showed me this error.Is it this ok i am running all utilities from 10.2.0/bin ????

Re: Can not see status of the Listener [message #269821 is a reply to message #269820] Mon, 24 September 2007 14:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post "env|grep ORA", "echo" is not a valid command to check environment variables.

Regards
Michel
Re: Can not see status of the Listener [message #269822 is a reply to message #269820] Mon, 24 September 2007 14:49 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello jroracledba,

Well... many things may cause this.

Consider that "tnsping" command is very similar a well known "ping" command in the computer network world.

What may cause this error?
1) Check if name service "WFM" is correct. You can check it running "netca";
2) There is allowed routing path from your PC (computer 2) until the database server (computer 1)?
3) The service WFM is up and running?

By the way: computer1 and computer2 are on local network? If not... is there some firewall that may block 1521/tcp port?

Regards,


mson77

Complement:

As anacedent and Michel Cadot said:
Please run this command below and post the result here:
env |grep ORA




[Updated on: Mon, 24 September 2007 15:14]

Report message to a moderator

Re: Can not see status of the Listener [message #269833 is a reply to message #269066] Mon, 24 September 2007 15:48 Go to previous messageGo to next message
jroracledba
Messages: 28
Registered: August 2007
Junior Member
here is the result :

vijaya@bolivia</home/oracle/product/10.2.0/bin>env | grep ora
ORACLE_HOME=/home/oracle/product/10.2.0
PWD=/home/oracle/product/10.2.0/bin


see also :
vijaya@bolivia</home/oracle/product/10.2.0/bin>ps -ef | grep smon
oracle 319522 1 0 Aug 28 - 1:13 ora_smon_WFM


and while i tried to do netca

vijaya@bolivia</home/oracle/product/10.2.0/bin>netca
****DISPLAY environment variable not set!
Oracle Net Configuration Assistant is a GUI tool
which requires that DISPLAY specify a location
where GUI tools can display.
Set and export DISPLAY, then re-run.
vijaya@bolivia</home/oracle/product/10.2.0/bin>echo $DISPLAY

What would be the Display parameter setting?
Re: Can not see status of the Listener [message #269839 is a reply to message #269833] Mon, 24 September 2007 16:23 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello jroracledba,


When I see this information...
vijaya@bolivia</home/oracle/product/10.2.0/bin>ps -ef | grep smon
oracle 319522 1 0 Aug 28 - 1:13 ora_smon_WFM
... I say that instance WFM is running in this computer.

Is this your computer or... is this the database server?


When I see:
vijaya@bolivia</home/oracle/product/10.2.0/bin>netca
****DISPLAY environment variable not set!
Oracle Net Configuration Assistant is a GUI tool
which requires that DISPLAY specify a location
where GUI tools can display.
Set and export DISPLAY, then re-run.
... I say that you don't have GUI (window; X-server) in this computer.
So you have to export the DISPLAY to some other computer that has X-Server.
Basic steps:
1) On the X-server side... allow this computer to connect issuing:
xhost +<IP_of_this_computer>

2) From this computer... tell where will be the DISPLAY (X-server) to this computer issuing:
DISPLAY=<IP_of_X-server>:0
export DISPLAY


Well... regarding your initial question:

Would you mind to tell us the whole scenario again... step by step...?

Regards,


mson77
Re: Can not see status of the Listener [message #270019 is a reply to message #269066] Tue, 25 September 2007 07:49 Go to previous messageGo to next message
jroracledba
Messages: 28
Registered: August 2007
Junior Member
Let me clear about one thing that , i am using putty session to connect with the database server and use the command there.

So i think i am working on the database server itself.,Am i correct ?
This question comes up in my mind because u were telling me some thing about computer1: Server on which database is running.
and Computer2 : the laptop on which i am working and have putty on it.

So to me i am working directly on the server where the database is resided.

If my above understanding of mine is not correct ,pl let me know.
Because thats very important to me to understand.

Thanks
Re: Can not see status of the Listener [message #270026 is a reply to message #270019] Tue, 25 September 2007 08:15 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello jroracledba,

I asked to you in may last message:
mson77 wrote:
Well... regarding your initial question:

Would you mind to tell us the whole scenario again... step by step...?
I realize that you tell us your scenario by installments.

Anyway...from your last message:
jroracledba wrote:
Let me clear about one thing that , i am using putty session to connect with the database server and use the command there.

So i think i am working on the database server itself.,Am i correct ?
Yes.
You are remotely working on the database server thru putty.
You are directly managing your database server. (Take care).

============================

Based on your information... (and YOU DON'T LIST CLEARLY YOUR SCENARIO ONCE)... I guess:
==> computer1 (server): IBM/AIX RISC System/6000
==> computer2 (your laptop): Some Microsoft Windows (because you use putty)

Also you shown:
vijaya@bolivia</home/oracle/product/10.2.0/bin>ps -ef | grep smon
oracle 319522 1 0 Aug 28 - 1:13 ora_smon_WFM
The computer1 (server) runs the database WFM. (This a text that you see from putty... accessing database server).

What you need now is:
On your laptop... on your Windows environment (not via putty):
1) Do you have oracle client software installed?
2) Did you configure name service using netca?
3) After setting oracle client, you will be able to:
C:\> tnsping WFM
from your laptop.

Regards,



mson77
Re: Can not see status of the Listener [message #270075 is a reply to message #269066] Tue, 25 September 2007 10:58 Go to previous messageGo to next message
jroracledba
Messages: 28
Registered: August 2007
Junior Member
HERE IS THE ANSWERs FOR YOUR LAST QUESTION :

1) yes i have installed the oracle 10g client.
2) Also i configured WFM via Netca
3)

C:\Documents and Settings\Administrator>tnsping WFM

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 25-SEP-2
007 11:49:22

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
C:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = bolivia.ccs.com)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SE
RVICE_NAME = WFM)))
OK (0 msec)



You understood my scenario right way. Sorry for trouble.
And Let me tell you that my question was , i perform
lsnrctl status , on the server( connecting via PuTTy).

vijaya@bolivia</home/oracle/product/10.2.0/bin>lsnrctl status

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 25-SEP-2007 11:57:14

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Message 1053 not found; No message file for product=network, facility=TNSMessage 1020 not found; No message file for product=network, facility=TNSMessage 1021 not found; No message file for product=network, facility=TNSMessage 1022 not found; No message file for product=network, facility=TNSMessage 1023 not found; No message file for product=network, facility=TNSM............etc

This is how problem started.
Also would you help me to set DISPLAY settings too.

[Updated on: Tue, 25 September 2007 11:21]

Report message to a moderator

Re: Can not see status of the Listener [message #270117 is a reply to message #270075] Tue, 25 September 2007 15:19 Go to previous message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello jroracledba,

Ok.
Then you please read de OraFAQ Forum Guide.
http://www.orafaq.com/forum/t/88153/0/
Then you post your messages formatted.
As DISPLAY is a new topic... please open a new topic... and the community will help you.

Please try to make your post readable for everyone who comes to OraFAQ. Not only for your understanding.
This little effort will surely help someone in the future.

Regards,


mson77

[edited]
By the way... DISPLAY is related with Oracle?
I have told you about DISPLAY setting in my earlier message. Read it carefully and I am sure you will understand.

[Updated on: Tue, 25 September 2007 15:33]

Report message to a moderator

Previous Topic: Net configuration assistant
Next Topic: Putty setting help needed !
Goto Forum:
  


Current Time: Wed Dec 07 20:39:33 CST 2016

Total time taken to generate the page: 0.29189 seconds