Enable Database Enterprise Manager Console on Oracle EBS R12.1.1

June 16, 2018

I’m yet to check this one out. Reblogging to avoid losing the link among the ocean of bookmarks those I already have.

Joey Out Of The Box

First login as applmgr user, shutdown all application tier process using .
Login as oracle user to linux. Source the database environment.
Ensureis set in the init.ora for the
database using this command:

SQL> show parameter
REMOTE_LOGIN_PASSWORDFILE;

Create a password file using this command on linux:

Then execute this command:

(remember to change SID and port if needed).
You will be asked some question:

SYSMAN schema will be dropped and recreated.
While dropping the scema, database will be quisced.
Database sessions that blocking the quiescing process must be killed.
Use sqlplus to identify the sessions:

Make note on SID and SERIAL#.
Kill the session using this sql command:

(don’t forget to change SID and SERIAL#).
On create schema process you may need to increase the size of SYSAUX tablespace.
After the process completed you can access the enterprise manager on internet browser using this URL:

You may also have…

View original post 18 more words

Advertisements

Oracle Applications R12 | Java applet font scaling issues

June 10, 2018

We are using Oracle applications R12 12.0.6 with JDK 6.0 while most of the clients are using JRE 7/8 based on different business requirements (With full knowledge that there would be unexpected results due to the compiled versions). We’ve observed a peculiar issue with the JRE applet once after the upgrade to Windows 10 version 1803. The Java applet started showing too small fonts while launched from displays with high DPI resolutions.

Digging in brought me to the following discussion:

https://superuser.com/questions/988379/how-do-i-run-java-apps-upscaled-on-a-high-dpi-display

Although there are multiple recommendations, for EBS environment, Please follow the below instructions:

Launch the JAVA applet by opening a forms based module.

Open task manager and locate “Java(TM) Platform…”, right click and open properties. This will open the properties for “jp2launcher.exe”. Click on “Compatibility” and click on “Change high DPI settings”. Now check “Override high DPI scaling behavior. Scaling performed by:” to “Application”. Refer the image for more details.

Once the changes are made to the properties of the executable, restart the box. It could be specific case, the changes were not applied until a restart for me.

Although it fixes the font scaling issues, the toolbar area of the Oracle forms are remains scaled with pretty small icons. I am yet to find out a fix for this minor annoyance. May be quite soon.

 

regards,

 


Windows 10 1803 | .NET Framework 3.5 installation error: 0x800F081F

June 4, 2018

Hi guys

Windows 10 gets more interesting day after day. I feel like Microsoft is slowly helping my HUGE beasty desktop machines to start looking like a MOBILE PHONE, well enough said.

One of the latest issues with Windows 10 version 1803 (build: 17134.81) is, one cannot add the .NET Framework 3.5 feature using “Turn Windows features…”, the attempts start reporting you are not connected to internet, which is not true (Microsoft should grow up)

So if you are looking for a quick solution to the said, don’t worry, Microsoft has truly messed up documentations available here:

https://support.microsoft.com/en-us/help/2734782/net-framework-3-5-installation-error-0x800f0906-0x800f081f-0x800f0907

& you should read this one as well

https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-8.1-and-8/hh825020(v=win.10)

Or if you don’t want to get confused, follow the instructions below:

Using the Windows Media Creation Tool for Version 1803, create ISO and mount it

Browse to sources\sxs folder within the ISO that’s been already mounted. Example, my ISO file is mounted on J: drive, hence the path to sources files is “J:\sources\sxs”

Copy the path and with an administrator account, open “LOCAL” group policy editor

Click Computer Configuration, click Administrative Templates, click System, and then double-click the Specify settings for optional component installation and component repair setting.

and once the LOCAL policies are updated, you have to apply it. Apply the policy changes using “gpupdate /force”. Don’t worry about domain policies (if you are using a domain joined computer)

Now try to install “.NET Framework 3.5”, should complete without giving more errors.

Hope this helps few out there