07-13-2009 6:00 AM
Dear All,
Good day. I am performing Heterogeneous system refresh of an ABAP stack system (BI 7.0 system) from AIX to Linux (Suse 10) on Oracle 10g database.
Steps executed successfully :
The export of the database went through without any errors.
The export of the database was copied to the target system.
The ASCS instance was installed successfully.
Stage where the error occurs :
During the Database instance installation in the target system, the Database creation phase throws error during the completion of catproc.sql.
Log files :
The ora_sql_results.log
SQL*Plus: Release 10.2.0.4.0 - Production on Sun Jul 12 09:31:14 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
ERROR:
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 30: Read-only file system
Additional information: 9925
ORA-01075: you are currently logged on
SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus
SAPINST: End of output of SQL executing program /oracle/BWD/102_64/bin/sqlplus.
SAPINST found errors.
SAPINST The current process environment may be found in sapinst_ora_environment.log.
No errors were found in the sapinst_ora_environment.log
Once the sapinst throws error, the filesystem /oracle/<SID>/102_64 becomes read only.
When the server is bounced back the filesystem becomes normal.
The listener works fine and TNS ping is successful.
The filesystem /oracle/<SID>/102_64 is a local filesystem and is mounted as read write in the fstab.
Please let me know if any of you have solved the above error.
Regards,
Anand Raghavendran
07-13-2009 10:50 PM
This was more a Linux issue and was solved by using the option barrier=0 while mounting the local oracle filesystem.
Regards,
Anand