Mir Sayeed Hassan – Oracle Blog

ORA-00119 invalid specification for system parameter REMOTE_LISTENER in RAC 11gR2 Database

Issue occur while startup of the RAC Database.

[oracle(racdb-n1)@racdb-n1 ~]$ srvctl start database -d racdb

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-00119: invalid specification for system parameter REMOTE_LISTENER
ORA-00132:... 
Read more..			

How to delete an agent from OEM 12C/13C in Oracle Database 11gR2

Stop the agent on the target database

[oracle@oem bin]$ cd /u01/app/OEM/agent_inst/bin/

[oracle@oem bin]$]$ ./emctl stop agent

Login to the OEM 1C/13C Database & goto the OMS Default location

Goto OMS location:

[oracle@oem bin]$ cd /oradata/oem12c/middleware/oms/bin

Login...

How to apply the Oracle PATCH’S AT OS & Database Level

The below patch are applied to one of our production database, due to the wrong result at standby level compare to primary database.

Download the OPatch (OS LEVEL)

p6880880_112000_Linux-x86-64.zip

Download the patch to be applied (DB LEVEL)

How to configure the 2 Node RAC Dataguard in Oracle 11gR2(11.2.0.4)

I’m going for step by step configuration for the 2 Node RAC Dataguard/Standby in Oracle Linux.

Let us take the below environment in this example:

How to add a new LVM disk into existing Oracle Linux Server

LVM (Logical Volume Management)  – It provides a flexible and high-level approach to managing disk space into the Linux Server.

Volume Group (VG) – It consists of the raw disk which holds one or more logical volumes & ...
Read more..

How to add the ASM DISK into Existing disks in RAC DB Server

In the below scenario, we are going to add the new asm disk into the existing disk in RAC DB Server

First Scan the newly added disk into the server

[root@rac1-testdb~]# echo "- - -"> /sys/class/scsi_host/host0/scan
[root@rac1-testdb... 
Read more..