To upgrade from Oracle 11gR2 to Oracle 18c/19c, we need to gather stat for fixed objects [oracle@localhost ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Feb 26 01:54:54 2018 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production With the Partitioning, […]
Articles Tagged: Oracle 18c
Remove OLAP for Oracle 18c
To upgrade from Oracle 11gR2 to Oracle 18c/19c, we need to remove OLAP. Remove OLAP Catalog by running the 11.2.0.4.0 SQL script $ORACLE_HOME/olap/admin/catnoamd.sql script. [oracle@localhost admin]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Feb 26 01:48:34 2018 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition […]
Remove EM for Oracle 18c
To upgrade from Oracle 11gR2 to Oracle 18c/19c, 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 gt; emctl stop dbconsole Step 2: Connect to the database using the SYS […]
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, […]
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 […]
First login to Oracle 18c
Database administrators have specific responsibilities and must understand how to complete database administration tasks. To get started with database administration, you must understand basic database concepts, such as the types of database users, database security, and privileges. You must also be able to complete basic tasks, such as submitting commands and SQL to the database and […]
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 […]
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 Example To set the […]
Oracle Database 18c and it’s features
Finally, Oracle officially released Oracle Database 18c with Oracle Documentation available on Oracle Public Cloud(OPC). To get more detailed on Oracle 18c release read Oracle Support Document 2285040.1. List of some new features in Oracle 18c: Data Guard Oracle Data Guard Multi-Instance Redo Apply Supports Use of Block Change Tracking Files for RMAN Backups Automatic Correction […]
TopicWise Interview Question on Oracle Database
Here is some Oracle Listeners Interview Question, hope it will help you. Listener Question: http://clouddba.co/generic-dba/ Here is some Oracle Tablespace Interview Question, hope it will help you. Tablespace Question: http://clouddba.co/generic-dba/ Here is some Oracle EXPDP IMPDP Datapump Interview Question, hope it will help you. EXPDP IMPDP Datapump Question: http://clouddba.co/expdp-impdp-datapump-interview-questions/ Here is some Oracle Database Architecture Interview Question, hope it will help you. Database Architecture Question: http://clouddba.co/database-architecture-interview-questions/ […]