cancel
Showing results for 
Search instead for 
Did you mean: 

Error connecting to database

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

hI

Check Note 619172 - ORA-03113 on entering the NOMOUNT phase

Answers (2)

Answers (2)

Former Member
0 Kudos

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??

markus_doehr2
Active Contributor
0 Kudos

Is this SLES 10 SP1? Check with


SPident

Is the reiser filesystem mounted with "-notail" and were the filesystems mounted with that option at time of creation (check metalink 399764.1)?

Markus

Former Member
0 Kudos

Hi Markus,

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"

Thanks in advance

markus_doehr2
Active Contributor
0 Kudos

> 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

markus_doehr2
Active Contributor
0 Kudos

And check

Note 914177 - File system reiserfs Oracle parameter filesystemio_options

That's what you need

Markus

markus_doehr2
Active Contributor
0 Kudos

What filesystem do you use for the storage and to what value is the parameter "filesystemio_options" set?

Markus