strange HP-UX 13 with oracle

[kholikt]

Hi,

I have a very strange problem sometimes we get this error message. We have checked all the permission, and all oracle related staff but do not have any finding.

Strange thing is this happened intermittent at night. We was told it could be shared memory related problems. Last time it happened about few months ago. Sometime it happened once a month

Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.4.0 - 64bit Production

SVRMGR> ORA-09925: Unable to create audit trail file
HP-UX Error: 13: Permission denied
Additional information: 9925
ORA-01017: invalid username/password; logon denied
SVRMGR> SVRMGR> ORA-01012: not logged on
SVRMGR> Server Manager complete.

[T G Manikandan]

The problem should be either the dir/file system is filled up by the audit trial logs.

Of either the dir is not available as defined in the init.ora file for
"audit_file_dest"

Also check for the permissions of the folder.
Also check the user by which you have logged into.Most probably u should log in as the dba so that the dir permissions are valid.

Make sure that you point the audit_file_dest location to the existing dir and the directory has permissions.

[Steven E. Protter]

This isn't strange, this is permissions.

You may be using the wrong user to start the database.

Or permissions on the file or directory may be wrong.

But you say you checkd.

Give me the following data:

output from the id command on the user you are starting the database with.

ll on the file in question and the directory.

I know you checked but another pair of eyes never hurts right? Even better, get a fresh pair of eyes in your shop to take a peak.


SEP

[Graham Cameron_1]

You say you have checked all permissions and so it must be something else, expecially if this is intermittent.

There is a report of this on metalink Note:1018924.102.

In case you don't have metalink access, a synopsis (ie paste!!) follows:

Solution Description -------------------- Have your UNIX sysadmin run fsck against the filesystem, unmount and mount the filesystem. Explanation ----------- There is an error in the status of the filesystem and it needs to be corrected so that writes to the audit directory will succeed. fsck audits and interactively repairs inconsistent file system conditions. If the file system is inconsistent the default action for each correction is to wait for the user to respond yes or no. If the user does not have write permission fsck defaults to a no action. Some corrective actions will result in loss of data. The amount and severity of data loss may be determined from the diagnostic output.

Hope this helps.

-- Graham

[Andy Beal]

I get this error when my oracle binaries disk fills up, such as leaving trace enabled on my developers box. A quick search on metalink, theres lots of issues with persons using alternate accounts rather than oracle to run sqlplus.

Could also be that the $ORACLE_HOME filesystem is mounted with nosuid.

[kholikt]

Just wondering one thing.

How about a shared memory issue? I have four instance running on this box.

However, only this instance having this problem.

We have checked all the permission and usage of oracle binary. I am very sure that there is no evidence of usage problem.

This thing happened intermittenly it could be 6 months it could be 3 months and it could be 1 month. We have this offline backup running everyday. Even we don't do any thing the next day backup is okay again.

I guess there must be some sort of shared memory issue.

Just wondering what parameter I need to monitor for this server.