ORA-01116: error in opening database file 1
651180Aug 15 2008 — edited Aug 17 2008Well some of you guys are probably DBA’S or experienced this problem before. I can not run queries in SQLPLUS through unix. I am getting the following error, My DBA added the SYSTEM tablespace because it was 99.9% full. But It did not do it.
Any ideas will be appreciated, I am stuck. I can not run any queries (simple ones)..
Here is the error:
sqlplus recheverri/xxxxx @cmfindrel.sql
SQL*Plus: Release 10.2.0.3.0 - Production on Fri Aug 15 07:59:47 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining Scoring Engine options
Enter Object Name (% for wildcard): BWGKOADR
FROM sys.dba_source b
*
ERROR at line 7:
ORA-00604: error occurred at recursive SQL level 1
ORA-01116: error in opening database file 1
ORA-01110: data file 1: '/u01/app/oracle/oradata/PNTR/system01.dbf'
ORA-27092: size of file exceeds file size limit of the process
Additional information: 262143
Additional information: 655361