Manual Oracle Database Grid Patching
As the database home owner execute: Run the pre root script (As Root User) Patch GI home. As the GI home owner execute: Patch DB home (As the database home owner execute:) Run the post script. As the root user execute:
Space and Objects details in Oracle Database
Object Count of schema and tablespace Physical Size of the Oracle database (Multi-Tenant) Physical Size of the Oracle Database (Logfile,Tempfile,datafile) Logical Size (Space utilise by the data in the database) Tablespace Utilisation Schema Size Tables inside specific Schema with size_in_mb
Convert Centos 7 to OEL 7.9
Several factors secure the change from CentOS to Oracle Enterprise Linux: The contents of the “/etc/centos-release” file indicate our current CentOS installation. Install the curl package or wget package before downloading the script from the public github repository. or Check the downloaded file in your present location Now execute the script using bash Now wait […]
Oracle 19c Database Installation
Installing Oracle Database 19c involves several steps, and the process can vary based on your operating system and specific requirements. Here’s a general outline of the steps you would follow for installing Oracle Database 19c: Update hosts parameter to point the DNS and IP to your server After, updating changes in the Hosts file, we […]
Data Guard switchover Pre & Post Steps
Pre-Steps for Data Guard Switchover: Verify Managed Recovery: Ensure that Managed Recovery is running on the standby database. This ensures that the standby database is synchronized with the primary database. Show lag for Data Guard configuration Show configuration for database role change[This will be useful with multiple standby databases] Validate database spfile (don’t use OS […]
Login from Non-Oracle User Run SQL*Plus
In Linux or Unix platform, installed SQL*Plus in database server can be executed by anyone. We just need to make the tnsnames.ora file readable by others. TNSNAMES Readable After this just login to the user you want to login the database and set the environment by .oraenv and providing the SID.
Oracle Database Patching
Oracle Database 19c standalone patching involves applying patches and updates to an existing Oracle Database 19c installation that is not part of an Oracle Real Application Clusters (RAC) configuration. High-Level steps for applying the patching Check current version of Opatch Tool Move the current OPatch tool as backup unzip the new OPatch tool to the […]