Why installation of the cvuqdisk RPM for Linux is required ?

If you do not use an Oracle Database Preinstallation RPM, and you want to use the Cluster Verification Utility, then you need to install the cvuqdisk RPM. Without cvuqdisk, Cluster Verification Utility cannot discover shared disks, and you receive the error message "Package cvuqdisk not installed" when you run Cluster Verification Utility.Use the cvuqdisk RPM … Continue reading Why installation of the cvuqdisk RPM for Linux is required ?

Check Parameter Values in a Parameter File i.e spfile

strings $ORACLE_HOME/dbs/spfileOEMCDB.ora | grep open*.open_cursors=300 ·      Execute an ALTER SYSTEM SET … SCOPE=SPFILE statement to update a server parameter file ·      Execute an ALTER SYSTEM RESET … SCOPE=SPFILE statement to remove a parameter from a server parameter file, causing the default value to take effect the next timeyou start an instance of the database. Happy … Continue reading Check Parameter Values in a Parameter File i.e spfile

Installing Oracle Enterprise Manager Cloud Control 13.5

1.. Login to server as OEM Installtion user. 1.1 Navigate to location of OEM software and then execute ./em13500_linux64.bin Note: - There is no requirement on unzipping. It will extract binaries and start installation GUI prompt. 2.. Installation Types: - Select Advanced  and click on Next Tab Note: -   Small: - Meant for demonstration … Continue reading Installing Oracle Enterprise Manager Cloud Control 13.5

Oracle Database 19c Installation on Oracle Linux 7

1.. Navigate to software location and unzip it unzip -qq LINUX.X64_193000_db_home.zip Note:- Unzip to ORACLE_HOME location 2.. Once it is unzipped, then execute  ./runInstaller 2.1 Configuration Option:- Select Set Up Software Only And click Next 3.. Database Installation Option: - Select Single instance database installation And click on Next 4.. Database Edition :-  Select Enterprise … Continue reading Oracle Database 19c Installation on Oracle Linux 7

Running An Empty Patching Cycle Without Applying A Patch in Oracle E-Business Suite R12.2.X

Quick Version: cd EBS_ROOT source EBSapps.env runadop phase=prepare,finalize,cutoversource EBSapps.env runadop phase=cleanup Complete Version: cd EBS_ROOTsource EBSapps.env runadop phase=prepareadop phase=actualize_alladop phase=finalize finalize_mode=fulladop phase=cutoversource EBSapps.env runadop phase=cleanup cleanup_mode=full Happy Learning !!!!

Checking Adop Cutover status in Oracle E-Business Suite R12.2.X

1.. sql query select prepare_status,apply_status,finalize_status,cutover_status,cleanup_status,abort_status,status,abandon_flag,node_name from ad_adop_sessions where adop_session_id=62 order by adop_session_id; Note:- Y denotes that the phase is doneN denotes that the phase has not been completedX denotes that the phase is not applicableR denotes that the phase is running (in progress)F denotes that the phase has failedP (is applicable only to APPLY phase) … Continue reading Checking Adop Cutover status in Oracle E-Business Suite R12.2.X

VPC Peering in GCP between two projects

1.. Login to your gcp cloud console and select choice of your project. I have selected project oracle-prod 1.1 Navigate to VPC networks à click on Create VPC network and create a custom network. 1.2 For Subnets:- select custom network, give name for subnet as oracle-prod-vpc-sub-us-central and enter detail as follows. 1.3. select dynamic routing … Continue reading VPC Peering in GCP between two projects

Sql to check Oracle E-Business Suite Concurrent Manager status …

column user_concurrent_queue_name format a65column target_node format a20column running_processes format a20column max_processes format a20column control_code format a15 select b.user_concurrent_queue_name "Concurrent Manager", a.target_node "Server Node", a.running_processes "ACTUAL Processes", a.max_processes "TARGET Processes", DECODE (b.control_code,'D', 'Deactivating','E', 'Deactivated','N', 'Node unavai','A', 'Activating','X', 'Terminated','T', 'Terminating','V', 'Verifying','O', 'Suspending','P', 'Suspended','Q', 'Resuming','R', 'Restarting') status from apps.fnd_concurrent_queues a, apps.fnd_concurrent_queues_vl bwhere a.concurrent_queue_id = b.concurrent_queue_id and a.running_processes = … Continue reading Sql to check Oracle E-Business Suite Concurrent Manager status …

Deploy your favorite DB system in Oracle Cloud Infrastructure aka OCI

1.. Login to OCI console navigate to Oracle Database and click on Bare Metal, VM and Exadata 1.1 Select choice of your compartments as create in compartment i.e network_POC and then click on Create DB System 1.2 Again select a compartment as above i.e network_POC, give name to your DB system as required I am … Continue reading Deploy your favorite DB system in Oracle Cloud Infrastructure aka OCI