system user is unable to access ASM, but sys can.
I have run into a issue which has me stumped. The other day we re-created one of our databases, and tried to load our schema into it. the tool we
use for this connects to the database as system. It almost immediately errors out because the system user cannot create a tablespace.
DBD::Oracle::db do failed: ORA-01119: error in creating database file '+ORADATA'
ORA-17502: ksfdcre:4 Failed to create file +ORADATA
ORA-15055: unable to connect to ASM instance
ORA-01031: insufficient privileges
ORA-15055: unable to connect to ASM instance
ORA-01031: insufficient privileges (DBD ERROR: OCIStmtExecute) [for Statement "CREATE TEMPORARY TABLESPACE HIS_TEMP TEMPFILE '+ORADATA' SIZE 1G AUTOEXTEND OFF EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M "] at /home/p/sys/shhis/HisDbTs.pl line 131.
DBD::Oracle::db do failed: ORA-01119: error in creating database file '+ORADATA'
ORA-17502: ksfdcre:4 Failed to create file +ORADATA
ORA-15055: unable to connect to ASM instance
ORA-01031: insufficient privileges
ORA-15055: unable to connect to ASM instance
ORA-01031: insufficient privileges (DBD ERROR: OCIStmtExecute) [for Statement "CREATE TEMPORARY TABLESPACE HIS_TEMP TEMPFILE '+ORADATA' SIZE 1G AUTOEXTEND OFF EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M "] at /home/p/sys/shhis/HisDbTs.pl line 131.
0