Oracle 12c Logo

Oracle 12c installation on Oracle Linux release-5 (64-bit)

Here we are installing Oracle 12c Release-1 (12.1)(64-bit) on Oracle Linux release-5 (64-bit)

Minimum swap size 2GB.
IP Tables off.
SELinux set to be permissive.

// Ensure swap size by issuing following command, if swap size do not meet minimum requirement then increase it.
[root@oracle5 ~]# free -m
total used free shared buffers cached
Mem: 664 461 202 0 100 202 Continue reading

Oracle 12c Logo

Delete Pluggable Database with Database Configuration Assistant

We can delete Pluggable database using Database Configuration Assistant OR manually from SQL prompt as sysdba privilege.

Here we covered Database Configuration Assistant to delete Pluggable database.

In this post, we considered Pluggable database already created, if not then kindly have a look at: Create Pluggable Database using Database Configuration Assistant

 

// To initiate database installer, start “Database Configuration Assistant” by issuing “dbca” command from bin library as shown below.

Del_plugdb_1 Del_plugdb_2

 

On “Database Operation” prompt, select the “Manage Pluggable Databases”

In this we can create new pluggable database delete it as well as manage existing pluggable databases.

Click Next to continue.

Del_plugdb_3

 

On “Manage Pluggable Databases” prompt, select the “Delete a Pluggable Database” radio button.

& click Next.

Del_plugdb_4

 

On “Database List” prompt, select the Container Database.

In my case, “orcl” is Container Database.

& click Next.

Del_plugdb_5

 

On “Delete Pluggable Database” prompt, select pluggable database to be delete from drop down list & click Next.

& click Next.

Del_plugdb_6

 

Ensure the summary about your provided database, if u wish to continue click Finish button.

Mentioned system01.dbf, sysaux01.dbf & PlugDB_users01.dbf file will be deleted permanently from the container database.

Del_plugdb_7

PlugDB – Pluggable database has been deleted successfully.

***********************************************************************

Note: Please don’t hesitate to revert in case of any query OR feedback.

Thanking you.

Have a easy life ahead.

Oracle 12c Logo

Plugin a Pluggable database using Database Configuration Assistant

We can plugin back a Pluggable database using Database Configuration Assistant OR manually from SQL prompt as sysdba privilege.

Here we covered Database Configuration Assistant to plugin back a Pluggable database.

 

// To initiate database installer, start “Database Configuration Assistant” by issuing “dbca” command from bin library as shown below.

Plugin_pluggdb_1

Plugin_pluggdb_2

 

On “Database Operation” prompt, select the “Manage Pluggable Databases”

In this we can create new pluggable database as well as manage existing pluggable databases.

Click Next to continue.

Plugin_pluggdb_3

On “Manage Pluggable Databases” prompt, select the “Create a Pluggable Database” radio button.

& click Next.

Plugin_pluggdb_4

 

On “Database List” prompt, select the Container Database.

In my case, “orcl” is Container Database.

& click Next.

Plugin_pluggdb_5

 

On “Create Pluggable Database” prompt, select the “Create Pluggable Database using PDB file set” radio button.

In my case, I have created PDB file set at the time of unplug pluggable database, that’s why I would like to go with “Create Pluggable Database using PDB file set” option.

If you unplug your Pluggable database with the help of “Create Pluggable Database From PDB archive” then choose same for re-plug pluggable database.

& click Next.

Plugin_pluggdb_6

Choose .xml file of your Pluggable database that you want to plug in back.

& click Ok.

Plugin_pluggdb_7

 

On “Pluggable Database Option” prompt.

Enter the pluggable database name that you want to plugin back, also provide PDB user details as below.

& click Next.

Plugin_pluggdb_8

 

Ensure the summary about your provided database, if u wish to continue click Finish button.

Plugin_pluggdb_9

 

Progress page will show you the progress of same.

Plugin_pluggdb_10

 

On completion of installation, click the “OK” button on the message dialog and the “Close” button on the main screen.

Plugin_pluggdb_11

PlugDB – Pluggable database has been plugin successfully.

***********************************************************************

Note: Please don’t hesitate to revert in case of any query OR feedback.

Thanking you.

Have a easy life ahead.

Oracle 12c Logo

Unplug Pluggable Database using Database Configuration Assistant

We can unplug Pluggable database using Database Configuration Assistant OR manually from SQL prompt as sysdba privilege.

Here we covered Database Configuration Assistant to unplug Pluggable database.

In this post, we considered Pluggable database already created, if not then kindly have a look at: Create Pluggable Database using Database Configuration Assistant.

 

// To initiate database installer, start “Database Configuration Assistant” by issuing “dbca” command from bin library as shown below.

Unplug_plugdb_1

Unplug_plugdb_2

 

On “Database Operation” prompt, select the “Manage Pluggable Databases”

In this we can create new pluggable database as well as manage existing pluggable databases.

Click Next to continue.

Unplug_plugdb_3

 

On “Manage Pluggable Databases” prompt, select the “Unplug a Pluggable Database” radio button.

& click Next.

Unplug_plugdb_4

 

On “Database List” prompt, select the Container Database.

In my case, “orcl” is Container Database.

& click Next.

Unplug_plugdb_5

 

On “Unplug Pluggable Database” prompt, select pluggable database to be unplug from drop down list & select “Generate Pluggable Database File Set” radio button for future purpose.

& click Next.

You can also select “Generate Pluggable Database Archive” radio button, as per your convenience. In my case, I would like to go with “Generate Pluggable Database File Set”.

Unplug_plugdb_6

 

Ensure the summary about your provided database, if u wish to continue click Finish button.

Unplug_plugdb_7

 

Progress page will show you the progress of the same.

Unplug_plugdb_8

On completion of process, click the “OK” button on the message dialog and the “Close” button on the main screen.

Unplug_plugdb_9

 

PlugDB – Pluggable database has been unplugged successfully.

***********************************************************************

Note: Please don’t hesitate to revert in case of any query OR feedback.

Thanking you.

Have a easy life ahead.

Oracle 12c Logo

Create Pluggable Database using Database Configuration Assistant

We can create Pluggable database at the time of creation of Container database & we can also create Pluggable database with the help of Database Configuration Assistant.

Here we considered Container database already installed, if not then kindly follow my one of the post: Oracle 12c Installation

 

// To initiate database installer, start “Database Configuration Assistant” by issuing “dbca” command from bin library as shown below.

Continue reading

Oracle 12c Logo

Oracle 12c installation on Oracle Linux release-6 (64-bit)

Here we are installing Oracle 12c Release-1 (12.1)(64-bit) on Oracle Linux release-6 (64-bit)

Pre-requisite installation check on CentOS:

Minimum swap size 2GB.
IP Tables off.
SELinux set to permissive.

// Ensure swap size by issuing following command, if swap size do not meet minimum requirement then increase it. Continue reading

Oracle 12c Logo

Enhanced compression options in oracle 12c data pump

COMPRESSION_ALGORITHM parameter with options ( BASIC | LOW | MEDIUM | HIGH ) have been used to compress data pump dump files, Prior to oracle 12c compression algorithms have been used in RMAN backup only & only Basic compression has been used in data pump export.

But now on-words same feature is also available with data pump in oracle 12c edition. Continue reading

Oracle 12c Logo

Exporting views as tables – Oracle 12c Data Pump

Data Pump Export with VIEWS_AS_TABLES:

Now with the help of “VIEWS_AS_TABLES” export parameter we can export multiple views as tables, this smart feature of data pump is invented in Oracle 12c edition.

According to Oracle, VIEWS_AS_TABLES parameter exports data in unencrypted format & creates an unencrypted tables. If the data is sensitive then it is strongly recommended to enable encryption while unloading. Continue reading