Upgrading Oracle Grid Infrastructure 11gR2 to 12cR2

Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) Grid Infrastructure to Oracle 12cR2 (12.2.0.1) on the same server. This upgrade process was done on Linux 6 (x86_64). 1. Before the GI upgrade backup the OCR manually. This could be used in downgrading the GI from 12.2.0.1 to 11.2.0.4 later one. If you […]

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

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

Oracle Database 12c Release 2 (12.2) Installation On Redhat Linux 6

In this post, I’m installing the Oracle Database 12c Release 2 (12.2.0.1.0) software on Oracle Linux 6.4.  Only the software is being installed at this point, in preparation for a single database installation which I’ll create later on using the DBCA tool. First and foremost, before you start, make sure your Linux server meets the minimum […]

Read More

Long Identifiers In Oracle 12.2

SQL*Plus now supports object lengths of 128 bytes. In previous releases, the object length limit was 30 bytes and if you try to create object with length more than 30, it will throw error as ORA-00972: identifier is too long. Oracle 12.2 increases the maximum size of most identifiers from 30 to 128 bytes, which […]

Read More

spool CSV in Oracle 12.2

Now we can spool spool CSV or JSON from Oracle Database. Prior to 12.2 , we can spool as text or html, but from 12.2 onward, the SET MARKUP command now has a CSV option to output data in CSV format. Syntax CSV {ON|OFF} [DELIMI[TER] character] [QUOTE {ON|OFF}] Traditionally you wiill get formatted output (without […]

Read More

Oracle Database 12cR2 (12.2) On-Prem

Finally Oracle Database 12cR2 (12.2) On-Prem is available. Previously it was available only on cloud services. You can download it from eDelivery or OTN. Good Thing is that , now only zip file for Database Home as well as Grid Home. Prior to 12.2, There are 2 zip files for each of them. We can […]

Read More

SQL*Plus History In Oracle 12.2

In Oracle 12.2, SQL*Plus can keep the history of the commands executed. You can enable or disable the HISTORY command in the current SQL*Plus session by using the SET HISTORY command. The history feature is not enabled by default, so after you start SQL*Plus, you need to enable history by running “set hist[ory] on”

[…]

Read More

VARIABLE In Oracle 12.2

    You may use SQL*Plus to test queries with bind variables. Here is what you do before 12.2:

You can now simply:

Read More