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 […]

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. […]

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” […]

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 […]

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 […]

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 […]

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 […]

This are the commands that you need to Start and Stop a running Oracle Standby Database in Oracle 11g or 12c Start a Oracle Standby Database startup nomount; ORACLE instance started. Total System Global Area 3206836224 bytes Fixed Size 2257520 bytes Variable Size 1191185808 bytes Database Buffers 1979711488 bytes Redo Buffers 33681408 bytes alter database mount […]

When we open the database, the error message comes up. Now, we create spfile from pfile. We are shutting down the database so we can not overwrite the spfile of a running database.  We’re starting Oracle Database. Our fault is fixed. Now let’s create a user. The user was successfully created. Hits: 0

It is very easy to change the LVM name we already defined to our system. With just one command we can change the name of LVM. For this: For LVM Syntax: # lvrename /dev/oracle/oracle /dev/oracle vs/oracle Or # lvrename Volu_Group_Name Old_log_vol_name new_log_vol_name For Volume Group Syntax: # vgrename old_vol_group_name new_vol_group_name Hits: 1