Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Saturday, October 21, 2017

Create/ Provision Oracle E-Business Suite 12.2.6 on Oracle Cloud.



Below we will create and deploy Oracle  E-Business Suite 12.2.6 on Oracle Cloud in less than a hour.
1) Go to Compute Classic --> Instances --> Create Instance.



































It will take around 2-3hrs depending on the configuration/resources you picked during the provisioning.

Once the instance is created, it will show the status as "Running", note down the public IP address,














Create security lists and assign them to the instance for SSH, weblogic, Apps login, FORMS so on..

Below is a sample for SSH & console logins:




















Test the connectivity via SSH and configure the new EBS system:

Now login into the Ebusiness suite cloud instance as opc user:

Make sure serveraliveinterval is set to 100 or above:

shaikprod@shaikprod ~/.ssh
$ cat config
ServerAliveInterval 100



shaikprod@shaikprod ~/.ssh
$ ssh -i ~/.ssh/id_rsa opc@129.158.66.82

Oracle Linux Server release 6.7
Kernel \r on an \m

Authorized uses only. All activity may be monitored and reported.


set the PS1 as appropriate:
-bash-4.1$ vi .profile
-bash-4.1$ . ./.profile
ebs-dev-app01@opc:/home/opc>
ebs-dev-app01@opc:/home/opc>
ebs-dev-app01@opc:/home/opc>


set up the user equivalency between the app server and db server if needed.

users created on the system:
-bash-4.1$ cat /etc/passwd |egrep "oracle|root|applmgr"
root:x:0:0:root:/root:/bin/bash
operator:x:11:0:operator:/root:/sbin/nologin
oracle:x:54321:54321::/home/oracle:/bin/bash
applmgr:x:54322:54321::/home/applmgr:/bin/bash


None of the services have been started:

[oracle@c6c28e ~]$ ps -ef|grep oracle
root      3109  3082  0 23:28 pts/0    00:00:00 sudo su - oracle
root      3110  3109  0 23:28 pts/0    00:00:00 su - oracle
oracle    3111  3110  0 23:28 pts/0    00:00:00 -bash
oracle    3136  3111  0 23:29 pts/0    00:00:00 ps -ef
oracle    3137  3111  0 23:29 pts/0    00:00:00 grep oracle
[oracle@c6c28e ~]$ ps -ef|grep applmgr
oracle    3139  3111  0 23:29 pts/0    00:00:00 grep applmgr

root user:
-bash-4.1# id
uid=0(root) gid=0(root) groups=0(root),1(bin),2(daemon),3(sys),4(adm),6(disk),10(wheel)

filesystem details:


-bash-4.1# df -k
Filesystem     1K-blocks      Used Available Use% Mounted on
/dev/xvdb2      16247680   2569476  12833424  17% /
tmpfs            3830068         0   3830068   0% /dev/shm
/dev/xvdb1        194241    154048     25857  86% /boot
/dev/xvdb4     340468036 233032616  90117616  73% /u01

template log file:

-bash-4.1# cat /var/log/oraclevm-template.log
[INFO] Oct 21 22:28:10 updatehosts.sh: Updating hosts file with the current IP
[INFO] Oct 21 22:28:10 updatehosts.sh: Hosts  file update completed
[INFO] Oct 21 22:28:10 updatehosts.sh: /etc/sysconfig/network  file update completed
[LOG]  Oct 21 22:28:10 oraclevm-template: ==> 2017-10-21 22:28:10: oraclevm-template --config <==
[LOG]  Oct 21 22:28:10 oraclevm-template: Running oraclevm-template --config
[LOG]  Oct 21 22:28:10 oraclevm-template: Loading parameters from config file: /etc/sysconfig/oraclevm-template
[LOG]  Oct 21 22:28:10 oraclevm-template: Reconfiguring OS
[INFO] Oct 21 22:28:11 oraclevm-template: Regenerating SSH host keys.
[LOG]  Oct 21 22:28:11 oraclevm-template: calling /u01/install/scripts/configdhcp.sh
[INFO] Oct 21 22:28:12 configdhcp.sh: Configure the Machine with the Dynamic IP Address
[INFO] Oct 21 22:28:12 configdhcp.sh: Configuring network interface.
[INFO] Oct 21 22:28:12 configdhcp.sh:   Network device: eth0
[INFO] Oct 21 22:28:12 configdhcp.sh:   Hardware address: C6:B0:AE:95:57:8C
[LOG]  Oct 21 22:28:12 configdhcp.sh: Stopping network...
[INFO] Oct 21 22:28:12 configdhcp.sh: Configuring network settings.
[INFO] Oct 21 22:28:12 configdhcp.sh:   IP configuration: DHCP
[LOG]  Oct 21 22:28:12 configdhcp.sh: Starting network...
[INFO] Oct 21 22:28:44 configdhcp.sh: Network configuration changed successfully.

[LOG]  Oct 21 22:28:44 configdhcp.sh: Disabling firewall
[INFO] Oct 21 22:28:44 configdhcp.sh: Updating hosts file with the current IP
[INFO] Oct 21 22:28:44 configdhcp.sh: Hosts  file update completed
[INFO] Oct 21 22:28:44 configdhcp.sh: /etc/sysconfig/network  file update completed
[LOG]  Oct 21 22:28:54 oraclevm-template: ==> 2017-10-21 22:28:54: oraclevm-template --disable <==
[LOG]  Oct 21 22:28:54 oraclevm-template: Running oraclevm-template --disable
[LOG]  Oct 21 22:28:54 oraclevm-template: Changed RUN_TEMPLATE_CONF=NO in /etc/sysconfig/oraclevm-template
[INFO] Oct 21 22:28:54 oraclevm-template: Template configuration disabled.

Filesystem details:

[oracle@erp APPS]$ ls -lrt
total 44
drwxr-xr-x  4 oracle oinstall  4096 Sep 18 21:13 fs_ne
drwxr-xr-x  3 oracle oinstall 12288 Oct 22 03:06 data
drwxr-xr-x 78 oracle oinstall  4096 Oct 22 03:10 12.1.0
drwxr-xr-x  2 oracle oinstall  4096 Oct 22 03:12 scripts
drwxr-xr-x  5 oracle oinstall  4096 Oct 22 03:12 fs1
drwxr-xr-x  5 oracle oinstall  4096 Oct 22 03:45 fs2
-rw-r--r--  1 oracle oinstall  6469 Oct 22 04:06 EBSapps.env
drwxrwx---  7 oracle oinstall  4096 Oct 22 04:24 oraInventory


[oracle@erp APPS]$ hostname
erp


Set the run environment:

[oracle@erp APPS]$ source EBSapps.env run

  E-Business Suite Environment Information
  ----------------------------------------
  RUN File System           : /u01/install/APPS/fs1/EBSapps/appl
  PATCH File System         : /u01/install/APPS/fs2/EBSapps/appl
  Non-Editioned File System : /u01/install/APPS/fs_ne


  DB Host: erp.compute-586447955.oraclecloud.internal  Service/SID: EBSDB


  Sourcing the RUN File System ...

Change the E-Business suite account passwords:
============================================


[oracle@erp scripts]$ ./adstpall.sh -skipNM -skipAdmin

You are running adstpall.sh version 120.22.12020000.7


Enter the APPS username: apps

Enter the APPS password:
Enter the WebLogic Server password:

The logfile for this session is located at /u01/install/APPS/fs1/inst/apps/EBSDB_erp/logs/appl/admin/log/adstpall.log
Skipping Admin Server shutdown as option -skipAdmin is passed

Skipping Node Manager shutdown as option -skipNM is passed


Executing service control script:
/u01/install/APPS/fs1/inst/apps/EBSDB_erp/admin/scripts/adcmctl.sh stop
Timeout specified in context file: 1000 second(s)

script returned:
****************************************************

You are running adcmctl.sh version 120.19.12020000.7

Shutting down concurrent managers for EBSDB ...

****************************************************



Executing service control script:
/u01/install/APPS/fs1/inst/apps/EBSDB_erp/admin/scripts/adopmnctl.sh stop
Timeout specified in context file: 100 second(s)

script returned:
****************************************************

You are running adopmnctl.sh version 120.0.12020000.2

Stopping Oracle Process Manager (OPMN)  and the managed processes ...
opmnctl stopall: opmn is not running.

adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/EBSDB_erp/logs/appl/admin/log/adopmnctl.txt for more information ...


.end std out.

.end err out.

****************************************************


adalnctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/EBSDB_erp/logs/appl/admin/log/adalnctl.txt for more information ...


.end std out.

.end err out.

****************************************************



All enabled services on this node are stopped.

adstpall.sh:Exiting with status 0

adstpall.sh: check the logfile /u01/install/APPS/fs1/inst/apps/EBSDB_erp/logs/appl/admin/log/adstpall.log for more information ...

[oracle@erp scripts]$

Connecting to t3://erp.compute-586447955.oraclecloud.internal:7001 with userid weblogic ...
Successfully connected to Admin Server 'AdminServer' that belongs to domain 'EBS_domain_EBSDB'



[oracle@erp scripts]$ perl /u01/install/APPS/fs1/EBSapps/appl/fnd/12.0.0/patch/115/bin/txkUpdateEBSDomain.pl -action=updateAdminPassword

Program: txkUpdateEBSDomain.pl started at Sun Oct 22 10:17:54 2017

AdminServer will be re started after changing WebLogic Admin Password
All Mid Tier services should be SHUTDOWN before changing WebLogic Admin Password
Confirm if all Mid Tier services are in SHUTDOWN state. Enter "Yes" to proceed or anything else to exit: yes

Enter the full path of Applications Context File [DEFAULT - /u01/install/APPS/fs1/inst/apps/EBSDB_erp/appl/admin/EBSDB_erp.xml]:
Enter the WLS Admin Password:
Enter the new WLS Admin Password:
Enter the APPS user password:

Executing: /u01/install/APPS/fs1/FMW_Home/webtier/perl/bin/perl /u01/install/APPS/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl  ebs-get-serverstatus -contextfile=/u01/install/APPS/fs1/inst/apps/EBSDB_erp/appl/admin/EBSDB_erp.xml -servername=AdminServer -promptmsg=hide -logfile=/u01/install/APPS/fs1/inst/apps/EBSDB_erp/logs/appl/rgf/TXK/txkUpdateEBSDomain_Sun_Oct_22_10_17_54_2017/EBSProvisioner.log

Updating Weblogic Domain in online mode
---------------------------------------
Backup Location : /u01/install/APPS/fs1/inst/apps/EBSDB_erp/logs/appl/rgf/TXK/txkUpdateEBSDomain_Sun_Oct_22_10_17_54_2017
Logfile Location: /u01/install/APPS/fs1/inst/apps/EBSDB_erp/logs/appl/rgf/TXK/txkUpdateEBSDomain_Sun_Oct_22_10_17_54_2017/updateAdminPassword.log

Executing: /u01/install/APPS/fs1/EBSapps/comn/util/jdk32/jre/bin/java -classpath :/u01/install/APPS/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/install/APPS/fs1/FMW_Home/Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/install/APPS/fs1/EBSapps/comn/java/classes:/u01/install/APPS/fs1/EBSapps/comn/shared-libs/ebs-3rdparty/WEB-INF/lib/ebs3rdpartyManifest.jar:/u01/install/APPS/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar oracle.apps.ad.util.UpdateEBSDomain updateAdminPassword  -contextfile /u01/install/APPS/fs1/inst/apps/EBSDB_erp/appl/admin/EBSDB_erp.xml -promptmsg hide -logdir /u01/install/APPS/fs1/inst/apps/EBSDB_erp/logs/appl/rgf/TXK/txkUpdateEBSDomain_Sun_Oct_22_10_17_54_2017 -logfile /u01/install/APPS/fs1/inst/apps/EBSDB_erp/logs/appl/rgf/TXK/txkUpdateEBSDomain_Sun_Oct_22_10_17_54_2017/updateAdminPassword.log


Domain updated successfully
Restarting AdminServer with new Admin Password.

You are running adadminsrvctl.sh version 120.10.12020000.10

Stopping WLS Admin Server...
Refer /u01/install/APPS/fs1/inst/apps/EBSDB_erp/logs/appl/admin/log/adadminsrvctl.txt for details

AdminServer logs are located at /u01/install/APPS/fs1/FMW_Home/user_projects/domains/EBS_domain_EBSDB/servers/AdminServer/logs

adadminsrvctl.sh: exiting with status 0

adadminsrvctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/EBSDB_erp/logs/appl/admin/log/adadminsrvctl.txt for more information ...


You are running adnodemgrctl.sh version 120.11.12020000.12


NodeManager log is located at /u01/install/APPS/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1

adnodemgrctl.sh: exiting with status 0

adnodemgrctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/EBSDB_erp/logs/appl/admin/log/adnodemgrctl.txt for more information ...


You are running adadminsrvctl.sh version 120.10.12020000.10

Starting WLS Admin Server...
Refer /u01/install/APPS/fs1/inst/apps/EBSDB_erp/logs/appl/admin/log/adadminsrvctl.txt for details

AdminServer logs are located at /u01/install/APPS/fs1/FMW_Home/user_projects/domains/EBS_domain_EBSDB/servers/AdminServer/logs

adadminsrvctl.sh: exiting with status 0

adadminsrvctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/EBSDB_erp/logs/appl/admin/log/adadminsrvctl.txt for more information ...


*************** IMPORTANT ****************
WebLogic Admin Password is changed.
Restart all application tier services using control scripts.
********************************************


Program: txkUpdateEBSDomain.pl completed at Sun Oct 22 10:21:32 2017
[oracle@erp scripts]$


Change E-Business Suite Passwords:

[oracle@erp scripts]$ sqlplus /nolog

SQL*Plus: Release 10.1.0.5.0 - Production on Sun Oct 22 10:32:09 2017

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn apps@ebsdb
Enter password:
Connected.
SQL> set linesize 1000
SQL> col comp_name for a40
SQL> select comp_name,version from dba_registry;

COMP_NAME                                VERSION
---------------------------------------- ------------------------------
Oracle Database Catalog Views            12.1.0.2.0
Oracle Database Packages and Types       12.1.0.2.0
Oracle Real Application Clusters         12.1.0.2.0
JServer JAVA Virtual Machine             12.1.0.2.0
Oracle XDK                               12.1.0.2.0
Oracle Database Java Packages            12.1.0.2.0
Oracle Machine Generated Data            12.1.0.2.0
Oracle XML Database                      12.1.0.2.0
Oracle Multimedia                        12.1.0.2.0
Spatial                                  12.1.0.2.0
OLAP Analytic Workspace                  12.1.0.2.0

COMP_NAME                                VERSION
---------------------------------------- ------------------------------
Oracle OLAP API                          12.1.0.2.0
OLAP Catalog                             11.2.0.4.0
Oracle Text                              12.1.0.2.0

14 rows selected.




SQL> select user_name,encrypted_user_password from fnd_user where encrypted_user_password !='INVALID';

USER_NAME
--------------------------------------------------------------------------------
ENCRYPTED_USER_PASSWORD
--------------------------------------------------------------------------------
GUEST
VGyiDXXXXXXXqzA2mfI=



Enable SYSADMIN Access:

[oracle@erp logs]$ /u01/install/APPS/scripts/enableSYSADMIN.sh

This script will let you set a new password for the SYSADMIN EBS Applications User,
the default password most likely was "sysadmin", so pick a different one now.

Enter new password for SYSADMIN:
 Re-enter password for SYSADMIN:
Changing password for SYSADMIN
Log filename : L7660120.log


Report filename : O7660120.out



[oracle@erp logs]$ /u01/install/APPS/scripts/enableDEMOusers.sh

Enter a new password for the EBS Applications Users, the default password
most likely was "welcome", so pick a different one now...

Enter new password for DEMO users:
 Re-enter password for DEMO users:
Setting password for DEMO users...
Log filename : L7660122.log


Report filename : O7660122.out
Log filename : L7660124.log


Report filename : O7660124.out
Log filename : L7660126.log


Verify that you can access the weblogic console/EBS Home Page:








No comments: