ORA-27101 Shared memory relam does not exist---- urgent
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-27101 Shared memory relam does not exist---- urgent

  1. #1
    Join Date
    Aug 2000
    Location
    NJ
    Posts
    54

    Angry

    Hi,
    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.

    Please help.

    Thanks,

    Geo.

  2. #2
    Join Date
    Feb 2001
    Posts
    389
    What is your shared pool size.

    Try commit=y and increase buffer variable in your import parameter file.

  3. #3
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    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.

  4. #4
    Join Date
    Aug 2000
    Location
    NJ
    Posts
    54

    Angry

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

    THanks,

    Geo.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width