OEM cloud Control

Oracle Databse Monitoring tool | OEM Introduction

Oracle enterprise manager (OEM) is monitoring tool for Oracle database server. Oracle enterprise manager monitor to Oracle database, Oracle database server, agent, listener and all the targets which are registered with the Oracle enterprise manager. Oracle enterprise manager tool is provided by the Oracle itself and having more demand for the Oracle database administration. Following …

Oracle Databse Monitoring tool | OEM Introduction Read More »

Convert Physical Standby database to Active Dataguard

Active dataguard means, the standby database is open with read only mode, even when redo logs are getting applied in real time. Below are the benefit of using active dataguard. Reporting queries can be offloaded to standby database. Physical block corruptions are repaired automatically either at primary or physical standby database. RMAN backups can be initiated from standby …

Convert Physical Standby database to Active Dataguard Read More »

How To Open The PDBS Automatically When CDB Restarts | Save State of PDBS

In oracle 12c , when we startup the CDB, the PDBS will be in MOUNTED stage. We need to open them manually using alter pluggable PDB open. To make the PDBS open automatically, we can use the saved state option . This feature is available from Oracle 12.1.0.2  onwards  Start the container database and you will …

How To Open The PDBS Automatically When CDB Restarts | Save State of PDBS Read More »

Drop datafile which is already removed Locally – ORA-01157,ORA-01110

I got the below issue while starting the database. Below issue occurred as I have deleted the datafiles from server level and not I am unable to start the datafile.SQL> startupORACLE instance started.Total System Global Area 1325400064 bytesFixed Size 8792488 bytesVariable Size 822085208 bytesDatabase Buffers 486539264 bytesRedo Buffers 7983104 bytesDatabase mounted.ORA-01157: cannot identify/lock data file …

Drop datafile which is already removed Locally – ORA-01157,ORA-01110 Read More »

Change Timezone in Oracle Database for CDB and PDB

In this blog, We are going to see how to change DBTime zone in multitenent database. Oracle recommends setting the database time zone to UTC (0:00), as no conversion of time zones will be required. CDB LevelSQL> SELECT DBTIMEZONE FROM dual;DBTIME——+00:00SQL> ALTER DATABASE SET TIME_ZONE=’Europe/London’;Database altered.SQL> SELECT dbtimezone FROM DUAL;DBTIME—— — > No change. Bounce …

Change Timezone in Oracle Database for CDB and PDB Read More »

Silent Oracle 12C Database Installation

Oracle 12C Database installationResponse file location/data/database/response/dbca.rsp/data/database/response/netca.rsp/data/app/oracle/product/12.2.0.1/assistants/dbca/dbca.rspvi /tmp/dbca.rsp to install databasegdbName=prim2sid=primcreateAsContainerDatabase=truenumberOfPDBs=1pdbName=pdbprim2pdbAdminPassword=Oracle1234templateName=General_Purpose.dbcsysPassword=Oracle1234systemPassword=Oracle1234emConfiguration=DBEXPRESSemExpressPort=5500dbsnmpPassword=Oracle1234datafileDestination=/data/app/oracle/oradatarecoveryAreaDestination=/data/app/oracle/flash_recovery_areastorageType=FScharacterSet=AL32UTF8nationalCharacterSet=AL16UTF16listeners=LISTENERsampleSchema=truedatabaseType=OLTPautomaticMemoryManagement=TRUEmemoryPercentage=40./dbca -silent -createDatabase -responseFile /tmp/dbca.rsp

Change Protection Mode in Oracle 12C Dataguard

Primary SideSQL> select status,instance_name,database_role,protection_mode from v$database,v$instance; STATUS INSTANCE_NAME DATABASE_ROLE PROTECTION_MODE—— ————- ————- ——————–OPEN prim PRIMARY MAXIMUM PERFORMANCEStandby SideSQL> select status,instance_name,database_role,protection_mode from v$database,v$instance; STATUS INSTANCE_NAME DATABASE_ROLE PROTECTION_MODE—— ————- ————- ——————–OPEN stand STANDBY MAXIMUM PERFORMANCEVerify Online logfile on PrimarySQL> select group#,bytes/1024/1024 from v$log; GROUP# BYTES/1024/1024—— ——————1 502 503 50Verify Online logfile on StandbySQL> select group#,bytes/1024/1024 from v$log; …

Change Protection Mode in Oracle 12C Dataguard Read More »

Startup and Shutdown Container and Pluggable database

Startup Container database SQL> select name, open_mode, cdb from v$database; NAME OPEN_MODE CDB ——— ——————– — NONCDB12 READ WRITE NO <—– SQL> create user raj identified by raj default tablespace users temporary tablespace temp; User created. SQL> grant connect,resource to raj; Grant succeeded. SQL> alter user raj quota unlimited on users; User altered. SQL> conn …

Startup and Shutdown Container and Pluggable database Read More »