Shulou(Shulou.com)06/01 Report--

ORA-00059: maximum number of DB_FILES exceeded

It was later found that:

The db_files value is set to integer 200

RMAN > BACKUP CURRENT CONTROLFILE FORMAT'/ home/bak/20150612/cntrl_%s_%p_%t'

RMAN > BACKUP Spfile FORMAT'/ home/bak/20150612/spfile_%s_%p_%t'

Cat / home/db/oracle10g/product/10.2.0/db_1/network/admin/listener.ora

To restart the library to take effect, stop listening first:

Lsnrctl stop LISTENER1

Netstat-an | grep 11521

SQL > show parameter db_files

NAME TYPE VALUE

-

Db_files integer 200

SQL > alter system set db_files=1024 scope=spfile

System altered.

SQL > show parameter db_files

NAME TYPE VALUE

-

Db_files integer 200

SQL >

SQL > shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL > startup

ORACLE instance started.

Total System Global Area 6815744000 bytes

Fixed Size 2133456 bytes

Variable Size 3812622896 bytes

Database Buffers 2990538752 bytes

Redo Buffers 10448896 bytes

Database mounted.

Database opened.

SQL >

SQL > show parameter db_files

NAME TYPE VALUE

-

Db_files integer 1024

Lsnrctl start LISTENER1 snooping recovery

=

When shutting down the library during the tidbits, observe the alert log:

Stopping background process MMNL

Fri Jun 12 19:15:12 2015

Stopping background process MMON

Fri Jun 12 19:15:13 2015

Shutting down instance (immediate)

License high water mark = 141

Fri Jun 12 19:15:13 2015

Stopping Job queue slave processes, flags = 7

Fri Jun 12 19:15:13 2015

Job queue slave processes stopped

Fri Jun 12 19:20:12 2015

Active call for process 11403540 user 'oracle10g' program' oracle@XXDB3300'

SHUTDOWN: waiting for active calls to complete.

I waited a long time, so...

Ps-ef | grep 11403540

Oracle10 11403540 1 100 Mar 18-78207 oracleecssdb 11 oracleecssdb (LOCAL=NO)

Kill-9 11403540

The subsequent database stops normally.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.