The Oracle DBA's

Issue: Can not Mount database in exclusive mode (RAC) On Startup or startup mount getting error ORA-01102: cannot mount database in EXCLUSIVE mode Database is running already on an instance Solution: Check If database is running on any node of RAC  and if yes then check whether the cluster parameter is true or not. ""It should be True"" Best Wishes, Nikhil Kumar. In SAP env connection between DB and app beaks multiple times??? ORA-19625 ORA-17503 ORA15012 failure of Archive backup via RMAN Protocol adaptor erro: Insufficient Privillege during starting the listener...

Issue: Can not Mount database in exclusive mode On Startup or startup mount getting error ORA-01102: cannot mount database in EXCLUSIVE mode Solution: If Database is go $ORACLE_HOME/dbs check if there is any 1K<SID>.dbf file is there if there is, remove that. now Make sure that DB is shut down and try to see if any background job is still running regarding the SID. ps -ef | grep ora_ | grep $ORACLE_SID Now kill these processes and after killing all these processes try to start the DB It should work. Best Wishes, Nikhil Kumar. In SAP env connection between DB and app beaks multiple times??? ORA-19625 ORA-17503 ORA15012 failure of Archive backup via RMAN Protocol adaptor erro: Insufficient Privillege during starting the listener...

Issue: Unable to start listener as it throws error as below: eul2006:oraSID 56> lsnrctl start LISTENER LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 07-FEB-2017 11:55:04 Copyright (c) 1991, 2010, Oracle.  All rights reserved. Starting /oracleSID/SID/112_64/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.2.0 - Production System parameter file is /oracleSID/SID/112_64/network/admin/listener.oraLog messages written to /oracle/diag/tnslsnr/eul2006/listener/alert/log.xml Error listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=SID.WORLD)) TNS-12555: TNS:permission denied TNS-12560: TNS:protocol adapter error TNS-00525: Insufficient privilege for operation Listener failed to startLinux Error: 1: Operation not permitted ee the error message(s) above..." Description: The reason for this issue could be if listener was not stopped correctly means got killed at OS level or any other thing. Solution. Just remove the all listener socket files of th

Issue: Some times You might find the issue (Especially in SAP env) that, your application is showing connection good with your Database (RAC) and all of sudden not, and then again shows connection then again not... When you run R3trans -d from Application ( SAP) many times output comes as 0000 and many times 0012. And in this if you find: [oracle@eul2504 ~]$ sqlplus /@SID001 SQL*Plus: Release 11.2.0.2.0 Production on Fri Jun 16 01:03:28 2017 Copyright (c) 1982, 2010, Oracle.  All rights reserved ERROR:ORA-01017: invalid username/password; logon denied Then There is a chance that one of the node in RAC might have remote parameter set wrong. Solution: Check for the remote authentication parameter: "primary:sys@SID001> show parameter AUTHENT NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------- os_authent_prefix                    string          ops$ remote_os_authent                  b