[Solved]Oracle APPS DBA Errors and Log Message:

Error 1: (Doc ID 1675470.1)

While execute any query in SQL prompt then getting below error.

 alter tablespace APPS_TS_TX_DATA add datafile '/oradata1/oracle/TST/db/apps_st/data/apps_ts_tx_data15.dbf' size 15G

*

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1

ORA-04031: unable to allocate 4160 bytes of shared memory ("shared

pool","unknown object","sga heap(3,0)","modification ")

 OR

Showing error in alert.log file.

 /oradata1/app/oracle/product/11.2.0/admin/TST_erptstdb01/diag/rdbms/tst/TST/trace/TST_m001_24889.trc  (incident=2110463):

ORA-04031: unable to allocate ORA-04031: unable to allocate 4160 bytes of shared memory

("shared pool","unknown object","sga heap(3,0)","modification ")

 bytes of shared memory ("","","","")

Solution:

To implement the solution, please execute the following steps: 

1. Please review Note: 146599.1 Diagnosing and Resolving Error ORA-04031. 
2. Flush shared pool. This should take care of the issue as it has come once.

ALTER SYSTEM FLUSH SHARED_POOL; 

if step 2 does not work:

3. Increase the shared memory or a simple DB bounce could resolve the issue. 

Error 2: (Doc ID 1276455.1)

1.  $ perl adcfgclone.pl dbTechStack then below error

 RC-00110: Fatal: Error occurred while relinking of ApplyDBTechStack

 Perl lib version (v5.8.4) doesn't match executable version (v5.10.0)

(Or)

Perl lib version (v5.8.8) doesn't match executable version (v5.10.0) at /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/Config.pm line 46.
Compilation failed in require at /clonedb/oradata/app/oracle/product/11.2.0/appsutil/clone/ouicli.pl line 35.
BEGIN failed--compilation aborted at  /clonedb/oradata/app/oracle/product/11.2.0/appsutil/clone/ouicli.pl line 35.

2. $ perl adpreclone.pl appsTier

Perl lib version (5.10.0) doesn't match executable version (v5.10.1) at /u03/oracle/DEV/apps/fs1/FMW_Home/webtier/perl/lib/5.10.0/x86_64-linux-thread-multi/Config.pm line 46.

Compilation failed in require at adpreclone.pl line 35.

BEGIN failed--compilation aborted at adpreclone.pl line 35.

Solution:

1. Setting the PERL5LIB environment variable on the Database tier.

 PERL5LIB=/clonedb/oradata/app/oracle/product/11.2.0/perl/lib/5.10.0:/clonedb/oradata/app/oracle/product/11.2.0/perl/lib/site_perl/5.10.0:/clonedb/oradata/app/oracle/product/11.2.0/appsutil/perl;

export PERL5LIB=/perl/lib/5.10.0:/perl/site_perl/5.10.0:/appsutil/perl

2.  export PATH=$ORACLE_HOME/perl:$ORACLE_HOME/perl/lib:$ORACLE_HOME/perl/bin:$PATH

Error 3:  (Doc ID 1638491.1)

$ perl adcfgclone.pl appsTier then below error

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

[SETUP PHASE]

AutoConfig could not successfully execute the following scripts:

Directory: /cloaneappl/inst/apps/CLONE_erpcloneappl/admin/install

      adgenjky.sh             INSTE8_SETUP       1

AutoConfig is exiting with status 1

AutoConfig execution completed on Wed May 1 13:59:46 2019

Solution:

$ cd /cloaneappl/inst/apps/CLONE_erpcloneappl/admin/install

$ ./ adgenjky.sh then check it’s log file

Log file showing that applprod.txt file Missing /Unable to open applprod.txt file in $APPL_TOP/admin.

So simply copy & past required files in that folder from source server.

Error 4: (Doc ID 1050646.1)

APP-FND-00362: Routine afpbep cannot execute request &REQUEST for program &PROGRAM

APP-FND-00362: Routine afpbep cannot execute request &REQUEST for program &PROGRAM, because the environment variable &BASEPATH is not set for the application to which the concurrent program executable &EXECUTABLE belongs.

Shut down the concurrent managers. Set the basepath environment variable for the application. Restart the concurrent managers. (VARIABLE=)

Routine AFPEOT cannot construct the name of an executable file for your concurrent request 4337779.

Check that the file name components are correct and valid on your system. Check that the environment for the person who started the concurrent manager

Solution:

Scenario:  There is a Custom Top registered and that top is not set in the ENV while starting the conc.

At the application tier check if CUSTOM_TOP is not set..

$ echo $CUSTOM_TOP

Request Name:   XXXXX ACCOUNT WISE

Query to Check whether the Env is set for the Particular request:

select variable_name,value from fnd_env_context e, fnd_concurrent_processes p, fnd_concurrent_requests r 

where p.concurrent_process_id =e.concurrent_process_id

and p.concurrent_process_id = r.controlling_manager 

and e.variable_name like '%CUSTOM_TOP%'

and r.request_id = &request_id;

Note: Above query return null value then set the custom top in custom environment file.

Add the respective Top in below  *.env files.

CUSTOM_TOP= /cloaneappl/apps/apps_st/appl/CUSTOM_TOP/12.0.0

export CUSTOM_TOP

1) $APPL_TOP/admin/adovars.env

Note: So that while running autoconfig it won’t remove every time.

2) Check the above custom top entry exist in $APPL_TOP/Custom<SID>_<hostname>.env

3) Bounce the Concurrent Manager or Bounce the Application services.

 Error 5:

 ORA-09925: Unable to create audit trail file

 $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 6 12:51:17 2019
Copyright (c) 1982, 2014, Oracle.  All rights reserved.
ERROR:
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 30: Read-only file system
Additional information: 9925
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 30: Read-only file system
Additional information: 9925

 Solution:

Just the other day, I tried to connect to my test database server as SYSDBA. And I hit the following error. The server which runs on VMware in some case when run this df -h command then not seeing the file system it's just showing as below. Contact system administrator.
$ df -h
Filesystem Size Used Avail Use% Mounted on

 But in my case all mount point showing properly so we have simply reboot the system.