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