Visit Counter

Sunday, October 25, 2020

EBS R12.2 OS ENVIRONMENT VARIABLES

EBS 12.2 

DB 12.1

Linux 6.5

------------------------------------------------------------------------------------------------------------------------

Below are some of the important Operating system-level environment variables related to R12.2.

$ echo $FILE_EDITION
<shows which file edition you are using, run or patch>

 $ echo $RUN_BASE

<shows absolute path to run file system>

 

$ echo $PATCH_BASE
<shows absolute path to patch file system>

 

$ echo $NE_BASE
<shows absolute path to non-edition file system>

 

$ echo $APPL_TOP_NE
<non-editioned appl_top path. Equivalent to $NE_BASE/EBSapps/appl>

 

$ echo $LOG_HOME
<Application Instance Specific Log Directory>

 

$ echo $ADOP_LOG_HOME
<Online patching Specific Log Directory. Equivalent to $NE_BASE/EBSapps/log/adop>

 

$ echo $IAS_ORACLE_HOME
<FMW Web Tier Home Directory>

 

$ echo $ORACLE_HOME
< 10.1.2 ORACLE_HOME>

 

$ echo $CONTEXT_FILE
<Source for information populating template files (autoconfig)>

 

$ echo $EBS_DOMAIN_HOME
<WLS Deployment of Oracle E-Business Suite 12.2 Domain (instance specific)>

 

$ echo $ADMIN_SCRIPTS_HOME
<Shell scripts to control processes associated to the Applications Instance>

 

$ echo $EBS_ORACLE_HOME
<Oracle E-Business Suite 12.2 FMW Deployment directory>

 

$ echo $RW
<10.1.2 reports directory>

 

$ echo $HOSTNAME
<hostname without domain name>

 

$ echo $APPS_VERSION
<to get the EBS version>

Tuesday, October 20, 2020

How to open Oracle Apps R12 forms in Internet Explorer 11 (IE. 11)

 

Installed E-business Suite 12.2 on Linux Oracle VM.


We installed EBS 12.2 and when we tried to open forms in IE11, it threw a message "In order to access this application, you must install the J2SE Plugin version 1.6.0_27. 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.



Solution:

1. Java Control Panel.







2) In internet explorer 11, navigate to Tools –> Compatibility View Settings. Then add the Domain name in the URL (ex: oraebs12.localdomain) using the Add this website option.




3) Navigate to Tools –> Internet options –> Security. Select the Internet and click on Custom level. Scroll down till the end of the options and change the option Enable XSS filter to  Disable.


4) Add EBS URL as Intranet Site in Internet Options to avoid most of the Java security-related issues.


 This solution worked for me and I am able to open R12 forms in Internet Explorer version 11.



Sunday, October 11, 2020

SQL Server 2014 Always On with Windows Cluster

 

Configure SQL Server 2014 Always On with Windows 2016 Cluster

------------------------------------------------------------------------------------



1. Install Windows 2016 Server on three VM Machines.

2. Create and Configure Active Directory Domain Server.

3. Create Two users for Windows Cluster & SQL Server 

Thursday, October 1, 2020

pg4admin 401 Unauthorized Error

 


I Installed the Postgresql Database...on windows 2016.......after that I got the below 

error while accessing the pg4admin through Internet Explorer 11.


Unauthorized


The server could not verify that you are authorized to access the URL requested. You either supplied the wrong credentials (e.g. a bad password), or your browser doesn't understand how to supply the credentials required.



Goto Internet Explorer: Tool Menu  -> Internet Option -> Secruity -> Trusted Sites Click on Sites add HTTP://127.0.0.1 then Security Level for this zone section should be Medium-low