Apply Patch on Oracle 18c Database

In this post, we are going to apply bug fix patch for testing in Oracle 18c Database. First of all, we can download latest opatch utility from support. Doc ID 274526.1 -> How To Download And Install The Latest OPatch (6880880) Version. Check the version from new OPatch utility.

Now we are going to […]

Read More

Background Processes and Listener in Oracle 18c

In this post we can see that how many background processes will come after starting the Oracle 18c Database on virtual box. Also we can create listener in Read Only Home to connect the database remotely with the help of tns entry. Let me start the newly created 18c Database. Configured the Listener Manually or […]

Read More

Upgrade Database from Oracle 11gR2 to Oracle 18c

Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) database to Oracle 18c(18.0.0.0.0) on the same server. This upgrade process was done on Linux 7 (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 for you. You should be able to use the […]

Read More

Read-Only Oracle Homes on Oracle 18c

Starting with Oracle Database 18c, you can configure an Oracle home in read-only mode. In a read-only Oracle home, all the configuration data and log files reside outside of the read-only Oracle home. This feature allows you to use the read-only Oracle home as a software image that can be distributed across multiple servers. Apart […]

Read More

ORA-12754: Feature ‘startup’ is disabled due to missing capability ‘Runtime Environment’

Installation of the Oracle 18c database software has been successfully completed, now while trying to run DBCA, there was an ORA-12754 error. Start DBCA DEBUG function, did not find valuable information, or decided to build a database by hand. However, the configuration of the password file and parameter file, the error is still

It […]

Read More

Upgrade Apex for Oracle 18c

Starting with Oracle Database Release 18, APEX has not upgraded automatically as part of the database upgrade. Refer to My Oracle Support Note 1088970.1 for information about APEX installation and upgrades. To download the latest APEX: Click Here

Stay tuned for more articles on Oracle 18c  Thank you for giving your valuable time to read […]

Read More

Compile Fixed Objects

To upgrade from Oracle 11gR2 to Oracle 18c, we need to gather stat for fixed objects

Stay tuned for more articles on Oracle 18c  Thank you for giving your valuable time to read the above information. If you want to be updated with all our articles send us the Invitation or Follow us: Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/ […]

Read More

Remove OLAP for Oracle 18c

To upgrade from Oracle 11gR2 to Oracle 18c, we need remove OLAP. Remove OLAP Catalog by running the 11.2.0.4.0 SQL script $ORACLE_HOME/olap/admin/catnoamd.sql script.

Stay tuned for more articles on Oracle 18c  Thank you for giving your valuable time to read the above information. If you want to be updated with all our articles send us […]

Read More

Remove EM for Oracle 18c

To upgrade from Oracle 11gR2 to Oracle 18c, we need to Enterprise Manager. Copy the $ORACLE_HOME/rdbms/admin/emremove.sql script from the target 18.0.0.0.0 ORACLE_HOME into the source 11.2.0.4.0 ORACLE_HOME. Step 1: If database control is configured, stop EM Database Control, using the following command

Step 2: Connect to the database using the SYS account AS SYSDBA […]

Read More

Flow Chart and Upgrade Paths for Oracle Database 18c

You can perform a direct upgrade to the new release from the following releases: 11.2.0.3 and 11.2.0.4 12.1.0.1 and 12.1.0.2 12.2.0.1 The path that you must take to upgrade to the latest Oracle Database release depends on the release number of your current database. If your current Oracle Database is a release earlier than 11.2.0.3, […]

Read More