genxtb problem running ORACLE 7 in AIX

Hi,

        I am trying to use user exits in sqlforms30 on on RS6000, O/S AIX, running ORACLE Version 7. According to the instructions in Oracle Tools for Unix: Administrator's Reference Guide, I need to run genxtb <user/passwd> from the O/S prompt to create the iapxtb table. When I did that I got the following message:

GENXTB: ORA-01034: ORACLE not available
ORA-07320: smsget: shmat error when tr

The full error message when I run 'oerr ora 7320' is: 07320, 00000, "smsget: shmat error when trying to attach sga."
// *Cause: Unable to attach segment.
// *Action: Check errno. sercose[0] returns segment id. Verify segment
// exists and that permissions are correct.

But the maximum shared-memory segment size, according to the documentation, is 256M. The UNIX system administrator did a search on SHMSIZE and SHMALL and couldn't find anything on them so we are not sure how to adjust them if that's what we should do.

When I typed 'show sga' in sqldba I got:

Total System Global Area      23857912 bytes  20M
              Fixed Size         38012 bytes
           Variable Size      10548860 bytes    10M
        Database Buffers      13107200 bytes    13M
            Redo Buffers        163840 bytes

I have no problem creating and accessing tables from sqldba or sqlplus and have been running sqlforms successfully.

Thanks in advance for any help on this problem!

Jenny Barrett
email jennyb_at_uiuc.edu Received on Wed Nov 09 1994 - 22:18:35 CET