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 August, 2020

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

Posted by Mir Sayeed Hassan on 23rd August 2020

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

Posted in ORA-Error | Comments Off on Error while loading shared libraries: libnsl.so.1 or libnsl.so.1 not found in Oracle 19c Grid Installation

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

Posted by Mir Sayeed Hassan on 9th August 2020

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

Posted in Datapump (Expdp/Impdp) | Comments Off on How to import the table by using the impdp in Oracle Database 11gR2(11.2.0.4)

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

Posted by Mir Sayeed Hassan on 9th August 2020

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

Posted in Datapump (Expdp/Impdp) | Comments Off on How to import the Schema by using the impdp in Oracle Database 11gR2(11.2.0.4)

How to create & drop the Enterprise Manager for RAC Database in Oracle 11gR2

Posted by Mir Sayeed Hassan on 5th August 2020

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

Posted in EM (Enterprise Manager) | Comments Off on How to create & drop the Enterprise Manager for RAC Database in Oracle 11gR2

How to deinstall the Oracle 19c database software only

Posted by Mir Sayeed Hassan on 4th August 2020

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 Read More

Posted in DB Install & Create | Comments Off on How to deinstall the Oracle 19c database software only