The post describes how to capture tracing for the PMON or LREG process. It is intended to help troubleshoot issues where dynamic service registration is failing or where the LSNRCTL services summary is not displaying services properly. 11g tracing option From 11.1.0.7 onwards, tracing can be enabled using the following command: alter system set events='immediate trace name listener_registration level 3'; When finished collecting pmon traces,turn this off using: alter system set … [Read more...] about How to Trace Dynamic Registration from PMON or LREG (Oracle 12c)
oracle 12c
Script To Find Redolog Switch History And Find Archivelog Size For Each Instances In Oracle RAC
This script will list the below items from each instance in the RAC Database. Report the redo log switches on an hourly basis from the all the instances on RAC Database Report the size of the archive logs generated on daily basis from all the instances on RAC Database The same can be used for a Standalone (Non-RAC) Database as well. The script Here is the actual script: /* setting up the environment */ set linesize 200 pagesize 1000 column day format a3 column total format … [Read more...] about Script To Find Redolog Switch History And Find Archivelog Size For Each Instances In Oracle RAC
How to upgrade Oracle database to 12c Pluggable database (Multitenant) using Transportable tablespace(TTS) method
Database upgrade to 12c can be done in multiple ways. Commonly used methods are DBUA (Database upgrade assistant) and Manual upgrade. Both methods will directly upgrade the database to a higher version but upgrade to 12c non-CDB. To convert the database to Multitenant architecture we require additional actions which add extra downtime. Transportable tablespace (TTS) is one of the methods commonly used to upgrade the database to higher version due to its advantage. In 12c TTS upgrade, it doesn’t … [Read more...] about How to upgrade Oracle database to 12c Pluggable database (Multitenant) using Transportable tablespace(TTS) method
Upgrading to Oracle 12c using RMAN DUPLICATE with “NOOPEN” clause and “BACKUP LOCATION”
When cloning (duplicating) a database to a higher version, traditionally (prior to 12c), you must use restore/recover of an RMAN backup. This is because the database in the destination must be opened with UPGRADE option. Therefore, the RMAN duplicate could not be used because RMAN automatically opens the auxiliary database with resetlogs. This would fail with error 'ORA-39700: database must be opened with UPGRADE option'. In RMAN 12c, a new option is available "NOOPEN" requesting RMAN to … [Read more...] about Upgrading to Oracle 12c using RMAN DUPLICATE with “NOOPEN” clause and “BACKUP LOCATION”
Beginners Guide to RMAN compression for backups
As the databases keep growing, so does the space occupied by their backups. Fortunately, RMAN has built-in support to compress such large-sized backups which can be handy rather than using an OS utility such as TAR or so on. The following are the 3 kinds of compression techniques used by RMAN: Null compression Unused block compression Binary compression RMAN uses block compression by default and that's why you can't set it off (or on either). Two modes of block compression are … [Read more...] about Beginners Guide to RMAN compression for backups
How to Monitor SGA Memory on Oracle Pluggable Databases
This post describes how to monitor SGA memory usage on pluggable databases using queries against database views. Pre-requisites to using the sample code provided below are: On RAC configuration, the scripts should be run on each instance since only V$ views are used to provide an accurate memory usage for the individual database instance. The scripts must be run in SQL*Plus session since specific SQL*Plus functions are used. Scripts must be run as sysdba or database user account having … [Read more...] about How to Monitor SGA Memory on Oracle Pluggable Databases
How To Automate The Opening Of Pluggable Databases After The CDB Starts Up in Oracle 12c
Here is a short note on how to automate the startup of PDBs after the CDB starts up in Oracle database 12c. You can start all the PDBs or selective PDBs using below steps. We will need to create a database startup trigger in order to automate the PDB startup. Follow the steps outlined below. 1. Login into the CDB as sysdba. $ sqlplus / as sysdba 2. Create a database startup trigger to open all pluggable databases. create or replace trigger open_all_pdbs after startup on … [Read more...] about How To Automate The Opening Of Pluggable Databases After The CDB Starts Up in Oracle 12c
Oracle 12.2 : RMAN Cross-Platform Transport of PDB into Destination CDB
Introduction and Pre-requisites Using RMAN, Pluggable database (PDBs) can be transported and plugged into a destination multitenant container database (CDB) which is on a different platform than the source CDB. In addition to the backup of the PDB, RMAN also copies the metadata required to plug the PDB into the destination CDB. The source CDB and the destination CDB must use the same endian format. Below steps show migration of closed PDB from source platform Solaris (Big Endian) to AIX (Big … [Read more...] about Oracle 12.2 : RMAN Cross-Platform Transport of PDB into Destination CDB
Automatic Stop of Oracle Database (dbshut) not working in CentOS/RHEL 7 with systemd
The Problem On CentOS/RHEL 7 with Oracle database 12.1.0.2 version, when attempting to stop DB during server shutdown the automatic shutdown script getting below error: # cat /u01/app/oracle/product/12.1.0.2/dbhome_1/shutdown.log Processing Database instance "XXXX1": log file /u01/app/oracle/product/12.1.0.2/dbhome_1/shutdown.log Info: Database instance "XXXX" already down (PMON process not there). Which indicate that PMON is forcefully being closed before the script is called. This is … [Read more...] about Automatic Stop of Oracle Database (dbshut) not working in CentOS/RHEL 7 with systemd
How to Monitor Process Memory Usage on Oracle Pluggable Databases
The purpose of this post is to demonstrate how to determine process memory usage of pluggable databases. Pre requisites - On RAC configuration, the scripts should be run on each instances since only V$ views are used to provide a accurate memory usage for individual database instance. - The scripts must be run in SQL*Plus session since specific SQL*Plus functions are used. - Scripts must be run as sysdba or database user account having access to CDB*, DBA* and V$ tables. - Example … [Read more...] about How to Monitor Process Memory Usage on Oracle Pluggable Databases