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

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

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

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

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

Bash: sqlplus: command not found solution

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