Got this while trying to install 11.2.0.4 RAC on Redhat Linux 7.3. root.sh fails with a message like # /u01/app/11.2.0/grid/root.sh Performing root user operation for Oracle 11g The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/11.2.0/grid Enter the full pathname of the local bin directory: [/usr/local/bin]: The contents of “dbhome” have not changed. […]
All posts by Skant Gupta
Manual upgrading Oracle database 11gR2 to 18c
Manual upgrading Oracle database 11gR2 to 18c If you want to know how we upgrade an 11.2.0.4 database to 18.0.0.0.0 using DBUA, click here. This article explains how to upgrade 11.2.0.3 and above, and 12.1.0.1, 12.2.0.1 to 18.0.0.0.0 manually. Manually upgrading to 18c There are many DBAs who don’t want to follow the recommended way of an upgrade […]
Tablespaces Info for upgrading to 18c
To help you keep track of your tablespace allocations, the following AUTOEXTEND tablespaces are expected to successfully EXTEND during the upgrade process. Tablespace Size Min Size For Upgrade ———- ———- ———– SYSAUX 490 MB 718 MB SYSTEM 750 MB 1194 MB TEMP 54 MB 150 MB UNDOTBS1 85 MB 446 MB Minimum tablespace sizes for […]
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. [oracle@18c ~]$ opatch version OPatch Version: […]
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 […]
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 […]