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

11k Views Asked by At

While trying to connect to Oracle database with sqlplus / as sysdba, I get the following error:

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

I am using Windows environment.

How I can correct this?

2

There are 2 best solutions below

0
On

You almost certainly do not have read access to the directories under ORACLE_HOME.

The tool is unable to generate messages because it cannot read the files.

4
On

Probably your oracle environment is not setup correctly. You need to set ORACLE_HOME and ORACLE_SID environment variables. ORACLE_HOME should point to the root directory of your client install.

Do you have your TNSNAMES.ORA configured also?

See here for similar issue: https://forums.oracle.com/forums/thread.jspa?threadID=619126