| Tnsping Error [message #556525] |
Tue, 05 June 2012 02:06  |
saagar
Messages: 79
Registered: December 2007
|
Member |
|
|
Hi
i am getting following mention error while using lsnrctl status <dbname>
<b>
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=TNSMessage 1026 not found; No message file for product=network, facility=TNSMessage 1034 not found; No message file for product=network, facility=TNSMessage 1024 not found; No message file for product=network, facility=TNSMessage 1025 not found; No message file for product=network, facility=TNSMessage 1040 not found; No message file for product=network, facility=TNSMessage 1033 not found; No message file for product=network, facility=TNSMessage 1028 not found; No message file for product=network, facility=TNSMessage 1415 not found; No message file for product=network, facility=TNS Message 1050 not found; No message file for product=network, facility=TNS
Message 1029 not found; No message file for product=network, facility=TNSMessage 1411 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1411 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS</b>
and also while doing tnsping also same
my oracle_home and SID is also get no issues with that
path also shows
echo $PATH
/u01/app/oracle/db/tech_st/11.1.0/perl/bin:/u01/app/oracle/db/tech_st/11.1.0/bin:/usr/bin:/usr/sbin:/u01/app/oracle/db/tech_st/11.1.0 /appsutil/jre/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:.:/u01/app/oracle/ db/tech_st/11.1.0/rdbms/admin:/u01/app/oracle/db/tech_st/11.1.0/OPatch/
please let me know ..how could i resolve this error
PS -- i am able to login to other database using sqlplus xx/xx@dbname of another database no issues with that
Cheers
|
|
|
|
| Re: Tnsping Error [message #556528 is a reply to message #556525] |
Tue, 05 June 2012 02:26  |
John Watson
Messages: 8963
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Which environment file did you source? Remember that you have several Oracle homes: for the database, the 10.1.2 application server, and the 10.1.3 application server. You must source the correct context file to connect to the correct Oracle home, you probably want the one called
<SID>_<hostname>.env
|
|
|
|
|
|
| Re: Tnsping Error [message #556533 is a reply to message #556528] |
Tue, 05 June 2012 03:09 |
John Watson
Messages: 8963
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
|
You say the file is there. Well, good. But did you source it? (Do you know what "source" means in this context?)
|
|
|
|
| Re: Tnsping Error [message #556536 is a reply to message #556533] |
Tue, 05 June 2012 03:18 |
saagar
Messages: 79
Registered: December 2007
|
Member |
|
|
Yes... this file is there and path is also there
PATH=" /u01/app/oracle/db/tech_st/11.1.0/bin:/usr/bin:/usr/sbin:/u01/app/oracle/db/tech_st/11.1.0/appsutil/jre/bin:/bin:/usr/bin/X11:/usr/lo cal/bin:$PATH:. "
its there in bash_profile the env file
/u01/app/oracle/db/tech_st/11.1.0/SID_HOSTANAME.env
Cheers
|
|
|
|
| Re: Tnsping Error [message #556544 is a reply to message #556536] |
Tue, 05 June 2012 03:35 |
John Watson
Messages: 8963
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Merely executing a shell script by calling it, which appears to be what you are doing, will not export any variables to your environment. This is why your PATH is wrong (what are those spaces doing? And those double quotes?) and probably other variables (ORACLE_HOME? LD_LIBRARY_PATH?) too. Google for "sourcing a shell script".
|
|
|
|
| Re: Tnsping Error [message #556547 is a reply to message #556544] |
Tue, 05 June 2012 03:57 |
saagar
Messages: 79
Registered: December 2007
|
Member |
|
|
when i do echo $PATH
echo $PATH
/u01/app/oracle/db/tech_st/11.1.0/perl/bin:/u01/app/oracle/db/tech_st/11.1.0/bin:/usr/bin:/usr/sbin:/u01/app/oracle/db/tech_st/11.1.0 /appsutil/jre/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:.:/u01/app/oracle/ db/tech_st/11.1.0/rdbms/admin:/u01/app/oracle/db/tech_st/11.1.0/OPatch/
this is the output
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
