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

Advertisements

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

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

OS: Oracle Linux 6.8 Oracle Database: 12c Problem Description: SQL> startup ORACLE instance started. Total System Global Area 1644167168 bytes Fixed Size     2925024 bytes Variable Size 1056968224 bytes Database Buffers   570425344 bytes Redo Buffers   13848576 bytes Database mounted. ORA-01589: must use RESETLOGS or NORESETLOGS option for database open  In this case, … Continue reading ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

RMAN > could not access datafile Error

This error is occur when RMAN is not able to access the desired datafile. RMAN>  backup database skip inaccessible; Starting backup at 10-AUG-17 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=7 device type=DISK could not access datafile 10 skipping inaccessible file 10 Solutions : RMAN> restore datafile 10; … Continue reading RMAN > could not access datafile Error

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