When you run adop phase=fs_clone, this will endup with the error no such files or Directory ADOPValidationUtils.pm in a minute or so, this is due to the patch context file…
Read MoreDescription: The backups feature of the Oracle Cloud Infrastructure Block Volume service lets you make a crash-consistent backup, which is a point in time snapshot of a boot volume without application interruption…
Read MoreOld disk group name : PROD New disk group name : NEWDG Check the databases are located in the Disk group srvctl config database -d clouddb Create a…
Read MoreRETURNING Clause With EXECUTE IMMEDIATE 1. Overview The RETURNING clause allows you to retrieve values of columns (and expressions based on columns) that were modified by an insert, delete…
Read MoreRETURNING Clause Using Bulk Collect 1. Overview The RETURNING clause can return multiple rows of data, in which case you will use the RETURNING BULK COLLECT INTO form.…
Read MoreUse RETURNING Clause to Avoid Unnecessary SQL Statements 1. Overview The RETURNING clause allows you to retrieve values of columns (and expressions based on columns) that were modified by an…
Read MoreDescription: The recommended method of creating your database is to use database configuration assistant (dbca). however, if you create your database manually using the create database statement, then oracle asm enables you…
Read MoreFind Database Query From the Linux PID PID=32370 select t.sql_id,t.sql_text from gv$process p , gv$session s , gv$sqlarea t where p.addr=s.paddr and s.sql_address=t.address and s.sql_hash_value=t.hash_value and p.spid = 32370;
Read MoreSELECT owner, table_name, TRUNC(sum(bytes)/1024/1024) MB FROM (SELECT segment_name table_name, owner, bytes FROM dba_segments WHERE segment_type in (‘TABLE’,’TABLE SUBPARTITION’,’TABLE PARTITION’) UNION ALL SELECT i.table_name, i.owner, s.bytes FROM dba_indexes i, dba_segments s…
Read MoreThe Output Post Processor (FNDOPP) Manager is not starting, process status is shown as Actual with 0 and the Target is 1 The OPP logfile shows the following exceptions: [UNEXPECTED] java.sql.SQLException:…
Read More