on 04-23-2008 3:57 PM
Hi gurus,
While we were looking at SM21 (filtering by day and user DDIC) we have detected an ORA-03113 (end-of-file on communication channel) together with an ORA-27091/27072 error.
We have also detected many core dumps at DB level related to this issue.
This error occurs when initiating the system.
The data of our system are:
SAP NetWeaver 7.1
O.S.: Linux SLES 10/64 Bits
SAP Kernel: 7.1 lvl 86
Basis Support Package Level: SPS5
Oracle Version: 10.2.0.2
Can you help me?
Thanks in advanced
hI
Check Note 619172 - ORA-03113 on entering the NOMOUNT phase
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks in advanced
Hi Markus,
Thanks very much,
filesystemio_options = async.
ORACLE_HOME is /oracle/<sid>/ and filesystem of storage is /oracle/<sid>/* (/oracle/<sid>/oraarch/, /oracle/<sid>/sapdataX/, /oracle/<sid>/mirrorlogX/, /oracle/<sid>/saptrace/background/*, etc)--> Type of partition: Linux native (reiser)
Hi Shaji,
Thanks very much,
We check Note 619172 but it isn't relevant:
1 - Our parameter "background_dump_dest" points to a existing and accessible directory.
2 - Parameter IFILE not exist in init<sid>.ora
3 - O.S parameterization is correct
4 - Oracle version is 10.2.0.2 not Oracle 8.1.7
5 - O.S. is Linux not Windows
Any idea more??
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> Our filesystem not mounted with "-notail":
>
>
/dev/sdb1 /opt/sap reiserfs acl,user_xattr 1 2
>
> O.S. is SLES 10
>
>
CONCLUSION: System is up-to-date!
> found SLES-10-x86_64-current + "online updates"
So you won't be able to use directIO but it's not configured as such.
I recommend opening an OSS call under BC-DB-ORA and ask there for a suggestion what you can do to avoid the problem.
If I'd be you, I would
- install ServicePack 1 for SuSE + online updates
- create a new filesystem (reiserfs), mount that using -notail and copy all the database files over (same goes for all oracle related files (control etc.))
This will give your the possibility to use filesystemio_options=setall (which is much faster) and may also avoid other I/O related problems since this configuration is recommended if you use reiserfs.
Markus
What filesystem do you use for the storage and to what value is the parameter "filesystemio_options" set?
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.