Error Messages: [oracle@ermankara ~]$ sqplus / as sysdba -bash: sqplus: command not found Environment variable has been with a good, but still error: [oracle@ermankara ~]$ cat .bash_profile # Oracle Settings export TMP=/tmp export TMPDIR=$TMP export ORACLE_HOSTNAME=ermankara.localdomain export ORACLE_UNQNAME=db12cc export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/12.1.2/db export ORACLE_SID=db12cc export PATH=/usr/sbin:$PATH export PATH=$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib Solution : … Continue reading Bash: sqlplus: command not found 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 22.214.171.124.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 : 126.96.36.199.9 OUI version : 188.8.131.52.0 Log … Continue reading Database 12c Opatch Failed error code 73 Solution
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
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
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
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.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.