ORA-00312: Message 312 not found; Solution
Applies to: Oracle Server – Enterprise Edition – Version: 18.104.22.168.0
This problem can occur on any platform.
When NLS_LANGUAGE is set to ENGLISH and NLS_TERRITORY is set to AUSTRALIA, the text related to Archival messages are not displayed. The following contents are shown in the Alert log :
Errors in file /smartdi/d03/oracle/SMTRMAN/admin/bdump/smtrman_arc0_659582.trc:
ORA-16014: Message 16014 not found; No message file for product=RDBMS,facility=ORA;
ORA-00312: Message 312 not found; No message file for product=RDBMS,facility=ORA;
But when its set back to NLS_LANGUAGE=AMERICAN and NLS_TERRITORY=AMERICA it works fine.
Bug 4600519 ” MESSAGE NOT FOUND ERRORS WHEN NLS_LANGUAGE IS SET TO ENGLISH ”
The reason is due to the missing oragb.msg/oragb.msb files and oraau.msg/oraau.msb files.
When the NLS_LANGUAGE is set to ENGLISH, Oracle looks out for the message file oragb.msg/oragb.msb
which it was not able to find and hence the behaviour.
Navigate to $ORACLE_HOME/rdbms/mesg and copy the message files ” oraus.msb/oraus.msg ” to ” oragb.msb/oragb.msg ”
$ cp oraus.msb oragb.msb
$ cp oraus.msg oragb.msg