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

RDBMS DST Upgrade

After upgrading to Oracle 12.2, we face the issue of RDBMS DST timezones.Then either check support id 1585343.1 or else follow the below step 1.Connect to “sqlplus” and run the “upg_tzv_check.txt” file. If you want to download the content of upg_tzv_check

2. Now check the current timezone.

3. Now run the “upg_tzv_apply.txt” file. […]

Read More

Manual upgrading Oracle database 11gR2 to 12cR2

Manual upgrading Oracle database 11gR2 to 12cR2 If you want to know how we upgrade an 11.2.0.4 database to 12.2.0.1 using DBUA, click here. This article explains how to upgrade 11.2.0.2 and above, and 12.1.0.1 to 12.2.0.1 manually. Manually upgrading to 12c There are many DBAs who don’t want to follow the recommended way of upgrade […]

Read More

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