今天在一数据库中新建一表空间时抛如下异常:
ORA-00059: maximum number of DB_FILES exceeded
赶紧做了下查询,见如下查询:
C:Documents and Settingsshiyihai>sqlplus /nolog
SQL*Plus: Release 9.2.0.6.0 - Production on 星期五 1月 26 16:34:40 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn / as sysdba
ERROR:
ORA-12560: TNS: 协议适配器错误
SQL> host set ORACLE_SID=PORTAL
SQL> conn / as sysdba
ERROR:
ORA-12560: TNS: 协议适配器错误
SQL> host net start oracleserviceportal
OracleServicePORTAL 服务正在启动 .
OracleServicePORTAL 服务已经启动成功。
SQL> conn / as sysdba
已连接到空闲例程。
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 135864308 bytes
Fixed Size 454644 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 1191936 bytes
数据库装载完毕。
数据库已经打开。
SQL>
SQL> select count(*) from dba_data_files;
COUNT(*)
----------
200
SQL> show parameter db_files
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_files integer 200
SQL> alter system set db_files=1024 scope=spfile;
System altered.
SQL>
即可.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/38542/viewspace-893869/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/38542/viewspace-893869/