Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to create tablespace as system user

688604Dec 10 2009 — edited Dec 18 2009
I am trying to create a temporary tablespace as system user but getting below error. Any help would be appecaiated.

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit

CREATE TEMPORARY TABLESPACE A_TEMP TEMPFILE '+ORADATA' SIZE 1G AUTOEXTEND OFF EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M

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 ./HisDbTs.pl line 132.
Could not create tablespace HIS_TEMP: 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)Tablespaces could not be created.HisDbObject done
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 15 2010
Added on Dec 10 2009
#11g, #asm, #performance-availability, #rac-asm-clusterware-installation
3 comments
3,438 views