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 [oracle@oracle122 admin]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Sat Mar 4 […]
Monthly Archives: March 2017
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 […]
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 […]
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 […]
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 […]
dbaascli dataguard reinstate
The dataguard reinstate subcommand of the dbaascli utility is used to reinstate a failed primary database as a standby database after a failover. Execute this command as the oracle user. dbaascli dataguard reinstate [–password password]
dbaascli dataguard failover
The dataguard failover subcommand of the dbaascli utility is used to perform a manual failover to the standby database in your Oracle Data Guard configuration. Execute this command as the oracle user. dbaascli dataguard failover [–force yes|no] [–password password]
dbaascli dataguard switchover
The dataguard switchover subcommand of the dbaascli utility is used to perform a switchover to the standby database in your Oracle Data Guard configuration. Execute this command as the oracle user. dbaascli dataguard switchover [–password password]
dbaascli dataguard status
The dataguard status subcommand of the dbaascli utility is used to check the status of the Oracle Data Guard configuration. Execute this command as the oracle user. dbaascli dataguard status [–details yes|no]
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 […]