Online DBA

<<Back to DB Administration Main Page How to connect to PDB directly as SYSDBA using OS Authentication The secret to this is environment variable ORACLE_PDB_SID SQL> show pdbs     CON_ID CON_NAME                       OPEN MODE  RESTRICTED ---------- ------------------------------ ---------- ----------          2 PDB$SEED                       READ ONLY  NO          3 PDB01                               READ WRITE NO          4 PDB02                             ...

<<Back to DB Administration Main Page ORA-65010: maximum number of pluggable databases created Solution: Increase the  max_pdbs parameter  alter session set container=cdb$root; Session altered. SQL> create pluggable database PDB02 admin user syspdb identified by password roles=(DBA) file_name_convert = ('pdbseed','PDB02'); create pluggable database PDB02 admin user syspdb identified by password roles=(DBA) file_name_convert = ('pdbseed','PDB02') * ERROR at line 1: ORA-65010: maximum number of pluggable databases created SQL> show parameter max_pdbs NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ max_pdbs            ...

<<Back to DB Administration Main Page How to Install Oracle 19c Database Software Oracle 12c Software Only Installation in Silent Mode   Step0> download the binaries Download Here Step1> Unzip Binaries Unzip the binary directly in the oracle home $unzip -d /ora_app/product/19c/dbd1 LINUX.X64_193000_db_home.zip Step2.0> Launch runInstaller $/ora_app/product/19c/dbd1/runInstaller  Step2.1> If you want to create the database together with software installation just click Next . If you want to install database binaries only and create the database later as demonstrated in this post choose Setup Software Only option and click Next   Step2.2> Choose Single Instance Database Installation and click Next     Step2.3>  Choose Enterprise Edition and click Next       Step2.4>  Enter correct path for OracleBase and click Next       Step2.5> Enter correct path for Invento...

<<Back to PT Main Page Steps to Configure HugePages on Linux 64-bit for Oracle Database Step0: Check if Transparent  HugePages are enabled cat /sys/kernel/mm/transparent_hugepage/enabled [always] madvise never Starting from RHEL6/OL6, Transparent HugePages are implemented and enabled by default. Therefore Oracle recommends disabling Transparent HugePages on all servers running Oracle databases this MOS note (Doc ID 1557478.1) Step1: Verify the current OS Page Size #grep Hugepagesize /proc/meminfo Step2:Configure memlock Set the memlock user limit in /etc/security/limits.conf file. Set the value (in KB) slightly smaller than installed RAM. e.g. If you have 450GB RAM installed, you may set: oracle soft memlock 419430400 oracle hard memlock 419430400 NOTE: There is no harm in setting this value larger than your SGA requirements. Step3: Verify the memlock limit Re-logon to the Oracle product owner account (e.g. 'oracle') and check the memlock...

<<Back to Oracle Data Guard Broker Page How Oracle Dataguard Broker Works Oracle Dataguard Broker has server side and client side components. At client side it has OEM and DGMGRL. Both the utilities can be used to read and manipulate Broker Configuration data. At server Side it has got 2 components 1> Binary Configuration File 2> DMON process DMON processes is responsible to monitor the health of the broker configuration and ensures that every database has a consistent description of the configuration. To Ensure this DMON process persistently maintains information about all members of the broker configuration in a binary configuration file. In Configuration file Broker stores various properties associated with each database to control the database's behavior. Whenever you add databases to a broker configuration, or make a change to an existing database's properties, each DMON process records the new information in its copy of the configuration file. The param...

<<Back to Oracle Data Guard Broker Page Understanding  Oracle Data Guard Broker and DGMGRL Utility Oracle Data Guard Broker is an Utility which logically groups all the dataguard members in oracle dataguard configuration to centrally  manage and monitor them together as an integrated unit. Oracle Dataguard Broker stores the necessary information in a file locally on each dataguard member server. The file location is configured using following database parameters dg_broker_config_file1 dg_broker_config_file2 The content of above the file is accessed and managed by Dataguard Monitor  ( DMON ) Process. The DMON process is an Oracle background process that runs on every database instance that is managed by the broker. The start/stop of DMON process (which interns enables or disables) broker is managed by database  parameter  called dg_broker_start , the value of which is TRUE (enabled) or FALSE (disabled). The broker configuration can be queried and/o...

<<Back to Oracle DataGuard Main Page How to Resolve : ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added DGMGRL>  ADD DATABASE "ORCL3PS" AS CONNECT IDENTIFIER IS "ORCL3PS"; Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added Cause: One of log_archive_dest_n parameter is set for service  ORCL3PS in either primary or standby or both databases Solution: Identify the log_archive_dest_n parameter which is set to value  ORCL3PS  and rest it. SQL> show parameter dest_4 log_archive_dest_4                   string      SERVICE=ORCL3PS.EU.MERCKGROUP.C                                         ...