Prev: ORA-00054 Question
Next: ORA-1113 signalled during: alter database open
From: Anurag Varma on 13 Jun 2005 17:30

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

From: Thanos on 14 Jun 2005 03:22

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(a)telus.net> ha scritto nel messaggio
news:pan.2005.06.13.21.05.08.47344(a)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 ***


From: HansF on 14 Jun 2005 09:50
On Tue, 14 Jun 2005 09:22:52 +0200, Thanos interested us by writing:

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

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** I no longer assist with top-posted newsgroup queries ***
First  |  Prev  | 
Pages: 1 2 3 4
Prev: ORA-00054 Question
Next: ORA-1113 signalled during: alter database open