Oracle EBS R12.2.12 Startup and Shutdown Sequence

 Dear All,

In this post i am going to share you how to start and stop oracle EBS R12.2.2 applications.

this will useful for oracle apps dba's .

Here is my current work environment details , its includes my OS version , database version and EBS application version.

Environment: Oracle apps R12.2 Single Node.

Database:  Oracle 19C

select banner_full from v$version;

BANNER_FULL

--------------------------------------------------------------------------------

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.18.0.0.0

Application: EBS R12.2.12

SELECT RELEASE_NAME FROM FND_PRODUCT_GROUPS;

RELEASE_NAME

--------------------------------------------------

12.2.12

OS: Oracle Linux.:

[oracle@apps ~]$ cat /etc/redhat-release

Red Hat Enterprise Linux Server release 7.9 (Maipo)

 

EBS R12.2.12 Application Start-up Sequence:

First we need to connect to the physical host and then we need to set the database environment then follow the below steps .

##check the database status 

[root@apps ~]# ps -ef |grep smon

oracle    1760     1  0 07:40 ?        00:00:00 ora_smon_EBSCDB

root      6868  6822  0 07:59 pts/0    00:00:00 grep --color=auto smon

Ø Start Database services.

sqlplus / as sysdba

SQL >  startup 

Ø Start Database Listener services.

lsnrctl status listner_name or lsnrctl 

start / status 

next we need to connect to application host and then set the application environment.

##check the application status.

[root@apps ~]# ps -ef |grep tns

root        35     2  0 07:39 ?        00:00:00 [netns]

oracle    2063     1  0 07:40 ?        00:00:00 /u01/install/APPS/19.0.0/bin/tnslsnr EBSCDB -inherit

oracle    3324     1  0 07:42 ?        00:00:00 /u01/install/APPS/fs1/EBSapps/10.1.2/bin/tnslsnr APPS_EBSDB -inherit

root      6873  6822  0 07:59 pts/0    00:00:00 grep --color=auto tns

[root@apps ~]#

 

Ø Start EBS Application services

set the application environment... then start the application  services using .. adstral.sh 

Ø

 

application services started successfully.

EBS R12.2.12 Application Stop Sequence:

First we need to connect to application host and then set the application environment.

[oracle@apps ~]$ . EBSapps.env

  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: apps.example.com  Service/SID: EBSDB

  E-Business Suite Environment Setting

  ------------------------------------

  - Enter [R/r] for sourcing Run File System Environment file, or

  - Enter [P/p] for sourcing Patch File System Environment file, or

  - Enter anything else to exit

  Please choose the environment file you wish to source [R/P]:R   ( we set the run filesystem )

  Sourcing the RUN File System ...

Ø Stop Application services

cd /u01/install/APPS/fs1/inst/apps/EBSDB_apps/admin/scripts

or 

cd $ADMIN_SCRIPTS_HOME/

[oracle@apps scripts]$ sh adstpall.sh

You are running adstpall.sh version 120.22.12020000.7

Enter the APPS username: apps

Enter the APPS password: appspassword 

Enter the WebLogic Server password: weblogic-password 

The logfile for this session is located at /u01/install/APPS/fs1/inst/apps/EBSDB_apps/logs/appl/admin/log/adstpall.log

stop log files.. 

Next we need to connect to the physical host and then we need to set the database environment then follow the below steps .

Ø Stop Database Listener services.

LSNRCTL> stop

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

The command completed successfully

LSNRCTL> status

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

TNS-12541: TNS:no listener

 TNS-12560: TNS:protocol adapter error

  TNS-00511: No listener

   Linux Error: 111: Connection refused

lsnrctl stop listner_name;

lsnrctl

LSNRCTL> stop / status / start 

Ø Stop Database services.

stop the pdb first using below command

SQL >  alter pluggable database EBSDB close;

SQL> shut immediate;

Post application started , Sanity checks .

application login page : 

we have successfully bounced the Oracle EBS R12.2.12 including the 19C database services .. 

Thanks,

Srini