The Oracle DBA's

Issue: In my alert log file i found several errors like below ones, Sun Aug 20 06:22:57 2017 Errors in file /oracleSID/diag/rdbms/SID/SID/trace/SID_j000_17106.trc: ORA-01114: IO error writing block to file  (block # ) Sun Aug 20 09:00:01 2017 Errors in file /oracleSID/diag/rdbms/SID/SID/trace/SID_j000_18872.trc: ORA-01114: IO error writing block to file  (block # ) Errors in file /oracleSID/diag/rdbms/SID/SID/trace/SID_j000_18872.trc: ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB" ORA-01114: IO error writing block to file  (block # ) ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073 ORA-06512: at line 1 Sun Aug 20 11:15:42 2017 Thread 1 cannot allocate new log, sequence 12922 Wed Aug 23 22:14:22 2017 Errors in file /oracleSID/diag/rdbms/SID/SID/trace/SID_m001_26283.trc: Wed Aug 23 22:14:27 2017 Dumping diagnostic data in directory=[cdmp_20170823221427], requested by (instance=1, osid=26283...

Issue : On pluggable database , unable to create user.... SQL> create user sapsr3 identified by sapsr3; create user sapsr3 identified by sapsr3             * ERROR at line 1: ORA-65096: invalid common user or role name Solution: For this connect as sys or system to the database and set parameter "_ORACLE_SCRIPT' to true. SQL> alter session set "_ORACLE_SCRIPT"=true; Session altered. SQL> create user sapsr3 identified by sapsr3; User created. SQL> select username,account_status from dba_users where username='SAPSR3'; USERNAME                       ACCOUNT_STATUS ------------------------------ -------------------------------- SAPSR3                         OPEN Best Wishe...

ISSUE: Sun Jul 09 05:37:05 2017 Errors in file /oracleSID/SID/saptrace/diag/rdbms/SIDstnd/SID/trace/SID_pr00_4496.trc: ORA-19502: write error on file " /oracleSID/SID/sapdata2/undo_31/undo.data31 ", block number 434688 (block size=8192) ORA-27061: waiting for async I/Os failed Linux-x86_64 Error: 28: No space left on device Additional information: -1 Additional information: 1048576 ORA-19502: write error on file "/oracleSID/SID/sapdata2/undo_31/undo.data31", block number 434432 (block size=8192) ORA-27085: Message 27085 not found;  product=RDBMS; facility=ORA Additional information: 528384 Additional information: 1048576 File #307 added to control file as 'UNNAMED00307'. Originally created as: '/oracleSID/SID/sapdata2/undo_31/undo.data31' Recovery was unable to create the file as: '/oracleSID/SID/sapdata2/undo_31/undo.data31' MRP0: Background Media Recovery terminated with error 1274 Errors in file /oracleSID/SID/saptrace/...

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  ...