Today we are going to have look at the Database growth. With the help of the given query. DBA can find the monthly growth of there database. Sometimes little information is too much useful. select to_char(CREATION_TIME,’RRRR’) year, to_char(CREATION_TIME,’MM’) month, round(sum(bytes)/1024/1024/1024) GB from v$datafile group by to_char(CREATION_TIME,’RRRR’), to_char(CREATION_TIME,’MM’) order by 1, 2; Output […]
Monthly Archives: February 2018
SQLT in Oracle
SQLTXPLAIN, also known as SQLT, is a tool provided by Oracle Server Technologies Center of Expertise – ST CoE. SQLT inputs one SQL statement and outputs a set of diagnostics files. These files are commonly used to diagnose SQL statements performing poorly. SQLT connects to the database and collects execution plans, Cost-based Optimizer CBO statistics, […]
Drop the SQLT in Oracle Database
Uninstalling SQLT removes the SQLT repository and all SQLTXPLAIN/SQLTXADMIN schema objects. SQLTXPLAIN and SQLTXADMIN users also gets dropped. To uninstall SQLT simply execute sqlt/install/sqdrop.sql connected as SYS. [oracle@localhost ~]$ cd /home/oracle/sqlt/install [oracle@localhost install]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Wed Feb 14 04:31:10 2018 Copyright (c) 1982, 2016, Oracle. All rights reserved. […]
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-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 […]
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 [oracle@localhost ~]$ sqlplus […]
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 [oracle@localhost ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Feb 26 01:54:54 2018 Copyright […]
Compile Fixed Objects
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, […]
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 […]