Lỗi khi startup database trên con standby SQL> startup ORACLE instance started. Total System Global Area 1912602624 bytes Fixed Size 2925792 bytes Variable Size 1191185184 bytes Database Buffers 704643072 bytes …
Category:
Troubleshoot
-
-
This was caused by reusing ASM disks from a previous installation of GI. Remedied this with the following commands: [root@redfern1 ~]# dd if=/dev/zero of=/dev/sda1 bs=32768 count=32768 conv=notrunc oflag=direct 32768+0 records …
-
ORA-1653: unable to extend table HR.TEST by 8192 in tablespace DATA_1 An error occurs during the insertion operation: ORA-1653: unable to extend table HR.TEST by 8192 in tablespace DATA_1 Error: …
-
-
OraclePerformance TuningTroubleshoot
Check maximum utilization of open cursor in Oracle
by tuanlpby tuanlpFor error: ORA-01000: maximum open cursors exceeded ORA-00604: error occurred at recursive SQL level 1 Check the session which causes the issue: select a.value, s.username, s.sid, s.serial# from v$sesstat a, …
-
Error: ORA-00018 maximum number of sessions exceeded SQL> drop table test; drop table test * ERROR at line 1: ORA-00018: maximum number of sessions exceeded Cause: Maximum number of session …
-
Error ORA-04031: unable to allocate nnn bytes of shared memory Solution Need to add more memory to the Shared pool area. Check the size of memory allocate to shared_pool_size, shared_pool_reserved_size …
-
OracleTroubleshoot
ORA-16397: statement redirection from Oracle Active Data Guard standby database to primary database failedWhat is Active DataGuard DML Redirection?
by tuanlpby tuanlpError: Following error occurred during insert/DML operation on the Standby side of Active Dataguard in Oracle. On Standby Database: [oracle@orcl19c ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 – Production …
-
OracleTroubleshoot
ORA-16198: Timeout incurred on internal channel during remote archival Dataguard
by tuanlpby tuanlpERROR: Redo transport problem detected: redo transport to database orcl has the following error: ORA-03111: break received on communication channel Redo transport problem detected: redo transport to database orcl …
-
Getting following warning in one of the standby server in Dataguard environment: Error: ORA-16853: apply lag has exceeded specified threshold On Oracle ORA ERROR C:\Oracle>oerr ora 16853 16853,0000, “apply lag …