ASMCMD-8102: no connection to ASM; command requires ASM to run

Let’s have a look on the steps which we use to resolve the issue “ASMCMD-8102: no connection to ASM; command requires ASM to run”. [grid@oraclehelpdb1 ~]$ asmcmd Connected to an idle instance. ASMCMD> ls ASMCMD-8102: no connection to ASM; command requires ASM to run Solution: [grid@oraclehelpdb1 ~]$ export ORACLE_HOME=/opt/grid/product/11.2.0.3/ [grid@oraclehelpdb1 ~]$ export PATH=/opt/grid/product/11.2.0.3/bin/ [grid@oraclehelpdb1 ~]$ […]

Read More

CHM (Cluster Health Monitor)

Which is analyzing the Os and cluster resource related degradation and failures. Its store real time OS metric in the CHM repository and also report and alert when certain metrics pass the resource utilization threshold. Tool can be replay the historical data to trace back what was happening at the time of failure, and its […]

Read More

LREG New BG Process In 12c

In 11.2 Pmon process propagates the service metrics to the listeners registered in local_listener and remote_listener initialization parameter. As the remote_listener specifies specifies the address of scan listener and the local_listener parameter specifies the address of the VIP listener, PMON process propogates the service metrics to both SCAN and VIP listeners. You can trace listener registration using […]

Read More

ora-02097 parameter cannot be modified because specified value is invalid

You might get ORA-02097 while changing PGA_AGGREGATE_LIMIT. SQL> show parameter PGA_AGGREGATE_LIMIT NAME TYPE VALUE ———————————— ——————————– —————————— pga_aggregate_limit big integer 2G SQL> SQL> alter system set PGA_AGGREGATE_LIMIT=5G scope=both; alter system set PGA_AGGREGATE_LIMIT=5G scope=both * ERROR at line 1: ORA-02097: parameter cannot be modified because specified value is invalid ORA-00093: pga_aggregate_limit must be between 6000M and […]

Read More

Downgrade Oracle Database from 12c to 11gR2

We have already upgraded Oracle Database11gR2 to 12c, the whole process is still relatively smooth, although some of the previous version of the upgrade is not the same, but the overall difficulty is not too large, because of too many different features, greatly extended the upgrade time. But for Oracle 12c back to the previous […]

Read More

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: alter session set container = pdbName; Method 2:For other methods, you need to know the service-name for the PDB: Get the service name for the PDB: SELECT name || ‘ ‘|| pdb […]

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