All Articles

Administration/Recovery/RMAN

Oracle Flex Cluster Oracle Flex ASM Autostart of Pluggable Databases Setting Huge Pages in Linux Disabling Transparent Huge Pages on Linux 6 and Linux 7 RMAN Duplicate Database using Live/Active Database RMAN DUPLICATE Database using Backup of a Database DDL Logging in 12C Oracle 12c Online Partition Move Starting and Stopping Grid Infrastructure on a Standalone GI Installation Starting and Stopping Oracle Cluster (RAC) Starting and Stopping OEM Cloud Control 13c Finding Cache Hit Ratios History Oracle Snapshot Standby Database Creating ASM Diskgroups Stamp Disks on Windows for ASM Creating ASM Disks using ASMLib Configuring Oracle ASMLib on Linux Configuring RMAN Backup Configuring Oracle Dataguard Configuring Oracle Dataguard for RAC Creating Standby Database using Duplicate from Active Database Performing Disaster Recovery using RMAN Issues with Bind Variables and Bind Peeking WARNING: inbound connection timed out (ORA-3136) Oracle Segment Adviser Recommendations and Redo/Undo Generation During Segment Shrink Implementing Class of Secure Transport (COST) RMAN Backup Performance Converting a Failed Over Standby Database Back to Standby Database OEM Database Control Setup fails with ACCESS DENIED error OEM Database Control Configuration gets Stuck ORACLE.EXE (SHAD) Processes Keep Increasing Universal Unique Identifier (UUID) error during 12c RAC Installation Warning: PDB altered with errors and PDB_PLUG_IN_VIOLATIONS Testing RMAN Restore Terminating the instance due to error 481 Transparent Data Encryption in 11g Transparent Data Encryption in 12c File #... added to control file as 'UNNAMED000' and ORA-15041 Migrating from ASMLib to Oracle ASM Filter Driver (ASMFD) Running cluvfy (Cluster Verification Utility) during 12cR2 RAC installation Slow RMAN Performance for CROSSCHECK and DELETE OBSOLETE Point in Time Recovery of a Pluggable Database Resuming Database Upgrade Assistant after Error How to Add and Remove database to CRS or Oracle Restart Creating services with srvctl Managing ASM Power Limit During Disk Re-balance Migrating from Filesystem to ASM Restricting Access/Connections to the Database Initialization parameter value setting back to original value automatically DBMS_AW_EXP: BIN$ZRGxDTT9TumIWFOmM0qIHQ==$0 not AW$ Not All Endpoints Registered ddl_lock_timeout to avoid ORA-00054 Dataguard out of sync OR Log shipping not working Standby Database Archived Redo Logs Gap and Incremental Restore Pluggable Database Remote Cloning Using Database link Pluggable Database Cloning on Local Host (Local CDB) enq: TX - row lock contention - Row Lock Wait Low or Poor Buffer Cache Hit Ratio and Full Table Scans Direct Path Read and Full Table Scan Changing Oracle Scheduler Maintenance Windows Timing and Settings ARCH Process Not Working - Killing Archive Process Moving Accidentally Created Datafile on Local File System in RAC to the Shared File System Rotating Listener Log File Time Based and SCN Based Flashback Recovery Database Point in Time Recovery of a Pluggable Database and Conventional Databases

Backing up OEM Cloud Conrol 12c, 13c Creating Oracle Database Using dbca in 12cR1 Creating Oracle Database Using dbca in 12cR2 Creating a Real Application Cluster(RAC) 12c database using DBCA Excessive PGA Memory Usage by Sessions and System Hang Tablespace Reorganization Oracle IO Consumption - Throughput (IOPS) and Transfer Rate (MBPS) Segment Space Growth History and Forecast Database Growth History and Forecast (10g, 11g) Tablespace Growth History and Forecast (10g, 11g) Tablespace Growth History and Forecast (For 12c and Above) Database Growth History and Forecast (12c and Above) DBA_TABLESPACE_USAGE_METRICS and CDB_TABLES_ACES_USAGE_METRICS Using Oracle Orion for IO Calibration Oracle Stats Gathering During Automated Maintenance Tasks Window Manual RAC Database Creation Installing Oracle Database 11.2 on IBM AIX 6.1 (Includes HACMP) OEM 12c Job Failing With "ERROR: Failed to create command process" The OracleService service terminated unexpectedly Configuring SSH for Oracle RAC installation Performing Block Media Recovery Fractured block found during backing up datafile Killing a process using orakill.exe on Windows CDB_TABLESPACES not Showing Tablespaces of Pluggable Database Oracle 12c Online Datafile Move Oracle Deferred Segment Creation Generating Bulk data for Testing Using DBMS_STATS to Gather Statistics Changing Listener and SCAN Listener Ports Enable Asynchronous IO for file System using FILESYSTEMIO_OPTIONS Calculating ASM diskgroup Usable Size Privilege Analysis in 12c Converting a non-CDB database to a PDB Table Point in Time Recovery using RMAN Using Cluster Verification Utility (cluvfy) Configuring OEM Express Control OEM Cloud Control Job Suspended - Target is not ready Data Masking using OEM Cloud Control Configuring Oracle ASM Filter Driver (ASMFD) and Labeling Disks Testing ASM Disk Failure Scenario and disk_repair_time Unplugging and Plugging in of a Pluggable Database ASM Disk not Accessible and not Appearing in V$ASM_DISK Slow tnsping Response and Slow Connections to the Database OEM Target Status Pending – OEM Metric Collection Error How to Enable Block Change Tracking Deinstalling or Removing Oracle software Why Opatch Auto is not applying PSU on Database Home? Archivelog Deletion Policy for RMAN Bind Variable Peeking Prior to 11g Adaptive Cursor Sharing ASM Disks not Reachable After Reboot - Manually Loading ASM Driver Checking Redo Log Switch and Redo Generating by Session Renaming Datafile(s) in Standby Database Monitoring RMAN Restore and Recovery Progress SQL Plan Management and SQL Baseline PX Deq: Signal ACK RSG Finding Size and Number of Rows in Each Table of a Schema Using Oracle Database Flashback and Creating Restore Point Switchover to Physical Standby Database Using Dataguard Broker DGMGRL Recovering a Dropped Table using RMAN Backup Investigating "read by other session" Wait Event Listener log file is empty and logging not happening

Linux/Virtual Box

Installing Oracle Linux 7 for DBAs Installing Oracle Linux 6 for DBAs Basic Linux Commands for DBAs Finding IO statistics in Linux Environment for Slow Disks Using scp command on Linux to copy Files and Directories

Running a Command or Script in Background on Linux Creating Virtual Machine using Oracle Virtual Box Creating Shared Disks for Oracle RAC on Oracle Virtual Box Linux Error: No Space Left on Device Finding Top Memory and CPU Consumers Using “top” Command

Installation/Patch/Upgrade

Type of Patches in Oracle – Patch Set Update (PSU), (Security Patch Update/Critical Patch Update (SPU/CPU), Bundle Patch, Proactive Bundle Patch Installing OEM 13c on Linux 6 and 7 Upgrade/Patch Grid Infrastructure 12.1.0.1 to 12.1.0.2 Upgrade Grid Infrastructure 11g to 12c Upgrade/Patch Oracle Database 12.1.0.1 to 12.1.0.2 using DBUA Upgrading Oracle Database 11g to 12c using DBUA Manual Upgrading Oracle database 11g to 12c Oracle Patching in Multitenant Environment with Minimal Downtime Installing Weblogic Server 12.2 on Linux 6 Linux 7 and Windows Creating Weblogic Domain for Weblogic Server DBUA Does not Find parameter file to Start Database for Upgrade

Installing Oracle 12c R2 RAC on Linux 6 and Linux 7 Installing Oracle 12c R1 RAC on Linux 6 Installing Oracle 12c R1 RAC on Linux 7 Installing Oracle 12c R2 Grid Infrastructure on Linux 6 and Linux 7 Installing Oracle 12c R2 Database Software on Linux 6 and Linux 7 Installing Oracle 12c R1 Grid Infrastructure on Linux 6 Installing Oracle 12c R1 Database Software on Linux 6 Installing Oracle 12c R1 Grid Infrastructure on Linux 7 Installing Oracle 12c R1 Database Software on Linux 7 Installing Oracle Fusion Middleware 12.2 on Linux 6, Linux 7 and Windows Initial Configuration of Fusion Middleware after the Installation Creating Weblogic Domain for Fusion Middleware Starting and Stopping Weblogic Server

Performance Tuning

Reading and Understanding AWR Report for IO or Disk latency - 1 Reading and Understanding AWR Report for IO or Disk latency - 2 Finding Sessions with High CPU Usage CPU Percentage Vs. CPU Load Average for DBAs gc buffer busy acquire and gc buffer busy release Read by Other Session - Oracle Wait Event

Changing AWR Snapshot Retention and Interval Checkpoint not Complete Don't COMMIT Too Often Using PGA_AGGREGATE_LIMIT to Limit PGA Memory Poor Database Performance After Setting Huge Pages Finding High CPU Consuming SQLs with Multiple Plans How to Invalidate a Cursor to Load a New Plan

Oracle Error Messages

ORA-15001 because ASM Diskgroup is Not Accessible by oracle user ORA-65139 Mismatch between XML metadata file and data file ORA-01017: invalid username/password - While Starting Instance using srvctl ORA-01113 when Tablespace is in Backup Mode ORA-38500 While Enabling Real-Time Redo Apply ORA-12514 During Switchover to Standby ORA-04030: Out of Process Memory ORA-04031 Unable to Allocate Bytes from Shared Memory ORA-00376 "file#" cannot be read at this time ORA-12154 and TNS-03505 ORA-17627 and ORA-12154 Returned by RMAN Duplicate Command ORA-12154 TNS:could not resolve the connect identifier specified in RAC (with Server Side Load Balancing) ORA-03113 end-of-file on communication channel ORA-01031 insufficient privileges - While logging in AS SYSDBA ORA-46661: keystore not open in root container ORA-28354: Encryption wallet, auto login wallet, or HSM is already open ORA-28417: password-based keystore is not open ORA-46658: keystore not open in the container ORA-46633: creation of a password-based keystore failed ORA-46630: keystore cannot be created at the specified locatio ORA-03264 cannot drop offline datafile of locally managed tablespace ORA-65026 XML metadata file error : LPX-00202: could not open ORA-06553: PLS-801: internal error [56319] ORA-00020: maximum number of processes exceeded ORA-01653: unable to extend table by 8192 in tablespace Heartbeat failed to connect to standby. Error is 16009 ORA-03135: connection lost contact ORA-24247: network access denied by access control list (ACL) TNS-12560: TNS:protocol adapter error Error: OSWatcher uses the OS utility Logman to gather its data ORA-16058 RMAN-00600: internal error, arguments [9222] [] [] [] [] CRS-4563: Insufficient user privileges ORA-00313 ORA-00312 ORA-17503 ORA-15173 in Standby Alert Log File CRS-4700: The Cluster Time Synchronization Service is in Observer mode ORA-00845: MEMORY_TARGET not supported on this system ORA-01013: user requested cancel of current operation ORA-01013: ORA-02095: specified initialization parameter cannot be modified ORA-12170 : TNS:Connect timeout occurred ORA-01145: offline immediate disallowed unless media recovery enabled CRS-0245: User doesn't have enough privilege to perform the operation ORA-00257 archiver error ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE Error 3113 in Primary Database while connecting Standby RMAN-08138: WARNING: archived log not deleted ORA-15075: disk(s) are not visible cluster-wide ORA-39087: directory name directory_name is invalid ORA-01126: database must be mounted in this instance and not open in any instance ORA-17503 ORA-27140 ORA-27300 ORA-27301 ORA-27302 ORA-39700: database must be opened with UPGRADE option kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089 ORA-01186 ORA-01157 ORA-01111 ORA-01110 ORA-01000: maximum open cursors exceeded ORA-01511 and ORA-01523 ORA-15046: ASM file name...is not in single-file creation form CORRUPTION DETECTED: In redo blocks starting at block in dataguard ORA-65179: cannot keep datafiles for a pluggable database that is not unplugged ORA-15039 and ORA-15001 while Dropping an ASM disk group Error: ORA-16765: Redo Apply is running ORA-16541: database is not enabled ORA-16024: parameter LOG_ARCHIVE_DEST_1 cannot be parsed ORA-15073: diskgroup DATA is mounted by another ASM instance ORA-19821: an intentionally corrupt log file was found ORA-16028 while setting log_archive_dest_n parameter ORA-16467: switchover target is not synchronized ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege ORA-01017: invalid username/password during dataguard switchover ORA-01157: cannot identify/lock data file and ORA-01110 ORA-19910: can not change recovery target incarnation in control file TNS-12508: TNS:listener could not resolve the COMMAND given ORA-65342: source pluggable database has unrecovered transaction ORA-16000: database or pluggable database open for read-only access ORA-02149: Specified partition does not exist ORA-56747: invalid value ... for parameter sga_target ORA-00371: not enough shared pool memory ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT ORA-00821: Specified value of sga_target 5120M is too small, needs to be at least 12352M ORA-29339: tablespace block size 4096 does not match configured block sizes ORA-01103: database name ... in control file is not ...

ORA-01555 Snapshot too old ORA-29701: unable to connect to Cluster Synchronization Service ORA-01157: cannot identify/lock data file ORA-01031 insufficient privileges during switchover using DGMGRL ORA-00054 resource busy and acquire with NOWAIT specified or timeout expired ORA-01031 While Creating or Accessing a View ORA-12514 During OEM Database Control Configuration for RAC ORA-00942 During upgrade to 11.2.0.3 or later on Windows ORA-29702 While Starting 10.2.0.4 Instance(s) on 11.2.0.3 RAC/Clusterware ORA-00942 table or view does not exist ORA-01624: log Needed for Crash Recovery of Instance [NS-20802] Grid Infrastructure Configuration Failed - During 11.2 RAC installation on Windows 2008R2 PRCR-1065 Failed to stop resource ora.asm PRCA-1057 Failed to retrieve the password file location used by ASM asm ORA-00214: control file 'string' version string inconsistent with file 'string' version string TNS-12531: TNS:cannot allocate memory ORA-15410: Disks in disk group DISKGROUP_NAME do not have equal size ORA-20005: object statistics are locked RMAN-05001 auxiliary filename string conflicts with a file used by the target database ORA-00354: corrupt redo log block header ORA-19909: datafile 1 belongs to an orphan incarnation ORA-00221: error on write to controlfile ORA-28365: wallet is not open CRS-4535: Cannot communicate with Cluster Ready Services CRS-4535: While Starting CRS ORA-38760: This database instance failed to turn on flashback database ORA-38701: Flashback database log... Error 1017 received logging on to the standby - Along with ORA-16191 Fatal NI connect error 12537 Fatal NI connect error 12547, connecting to: ASMCMD-9524: AFD configuration failed 'ERROR: ASMLib deconfiguration failed' "Message 279 not found" while starting Listener Error 1031 received logging on to the standby ORA-39510 While Starting Cluster Health Monitor Repository (MGMTDB) ORA-01586: database must be mounted EXCLUSIVE and not open for this operation ORA-00742: Log read detects lost write in thread %d sequence %d block % Error 1033 received logging on to the standby Error 12154 received logging on to the standby ORA-16191: Primary log shipping client not logged on standby PRKO-3141 : Database could not be removed because it was running ORA-48913: Writing into trace file failed, file size limit... ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated Fatal NI connect error 12541 ORA-01654 and ORA-03234 for index tablespace ORA-01652: unable to extend temp segment by 128 in tablespace TEMP RMAN-03009 and ORA-19510: failed to set size of 92079 blocks for file ORA-01503: CREATE CONTROLFILE failed with ORA-01192 ORA-00245: control file backup failed; target is likely on a local file system PING[ARC1]: Heartbeat failed to connect to standby 'my_standby'. Error is 12154 ORA-12899: value too large for column... ORA-01438: value larger than specified precision allowed for this column ORA-12546: TNS:permission denied ORA-00972: identifier is too long ORA-10485: Real-Time Query cannot be enabled while applying migration redo ORA-19809: limit exceeded for recover files ORA-15032 ORA-15040 ORA-15042 while mounting a diskgroup ORA-17502 and ORA-15001 ORA-17627: ORA-01017: invalid username/password; logon denied ORA-16053: DB_UNIQUE_NAME my_dr, is not in the Data Guard ORA-00093: pga_aggregate_limit must be between... Error: Do not have sufficient voting files - Restoring Voting Disk ORA-01105: mount is incompatible with mounts by other instances ORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified ORA-16012: database identifier mismatch Error: ORA-16724: cannot resolve gap for one or more standby databases Error ORA-235 occurred during an un-locked control file transaction ORA-46697: Keystore password required ORA-65040: operation not allowed from within a pluggable database ORA-65179: cannot keep datafiles for a pluggable database that is not unplugged ORA-12578: TNS:wallet open failed ORA-16789: standby redo logs configured incorrectly ORMAN-20208: UNTIL CHANGE is before RESETLOGS change ORA-13792: This operation requires a database link RMAN-06617: UNTIL TIME (20-JUN-24) is ahead of last NEXT TIME in archived logs... ORA-03214: File size specified is smaller than minimum required RMAN-06617: UNTIL TIME is ahead of last NEXT TIME in archived logs