Check EBS Installed Modules/Versions

Problem:
How to check if certain Oracle Applications modules/products are installed, and their versions?

Solution:
You can run script adutconf.sql

1. From Application tier, go into:
          cd $AD_TOP/sql/

2. Execute:
         sqlplus apps/<password> @adutconf.sql

File adutconf.ls will be created in directory $AD_TOP/sql

Check product name by searching for “Product” in list file

Cause: FDPSTP failed due to ORA-20100: FND_FILE could not write to file

They were trying to import items from the items menu thru the inventory responsibility. In the logs it shows

**Starts**21-MAY-2018 18:13:02

**SQL error and free**21-MAY-2018 18:13:02

ORACLE error 20100 in FDPSTP

Cause: FDPSTP failed due to ORA-20100: FND_FILE could not write to file l0263903.tmp.

An operating system error occurred during the write operation.

Contact your system administrator. (TEMP_DIR=/dbapps/tmp)

ORA-06512: at "APP21-MAY-2018 18:13:02

Solution

Check if $APPLPTMP on the application server node is the same as the utl_file_dir parameter on the database. In this example mine was /dbapps/tmp

• On the application server node environment 
• $ echo $APPLPTMP
• /dbapps/tmp
• On the database 
• SQL> show parameter utl_file_dir
• 
  
• NAME                                 TYPE        VALUE
• ------------------------------------ ----------- ------------------------------
• utl_file_dir                         string      /dbapps/tmp
• Run this on the database

1. • exec FND_FILE.PUT_LINE(FND_FILE.LOG, 'THIS IS A TEST');
   • BEGIN FND_FILE.PUT_LINE(FND_FILE.LOG, 'THIS IS A TEST'); END;
   • SQL> show user
   • USER is "APPS"
   • SQL> exec FND_FILE.PUT_LINE(FND_FILE.LOG, 'THIS IS A TEST');
   • BEGIN FND_FILE.PUT_LINE(FND_FILE.LOG, 'THIS IS A TEST'); END;
   • PL/SQL procedure successfully completed.
   • 
     
   • SQL>
   •   2  /
   • 
     
   • PL/SQL procedure successfully completed.

• Go to the /dbapps/tmp directory on the DATABASE node!!! 
• cat the last file that was generated
• -rw-r--r-- 1 oracle dba  0 May 21 23:17 o0263921.tmp
• -rw-r--r-- 1 oracle dba 30 May 21 23:17 l0263921.tmp
• ! R12D2:ghoul.ecp.priv:/dbapps/tmp> cat l0263921.tmp
• THIS IS A TEST
• THIS IS A TEST
• ! R12D2:ghoul.ecp.priv:/dbapps/tmp>
• 
  

EBS looking for Java

IE 11: Certification issue with Oracle EBS 12 (Tested in Oct-14)

Post is not my own.

The original is http://layman-is-oracleappsdba.blogspot.tw/2014/10/ie-11-certification-issue-with-oracle.html

Aim:
To resolve following error:

In order to access this application, you must install the J2SE Plugin version 1.7.x_xx. To install this plugin, click here to download the oaj2se.exe executable. Once the download is complete, double-click the oaj2se.exe file to install the plugin. You will be prompted to restart your browser when the installation is complete.

Cause:

Internet Explorer 11 is not certified at this time (when this blog is written).

Solution:

You have to add the particular EBS URL's domain to Compatibility Mode in IE 11.

1) Open IE window
2) Click Tools -> Compatibility View Settings
3) Add domain only

For example if your URL is

http://tstunx13.mytestdomain.net:8000

then add

mytestdomain.net

into compatibility view settings. In the image below. I have masked my settings for privacy.

After you have added the domain, restart the browser and try again. You should see similar prompt as below.

The issue is resolved !!

Moving existing Oracle temp datafiles

SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300
 
COL TABLESPACE_SIZE FOR 999,999,999,999
COL ALLOCATED_SPACE FOR 999,999,999,999
COL FREE_SPACE FOR 999,999,999,999
 
SELECT *
FROM   dba_temp_free_space
/

CREATE TEMPORARY TABLESPACE TEMP_NEW TEMPFILE '/dbapps/oracle/oradata/DWHD/temp/temp02.dbf' SIZE 500m autoextend on next 10m maxsize 16G;
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP_NEW;

/*Retrieve ‘SID_NUMBER’ & ‘SERIAL#NUMBER’ of existing 
live session’s who are using old temporary tablespace ( i.e. TEMP ) and kill them. */
SELECT b.tablespace,b.segfile#,b.segblk#,b.blocks,a.sid,a.serial#,
a.username,a.osuser, a.status
FROM v$session a,v$sort_usage b
WHERE a.saddr = b.session_addr;

alter system kill session '211,11509';

select * from v$datafile where TS#='45';

--Get tablespacename
select * from v$tablespace where TS#='45';

DROP TABLESPACE TEMP1 including contents and datafiles;

Cannot get the column information from OLE DB provider "OraOLEDB.Oracle" for linked server "x".

editing the Provider Properties (right-click the provider in the providers folder) and ticking the "Allow inprocess" option corrects my problem.

Fs_Clone fails with "ERROR: RC-50410: Fatal: OUI Registration failed with an Abnormal Termination error" (Doc ID 2095966.1)

echo $ENV
unset ENV
adop phase=fs_clone forced=yes

How to Check if adminserver in EBS is up

cd $ADMIN_SCRIPTS_HOME

$ ./adadminsrvctl.sh status

You are running adadminsrvctl.sh version 120.10.12020000.9

Enter the WebLogic Admin password:
Enter the APPS Schema password:
Database connection could not be established. Either the database is down or the APPS credentials supplied are wrong.
$ ./adadminsrvctl.sh status

You are running adadminsrvctl.sh version 120.10.12020000.9

Enter the WebLogic Admin password:
Enter the APPS Schema password:

 The AdminServer is running

adadminsrvctl.sh: exiting with status 0