Database 12c Opatch Failed error code 73 Solution

Problem description: Applying opatch failled: [oracle@ermankara 24732082]$ /u01/app/oracle/product/12.1.2/db/OPatch/opatch apply Oracle Interim Patch Installer version 12.2.0.1.9 Copyright (c) 2017, Oracle Corporation.  All rights reserved. Oracle Home       : /u01/app/oracle/product/12.1.2/db Central Inventory : /u01/app/oraInventory from           : /u01/app/oracle/product/12.1.2/db/oraInst.loc OPatch version    : 12.2.0.1.9 OUI version       : 12.1.0.2.0 Log … Continue reading Database 12c Opatch Failed error code 73 Solution

DBCA Templates Provided by Oracle

Here in DBCA we have to choose the template of our database which means that here we have to choose what kind of database we want to create. Here we have 3 options: Data warehouse :  Users perform numerous, complex queries that process large volumes of data. Response time, accuracy, and availability are key issues. … Continue reading DBCA Templates Provided by Oracle

Adding Physical Disk to Server -SCSI

SCSI ( Small Computer System Interface ) If you have added new storage to a running VM, you probably won’t see it. This is because the SCSI bus to which the storage devices are connected needs to be rescanned to make the new hardware visible. Linux, when adding a new disc. Connect to system with "root" … Continue reading Adding Physical Disk to Server -SCSI

WebLogic Server 11g and 12c Configure SSL for a Managed Server

Web browser connects to WebLogic Server by supplying the SSL listen port and the HTTPs protocol in the connection URL, for example, https://ip:7002/console Connect  to weblogic with Username / Password. Weblogic server must be reachable, Node Manager Type = Plain make sure that each server has the SSL port enabled. You can find the setting … Continue reading WebLogic Server 11g and 12c Configure SSL for a Managed Server

TOAD Grand Error on Oracle Database

I recently received the following error while trying to connect to a database. Error Message : "Access to the following views required: V$SESSION, V$PROCESS, V$SESS_IO, V$SESSION_WAIT, V$SESSION_EVENT, V$ACCESS, V$SESSSTAT, V$STATNAME, V$OPEN_CURSOR, V$SQL, V$LOCK, V$SESSION_LONGOPS, SYS.V_$TRANSACTION, SYS.V_$ROLLNAME, V$SQLTEXT_WITH_NEWLINES" Solution : Open a Linux  terminal and enter the SQL*Plus command: sqlplus /as sysdba SQL> Grant select any … Continue reading TOAD Grand Error on Oracle Database

Create Oracle Net Listener that is a network service on Oracle.

Create Oracle Net Listener that is a network service on Oracle.Login with the "oracle" user and input a command "netca"  or [oracle@ermantestdb ~] $cd $ORACLE_HOME/network/bin/ [oracle@ermantestdb ~] $ ./netca Check a box "Listener Configuration" and go next. Go next. Set Listner's name. This example goes next with keeping default TCP (Transmission Control Protocol ) Set a … Continue reading Create Oracle Net Listener that is a network service on Oracle.

How to Mount and Unmount an ISO Image in RHEL ( Version 5,6,7 )

If you want to install this package from the oracle installation DVD, you first need to mount the dvd and identify the address of the dvd to the oracle repository. # cd /etc/yum.repos.d # vi public-yum-ol6.repo Add the following code to the repository. ( public-yum-ol6.repo ) [Install_DVD_base] name=Install DVD baseurl=file:///cdrom/Server gpgcheck=0 enabled=1 skip_if_unavailable=True Create a … Continue reading How to Mount and Unmount an ISO Image in RHEL ( Version 5,6,7 )