DBMS_TNS package for tnsping in database Oracle 12.2

DBMS_TNS package provides the RESOLVE_TNSNAME function to resolve a TNS name and return the corresponding Oracle Net8 connection string.When you connect locally to the server (no SQL*Net, no listener), the Oracle session inherits the client environment.   It is available on oracle 12.2 Release . The DBMS_TNS package contains one function, RESOLVE_TNSNAME, which returns the […]

Read More

Read only Partition in Oracle 12.2

Till now we can make a table read only, But what about setting few partitions of a table to read-only. Thanks to Oracle 12.2 Release, We can do this. This is usually helpful, If requirement is to make the historical data not editable.

SYNTAX – ALTER TABLE MODIFY PARTITION READ ONLY;

If you […]

Read More

Split partition online oracle 12.2

In Oracle 12.2, We can split partitions or subpartitions online without impacting the DML statements.

Read More

Local/Shared Undo mode in oracle 12.2 multitenant database

There are two undo modes in oracle 12.2 Multitenant database 1. Local undo mode 2. Shared undo mode Local undo mode: In this mode, each container ( i.e PDB ) in multitenant will have their own active undo tablespace. Share Undo mode: In this mode, There will be only one undo tablespace for the instance. […]

Read More

Creating Oracle Database 12cR2 with DBCA in text mode

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. A database is a collection of information that is organized so that it can be easily accessed, managed and updated.Data is organized into rows, columns, and tables, and it is indexed to make it easier to find relevant information. Data […]

Read More

Creation of Listener via NETCA in text mode

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. We know NetCA  Oracle command line for configuring the Oracle listener. NetCA stands for (Network Configuration Assistant). NetCA is used as a configuration assistant launched by the OUI at install time. It is more suitable for a batch mode for silent installations. I […]

Read More

Installing Oracle Database 12cR2 in text mode

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. This is an article about Installing Oracle Database 12cR2 in text mode using the response file. Oracle Database 12cR2 Installation Process via response file This is the response file I used, feel free to download it: db_install.rsp. Adjust the response file according to […]

Read More

Oracle Data Guard 12cR2 “Multitenant”(Part -3)

I must thank my fellow DBA César Aguilar and Joel Pérez for his publication in Spanish OTN. Continuing with the sequence of Oracle Data Guard 12c articles in “Multitenant” Architecture: PDBs behavior, we will end the series by analyzing what happens in the Data Guard “DG” when we delete and when we do an “unplug” […]

Read More