💡 No more data to read from socket Cách fix chạy 2 câu lệnh sau SQL> alter system set “_sql_plan_directive_mgmt_control” = 0; System altered. SQL> alter system set “_optimizer_dsdir_usage_control” = …
Troubleshoot
-
-
OracleTroubleshoot
Fix lỗi: “ORA-00845: MEMORY_TARGET not supported on this system” trên Oracle
by tuanlpby tuanlp💡 ORA-00845: MEMORY_TARGET not supported on this system Bạn sẽ gặp lỗi ORA-00845 nếu Shared Memory File System không đủ để cung cấp cho Instance. GIẢI PHÁP / SOLUTION Tăng Shared Memory …
-
OracleTroubleshoot
RMAN-06026: some targets not found – aborting restore, RMAN-06023: no backup or copy of datafile X found to restore
by tuanlpby tuanlp💡 While running the database error following error occurred: ERROR: RMAN> restore database; Starting restore at 15-FEB-16 using channel ORA_DISK_1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: …
-
💡 RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed standby start until change 20613783 Cause: Restore completed, However Recover database failed with RMAN-11003 ORA-00283 RMAN-03002 ORA-38760: …
-
OracleTroubleshoot
DGM-17016: failed to retrieve status for database ORA-16664: unable to receive the result from a database
by tuanlpby tuanlpCause: The network between primary and standby must be broken ERROR: ORA-16664: unable to receive the result from a database DGM-17017: unable to determine configuration status SOLUTION: Check lại …
-
ORA-16714: the value of property ArchiveLagTarget is inconsistent with the database setting ORA-16714: the value of property LogArchiveMaxProcesses is inconsistent with the database setting ORA-16714: the value of property LogArchiveMinSucceedDest …
-
ERROR: CREATE CONFIGURATION my_dg_config AS PRIMARY DATABASE IS bvtb CONNECT IDENTIFIER IS bvtb; Error: ORA-16501: The Oracle Data Guard broker operation failed. Error: ORA-16625: cannot reach database “dktb” SOLUTION: …
-
Error in invoking target ‘client_sharedlib’ of makefile ‘/u01/app/oracle/product/12.1.0.2/db_1/rdbms/lib/ins_rdbms.mk’. See Chạy câu lệnh sau yum -y install gcc or yum -y install gcc-c++
-
-
OracleTroubleshoot
[WARNING] [INS-08101] Unexpected error while executing the action at state: ‘supportedOSCheck’ 19c on Oracle Linux 8
by tuanlpby tuanlpWe have got this error while we begin the installation Of Oracle database 19c on Oracle Linux 8 Lỗi / Problem $ ./runInstaller -silent -responseFile install/response/db_install.rsp Launching Oracle Database Setup Wizard… …