Connect as SYSDBA on 11.2 Cloned Home Gives "ORA-1031: Insufficient Privileges" Error
(Doc ID 1061788.1)
Last updated on FEBRUARY 13, 2023
Applies to:
Oracle Cloud Infrastructure - Database Service - Version N/A and laterOracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Oracle11g Release 2 (11.2) database software has been cloned using the following syntax:
$ORACLE_HOME/perl/bin/perl clone.pl ORACLE_BASE="target_oracle_base" ORACLE_HOME="target_oracle_home" ORACLE_HOME_NAME="target_home_name"
After cloning has completed, connecting to a database as SYSDBA gives the following error:
ORA-01031: insufficient privileges
The $ORACLE_HOME/rdbms/lib/config.c contains the following lines:
#define SS_DBA_GRP ""
#define SS_OPER_GRP ""
#define SS_ASM_GRP ""
#define SS_OPER_GRP ""
#define SS_ASM_GRP ""
NOTE: 11.2 on Linux and HP-UX use config.c, but 11.2 on Solaris and AIX use config.s (see <Note:50507.1> for more information about this)
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 |
Cause |
Solution |
References |