Mir Sayeed Hassan – Oracle Blog

Error while deleting the oracleasm disks from Oracle Server

Check the disk need to delete

[root@pri-db ~]# cd /dev/oracleasm/disks/

[root@pri-db disks]# ls
ORADATA

Delete the oracleasm disk “ORADATA”

[root@pri-db disks]# oracleasm deletedisk ORADATA
Clearing disk header: failed
Unable... 
Read more..			

Error while loading shared libraries: libnsl.so.1 or libnsl.so.1 not found in Oracle 19c Installation

This error is occur while installation of Grid Infrastructure for Oracle 19c database.

[root@pri-db ~]# cd /u01/app/19c/grid/

[root@shop-pri grid]# ls

acfsccm addnode cdp css demo gnsd instantclient ldap network oracore... 
Read more..			

How to import the table by using the impdp in Oracle Database 11gR2(11.2.0.4)

In this scenario, I am going to import at the table “test1” in schema “MIRTEST” from the given dumpfile

Create a directory at OS Level

[oracle@testdb ~]$ mkdir -p /u01/dump/

Give the permisssion for directory & verify...
Read more..

How to import the Schema by using the impdp in Oracle Database 11gR2(11.2.0.4)

In the below scenario, I am going to perform the import of the schema “MIRTEST” from the dumpfile

Create a directory at OS Level

[oracle@testdb ~]$ mkdir -p /u01/dump/

Give the permisssion for directory & verify the Ownership

How to Create & Drop the Enterprise Manager for RAC Database in Oracle 11gR2

Login to the server with Oracle User

Goto the default location of the home & drop the existing configuration of the EM

[oracle@racdb1 ~]$ cd $ORACLE_HOME

[oracle@racdb1 db_1]$ pwd
/u01/app/oracle/product/11.2.0/db_1

How to deinstall the Oracle 19c database software only

Here iam going to deinstall the Oracle 19c database software only, this will delete the Oracle DB configuration files, user data & recovery area (FRA) also the files which are related to the oracle base.

Login to the server with Oracle user

Goto the Oracle Home location:

[oracle@ora19cpri... 
Read more..