Expensive All,
On this put up i’m going to share you find out how to begin and cease oracle EBS R12.2.2 functions.
this can helpful for oracle apps dba’s .
Right here is my present work atmosphere particulars , its consists of my OS model , database model and EBS utility model.
Surroundings:
Oracle apps R12.2 Single Node.
Database:
Oracle 19C
choose
banner_full from v$model;
BANNER_FULL
——————————————————————————–
Oracle Database 19c Enterprise Version Launch
19.0.0.0.0 – Manufacturing
Model 19.18.0.0.0
Utility:
EBS R12.2.12
SELECT
RELEASE_NAME FROM FND_PRODUCT_GROUPS;
RELEASE_NAME
————————————————–
12.2.12
OS:
Oracle Linux.:
[oracle@apps
~]$ cat /and many others/redhat-release
Crimson Hat Enterprise Linux Server launch 7.9
(Maipo)
EBS R12.2.12 Utility Begin-up Sequence:
First we have to hook up with the bodily host after which we have to set the database atmosphere then observe the under steps .
##verify the database standing
[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
Ø Begin Database providers.
sqlplus / as sysdba
SQL > startup
Ø Begin Database Listener providers.
lsnrctl standing listner_name or lsnrctl
begin / standing
subsequent we have to hook up with utility host after which set the appliance atmosphere.
##verify the appliance standing.
[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/set up/APPS/19.0.0/bin/tnslsnr EBSCDB -inherit
oracle 3324 1 0 07:42 ? 00:00:00 /u01/set up/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 ~]#
Ø Begin EBS Utility providers
set the appliance atmosphere… then begin the appliance providers utilizing .. adstral.sh
Ø
utility providers began efficiently.
First we have to hook up with utility host after which set the appliance atmosphere.
[oracle@apps ~]$ . EBSapps.env
E-Enterprise Suite Surroundings Data
—————————————-
RUN File System : /u01/set up/APPS/fs1/EBSapps/appl
PATCH File System : /u01/set up/APPS/fs2/EBSapps/appl
Non-Editioned File System : /u01/set up/APPS/fs_ne
DB Host: apps.instance.com Service/SID: EBSDB
E-Enterprise Suite Surroundings Setting
————————————
– Enter [R/r] for sourcing Run File System Surroundings file, or
– Enter [P/p] for sourcing Patch File System Surroundings file, or
– Enter anything to exit
Please select the atmosphere file you want to supply [R/P]:R ( we set the run filesystem )
Sourcing the RUN File System …
Ø Shigh Utility providers
cd /u01/set up/APPS/fs1/inst/apps/EBSDB_apps/admin/scripts
or
[oracle@apps scripts]$ sh adstpall.sh
You might be working adstpall.sh model 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 positioned at /u01/set up/APPS/fs1/inst/apps/EBSDB_apps/logs/appl/admin/log/adstpall.log
cease log recordsdata..
Subsequent we have to hook up with the bodily host after which we have to set the database atmosphere then observe the under steps .
Ø Shigh Database Listener providers.
LSNRCTL> cease
Connecting to
(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The command accomplished efficiently
LSNRCTL> standing
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 cease listner_name;
lsnrctl
LSNRCTL> cease / standing / begin
cease the pdb first utilizing under command
SQL > alter pluggable database EBSDB shut;
SQL> shut instant;
Put up utility began , Sanity checks .
utility login web page :
now we have efficiently bounced the Oracle EBS R12.2.12 together with the 19C database providers ..
Thanks,
Srini
