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: