Wednesday, May 11, 2016

Migrating Oracle E-Business Suite R12 from Linux 32-bit to Linux 64-bit - Docs

Migrating Oracle E-Business Suite R12 from Linux 32-bit to Linux 64-bit (Doc ID 471566.1)
Cloning Oracle Applications Release 12 with Rapid Clone (Doc ID 406982.1)
Using Oracle EBS R12 with a Database Tier Only Platform on Oracle 11gR1 (Doc ID 762669.1)
Migrating OLAP From 32 Bits to 64 Bits or Across Platforms (Doc ID 352306.1)

Wednesday, May 4, 2016

Oracle EBS 12.2.5 Reference Docs

Oracle E-Business Suite Release Notes, Release 12.2 (Doc ID 1320300.1)
Oracle E-Business Suite Release 12.2.5 Readme (Doc ID 1983050.1)
Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 (Doc ID 1330701.1)
Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)
Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Doc ID 1594274.1)

Oracle EBS Workflow Notification Mailer with Cloud E-Mail Servers

Configuring an Oracle Workflow Notification Mailer with Cloud E-Mail Servers (Doc ID 2077434.1)

Query to get the workflow notification mailer logfile to troubleshoot issues.

select fl.meaning,fcp.process_status_code,
decode(fcq.concurrent_queue_name,'WFMLRSVC','mailer container','WFALSNRSVC','listener container',fcq.concurrent_queue_name) "CONTAINER",
fcp.concurrent_process_id,os_process_id, fcp.logfile_name
from fnd_concurrent_queues fcq, fnd_concurrent_processes fcp , fnd_lookups fl
where fcq.concurrent_queue_id=fcp.concurrent_queue_id and fcp.process_status_code='A'
and fl.lookup_type='CP_PROCESS_STATUS_CODE' and
fl.lookup_code=fcp.process_status_code
and concurrent_queue_name in('WFMLRSVC','WFALSNRSVC')
order by fcp.logfile_name;

Saturday, March 5, 2016

How to find Oracle EBS Weblogic Server Admin Port Number and URL

Web Logic Server Admin Port 

 Method 1:

Open the EBS domain config file in following location.
$EBS_DOMAIN_HOME/config/config.xml

Then check for Admin Server Port.

Method 2:

Open the application tier context file
$CONTEXT_FILE

Then check the value of variable "s_wls_adminport" in the for the correct Web Logic Server Admin port number

Web Logic Server Console URL

http://<server name>. <domain name> : < WLS Admin Port>/console
For example. http://oracle.test.com:7003/console

Steps to Change Oracle Weblogic Server Node Manager & Administration User Password



The option to set the Oracle WebLogic Server Administration User password to a
non-default value is available during Oracle E-Business Suite installation. This section
describes the procedure to use (on the run file system) if you need to change the
password at a later time.


The EBS WebLogic Domain uses Node Manager to control the Administration Server
and the managed servers. For the EBS WebLogic Domain, the Node Manager and
WebLogic Server Administration User passwords must be same, otherwise the AD
control scripts will not work properly.


Important: 

If you need to change the Administration User password, you must change the Node Manager password first, If you do not do this, the WebLogic Server configuration change will not be detected and the next online patching cycle may fail.

The instructions that follow should be performed on the run file system. The password

change will be automatically propagated to the patch file system during the next adop

prepare phase or fs_clone operation.


1.Shut down all application tier services except the Admin Server.

On the primary node, run the command:
$ <ADMIN_SCRIPTS_HOME>/adstpall.sh -skipNM -skipAdmin

2. Change the Oracle WebLogic Server Node Manager and Administration User passwords by performing the following steps on weblogic console

Changing the Oracle WebLogic Server Node Manager Password

-Login to weblogic to server console: 


 

- Login using the current weblogic admin username and  password.

- Click on the lock and edit button



- Click on Domain link
- Click on Security TAB
   


- Click on "Advanced" Tab
- Provide the new node manager  password which you want to configure for weblogic admin user



- Click on "save"

 

- Verify settings updated successfully and then click on "Activate changes"

- Verify all changes has been activated successfully.

Changing the Oracle WebLogic Server Administration User Password

- Click on "Security Realms"
- Click on "myrealm"



-  select "users and groups" and select weblogic User: