ORA-00059的異常處理

今天在一資料庫中新建一表空間時拋如下異常:
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>
即可.

[@more@]