Prev: ORA-00054 Question
Next: ORA-1113 signalled during: alter database open
From: HansF on 13 Jun 2005 14:23
On Mon, 13 Jun 2005 07:47:02 +0200, Thanos interested us by writing:

> 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

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** I no longer assist with top-posted newsgroup queries ***
From: Anurag Varma on 13 Jun 2005 14:36

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

Anurag

From: Thanos on 13 Jun 2005 15:57
> Provide us with the following to help determine the problem more closely:
> echo $USER
> set | grep ORA

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

Thanks
A.


From: HansF on 13 Jun 2005 16:06
On Mon, 13 Jun 2005 21:57:08 +0200, Thanos interested us by writing:

>> Provide us with the following to help determine the problem more closely:
>> echo $USER
>> set | grep ORA
>
> [oracle(a)webdev oracle]$ echo $USER
> oracle
> [oracle(a)webdev oracle]$ set | grep ORA
> 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.

> ORA_NLS10=/opt/oracle/orcldb/nls/data
> [oracle(a)webdev oracle]$
>

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



--
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 13 Jun 2005 16:14
On Mon, 13 Jun 2005 20:06:49 +0000, HansF interested us by writing:

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

--
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  |  Next  |  Last
Pages: 1 2 3 4
Prev: ORA-00054 Question
Next: ORA-1113 signalled during: alter database open