Rollback applied patch ?

Sometimes a patch is applied to the system may need to take back because of its effect. In this case, rollback is performed as follows. $ORACLE_HOME/OPatch/opatch rollback -id Patch_id For example : $ORACLE_HOME/OPatch/opatch rollback -id 2435623

How to Find Character Set?

Oracle recommends Unicode AL32UTF8 as the database character set. Character Set Control: SQL> SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ; PARAMETER                     VALUE ------------------------------ ------------------------------ NLS_CHARACTERSET       AL32UTF8 It should return the value AL32UTF8. Another option is to run the following SQL … Continue reading How to Find Character Set?

Cloning an Oracle Home DB 12C

Perform the following to clone an Oracle home If you install patches, then check their status using the following $ cd $ORACLE_HOME/OPatch $ opatch lsinventory [oracle@ermankara OPatch]$ /u01/app/oracle/product/12.1.2/db/OPatch/opatch lsinventory 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    … Continue reading Cloning an Oracle Home DB 12C

Creating Control File in oracle database

SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS '/home/oracle/dbscripts/control_file.sql'; Database altered. SQL>exit Now open your control_file.sql [oracle@ermankara dbscripts]$ cat control_file.sql STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE "DB12CC" NORESETLOGS  NOARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE GROUP 1 ( '/data/DB12CC/onlinelog/o1_mf_1_dq1dsxry_.log', '/reco/DB12CC/onlinelog/o1_mf_1_dq1dsxvb_.log' ) SIZE 50M BLOCKSIZE 512, GROUP 2 ( '/data/DB12CC/onlinelog/o1_mf_2_dq1dsy3t_.log', '/reco/DB12CC/onlinelog/o1_mf_2_dq1dsy5p_.log' … Continue reading Creating Control File in oracle database

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

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.