| Can not see status of the Listener [message #269066] |
Thu, 20 September 2007 11:08  |
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 #269090 is a reply to message #269066] |
Thu, 20 September 2007 12:33  |
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 #269156 is a reply to message #269099] |
Thu, 20 September 2007 21:36 |
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):
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 |
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 #269822 is a reply to message #269820] |
Mon, 24 September 2007 14:49 |
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:
[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 |
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 |
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
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.
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 |
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 |
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
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:
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 |
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 |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
