Troubleshoot

💡 How do identify a transport error in a Data Guard setup using the broker If the broker has been setup, check the configuration basics: dgmgrl / show configuration; Configuration …

 Error log: SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: ‘/u01/app/oracle/oradata/RTS_NEW/system_new.dbf’ …

 Dùng netca tạo nó báo lỗi: Use another port number The information provided for this listener is currently in use by other software on this computer. You can proceed with …

 💡 I faced “ORA-39213: Metadata processing is not available” error during data pump import as below. impdp “‘/ as sysdba’” directory=EXPORT dumpfile=RTLS_FULL_10-09-2018_GECIS.DMP full=Y logfile=RTLS_FULL_IMP_10-09-2018_GECIS.LOG cluster=no parfile=imp.par Import: Release 12.1.0.2.0 – …

💡 While running the database error following error occurred: ERROR: RMAN-03009: failure of Control File and SPFILE Autobackup command on ch00 channe l at 08/16/2018 04:53:13 ORA-19504: failed to create …

 Xử lý như sau sqlplus sys/sysdba as sysdba 1. SQL> startup mount; 2. SQL>show parameter undo NAME TYPE VALUE ———————————— ———– —————————— undo_management string AUTO undo_retention integer 900 undo_tablespace string …

💡 Khi resize datafile để giải phóng datafile bị thừa thì xuất hiện lỗi ORA-03297: file contains used data beyond requested RESIZE value 🚚 Solution Chạy câu lệnh sau để …

  🚚 When trying to connect to an Oracle database, you might run into this error: ORA-01045: user xxx lacks CREATE SESSION privilege; logon denied The reason is that the …

💡 RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process Cause: The archive logs seems that it is not yet applied in the standby database. Select …

💡 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” = …