ORA-01119 ORA-27040 Linux Error: 13

SQL> alter tablespace DRSYS add datafile '/oracletemp/drsys02.dbf' size 1000m;
alter tablespace DRSYS add datafile '/ora_data/drsys02.dbf' size 1000m
*
ERROR at line 1:
ORA-01119: error in creating database file '/oracletemp/drsys02.dbf'
ORA-27040: skgfrcre: create error, unable to create file
Linux Error: 13: Permission denied

 

解决方法：

使用root账号登陆给其/oracletemp付dba权限

使用root账号登陆

chown -R oracle.dba /oracletemp/

 

/oracle/product/10.2.0/db_1/oradata/tputf8/users01.dbf

alter tablespace TBS_TP_DAT add datafile '/oracletemp/users01.dbf'  size 500M autoextend on next 100M;

alter database datafile '/oracle/product/10.2.0/db_1/oradata/tputf8/users01.dbf' autoextend off;

create temporary tablespace TEMP2 tempfile   '/oracletemp/TEMP2.dbf' size 500m reuse autoextend on next 100m;