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