Posted by Mir Sayeed Hassan on 16th January 2019
How to Install & COnfigure the OSWATCHER (OSWbb) in RAC Database This Oracle OSWatcher Black Box (OSWbb) is mainly used in RAC Database for collects & archive OS & Network metrics which use to diagnose performance issue & it Should be install in every NODE of RAC DB. It will invoke the unix utilities are Read More
Posted in RAC | Comments Off on How to Install & Configure the OSWATCHER (OSWbb) in RAC Database
Posted by Mir Sayeed Hassan on 15th January 2019
RAC DB Command for CRSCTL & SRVCTL in Oracle 11gR2 CRSCTL COMMANDS Database Status SQL> select instance_name,version, status from v$instance; INSTANCE_NAME VERSION STATUS —————- —————– ———— rac_1 11.2.0.4.0 OPEN Login to the grid user… Read more..
Posted in RAC | Comments Off on RAC DB Command for CRSCTL & SRVCTL in Oracle 11gR2
Posted by Mir Sayeed Hassan on 15th January 2019
How to Kill Single & Multiple Sessions in Oracle Database 11gR2 To kill the Oracle session in a database, you should be careful with the consult team to kill the correct session as per there requirement. Database Status: sys@TESTDB> select instance_name,version,status from v$instance; INSTANCE_NAME VERSION … Read more..
Posted in DBA Administration | Comments Off on How to Kill Single & Multiple Sessions in Oracle Database 11gR2
Posted by Mir Sayeed Hassan on 12th January 2019
ORA-04063: package body “SYS.KUPW$WORKER” has errors The above error occurs while performing the expdp of the full database in Oracle 11gR2. Error Log: [oracle@testdb new_dump]$ cat fulldbrec.log ;;; Export: Release 11.2.0.4.0 – Production on Sat Jan 12 15:43:42 2019 Copyright (c) 1982, 2011, Oracle and/or its affiliates…. Read more..
Posted in ORA-Error | Comments Off on ORA-04063: package body “SYS.KUPW$WORKER” has errors
