This chapter covers the following topics:
There are two ways to start and stop the services running on each instance node: by selecting the options in the Administration menu or by using command line verbs.
You can start and stop the components running on each node using the Administration menu. Select Administration > Start and Stop Services from the instance target menu (labeled "Oracle E-Business Suite"). All application nodes are shown with the targets running in them. You can select individual target or a node (which means you are selecting all targets running on that node) and start or stop it. ICM does not show up under a specific node because we can start and stop it from any node where it is enabled. If the Oracle E-Business Suite instance features Online Patching, only run editions targets are shown.
Job sare submitted to start and stop services. The details and status of these jobs can be tracked through standard Enterprise Manager Job screens.
Note: For Oracle E-Business Suite Release 12.2, you cannot perform any action if a cutover is detected.
An administrator must have the EM_ALL_ADMINISTRATOR role to run the jobs to start and stop components. In addition, an administrator must have the "Start and Stop Services" privilege to start and stop services.
For more information on privileges and roles, see: Privileges and Roles for Managing Oracle E-Business Suite.
The preferred credential must be set for Oracle E-Business Suite node for the credential set OS Credentials.
The preferred credential must be set for Oracle E-Business Suite for the credential set AppsDBCredsSet.
For more information on preferred credentials, see: Setting Oracle E-Business Suite Preferred Credentials.
The Oracle Application Management Pack for Oracle E-Business Suite provides a command-line interface for the batch execution of start/stop multiple Oracle E-Business Suite systems. This feature uses Enterprise Manager Command Line Interface (EM CLI). See Enterprise Manager Command Line Interface to understand more about EM CLI.
Oracle E-Business Suite start and stop EM CLI verbs allows you to start and stop on-premises Oracle E-Business Suite instance to Oracle Cloud. These verbs also generate a health check report which reports the status of certain target types if certain services are accessible.
The health check is generated before stopping Oracle E-Business Suite and after starting Oracle E-Business Suite. You can use both the reports to validate to check any discrepancies that might occur between the stop and start of Oracle E-Business Suite.
EM CLI must be installed. See "Downloading and Deploying the EM CLI Client for Standard EM CLI" in Oracle Enterprise Manager Command Line Interface.
Set up EM CLI. See "Getting Started with EM CLI" in Oracle Enterprise Manager Command Line Interface.
Log in to your Oracle Management Server (OMS).
Synchronize the EM CLI client with OMS.
The following are the mandatory preferred credentials that must be set:
"OS credentials" credential set for Oracle E-Business Suite Node target type
"AppsUserCredsSet" credential set for Oracle E-Business Suite
"Normal Host Credentials" credential set for Host target type (For all application node hosts)
The EM CLI verb start_ebs must be used to start components on the Oracle E-Business Suite instance with the details of the instance provided as an XML file. Schema and sample XML with comments are found in the appendix XML Schema Using EM CLI.
You can provide the following named credentials in the input XML file:
"E-Business Suite Database credentials " type for Oracle E-Business Suite target type set for apps schema.
"Oracle Weblogic credentials" type for Oracle web logic server target type
The required apps schema database credentials and Web Logic Server administration credentials is chosen in the following order of precedence:
Preferred credentials set for
Named credentials provided in the individual Oracle E-Business Suite instance level
Global named credentials
Note: You can generate the XML from the schema using any IDE. Choose a depth of 8 or more, if you do so.
Execute the following command to stop the Oracle E-Business Suite instance:
./EM CLI start_ebs -input_file=start_file:<fully qualified path of start_ebs_file.xml> -log_file=<fully qualified path of log file>
The log_file
parameter is optional. If it is not provided, the system generates its own and the path will be displayed in the console. The log file contains the debug statements , job IDs of various jobs that gets submitted in the process of starting Oracle E-Business Suite.
The path of the health check report generated is shown in the console. The following is the sequence of actions that occurs while starting Oracle E-Business Suite.
Submits a job to start the Oracle E-Business Suite instance
Starts the Oracle E-Business Suite database and listener
Starts all services on all application nodes of Oracle E-Business Suite
Removes blackout on the Oracle E-Business Suite instance.
The health check report is generated and the path of the report is displayed in on the console.
You can check the job summary to view the execution report of all Oracle E-Business Suite instances.
As part of the health check report, the following tests are executed on Oracle E-Business Suite. The name of the test and its results are displayed in a table in HTML format.
S. No | Test Name |
---|---|
1 | Verify that maintenance mode is disabled |
2 | Verify Service Manager concurrent manager on each node |
3 | Verify if AppsLocalLogin.jsp is accessible |
4 | Verify database in Archive Mode |
5 | Verify Forms server is up and running |
6 | Verify OPMN processes are up and running |
7 | Verify JTF Login as sysadmin |
8 | Verify MWA server |
9 | Verify responsibilities assigned to SYSADMIN |
10 | Show number of JVMs configured |
11 | Verify Workflow Notification Mailer |
12 | Compare the Workflow Components status |
13 | Compare invalid database objects |
14 | Verify duplicate rows in FND_OAM_CONTEXT_FILES |
15 | Run "Prints environment variable values" CP |
Use the EM CLI verb stop_ebs to stop services on Oracle E-Business Suite instances. The details of these instances must be provided as an XML file. Schema and sample XML with comments are found in the appendix XML Schema Using EM CLI.
You can provide the following named credentials in the input XML file:
"E-Business Suite Database credentials " type for Oracle E-Business Suite target type set for apps schema.
"Oracle Weblogic credentials" type for Oracle web logic server target type.
The required apps schema database credentials and WebLogic Server administration credentials are chosen in the following order:
Preferred credentials set for:
"AppsDBCredsSet" credential set for Oracle E-Business Suite
"Oracle Weblogic Administration credentials" credential set of Oracle Web Logic server target type
Named credentials provided in the individual Oracle E-Business Suite instance level
Global named credentials
Note: You can generate the XML from the schema using any IDE. Choose a depth of 8 or more, if you do so.
Execute the following command to stop services on the Oracle E-Business Suite instance:
/EM CLI stop_ebs -input_file=stop_file:<fully qualified path of stop_ebs_file.xml> -log_file=<fully qualified path of log file>
The log_file
parameter is optional. If it is not provided, the system generates its own, and the path is then displayed in the console. The log file contains the debug statements, job IDs of various jobs that gets submitted in the process of stopping Oracle E-Business Suite.
The path of the generated health check report is shown in the console. The following is the sequence of actions that occurs while stopping Oracle E-Business Suite:
A job is submitted to stop the Oracle E-Business Suite instance.
A health check report is generated and the path of the report is displayed in the console.
Blackout is performed on the Oracle E-Business Suite instance. This is to avoid getting alerts that the instance is down.
Services on all application nodes are stopped. When using Oracle E-Business Suite Release 12.2 and later, only run application nodes are stopped.
Database instance and its listener are stopped.
You can check the job summary to view the execution report of all Oracle E-Business Suite instances.
The start and stop feature has been enhanced in Oracle Application Management Pack Bundle Patch 1 (BP 1) to be more granular. You can now choose which nodes need to be started or stopped, and also choose the components running on the node to be started or stopped. New elements, which are described in this section, have been added in the input XML to support this. See the appendix XML Schema Using EM CLI for sample schema and XML. Syntax for the command remains the same.
Selection of application nodes
Either all or only selected application nodes are stopped, based on the attribute StartAndStopOnAllNodes
value of the EBSInstancesList
/GlobalSettings
/AppsTier
tag.
All application nodes are stopped if this value is true
.
If this value is false
, only the application nodes mentioned in the EBSInstancesList
/EBSInstances
/EBSInstance
/AppNodes
/ContextName
tag are stopped.
Multiple ContextName
tags could be provided to mention multiple application context names.
For Oracle E-Business Suite Release 12.2, only application nodes of run edition type are stopped.
Components to be stopped
Using the EBSInstancesList
/GlobalSettings
/AppsTier
/Component
tag, you can specify the component that has to be stopped. To do this, provide one of the following options:
All
ICM
APPS_LISTENER
HTTP_SERVER
OAFM_OC4J
OACORE_OC4J
FORMS_OC4J
ADMIN_SERVER_WEBLOGIC
FORMS_WEBLOGIC
OACORE_WEBLOGIC
FORMS_LISTENER
Selection of database nodes
Either all or only selected database nodes are stopped based on the attribute StartAndStopOnAllNodes
value of the EBSInstancesList
/GlobalSettings
/DBTier
tag.
All database nodes are stopped if this value is true
.
If this value is false
, only the database nodes mentioned in the EBSInstancesList
/EBSInstances
/EBSInstance
/DBNodes
/ContextName
tag are stopped.
Multipe ContextName
tags could be provided to mention multiple DB context names.
Components to be stopped
Using the EBSInstancesList
/GlobalSettings
/DBTier
/Component
tag, you can specify the component that has to be stopped. To do this, provide one of the following options:
ALL
LISTENER
DATABASE
Selection of application nodes
Either all or only selected application nodes are started based on the attribute StartAndStopOnAllNodes
value of the EBSInstancesList
/GlobalSettings
/AppsTier
tag.
All application nodes are started if this value is true
.
If this value is false
, only those application nodes mentioned in the EBSInstancesList
/EBSInstances
/EBSInstance
/AppNodes
/ContextName
tag are started.
Multiple ContextName
tags could be provided to mention multiple application context names.
For Oracle E-Business Suite Release 12.2, only application nodes of run edition type are started
Components to be started
Using the EBSInstancesList
/GlobalSettings
/AppsTier
/Component
tag, you can specify the component that has to be started. To do so, provide one of the following options:
ALL
ICM
APPS_LISTENER
HTTP_SERVER
OAFM_OC4J
OACORE_OC4J
FORMS_OC4J
ADMIN_SERVER_WEBLOGIC
FORMS_WEBLOGIC
OACORE_WEBLOGIC
FORMS_LISTENER
Selection of database nodes
Either all or only selected database nodes are started based on the attribute StartAndStopOnAllNodes
value of the EBSInstancesList
/GlobalSettings
/DBTier
tag.
All database nodes are started if this value is true
.
If this value is false
, only database nodes mentioned in the EBSInstancesList
/EBSInstances
/EBSInstance
/DBNodes
/ContextName
tag are started.
Multiple ContextName
tags could be provided to mention multiple DB context names.
Components to be started
Using the EBSInstancesList
/GlobalSettings
/DBTier
/Component
tag, you can specify the component that has to be started. To do so, provide one of the following options:
ALL
LISTENER
DATABASE
Note: This feature is only available to those who have applied BP 1 on top of Oracle Application Management Pack 13.1.1.1.0.
The EM CLI verbs ebs_start_blackout and ebs_stop_blackout can be used to start and stop a blackout on a given Oracle E-Business Suite instance.
The name of the Oracle E-Business Suite instance will be passed as an input parameter to the verb and it is mandatory to pass. The log file parameter is optional. If it is not provided, the log file is then generated at a temporary location and is displayed on the console after the execution of the verb.
emcli ebs_start_blackout -ebs_name="ebs target name" -log_file="<fully qualified path of log file to be generated>"
emcli ebs_stop_blackout -ebs_name="ebs target name" -log_file="<fully qualified path of log file to be generated>"
When monitoring an Oracle E-Business Suite instance that features Online Patching, the plug-in ensures that only the run edition targets are monitored after a cutover. This is achieved through a corrective actions job which will black out the patch edition targets. The corrective actions are triggered based on the metrics collected about the patching activity. In case if they fail to trigger, the plug-in will end up monitoring the wrong file system. Corrective actions will not be triggered until the next cutover. Therefore, if the user observes that the plug-in is monitoring the wrong file system, with the Operator privilege the user must manually trigger the corrective actions job. .
Navigate to Administration > Synchronize Edition Details in the instance target menu.
By synchronizing the edition details, this will ensure that the plug-in monitors the run edition only. This job will exit gracefully if the correct file system is being monitored. The same UI will also show the details of previous submissions for the same purpose.
An administration group in Enterprise Manager is a special kind of group wherein the target members can be added automatically based on certain target properties of the members. When target properties match with administrative group specifications, then the target is automatically added to that administration group. A privilege defined for an administrative group is also set for all the member targets. A target must have the ability to accept privilege propagation to be part of administration group, otherwise the privileges cannot be set for the members of that target. All Oracle E-Business Suite targets can be part of administration groups and allow privilege propagation.
For more information on administration groups in Enterprise Manager, see the Oracle Enterprise Manager Cloud Control Administrator's Guide.
Important: To use this functionality, an administrator must have both Full Any Target and Create Privilege Propagating Group target privileges to be able to create an Administration Group.
From the Enterprise Manager console, click the Targets drop-down menu > Groups.
On this screen, click on the Create drop-down.
Select Administration Group from the list.
Define the Administration Group's target properties. Choose one or more target properties by clicking on Add in Hierarchy Levels table.
Specify the target property value(s) by adding in the Hierarchy Nodes table.
Click Create to save your work and create the group.
Once an administration group is created, members can be added by specifying member properties as that are of the group. For an Oracle E-Business Suite instance, the following steps are used to set the target properties.
Navigate to Targets > Oracle E-Business Suite from the Oracle Enterprise Manager console.
Select an instance by clicking on it.
From the Oracle E-Business Suite instance target menu, select Target Setup > Properties.
Set the target property value to one of the values specified in the Administration Group page by clicking on the Edit button.
To save, click OK.
To view the Administration group members, go back to Targets and then Groups.
You can now see the Oracle E-Business Suite instance and members added to the administration group created earlier and also in the corresponding subgroup based on the value of target property chosen.
For example, you can create an administration group with two subgroups corresponding to Production and Development lifecycle statuses.
Set the Lifecycle Status of an Oracle E-Business Suite instance by selecting Production in the drop-down listing.
Now, the Oracle E-Business Suite target members should be added to the group automatically and to the Production level.
The Oracle E-Business Suite Instance Administration feature provides the option to modify the existing Oracle E-Business Suite instance in the following ways:
Add/Remove application tier nodes
Enable/Disable service groups in each application node
Create/Delete managed servers in each application node (For Oracle E-Business Suite Release 12 only)
Oracle E-Business Suite Instance Administration requires Perl 5.005 or later on the Oracle Enterprise Manager agent. The user who starts the agent processes must set the PERL5LIB environment variable to point to the Perl 5.005 (or later) libraries. Also, the Perl executable 5.005 must be used.
All virtual internet protocol (VIP) addresses configured in the Oracle Cluster Ready Services (CRS) of the target nodes identified for the created RAC instance must be up and running.
The OS utilities make, ld, cc, and ar must be in the environment PATH variable in all host targets. If not, please update the PATH variable accordingly and restart the agent in the same terminal.
Before starting Oracle E-Business Suite Instance Administration, please make sure the following prerequisites are met:
Oracle E-Business Suite Instance Prerequisites
The Oracle E-Business Suite instance to be modified must be up and healthy.
The instance should have been discovered in Enterprise Manager and the status must not be pending.
The instance should have had AutoConfig run successfully. It is mandatory that AutoConfig was successfully run on the source applications tier and source database tier.
At the time of running the Oracle E-Business Suite instance, the etc/oraInst.loc
must point to the correct oraInventory.
Note: On some platforms such as Solaris, the variable is /var/opt/oracle/oraInst.loc
.
Oracle Application Management Pack for Oracle E-Business Suite Prerequisites
All database hosts and application tier hosts should have "Oracle E-Business Suite Plug-in" deployed before starting Oracle E-Business Suite Instance Administration.
User Privileges
User privileges for the Cloning module are also applicable to Oracle E-Business Suite instance administration.
Oracle E-Business Suite Instance Administration can be accessed through the Oracle E-Business Suite home page or from the Procedure Library.
Go to the Oracle E-Business Suite Management page and expand the Administer menu. Then, select Instance Administration.
Navigate to the Procedure Library from the Enterprise menu > Provisioning and Patching > Procedure Library.
Search for and select the "Instance Administration for R12, 12.2.x" procedure radio button. Then, click Go.
From the Oracle E-Business Suite Instance Administration start page, follow the steps below to submit an Oracle E-Business Suite Instance Administration procedure:
Select the Oracle E-Business Suite instance by clicking on the Search icon. Selecting an instance will display the application and database node information.
Verify the current Oracle E-Business Suite details.
Then, enter the following data:
Job name: Name of the current job to be submitted
Database Apps Credential
Database Apps Credential
For Oracle E-Business Suite Release 12.2 only: WebLogic password
Manage the application nodes.
To add application nodes:
In the Application Nodes section, click Add. The Select Host(s) window will appear.
Select one or more hosts to be added, then click OK.
For Release 12.2 only: To add an application node as a shared file system node:
In the Select Host(s) window, select the Shared Application Node radio button. Choose the node to be added in the Select APPL_TOP drop-down.
Then, select one or more hosts to be added. Click OK.
To delete application nodes:
Select one or more rows in the Application Nodes table.
In the Application Nodes panel, click Delete, which pops up a list of hosts.
To update the service groups of each application node:
The user will be able to update the following service groups for each node:
Web Entry Point Service Group: To enable following services in the current node:
OHS, OPMN
Web Application Service Group: To enable following services in the current node:
oacore, forms, oafm, tns_apps
For Release 12.2 only: forms-c4ws, oaea
Batch Processing Service Group: To enable following services in the current node:
Concurrent Manager, ICSM, JTFF
Other Services: To enable following services in the current node:
forms_server, met_cl, met_srv, mwa_srv
For Release 12.2 only: Admin - To enable WebLogic Admin Server in the current node.
For Releases earlier than 12.2.x only: Root Service Group - To enable Node Manager in the current node.
Note: For Release 12.2, the node manager will automatically be enabled if the Web Application Service Group is enabled.
For Release 12.2 only: Updating managed servers:
When a user selects "Web Application Services," default managed servers will automatically be populated.
Users can delete/add managed servers with the options found in the Managed Servers column. Click Add to add a managed server. Click the red X icon to delete it.
Modify the stage directory details.
If the user has added at least one new node, this option will appear.
Manual copy: If a user wants to copy files manually / file system on the new application node is already present.
Automatic copy: This option allows users to automatically copy files from the Admin node to the new application nodes. Users can choose from one of the copy methods described below:
Remote file transfer: When in the Admin node, new application nodes do not have any shared storage mounted.
Shared file system storage: When in the Admin node, new application nodes are on different hosts and have a common storage location mounted across.
Enter the stage directory path.
Enter the absolute path for the Admin Host stage directory.
Also, enter the absolute path of the stage directories for new application host(s).
Note: Make sure this directory has write permissions. Also, the stage directory has sufficient space to hold a complete course file system (Approximately 15GB - 20GB or more free space is required, depending on the source application file system).
The following screenshot shows an example of when the user had added 2 new nodes to the existing Oracle E-Business Suite instance:
The following host credentials need to be defined:
Database node credentials: This table lists all the database nodes.
Application node credentials: This table contains all the application node hosts.
Note: It is recommended that you verify your entries and click on the Test button before proceeding to the next step.
The last step displays the data which was entered by the user. Review and click on the Finish button to submit the clone.
Open the Procedure Activity page by navigating to the Enterprise menu > Provisioning and Patching > Procedure Activity.
Enter the Job Name that was provided when the procedure was submitted into the Search Text Fields field and click Go.
In the Procedure Steps section, select the corresponding check box to choose a procedure to view its details.
If any of the procedure step statuses are marked as failed, select the step to view it in the procedure view and choose one of the following options:
Ignore - Ignore the current failed step and proceed to the next step.
Retry - Retry the failed step.
Update and Retry - Update the job parameters and retry the failed step.
Note that in the Instance Administration deployment procedure for Release 12.2.x, as AutoConfig on the database tier will update the sqlnet.ora
there will be a manual step just before the target Oracle E-Business Suite discovery step to enable the OMS host(s) to connect to the target Oracle E-Business Suite database. You need to verify and update the OMS host(s) entry for tcp.invited_nodes if tcp.validnode_checking is set to yes.