Posted by Mir Sayeed Hassan on July 15th, 2020
How to clear the stateless alert from OEM 12C/13C by using the EMCLI method
The explanation for clearing the unnecessary alert from the OEM 12C/13C.
Login to the sysman user to perform this operation.
To login to the sysman user, you need go to oms bin location as shown below.
[oracle@oem12c ~]$ cd /u01/app/oracle/middleware/oms/bin/
Posted in OEM (Oracle Enterprise Manager) | Comments Off on How to clear the stateless alert from OEM 12C/13C by using the EMCLI method
Posted by Mir Sayeed Hassan on June 25th, 2020
How to perform the Snapshot Standby database in Oracle Database 11gR2(11.2.0.4)
The below scenario is to test the snapshot standby database in Oracle database 11gR2(11.2.0.4), Its an feature which allow a read-write operation on standby DB.
We are performing the convert of physical standby db to the snapshot standby, after its conversion is completed...
Read more..
Posted in DBA Administration | Comments Off on How to perform the Snapshot Standby database in Oracle Database 11gR2(11.2.0.4)
Posted by Mir Sayeed Hassan on June 22nd, 2020
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..
Posted in ORA-Error | Comments Off on ORA-00119 invalid specification for system parameter REMOTE_LISTENER in RAC 11gR2 Database
Posted by Mir Sayeed Hassan on June 20th, 2020
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...
Read more..
Posted in OEM (Oracle Enterprise Manager) | Comments Off on How to delete an agent from OEM 12C/13C in Oracle Database 11gR2
Posted by Mir Sayeed Hassan on June 20th, 2020
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)
Read more..
Posted in DB Patch | Comments Off on How to apply the Oracle PATCH’S AT OS & Database Level
Posted by Mir Sayeed Hassan on May 7th, 2020
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:
Read more..
Posted in RAC | Comments Off on How to configure the 2 Node RAC Dataguard in Oracle 11gR2(11.2.0.4)
