When you are backing up with Data Pump (expdp), it may indicate that the privileges are insufficient and may end with errors such as ORA-39127, …
Read More »ORACLE
ADR Command Interpreter(ADRCI)
ADR Command Interpreter (ADRCI) is a command-line tool in the fault detection infrastructure of Oracle databases. With ADRCI; We can see the diagnostic data in …
Read More »Oracle Flashback Query
Oracle Flashback Query allows us to query as much as possible of the past committed data. We can query the data in the past …
Read More »ORA-00600 qcisSetPlsqlCtx
Depending on the timezone differences ORA-00600 error can be occured when opening the database. The argument for this error is [qcisSetPlsqlCtx: tzi init], which …
Read More »ACFS-9459 while acfsdrivestate supported command OS version ‘unknown’
For ACFS-9459 errors when you work on ACFS drivers, you can apply the following solution if the version is ‘unknown’. Do not implement this …
Read More »Running DDL Command on Remote Database With Database Link
The DDL command cannot be executed directly with the database link on the remote database. If it is run, it will cause the error …
Read More »How To Add Email Notification for Scheduled Job
It is possible to define the email notification for the scheduled job. An e-mail can be sent when a job-related event occurs. The following …
Read More »How To Move a Datafile in the File System to the ASM Disk Group
Files that are created accidentally or deliberately in the file system in a database that uses ASM often cause problems. In particular, a file …
Read More »How To Change the Size of the ACFS File System Online
We can change the size of the ACFS file system online without requiring any umount or disable volume. We use the acfsutil tool for …
Read More »How To Solve “gcs log flush sync” Wait Event
In busy databases you may encounter this wait event. The general reason is the low redo log I/O performance or the slow interconnect connection. …
Read More »