How to Create the boot.properties in IDCS Asserter
Problem: When you are running the weblogic in production mode and when you try to start the weblogic using nohup then there is no chance to enter the username and…
Read MoreHow to Change APEX admin password using SQL
Steps to change APEX admin password using SQL, 1. Change the current schema to the one relevant for your APEX version ALTER SESSION SET CURRENT_SCHEMA = APEX_050000; 2. Find the…
Read MoreFS_CLONE Fails with no such files or Directory ADOPValidationUtils.pm
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 MoreBacking Up a Block Volume in OCI
Description: 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 MoreRename Disk group name
Old 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
RETURNING 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 with BULK COLLECT
RETURNING 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 MoreReturning Clause in Oracle Plsql
Use 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 MoreHow to Create Manual Database in Oracle ASM File-system using Cloud Instance
Description: 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
Find 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 More