Re: Error messages not displayed

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 !!

:-)

"HansF" <News.Hans_at_telus.net> ha scritto nel messaggio news:pan.2005.06.13.21.05.08.47344_at_telus.net...
> On Mon, 13 Jun 2005 22:27:50 +0200, Thanos interested us by writing:
>
> >> 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):
>
> 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 ***
Received on Tue Jun 14 2005 - 02:22:52 CDT