Skip to Content
avatar image
Former Member

Oracle error "No message file for" after Upgrade to 10.2.0.5

After upgrade from 9.2.0.8 to 10.2.0.5 i get the following error "No message file for"

(with both Users sidadm and orasid)

Platform AIX 64 bit

The installation und Upgrade with dbua works fine.

DB and SAP runs after the Upgrade.

then I tried

SQL> select xx from v$log;

select xx from v$log

*

ERROR at line 1:

ORA-00904: Message 904 not found; No message file for produstyle='font-

family:courier' ct=RDBMS,

facility=ORA; arguments: ["XX"]

The Environment is correct,

ORACLE_HOME,ORACLE_SID,PATH,LIBPATH have right Values.

I cant find any failure in Configuration or Install Logs.

So i tried the following:

Copy the complete Directorie /oracle/SID/102_64/rdbms/msg from a

10.2.0.4 Oracle Installation to the 10.2.0.5 home.

the result ist that the Messagefile could be read by Oracle an i get

the ORA-00904

Here the same Query:

SQL> select xx from v$log;

select xx from v$log

*

ERROR at line 1:

ORA-00904: "XX": invalid identifier

So I do the same procedure with an other System.

I detect:

the Patch 9952230 (SAP_102051_201011/9952230) delivers

both Message Files oraus.msg and oraus.msb which caused the problem.

Has anyone the same Problem?

Are there any other Impacts with wrong Message Files .

I raised a OSS Call, but no answer till today.

best regards

Uwe

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer