How to Get ddl of any Object in Oracle: In this article we will explain about How to Get ddl of any Object in Oracle using DBMS_METADATA.GET_DDL. Use of DBMS_METADATA: Every time all DBAs and Developers required to create scripts of objects like Tables, Indexes, Packages, Packages Body etc. In Oracle database has a package … Read more
Create Container Database (CDB) in Oracle 19c using DBCA:. In this article we will explain about how to Create Container Database (CDB) in Oracle 19c using DBCA. CDB PDB database features is started from Oracle 12c onwards. A cdb database is the root database in multitenant architecture which contains zero, one or multiple pdbs. Steps … Read more
How to create a new Pluggable Database in Oracle 19c using dbca.- In this article we will explain about How to create a Pluggable Database in Oracle 19c using dbca. From Oracle 12c oracle started Multitenant Architecture. In multitenant architecture you could create multiple PDBs and PDBs are created in CDB. Before we create a … Read more
Transparent Data Encryption In Oracle: In this article we will discuss about configuring and enabling Transparent Data Encryption In Oracle 11g (11.2.0.4) RAC Database. Let’s see steps how to configure TDE. Take full database RMAN backup: Take full database RMAN backup before starting the TDE implementation activity. Use below script to take full Database RMAN … Read more
How to create a password file using ORAPWD Utility in oracle: In this post we will discuss about how to create a password file using ORAPWD Utility in oracle. What is password file in ORACLE ? The password file stores a list of usernames and passwords that are allowed to remotely authenticate as SYSDBA over … Read more
For a DBA, starting up and shutting down of oracle database is a routine and basic operation. Sometimes Linux administrator or programmer may end-up doing some basic DBA operations on development database. So, it is important for non-DBAs to understand some basic database administration activities. Oracle Database startup and shutdown procedure Oracle Database startup and … Read more
Compile Invalid Objects In Oracle : In this article we will discuss about how to Compile Invalid Objects In Oracle. Objects in the database can become invalid, if there are any changes to the dependent objects. Oracle recommends that you run the utlrp.sql script after you install, patch, or upgrade a database, to identify and … Read more
Create an Oracle Listener with Oracle Network Configuration Assistant : In this article we will see how to Create an Oracle Listener with Oracle Network Configuration Assistant. In order t remote connections to an Oracle database the database must be registered with an Oracle Listener. If you will need to create a Listener manually. This document will detail the … Read more
Drop And Recreate Temp Tablespace In Oracle : During this article we’ll see how to Drop And Recreate temp tablespace In Oracle Database. Note :- While doing this activity, existing temporary tablespace may have existing live sessions, due to same oracle won’t let us to drop existing temporary tablespace. Resulting, we need to kill existing … Read more
How To Rename Or Move A Datafile In Oracle: In this article we will see How To Rename Or Move A Datafile In Oracle Database. Here is a sample procedure for relocating a datafile. Assume the following conditions: An open database has a tablespace named users that is made up of datafiles all located on … Read more
