Mir Sayeed Hassan – Oracle Blog

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..			

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..			

ORACLE DBA – ACTIVITY CHECKLISTon DAILY/WEEKLY/MONTHLY/NIGHTLY

Aim:

This activity checklist is for Oracle DBA to perform the complete health check report of production databases on Daily/Weekly/Monthly basis as per the requirement.

DAILY CHECKLIST

1. Read more..

How to reopen the expired db account without changing the password

Consider you have an expired db account & you need to recover this acccount at any cost as per your client request, Yes its possible to recover it, Find the below scenario tested in our env

Create a test user in database & try to expire this user & recover...
Read more..

How to export schema with Parallel method by using expdp

[oracle@testdb dump_bkp]$ expdp system directory=dump_bkp dumpfile=expdp%U-`date '+%d%m%Y_%H%M%S'`.dmp logfile=expdp-`date '+%d%m%Y_%H%M%S'`.log schemas=mir PARALLEL=2

Export: Release 11.2.0.4.0 - Production on Sat Oct 13 15:25:00 2018

Copyright (c) 1982, 2011, Oracle and/or... 
Read more..			

Switchover in Realtime Production database in Oracle 11gR2

=================
PRIMARY DATABASE
=================

Pre-requisite

SQL> select INSTANCE_NAME,VERSION,STATUS from V$instance;
 
INSTANCE_NAME VERSION STATUS
 ----------------... 
Read more..