Posted by Mir Sayeed Hassan on February 4th, 2019
How to take the Online Fulldb backup using Backup Script in Oracle 11gR2
Database Status
sys@TESTDB> select instance_name,status,version from v$instance;
INSTANCE_NAME STATUS VERSION
---------------- ------------ -----------------
testdb OPEN 11.2.0.4.0
Posted in DBA Scripts | Comments Off on How to take the Online Fulldb backup using Backup Script in Oracle 11gR2
Posted by Mir Sayeed Hassan on February 4th, 2019
Query to delete all Objects from specific user in Oracle database 11gR2
Database Status
sys@TESTDB>select instance_name,status,version from V$instance;
INSTANCE_NAME STATUS VERSION
---------------- ------------ -----------------
testdb OPEN 11.2.0.4.0
Connect to specific user “MIR”
sys@TESTDB>connect...
Read more..
Posted in Oracle SQL | Comments Off on Query to delete all Objects from specific user in Oracle database 11gR2
Posted by Mir Sayeed Hassan on February 4th, 2019
How to kill all the Oracle Session for specific user in Oracle Database 11gR2
Database Status:
sys@TESTDB> select instance_name,status, version from V$instance;
INSTANCE_NAME STATUS VERSION
---------------- ------------ -----------------
testdb OPEN 11.2.0.4.0
Posted in DBA Administration | Comments Off on How to kill all the Oracle Session for specific user in Oracle Database 11gR2
Posted by Mir Sayeed Hassan on February 4th, 2019
How to create directory in Oracle database 11gR2
The directories must be created if any of the external tables are used in database for any operation as example for expdp/impdp etc & this directory should be granted the object privilege as read & write, data dictionary view are all_directories/dba_directories.
Database Status:
sys@TESTDB>...
Read more..
Posted in DBA Administration | Comments Off on How to create directory in Oracle database 11gR2
Posted by Mir Sayeed Hassan on January 16th, 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 vmstat, netstat, iostat, and...
Read more..
Posted in RAC | Comments Off on How to Install & Configure the OSWATCHER (OSWbb) in RAC Database
Posted by Mir Sayeed Hassan on January 15th, 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
