Davis Apps DBA

Today in my Primary database I was dong some log switching. It took a bit long to complete the log switch and so I decided to look into the alert log. I could able to see some issue been recorded in the alert log. Below is the issue. Issue: Alert log: ARC1: Error 19504 Creating archive log file to '+DATA/vis/datafile/archive/1_1221_970193294.dbf' ARCH: Archival stopped, error occurred. Will continue retrying ORACLE Instance VIS - Archival Error ORA-16038: log 1 sequence# 1221 cannot be archived ORA-19504: failed to create file "" ORA-00312: online log 1 thread 1: '+DATA/vis/logfile/log01b.dbf' ORA-00312: online log 1 thread 1: '+DATA/vis/logfile/log01a.dbf' Archiver process freed from errors. No longer stopped Tue Jul 24 19:17:42 2018 ARC3: LGWR is actively archiving destination LOG_ARCHIVE_DEST_2 ARCH: Archival stopped, error occurred. Will continue retrying ORACLE Instance VIS - Archival Error ORA-16014: log 1 sequence# 12...

Today I ran adcfgclone to refresh my UAT Instance and faced the below issue after alomost 70% of the process is completed. On digging the particular log file for issues, found the below two error. Error : 1 Updating s_tnsmode to 'generateTNS' UpdateContext exited with status: 0 AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora. Error generating tnsnames.ora from the database, temporary tnsnames.ora will be generated using templates Instantiating Tools tnsnames.ora Tools tnsnames.ora instantiated Web tnsnames.ora instantiated adgentns.pl exiting with status 2 ERRORCODE = 2 ERRORCODE_END .end std out. .end err out. Error : 2 [AutoConfig Error Report] The following report lists errors AutoConfig encountered during each phase of its execution.  Errors are grouped by directory and phase. The report format is:       <filename>  <phase>  <return code where appropriate>   [SE...

Today I ran adcfgclone at Apps Tier to refresh my TEST Instance and faced the below issue. Issue: no linkxlC in /u01/oracle/ERPDEV3/apps/apps_st/comn/clone/bin/../jre/bin /usr/bin /etc /usr/sbin /usr/ucb /home/oracle/bin /usr/bin/X11 /sbin . Checking for make...    found - /usr/bin/make  Checking for ld...     found - /usr/bin/ld  Checking for linkxlC...  Unable to locate 'linkxlC' utility in path  Checking for ar...     found - /usr/bin/ar  Unable to locate all utilities with system path.  PATH = /u01/oracle/ERPDEV3/apps/apps_st/comn/clone/bin/../jre/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/oracle/bin:/usr/bin/X11:/sbin:. WARNING: Could not find all the required OS utilities in the $PATH. Please review the checks above Solution: Export the path variable along with the location of linkxlC Steps: which linkxlC /usr/vacpp/bin/linkxlC $ export PATH=/usr/vacpp/bin:$PATH Now run adcfgclone, this time...

One of my colleague reported he is facing issue while trying to connect  instance from back-end using sql-developer. Issue : Status : Failure - Test failed : IO Error : Got minus one from a read call Solution :  After changing a parameter "tcp.validnode_checking" in sqlnet.ora file, this issue is resolved and can connect from back-end successfully. Before change   After change **************************** நன்றி ****************************

Today I faced a new issue after refreshed my TEST Instance. After the refresh has completed, took a complete bounce on both DB and APPS Tiers. While bringing back the DB, listener process is not getting started and throws the below error. Quick googling provide me the solution for this issue. Issue:  TNS-12549: TNS:operating system resource quota exceeded TNS-12560: TNS:protocol adapter error TNS-00519: Operating system resource quota exceeded Linux Error: 28: No space left on device Solution:  Delete unwanted files under the /var mount point or under the /var/tmp folder. Now re-start the listener and this time, listener will start without any issues. Ref :  Listener / Database Startup fails with underlying OS error Linux Error: 28: No Space Left On Device (Doc ID 553709.1) **************************** நன்றி ****************************

After creating the Stand-by Instance using RMAN backup from Primary Instance, below issue occurs while trying to start the standby database. dbmgrprd@db_dr:/oracle/RMAN#!sq sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Wed Jul 11 17:51:18 2018 Copyright (c) 1982, 2011, Oracle.  All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 1068937216 bytes Fixed Size                  2228344 bytes Variable Size             432017288 bytes Database Buffers          620756992 bytes Redo Buffers               13934592 bytes Database mounted. ORA-10458: standby database requires recovery ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '+DATA/vis/datafile/system01.dbf' On investigating the alert ...