Connecting PDB in Oracle 12c

To connect as sys or other elevated local users, use the same methods as below, but use ‘as sysdba‘ where necessary Method 1:

Method 2:For other methods, you need to know the service-name for the PDB: Get the service name for the PDB:

or by doing “lsnrctl services LISTENER” and locating service for […]

Read More

Prereq Check Failed – The Database Must Be In Upgrade Mode

Database release 12c extends patch install automation for patches that contain post-patch SQL instructions. Prior to Oracle 12c such patches required manual intervention to complete the post-patch SQL instructions after restarting the database. Datapatch is the new tool that enables automation of post-patch SQL actions for RDBMS patches. Datapatch resides in the opatch directory i.e […]

Read More

ASM – (ACFS commands for multiple environments)

Overview of ACFS:- Oracle ACFS is designed as a general-purpose, single-node and cluster-wide file system that delivers support for customer file system application data maintained outside of Oracle Database. Users and applications can access and manage Oracle ACFS using native operating system file system application programming interfaces (APIs) and command-line interface (CLI) tools. Users can also […]

Read More

ASM Clients

Being an Oracle DBA we have learned about ASM and its qualities. Today we are going to learn about ASM Clients.  We all are aware that Oracle ASM is a volume manager and file system for Oracle database files. Let’s start to have knowledge of ASM Client. Clients that connect directly to ASM. Oracle Database:-  This is […]

Read More

Open Wallet Automatically After Starting The Database

This article about Open Wallet Automatically After Starting The Database.  If encryption wallet is enabled, then every time we start the database, we have to open the wallet manually. So to avoid this, we can create one trigger which will open the wallet automatically, once you start the database. Below is the trigger: CREATE or replace […]

Read More

How To Use DBMS_PRIVILEGE_CAPTURE To Capture Privs In Oracle 12c

Introduction:- Oracle 12c introduced the DBMS_PRIVILEGE_CAPTURE package, which helps us in doing privilege analyze and find a report on used and unused privileges.In order to use the DBMS_PRIVILEGE_CAPTURE package, you must be granted the CAPTURE_ADMIN role. One of the most important Security Principals while maintaining your Enterprise Database Landscape is implementing the “least privilege” principle. The […]

Read More

ENABLE_DDL_LOGGING In Oracle 12c

This  ENABLE_DDL_LOGGING parameter has been introduced in Oracle 12c. If this ENABLE_DDL_LOGGING is enabled, then DDL records are written to the ADR. All DDL operations like alter/create/drop/truncate objects. Only drop user will be logged, But create user will not be. Enable the parameter: SQL> show parameter enable_ddl_logging NAME TYPE VALUE ———————————— ———– —————————— enable_ddl_logging boolean FALSE SQL> alter system […]

Read More

Unified Audit Trail In Oracle 12c

This post is about Unified Audit Trail In Oracle 12c . Few starting lines give the overview of ” Unified Audit Trail ” .   With Oracle 12c, unified auditing has been introduced. It consolidates all audit trails into a single audit trail table. It will capture audit records from below sources. SYS audit records ( which was […]

Read More

Shutdown mode in Oracle ASM Instance

Being an Oracle DBA we have learned about the db instance in Oracle database. As we know db instance has shutdown mode. In this post, we are going to have look at Oracle ASM Instance. The ASM shutdown process is initiated when you run the SHUTDOWN command in SQL*Plus. While running this command we must ensure […]

Read More

ASM Dynamic Performance Views

We are going to have look at the ASM Dynamic Performance Views.  In the database, we have learned about views. Here we are going to focus on ASM Dynamic Performance Views. As we know An ASM instance does not have a data dictionary. The information relating to its configuration and operation is available by querying a set of […]

Read More