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