The Problem Oracle Real Application Clusters (RAC) servers run on CentOS/RHEL 7 and utilizing ASMLib-managed iSCSI multipathed disks. Upon server reboot, Oracle ASMLib disks are not automatically discovered at boot time causing Oracle Cluster Ready Services (CRS) to fail to start. ASM disks are, however, correctly discovered when manually running the oracleasm scandisks command soon after the server reboot. Following is the oracleasm configuration # cat … [Read more...] about ASMLib-Managed Disks on Multipathed iSCSI Targets are not Discovered after Server Reboot in CentOS/RHEL 7
oracle
How to load SELinux Module For Oracleasm
Question: How to load the SELinux module for oracleasm? When searching for the selinux oracleasm module with the locate command it may return as if the file exists: # locate /oracleasm.pp /etc/selinux/targeted/modules/active/modules/oracleasm.pp However, when running the command semodule to load the oracleasm.pp module it fails: # semodule --verbose -i /etc/selinux/targeted/modules/active/modules/oracleasm.pp Attempting to install module … [Read more...] about How to load SELinux Module For Oracleasm
SLES 12: Database Startup Error with ORA-27300 ORA-27301 ORA-27303 While Starting using Srvctl
The Problem 12.1 RAC database error while starting via srvctl, alert log showing database startup and further goes down: alert_ORCL2.log inside [oracle base]/diag/rdbms/[db name]/[SID name]/trace: Fri Nov 03 15:06:25 2017 Adjusting the default value of parameter parallel_max_servers from 960 to 486 due to the value of parameter processes (600) Starting ORACLE instance (normal) (OS id: 19684) . . Fri Nov 03 15:10:45 2017 Process startup failed, error stack: Fri Nov 03 15:10:45 … [Read more...] about SLES 12: Database Startup Error with ORA-27300 ORA-27301 ORA-27303 While Starting using Srvctl
New Connections to the Database lead to ORA-12518 or TNS-12518
The Problem ORA-12518 errors in the listener log when new users are connecting to the Database. Example is as follows: TNS-12518: TNS:listener could not hand off client connection TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter error TNS-00517: Lost contact IBM/AIX RISC System/6000 Error: 32: Broken pipe This is an intermittent problem that would likely occur at peak database usage times. The Solution There are two possible causes: If using DEDICATED … [Read more...] about New Connections to the Database lead to ORA-12518 or TNS-12518
ORA-12518: TNS:listener Could Not Hand Off Client Connection
On : 11.2.0.4 version, Clusterware, when attempting to connect to database via listener, the following error occurs: ERROR ----------------------- ERROR: ORA-12518: TNS:listener could not hand off client connection 15-AUG-2017 01:40:01 * (CONNECT_DATA=(CID=(PROGRAM=myapp)(HOST=__jdbc__)(USER=admin))(SERVER=DEDICATED)(SERVICE_NAME=oracle)) * (ADDRESS=(PROTOCOL=tcp)(HOST=11.22.33.44)(PORT=1521)) * establish * oracle * 12518 TNS-12518: TNS:listener could not hand off client connection … [Read more...] about ORA-12518: TNS:listener Could Not Hand Off Client Connection
Oracle 12c Multitenant Architecture: Troubleshooting Ora-12518
The Problem When attempting to connect to PDB via listener, the following error occurs. ORA-12518: TNS:listener could not hand off client connection Listener log: 03-APR-2017 08:57:31 * (CONNECT_DATA=(SID=wd1)(CID=(PROGRAM=d:\orasfw\prd1\bin\sqlplus.exe)(HOST=Host name )(USER=ismeirb))) * (ADDRESS=(PROTOCOL=tcp)(HOST=XX.XX.XX.XX)(PORT=63994)) * establish * wd1 * 12518 TNS-12518: TNS:listener could not hand off client connection TNS-12560: TNS:protocol adapter error TNS-00530: … [Read more...] about Oracle 12c Multitenant Architecture: Troubleshooting Ora-12518
Empty Directories in the Flash Recovery Area (FRA) are not deleted
The Problem RMAN archived redolog backups and maintenance commands are deleting files from the Flash Recovery Area (FRA) when needed. For example: RMAN> backup archivelog all delete input; delete obsolete; These commands only delete the files, but not the actual directories when they are empty after the deletion of the files. The Solution When there is an empty subdirectory that is more than 7 days old, they will get purged automatically at the end of controlfile backup. The … [Read more...] about Empty Directories in the Flash Recovery Area (FRA) are not deleted
Beginners Guide to Flash Recovery Area in Oracle Database
This post discusses the below topics: Benefits of using Flash Recovery Area. Explains how to Create FRA using DB_RECOVERY_FILE_DEST_SIZE and DB_RECOVERY_FILE_DEST Database Files that can reside in Flash Recovery Area. How to Disable FRA What is a Flash Recovery Area? The flash recovery area can be defined as a single, unified storage area that keeps all the database recovery related files and performs recovery activities in an Oracle database. The flash recovery area is the most … [Read more...] about Beginners Guide to Flash Recovery Area in Oracle Database
Oracle Interview Questions – Flash Recovery Area
Naming convention: Oracle 10g: FLASH Recovery Area Oracle 11g: FAST Recovery Area 1. What is a Flash Recovery Area ? The flash recovery area is an Oracle-managed directory, file system, or Automatic Storage Management disk group that provides a centralized disk location for backup and recovery files. All the files you need to completely recover a database from a media failure are part of the Flash Recovery Area. Oracle creates archived logs and flashback logs in the flash recovery area. … [Read more...] about Oracle Interview Questions – Flash Recovery Area
How to Identify Different File types and space used in Flash Recovery Area
Question: How to find out the existence of different types of files and backups available with the usage of space in the Flash Recovery Area? Starting with Oracle 10G Release 2, a new view has been made available: V$FLASH_RECOVERY_AREA_USAGE. V$FLASH_RECOVERY_AREA_USAGE shows the percentage of the total disk quota used by different types of files, and how much space for each type of file can be reclaimed by deleting files that are obsolete, redundant, or already backed up to tape. SQL> … [Read more...] about How to Identify Different File types and space used in Flash Recovery Area