Ameer Khan

Create an env file with following details.  Note: It is assumed that boot.properties file is configured with weblogic username and password. Otherwise the script will prompt for username and password. cat /home/oracle/app_env ORACLE_BASE=/d01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/12.2.1.4; export ORACLE_HOME MW_HOME=$ORACLE_HOME ; export MW_HOME WLS_HOME=$MW_HOME/wlserver; export WLS_HOME WL_HOME=$WLS_HOME  ;export WLS_HOME DOMAIN_HOME=/d01/app/oracle/product/12.2.1.4/user_projects/domains/prod_domain; export DOMAIN_HOME JAVA_HOME=/usr/java/jdk1.8.0_231-amd64; export JAVA_HOME export OHS_INST=/d01/app/oracle/product/12.2.1.4/user_projects/domains/prod_domain/config/fmwconfig/components/OHS/instances/ohs1… Continue Reading

Create an env file with following details.  Note: It is assumed that boot.properties file is configured with weblogic username and password. Otherwise the script will prompt for username and password. cat /home/oracle/app_env ORACLE_BASE=/d01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/12.2.1.4; export ORACLE_HOME MW_HOME=$ORACLE_HOME ; export MW_HOME WLS_HOME=$MW_HOME/wlserver; export WLS_HOME WL_HOME=$WLS_HOME  ;export WLS_HOME DOMAIN_HOME=/d01/app/oracle/product/12.2.1.4/user_projects/domains/prod_domain; export DOMAIN_HOME JAVA_HOME=/usr/java/jdk1.8.0_231-amd64; export JAVA_HOME export OHS_INST=/d01/app/oracle/product/12.2.1.4/user_projects/domains/prod_domain/config/fmwconfig/components/OHS/instances/ohs1… Continue Reading

In our daily life, sometimes we require to gather various information related to undo tablespace and for many of us it becomes challenging to remember all the views to gather that information. Using this script, we can gather various information related to undo tablespace in a single go. [db@server102 ~]$ cat undotablespace.sql #Please execute following… Continue Reading

Environment Details:- OMS DB Version 19.3.0 OEM Version 13.5.0.0.0 OS Windows Server 2019 Error Details:- During Oracle Enterprise manager 13.5 installation following error message is seen inside OMS_HOME/cfgtoollogs/omsca/omsca_<timestamp>.log location Aug 28, 2021 11:24:51 AM oracle.sysman.omsca.util.CoreOMSConfigAssistantUtil execCommand INFO: Output messages of the command C:\app\Middleware\bin\emctl.bat create service -oms_svc_name OracleManagementServer_EMGC_OMS1_1 : Oracle Enterprise Manager Cloud Control 13c Release… Continue Reading

OS : OEL 7.9 Download EPEL Repo You can download EPEL repo from this link https://dl.fedoraproject.org/pub/epel To download directly in the server use wget command [root@bastionhost opc]# wget https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm Install EPEL repo [root@bastionhost opc]# rpm -Uvh epel-release-latest-7.noarch.rpm warning: epel-release-latest-7.noarch.rpm: Header V4 RSA/SHA256 Signature, key ID 352c64e5: NOKEY Preparing…                          ################################# [100%] Updating / installing…    1:epel-release-7-13                #################################… Continue Reading

While running adpreclone on DB Tier , it fails with error RC-20010: Fatal: Could not find Info-ZIP’s zip version 2.3 in the PATH Environment Details:- Application Version R12.1.1 DB Version 11.2.0.4 OS RHEL 7 While running adpreclone on dbTier following error message is thrown [orapay@ccuine EIILPAY_ccuine]$ perl adpreclone.pl dbTier                       Copyright (c) 2002 Oracle Corporation                         Redwood Shores,… Continue Reading

Error Details: Database was cloned from source to target environment. While running autoconfig in DB tier  autoconfig is failing with following error  Environment Details:-  Application : EBS R12.1.3 Database : 19.9.0 sh adautocfg.sh  Enter the APPS user password: The log file for this session is located at: /u01/ebsclone/db/tech_st/19.3.0/appsutil/log/EBSCLONE_ccuine105/07172228/adconfig.log AutoConfig is configuring the Database environment… …. ….… Continue Reading

Oracle Enterprise Manager Cloud Control 13c Release 5 (13.5.0.0.0) Installation on Windows server 2019 Environment Details Hostname TSTAPP-WLS.amana.com OMS DB Version 19.3.0 OEM Version 13.5.0.0.0 OS Windows Server 2019 OMS Home D:\app\middleware Agent Home D:\app\agent Download Oracle Enterprise Manager Cloud Control 13c Release 5 (13.5.0.0.0) URL:- https://www.oracle.com/enterprise-manager/downloads/cloud-control-downloads.html Download Oracle Database 19c (19.3) for Windows 64bit URL… Continue Reading

To enable Diagnostic option in EBS R12.2  perform the following steps. Steps 1 Navigate to System Administrator responsibility> Profile> System> Steps 2 Enter profile name: Utilities:Diagnostics Application User for whom you want to enable Diagnostics and tick on user option -> Find Steps 3 Set Yes at User level and Save the Changes. You can keep… Continue Reading

After implementing PASSWORD_LIFE_TIME TO 30 DAYS for default profile, applsyspub user’s password was expired after 30 days. Following error is observed after logging in to application, Solution:- We altered the profile of APPLSYSPUB user from default to EBS_APPS and rested the password of APPLSYSPUB user. SQL> SELECT USERNAME,ACCOUNT_STATUS,EXPIRY_DATE,PROFILE FROM DBA_USERS WHERE USERNAME=’APPLSYSPUB’; USERNAME             ACCOUNT_STATUS       EXPIRY_DATE     PROFILE ——————–… Continue Reading