Posted by Mir Sayeed Hassan on 25th June 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 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 22nd June 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 20th June 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 20th June 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)
Posted in DB Patch | Comments Off on How to apply the Oracle PATCH’S AT OS & Database Level