Wednesday, August 23, 2017

How to get Weblogic Admin Password


If we don't remember weblogic admin password, we can get it as below.

[applmgr@ebs1213 ~]$ sh /u01/app/oracle/ebsappl/FIN2DB/fs1/FMW_Home/wlserver_10.3/common/bin/wlst.sh


Initializing WebLogic Scripting Tool (WLST) ...

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

wls:/offline> domain="/u01/app/oracle/ebsappl/FIN2DB/fs1/FMW_Home/user_projects/domains/EBS_domain_FIN2DB"
wls:/offline> service = weblogic.security.internal.SerializedSystemIni.getEncryptionService(domain)
wls:/offline> encryption = weblogic.security.internal.encryption.ClearOrEncryptedService(service)
wls:/offline> print encryption.decrypt("{AES}Gp7Q+3yqpimz1+27+ftmbCRHpgkMTpEZc67RsxM9XS0=")
weblogic@123
wls:/offline>

We can get encrypted password from boot.properties.

[applmgr@ebs1213 security]$ cd $FMW_HOME/user_projects/domains/EBS_domain_FIN2DB/servers/AdminServer/security
[applmgr@ebs1213 security]$ cat boot.properties
username={AES}LY9AdjI1A7wTpNJpOl4/aMIH3uc0HEwLVcbM9kXwffE=
password={AES}Gp7Q+3yqpimz1+27+ftmbCRHpgkMTpEZc67RsxM9XS0


--
Sent from Gmail Mobile

Saturday, April 9, 2016

Installation Oracle Ebusiness Suite 12.2.5 using startCD 12.2.0.51

Oracle E-Business Suite Release 12.2.5 Readme (Doc ID 1983050.1)
- Instal ebs dari startCD versi 12.2.0.51

Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Doc ID 1594274.1)
- Apply patch database Database
Missing Bugfix: 21028698 -> Patch 22098146
Missing Bugfix: 21286665 -> Patch 21286665
Missing Bugfix: 21387964 -> Patch 21387964
Missing Bugfix: 21614112 -> Patch 21841318
Missing Bugfix: 21967332 -> Patch 21967332'


- Apply patch Oracle Forms and Reports
Missing Bugfix: 17353142 -> Patch 21539521
Missing Bugfix: 20643256 -> Patch 21539521
Missing Bugfix: 16041055 -> Patch 21539521
Missing Bugfix: 16910762 -> Patch 21539521
Missing Bugfix: 20270659 -> Patch 21539521
Missing Bugfix: 17372642 -> Patch 21539521
Missing Bugfix: 17566694 -> Patch 21539521
Missing Bugfix: 20240480 -> Patch 21539521
Missing Bugfix: 19304738 -> Patch 21539521
Missing Bugfix: 20391574 -> Patch 21539521
$ . ./fsauto.sh
$ cd /u02/titip_made/21539521
$ $ORACLE_HOME/OPatch/opatch apply

- Apply patch Oracle Fusion Middleware (FMW) - Web Tier.
Missing Bugfix: 21300463 -> Patch 22107540
$ . ./fsauto.sh
$ cd /u02/titip_made/22107540
$ export ORACLE_HOME=$IAS_ORACLE_HOME
$ $ORACLE_HOME/OPatch/opatch apply


- Apply patch Oracle Fusion Middleware (FMW) - oracle_common
Missing Bugfix: 21366277 -> Patch 21366277
Missing Bugfix: 21628307 -> Patch 21628307
$ export ORACLE_HOME=$FMW_HOME/oracle_common

- Apply patch Oracle WebLogic Server (WLS)
Missing Patch ID: 20780171 -- diganti 21984589
$ unzip p21984589_1036_Generic.zip ke $FMW_HOME/utils/bsu/cache_dir
$ cd $FMW_HOME/utils/bsu
$ sh bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=S28A -prod_dir=$FMW_HOME/wlserver_10.3
-- bsu.sh -remove -patchlist=Y5AP -prod_dir=$FMW_HOME/wlserver_10.3


Missing Patch ID: 11781879
Missing Patch ID: 13337000
Missing Patch ID: 13729611
Missing Patch ID: 17319481
Missing Patch ID: 19687084
Missing Patch ID: 19600486
Missing Patch ID: 20780171

[demomgr@laberp bsu]$ sh bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=EJUW -prod_dir=$FMW_HOME/wlserver_10.3
Checking for conflicts...
Conflict(s) detected - resolve conflict condition and execute patch installation again
Conflict condition details follow:
Patch EJUW is mutually exclusive and cannot coexist with patch(es): Y5AP,UITV,MRF8,YVFP,S28A,A6GS



Apply Consolidated Seed Table Upgrade Patch (Required)
$ . ./fsauto.sh
$ sh $ADMIN_SCRIPTS_HOME/adstpall.sh
$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
$ adop phase=apply patches=17204589,21900871 merge=yes hotpatch=yes
$ sh $ADMIN_SCRIPTS_HOME/adstrtal.sh

Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)
$ . /u01/oracle/demo/fs1/EBSapps/appl/APPSdemo_laberp.env
$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start

Patch 20745242 (R12.AD.C.Delta.7)
Patch 22123818:R12.AD.C
Patch 20784380 (R12.TXK.C.Delta.7)
Patch 22363475:R12.TXK.C
Patch 22495069:R12.TXK.C


$ . ./db.env
$ $ORACLE_HOME/appsutil/admin
$ cp adgrants $ORACLE_HOME/appsutil/admin
$ sqlplus /nolog
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql <APPS schema name>


$ . /u01/oracle/demo/fs1/EBSapps/appl/APPSdemo_laberp.env
$ sh $ADMIN_SCRIPTS_HOME/adstpall.sh
$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
$ adop phase=apply patches=20745242 hotpatch=yes
$ adop phase=apply patches=22123818 hotpatch=yes
$ adop phase=apply patches=20784380,22363475,22495069 hotpatch=yes merge=yes
$ . <EBS_ROOT>/EBSapps.env run
$ autoconfig
$ perl <AD_TOP>/bin/admkappsutil.pl
$ cp <INST_TOP>/admin/out/appsutil.zip <RDBMS ORACLE_HOME>

$ cd <RDBMS ORACLE_HOME>
$ . ./<RDBMS ORACLE_HOME>/<CONTEXT_NAME>.env
$ cd <ORACLE_HOME>
$ unzip -o appsutil.zip

Path A — Upgrade and New Installation Customers upgrading to Oracle E-Business Suite 12.2.5 Release Update Pack
$ . <INSTALL_BASE>/EBSapps.env run
$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop
$ sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop
SQL> alter system set optimizer_adaptive_features=false;
$ adop phase=apply apply_mode=downtime patches=19676458
SQL> alter system set optimizer_adaptive_features=true;
$ sh $ADMIN_SCRIPTS_HOME/adstrtal.sh
$ adop phase=cleanup
$ adop phase=fs_clone


Section 9: Post-Update Steps
$ adop phase=apply patches=19676460 hotpatch=yes