Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

  • Translate

  • It’s Me




  • My Certificates

  • Links

    My Acclaim Certification : Credly Profile
    My Oracle ACE Pro Profile

  • Achievements

    Awarded Top 100 Oracle Blogs from Worldwide - #RANK 39
  • VISITORS COUNT

  • Verified International Academic Qualification from World Education Service (WES)

    Verified International Academic Qualification from World Education Service (WES)

  • Jobs

Archive for June, 2020

How to perform the Snapshot Standby database in Oracle Database 11gR2(11.2.0.4)

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)

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

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

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

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

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

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