Component : Oracle -

Solution : https://service.sap.com/sap/support/notes/583861 (SAP Service marketplace login required)

Summary :
Various Oracle-related errors including "ORA-03113: end-of-file on communication channel," "ORA-07497: cannot create trace file," and "ORA-12500: TNS:listener failure," indicate issues mainly associated with the connection to the database, parallel queries, and live database operations. These issues stem from incorrect or missing executable files in the Oracle $ORACLE_HOME/bin directory. The resolution involves verifying and correcting the file presence, size, and permissions (specifically "-rwsr-s--x"), ensuring file ownership by ora and group dba, and potentially relinking the software using SAP Note 97953. Additionally, directory permissions should reflect "drwxr-xr-x," and attention should be paid to the file system’s support for the s-bit without setting NOSUID. Corrections might also require system tools like ipcs/ipcrm or a system reboot if shared memories are hanging or semaphores are misassigned.

Key words :
chmod 6751 oraclechown ora<sid> oraclechgrp dba oraclealso check, oracle software previous hardware problems, post/wait facility failedora-09925, recursive sql level 1ora-01110, data file <file>ora-27041, io error writing block, io error reading block, bad file number errors, open file<unix> error, create audit trail fileora-09817

Related Notes :

761171	CPCC Service Package 2.2.300
723641	Composite SAP Note: ORA-12545
722966	Composite SAP Note: ORA-12546
592393	FAQ: Oracle
546006	Problems with Oracle due to operating system errors
491174	Composite SAP note for ORA-01034
480266	Problems with the SYSDBA/SYSOPER/INTERNAL connect
437362	Composite note ORA-12500
370278	ORA-3113 when starting SQLPLUS or SVRMGRL
97953	UNIX: Relinking of the Oracle executables