Error messages not displayed

[Thanos]

Hello all,

I get the following errors when I run tnsping (and lsnrctl)

#tnsping orcldb

TNS Ping Utility for Linux: Version 10.1.0.3.0 - Production on 13-JUN-2005
07:30:20

Copyright (c) 1997, 2003, 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

It seems that status/error messages aren't found, but other Oracle DB tools
works fine.
Can anyone help me in solving this issue ?

Thanks
A.

[DA Morgan]

Post by Thanos
Hello all,
I get the following errors when I run tnsping (and lsnrctl)
#tnsping orcldb
TNS Ping Utility for Linux: Version 10.1.0.3.0 - Production on 13-JUN-2005
07:30:20
Copyright (c) 1997, 2003, 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
It seems that status/error messages aren't found, but other Oracle DB tools
works fine.
Can anyone help me in solving this issue ?
Thanks
A.

Set the ORACLE_HOME environment variable.

Seems like your .profile is in need of some adjustment.

[Thanos]

Post by DA Morgan
Set the ORACLE_HOME environment variable.
Seems like your .profile is in need of some adjustment.

ORACLE_HOME is correctly set.

Actually the oracle env vars are the following:

export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/orcldb
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export ORA_NLS10=$ORACLE_HOME/nls/data
export NLS_LANG=Italian_Italy.WE8ISO8859P15
export ORACLE_SID=orcldb

Any advice ?

Thanks
A.

[Frank van Bortel]

Post by Thanos

Post by DA Morgan
Set the ORACLE_HOME environment variable.
Seems like your .profile is in need of some adjustment.

ORACLE_HOME is correctly set.
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/orcldb
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export ORA_NLS10=$ORACLE_HOME/nls/data
export NLS_LANG=Italian_Italy.WE8ISO8859P15
export ORACLE_SID=orcldb
Any advice ?
Thanks
A.

Do env|grep ORA - not a copy/paste from a .profile, or
whatever file - it does not prove anything.
Also - what user? # is root standard!

[Sybrand Bakker]

Post by Thanos

Post by DA Morgan
Set the ORACLE_HOME environment variable.
Seems like your .profile is in need of some adjustment.

ORACLE_HOME is correctly set.
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/orcldb
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export ORA_NLS10=$ORACLE_HOME/nls/data
export NLS_LANG=Italian_Italy.WE8ISO8859P15
export ORACLE_SID=orcldb
Any advice ?
Thanks
A.

ORACLE_HOME is set incorrectly.
LD_LIBRARY_PATH is set incorrectly
ORA_NLS10 will not be used, it has to be ORA_NLS33, and has been set
incorrectly.
The correct values are documented in the installation manual.



--
Sybrand Bakker, Senior Oracle DBA

[Anurag Varma]

ORA_NLS10 should be set for 10.x.x databases. ORA_NLS33 is for 8i and
9i.

Anurag

[Matthias Kleinicke]

Post by Thanos
export NLS_LANG=Italian_Italy.WE8ISO8859P15

maybe this is part of the problem. Have You tried with

NLS_LANG=American_America.WE8ISO859P1
?

Maybe the Italian language is not supported (or installed)?

greetings

Matthias

[Thanos]

Post by Matthias Kleinicke

Post by Thanos
export NLS_LANG=Italian_Italy.WE8ISO8859P15

maybe this is part of the problem. Have You tried with
NLS_LANG=American_America.WE8ISO859P1
?
Maybe the Italian language is not supported (or installed)?

I tried with American language too, but it doesn't work :-(

Thanks
A.

[HansF]

Post by Thanos
Hello all,
I get the following errors when I run tnsping (and lsnrctl)
#tnsping orcldb
TNS Ping Utility for Linux: Version 10.1.0.3.0 - Production on 13-JUN-2005
07:30:20
Copyright (c) 1997, 2003, 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

This is always an indication that you are not using an Oracle
environment. Often happens when doing an 'su -', instead of an 'su'. No
matter how much you want to swear otherwise, the most likely suspects are:

1) You have switched users and the new user is not using the environment
variables;

2) You have unset the ORACLE_HOME and ORACLE_SID variables.

Provide us with the following to help determine the problem more closely:

echo $USER
set | grep ORA

[Thanos]

Post by HansF
echo $USER
set | grep ORA

[***@webdev oracle]$ echo $USER
oracle
[***@webdev oracle]$ set | grep ORA
ORACLE_BASE=/opt/oracle
ORACLE_HOME=/opt/oracle/orcldb
ORACLE_SID=orcldb
ORA_NLS10=/opt/oracle/orcldb/nls/data
[***@webdev oracle]$

Thanks
A.

[HansF]

Post by Thanos

Post by HansF
echo $USER
set | grep ORA

oracle
ORACLE_BASE=/opt/oracle
ORACLE_HOME=/opt/oracle/orcldb
ORACLE_SID=orcldb/opt/oracle/orcldb

ORACLE_SID is messed up. Probably should be orcldb. Look in /etc/oratab
for valid values.

Post by Thanos
ORA_NLS10=/opt/oracle/orcldb/nls/data

If you did the install right, you have a routine: /usr/local/bin/oraenv
and you really, really, really want to use that instead of hardcoding your
environment variables into your profiles. Run

. oraenv

and enter the the SID at the prompt.

In your profile, replace the hardcoded variables with the following

ORACLE_SID= <<< put the correct sid here
ORAENV_ASK=NO
. oraenv

[HansF]

On Mon, 13 Jun 2005 20:06:49 +0000, HansF interested us by writing:

...

Post by HansF

Post by Thanos
ORACLE_HOME=/opt/oracle/orcldb
ORACLE_SID=orcldb/opt/oracle/orcldb

ORACLE_SID is messed up. Probably should be orcldb. Look in /etc/oratab
for valid values.

Looks like my edit messed up the SID you sent. Try the oraenv trick anyway.

Another possibility is you have partially installed oracle or attempted to
remove some subdirectories. In every case I've encountered this problem,
it's pointed back to a bad set of environment variables, a path problem
(some mismatch between the tnsping executable and the error files) or
occasionally due to a directory-based copy instead of oracle install and
not taking everything. (Losing special links when trying to get extra
space can also cause this.)

[Thanos]

Post by HansF
ORACLE_SID is messed up. Probably should be orcldb. Look in /etc/oratab
for valid values.

ORACLE_SID is correctly set to orcldb.

Post by HansF
In your profile, replace the hardcoded variables with the following
ORACLE_SID= <<< put the correct sid here
ORAENV_ASK=NO
. oraenv

I tried this solutions but it doesn't work... i get the same errors.
Any other advice ?

Thanks
A.

[Thanos]

Post by Thanos
I tried this solutions but it doesn't work... i get the same errors.
Any other advice ?

BTW, as you can see language files are present on the system (oerr returns
correct error message):

[***@webdev oracle]$ tnsping

TNS Ping Utility for Linux: Version 10.1.0.3.0 - Production on 13-JUN-2005
22:11:03

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

TNS-03502: Message 3502 not found; No message file for product=network,
facility=TNS
[***@webdev oracle]$ oerr tns 3502
03502, 00000, "Insufficient arguments. Usage: tnsping <address> [<count>]"
// *Cause: Some required command-line arguments are missing.
// *Action: Re-enter the command using the correct arguments.
[***@webdev oracle]$

Thanks
A.

[HansF]

Post by Thanos

Post by Thanos
I tried this solutions but it doesn't work... i get the same errors.
Any other advice ?

BTW, as you can see language files are present on the system (oerr returns

Guessing ... iirc, back in Oracle6, oerr looked in the Oracle Home for the
various message files. If that is still true, then an incomplete install,
or simply having copied the files from one environment to another, could
cause a similar situation.

Do you have any other oracle installations (any version, any product) on
that machine? Did the install abort at any time? Did you run all aspects
of the install, including the root.sh?

Again - everything I have ever seen around this points at a messed up
environment, usually through some poor mix 'n match of environment
variables and occasionally traced back to a mismatch between the Oracle
environment selected by the PATH being different from the one identified
by the ORACLE_SID. (That last can be created by appending the
$ORACLE_HOME/bin to an existing $PATH.)

Try a 'which tnsping' and 'whereis tnsping' to make sure you are running
the one you expect.

Try cd'ing to the directory under $ORACLE_HOME that contains tnsping and
run it from there by using ./tnsping. See if that changes things.

I have also noted that some of the recent 10g App Server stuff (such
as emctl) embeds the $ORACLE_HOME/bin (and other directories) into the
scripts found in the $ORACLE_HOME/bin - when copying from another
ORACLE_HOME, the original path is still there, messing things up royally
as the script still points at the orginal directories.


So, since I don't have a DB 10g handy, I'm guessing that another remote
possibility is to check whether tnsping is now a script which has
directories embedded. IOW - if it is a script, edit the one that should
be run to check the paths. If not as expected, I suspect some copy/move
happened that you have not discussed.

Needless to say, I give up. Let us know when/how you resolve it.

[Thanos]

On my server there is only one instance of Oracle Database 10.
Installation path is /opt/oracle/orcldb
$ORACLE_HOME/bin is correctly set and tnsping is in that directory.
if i try 'which tnsping' i get /opt/oracle/orcldb/bin/tnsping.

All functions of database works (emctl, sqlplus, etc...)! But messages are
not displayed correctly !!

:-)

Post by HansF

Post by Thanos

Post by Thanos
I tried this solutions but it doesn't work... i get the same errors.
Any other advice ?

BTW, as you can see language files are present on the system (oerr returns

Guessing ... iirc, back in Oracle6, oerr looked in the Oracle Home for the
various message files. If that is still true, then an incomplete install,
or simply having copied the files from one environment to another, could
cause a similar situation.
Do you have any other oracle installations (any version, any product) on
that machine? Did the install abort at any time? Did you run all aspects
of the install, including the root.sh?
Again - everything I have ever seen around this points at a messed up
environment, usually through some poor mix 'n match of environment
variables and occasionally traced back to a mismatch between the Oracle
environment selected by the PATH being different from the one identified
by the ORACLE_SID. (That last can be created by appending the
$ORACLE_HOME/bin to an existing $PATH.)
Try a 'which tnsping' and 'whereis tnsping' to make sure you are running
the one you expect.
Try cd'ing to the directory under $ORACLE_HOME that contains tnsping and
run it from there by using ./tnsping. See if that changes things.
I have also noted that some of the recent 10g App Server stuff (such
as emctl) embeds the $ORACLE_HOME/bin (and other directories) into the
scripts found in the $ORACLE_HOME/bin - when copying from another
ORACLE_HOME, the original path is still there, messing things up royally
as the script still points at the orginal directories.
So, since I don't have a DB 10g handy, I'm guessing that another remote
possibility is to check whether tnsping is now a script which has
directories embedded. IOW - if it is a script, edit the one that should
be run to check the paths. If not as expected, I suspect some copy/move
happened that you have not discussed.
Needless to say, I give up. Let us know when/how you resolve it.
--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** I no longer assist with top-posted newsgroup queries ***

[HansF]

Post by Thanos
On my server there is only one instance of Oracle Database 10.
Installation path is /opt/oracle/orcldb
$ORACLE_HOME/bin is correctly set and tnsping is in that directory.
if i try 'which tnsping' i get /opt/oracle/orcldb/bin/tnsping.
All functions of database works (emctl, sqlplus, etc...)! But messages are
not displayed correctly !!
:-)

If none of the messages display the way they are supposed to, then I
suspect you have a messed up installation. It ain't working the way it's
supposed to work. Probably time to reinstall. (And not just copy from
the previous installation.)

BTW ... read the final line of my sig. Bye ...

[Anurag Varma]

This should be ORACLE_HOME related.
Try setting the correct ORACLE_HOME by typing
export ORACLE_HOME=.....

Maybe there is a bad character at the end of current ORACLE_HOME
definition...?

Anurag