ORA-01031: No message file for product=RDBMS, facility=ORA

[Former Member]

Hello,

i run instance and get message:

ORA-01031: Message 1031 not found; No message file for product=RDBMS,

facility=ORA

what can i do for solving that problem?

regards

Denis

[former_member204746]

set ORACLE_HOME (as Peter suggested) and ORACLE_SID

ORACLE_SID= [SID]

such as:

ORACLE_SID=PRD

[Former Member]

I assume you run under Windows:

Check environment variable ORACLE_HOME and environment Variable Path.

Path looks something like:

PATH=c:\oracle\XXX\920\bin;<someother minor important oracle DIRs>;c:\windows;c:\windows\system32.......

ORACLE_HOME looks like:

ORACLE_HOME=c:\oracle\XXX\920 (without \bin!!!!)

If you have installed more than one Oracle_home following is important:

Your Path variable looks like following:

PATH=c:\oracle\xx1\920\bin;c:\oracle\xx2\102\bin;c:\windows;c:\windows\system32;....

if your ORACLE_HOME points now to c:\oracle\xx2\102 then you run in the problems you have documented.

you have to remove oracle\*\bin references from System environment and have to move them to the userenvironment of the affected users:

1. remove c:\oracle\xx1\920\bin;c:\oracle\xx2\102\bin; from system environment variable PATH

2. modify xx1adm's environment variable PATH to include c:\oracle\xx1\920\bin

3. modify xx2adm's environment variable PATH to include c:\oracle\xx2\102\bin

Important:

The first %ORACLE_HOME%\bin directory in PATH must be identical with %ORACLE_HOME%

regards

Peter

[Former Member]

I wish to say,

that we are using windows and oracle 10.2,

and all has been working till this morning.

variables environment are checked - all ok.

regards

Denis

Message was edited by:

Denis Yugay