Skip to main content

ORA-00059 - maximum number of db_files exceeded : FIX

 There is an easy fix for the below issue.


Try to shutdown the Database first.

Go to the oracle pfile location

edit init.ora file with the below code

DB_FILES=999

and save the file 

startup mount;


it should be able to start with out having this error. its a simple fix. 

Comments

Post a Comment

Popular posts from this blog

Warning: long redo log write elapsed times detected, the LG* process tracefiles have more details

Warning: long redo log write elapsed times detected, the LG* process tracefiles have more details This warning means LGWR / LGnn background processes are taking too long to write redo to the online redo logs. It is usually related to one of these: - Slow storage / high I/O latency on redo log disks - Redo logs placed on busy disks together with datafiles, FRA, archive logs, backups, or OS files - Too many commits from the application, causing frequent LGWR flushes - Redo log size too small, causing frequent log switches - CPU scheduling issue, where LGWR is not getting CPU quickly - Data Guard synchronous transport delay, if using SYNC/AFFIRM - In newer 19c RU versions, especially around 19.28, this warning can appear more visibly because of diagnostic changes, so first confirm whether there is a real performance impact before changing anything. - Oracle’s own wait-event documentation says log file sync is the foreground wait for redo write confirmation after commit, and log file paral...
Post a Comment
Read more

ORACLE AUDIT VAULT - UPDATE FROM 20.14 to 20.17.

 We can update the Oracle Audit Vault using the same configuration and we require to follow the below commands. firstly you need to download the Oracle Audit Vault patches. -- first need to update the new network environment using below commands.   vi /usr/local/dbfw/etc/dbfw.conf    - change GATEWAY to 192.168.128.255 and host ip to 192.168.128.50  - remove syslog ip from both records.  SYSLOGDEST="192.168.10.1" SYSLOGDEST="192.168.10.1:4444"  /usr/local/dbfw/bin/priv/configure-networking you can check the current status of the below command. [oracle@auditvault-testvm ~]$ rpm -qa | grep -i avs  [root@auditvault-testvm bin]# rpm -qa | grep -i avs avs-database-2-19.27.0.0.0-0.x86_64 avs-database-19.27.0.0.0-0.x86_64 avs-bootstrap-20.17.0.0.0-0_260303.0015.noarch bootstrap-avs-dependencies-20.17.0.0.0-0_260303.0015.noarch avs-dbsat-20.14.0.0.0-0_250520.0400.x86_64 bootstrap-avs-application-20.14.0.0.0-0_250520.0400.noarch avs-apex-20.14.0.0.0-0_2505...
Post a Comment
Read more

Test NETWORK interface using iperf3

 C:\iperf3.5_64>iperf3 -c 172.168.1.100 warning: Ignoring nonsense TCP MSS -13312 Connecting to host 172.168.1.100, port 5201 [  5] local 192.168.8.101 port 52570 connected to 172.168.1.100 port 5201 [ ID] Interval           Transfer     Bitrate [  5]   0.00-1.00   sec  6.88 MBytes  57.5 Mbits/sec [  5]   1.00-2.00   sec  3.50 MBytes  29.4 Mbits/sec [  5]   2.00-3.00   sec  4.00 MBytes  33.5 Mbits/sec [  5]   3.00-4.01   sec  6.25 MBytes  52.0 Mbits/sec [  5]   4.01-5.00   sec  4.75 MBytes  40.2 Mbits/sec [  5]   5.00-6.01   sec  5.50 MBytes  45.9 Mbits/sec [  5]   6.01-7.01   sec  5.88 MBytes  49.1 Mbits/sec [  5]   7.01-8.00   sec  5.25 MBytes  44....
Post a Comment
Read more