Home » RDBMS Server » Networking and Gateways » Tnsping Error (Oracle 11G,Linux 5)
Tnsping Error [message #556525] Tue, 05 June 2012 02:06 Go to next message
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 Go to previous messageGo to next message
John Watson
Messages: 8922
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 #556530 is a reply to message #556528] Tue, 05 June 2012 02:38 Go to previous messageGo to next message
saagar
Messages: 79
Registered: December 2007
Member
Hi

Yes ... its there and no issues with that

Re: Tnsping Error [message #556533 is a reply to message #556528] Tue, 05 June 2012 03:09 Go to previous messageGo to next message
John Watson
Messages: 8922
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
John Watson
Messages: 8922
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 Go to previous messageGo to next message
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

Re: Tnsping Error [message #556549 is a reply to message #556547] Tue, 05 June 2012 04:01 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I give up. Perhaps someone else can help.
Re: Tnsping Error [message #559493 is a reply to message #556549] Tue, 03 July 2012 10:48 Go to previous message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Show us the output from the following command:

env | sort
Previous Topic: ORA-28035 Cannot Get Session Key for Authentication while using Radius
Next Topic: ORA-03114 and ORA-03135
Goto Forum:
  


Current Time: Thu Mar 28 11:31:16 CDT 2024