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

Installing Oracle 18c Binary on OEL 6.3

In this post, we are installing Oracle 18c binaries on OEL 6.3. First, we need to download the software and start runInstaller from software location. Select a “Set Up Software Only” and click next. Select on “Single instance database Installation” and click on next. Select on “Enterprise Edition” and click on next Put the Oracle […]

Read More

Display the sql_id for a query in Oracle 18c

The SET FEEDBACK command has an SQL_ID option to display the sql_id for the currently executed SQL or PL/SQL statements. The sql_id will be assigned to the predefined variable SQL_ID. Displays the number of records returned by a script when a script selects at least n records. SQL_ID returns the sql_id for the SQL or PL/SQL […]

Read More

SET LINESIZE window in Oracle 18c

Sets the total number of characters that SQL*Plus displays on one line before beginning a new line. WINDOW adjusts the linesize and pagesize for the formatted output according to the width and height of the screen. If the output is longer than the screen width, then the output is wrapped accordingly

To dynamically change […]

Read More