Catalog Database Configure

Description:    RDB1 as TARGET SERVER                         RDB2 as CATALOG SERVER  create a database using DBCA on catalog server as catalog database i.e. RDB create a service in target server for the catalog server connection. check service alias using TNSPING servicename(EX:TNSPING RDB2) in terminal […]

Read More

Upgrade Oracle 11gR2 (11.2.0.4) database to 12cR2 (12.2.0.1)

Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) database to Oracle 12cR2 (12.2.0.1) on the same server. This upgrade process was done on Linux 6 (x86_64). I used DBUA (Database Upgrade Assistant) to perform this upgrade. DBUA is also a recommended way to perform the upgrade as it would automate almost everything […]

Read More

Displays contents of the registry history

Read More

How to make a table read only in Oracle

Oracle 11g allows tables to be marked as read-only using the ALTER TABLE command.

Let’s create a table and make it read-only.

Any DML statements that affect the table data results in an ORA-12081 error message.

DML and DDL operations return to normal once the table is switched back to read-write mode. […]

Read More