ORA-07429 shmget() failed

[CBW]

We have a system on Unix that is suddenly not working. We cannot even sign on to Oracle because of this error. There is a message about not being able to create an audit trail. Unfortunately this is a system with no documentation so we know little about it. We are also unfamiliar with Unix but are trying to get this running so we can export to NT. Can anyone advise us how to go about fixing this problem? This is version 7.3.4.

Any advice is appreciated.

Thanks.

[marist89]

You have probably filled up sys.aud$ if you have auditing turned on. To clear out sys.aud$:
% svrmgrl
SVRMGRL> connect internal
SVRMGRL> truncate table sys.aud$

[gsprince]

try restarting the oracle instance, if feasible. Also see the environment variables for the user is set properly and the oarcle executable has the correct permissions.

[CBW]

Thanks for your help. We could not get in to the Oracle database at all on Unix so that we could use servermanager to truncate the tables. We had to go into Unix and increase the shared memory storage first. Then the truncate command worked on sys.aud$.

Thanks for the assistance.