My Oracle Support Banner

"Permission Denied" using SQL*Plus as Non-Oracle User (Doc ID 845313.1)

Last updated on FEBRUARY 09, 2024

Applies to:

SQL*Plus - Version 10.2.0.3 to 11.1.0.7 [Release Oracle10g to 11.1]
Oracle Database - Enterprise Edition - Version 10.2.0.3 to 11.1.0.7 [Release 10.2 to 11.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
IBM AIX on POWER Systems (64-bit)Symptoms

New installation of Database version 11.1 on AIX 5.3 Platform.

When attempting to run SQL*Plus with a non-oracle user, the following error occurs:



-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Install Database software 11.1.
2. Run SQL*Plus as non-oracle user who does not belong to the dba unix group.
3. Error is returned.

Changes

This error does not happen with an oracle user or any user in the same unix group (dba) as oracle.

There is not any ChangePerm.sh file for release 11.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.