I run 64bit Oracle 8.1.7 on IBM AIX 4.3.3
I followed all Oracle supplied instructions while installing.
The server has a memory of 8Gb and I alloted SGA to be 2GB.
I was importing a 4GB table into the database and during import, the database crashed with the following erors:
ORA-01034 Oracle not available
ORA-27101 : shared memory realm does not exist.
IBM AIX RISS System/6000 erro: 2 no such file or directory.
I checked the alertlog
here it goes:
CKPT terminiating instance due to error 1110.
Instance terminated by CKPT.
Trc file in bdump:
Error 1110 detected in backgruod process.
What is your shared pool size.
Try commit=y and increase buffer variable in your import parameter file.
Verify ORA-1110. This error is with regards to a particular dbf, most probably, the dbf which was being written to. CKPT could not be performed on this dbf and therefore the instance was terminated.
Thanks for replying.
I used COMMIT =Y as this is a 4GB dmp file.
Oracle software is installed on mount point /u01 with large files support disabled (this should not matter as I am not putting any dat file on /u01.
The particualer datafiles are residing on a NAS (EMC IP4700)
Could that be a problem I had no other option to use this NAS
In addition this I tried importing the same dmp on toa sun machine with 256 MG of memory and 100 MB SGA. It weas slow but import was complete.
What could be the problem with the AIX server ???
Click Here to Expand Forum to Full Width