Oracle EBS R12.2, Login Page doesn’t not open EBS_DOMAIN log where there was a stuck thread processing the AppsLocalLogin.jsp page Error: <Error> <WebLogicServer> <devebsapp.bescom.com> <oacore_server1> <[ACTIVE] ExecuteThread: ’23’ for queue: ‘weblogic.kernel.Default (self-tuning)’> <<WLS Kernel>> <> <0c3c553ba012d498:21ac6fdc:1789db30822:-8000-0000000000000756> <1617632797420> <BEA-000337> <[STUCK] ExecuteThread: ’20’ for …
While am executing the adop -status, The following got Error [applmgr@devebsapp admin]$ adop -status Enter the APPS password: *******FATAL ERROR******* PROGRAM : (/prodapps/applmgr/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl) TIME : Fri Mar 26 22:40:21 2021 FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ] MESSAGES: SQLPLUS error: buffer= SQL*Plus: Release 10.1.0.5.0 – Production on Fri Jun 25 22:40:21 2021 …
ORA-04063: package body “APPS.AD_ZD_ADOP” has errors when Running adop -status Read More »
ORACLE EBS R12.2 cloning Cold Backup Details here…… Application Cold Backup of ORACLE EBS 12.2 step by step DB Cold Backup of ORACLE EBS 12.2 step by step 1.Source Database: DEV instance /dev/backup/01AUG21/ORACLE_HOME_01AUG21.tar.gz /dev/backup/01AUG21/DB_BACKUP_01AUG21.tar.gz 2.Backup move to Target database: Backup move to Target database(TEST instance) I.ORACLE_HOME Move to Test server scp -P ORACLE_HOME.tar.gz 172.165.12.17:/testebsdb/TEST/db/tect_st/ II. …
Oracle EBS R12.2 Cloning Using Cold Backup step by steps Read More »
1.Execute the adpreclone.pl both application and database. 2.Move the RMAN Backup, database ORACLE HOME, and application backup to the target server. Source Database: PROD Target Database: TEST Backup Details (PROD): /prod/rman_backup/15Jul2021_bkp Database backup move to target Server (testdb) : ***************************************************** Copy Command from Source (PROD) server to Target server(TEST) scp -P 15Jul2021_bkp …
Oracle EBS R12.2 Cloning using RMAN Backup Step by Steps Read More »
1. Database autoconfig: 1. To source the environment file from the $ORACLE_HOME oracle@visebsdb 12.1.0]$ . VIS_visebsdb.env 2. To connect the SQLPLUS [oracle@visebsdb 12.1.0]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Fri Jul 16 23:08:28 2021 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to …
How to run Autoconfig in Database Tier and Application Tier in Oracle EBS R12.2 ? Read More »
To Start the Database(12c) : In the ORACLE_HOME source the environment file (ie VIS_ebs-db.env) [oracle@ebs-db 12.1.0]$ . VIS_ebs-db.env To connect the SQLPLUS : [oracle@ebs-db 12.1.0]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Mon Jul 1 11:25:09 2021 Copyright (c) 1982, 2014, Oracle. All rights reserved. …
How to Start Database and Application in ORACLE EBS R12.2 Read More »
Go to following Directory: /devapps/OBIEE/Middleware/user_projects/domains/bi/bitools/bin To Know the Status of All Services : [obiee@obiee-app bin]$ ./status.sh Domain status; Using domainHome: /devapps/OBIEE/Middleware/user_projects/domains/bi … Initializing WebLogic Scripting Tool (WLST) … Welcome to WebLogic Server Administration Scripting Shell Type help() for help on available commands <Jul 3, 2021 9:05:07 AM …
Starting and Stopping OBIEE 12c Services in Linux Read More »
Create the following details to create : username : archive_purge password: archive123 tablespace name : archive_purge temporary tablespace name: temp To Create tablespace : SQL>CREATE TABLESPACE archive_purge DATAFILE ‘/u01/MIC1213/db/apps_st/data/archive_purge01.dbf’ size 5G; To Create Create User : SQL> create user archive_purge identified by archive123 temporary tablespace temp default tablespace archive_purge; To Permission to User : SQL> grant connect …
How to Create Custom Schema in Oracle 11g /12c ? Read More »
Cloning Oracle E-Business Suite R12.2.6 using 19c database Single PDB export PERL5LIB=/u01/install/APPS/19.5.0/perl/lib/5.28.1:/u01/install/APPS/19.5.0/perl/lib/site_perl/5.28.1 export PATH=/u01/install/APPS/19.5.0/bin:$PATH export LD_LIBRARY_PATH=/u01/install/APPS/19.5.0/lib CONTAINER DB NAME=EBSCDB1 pluggable DB NAMe=EBSDB1 1. I got new server , so that I checked prerequest ************************************************** Red Hat Enterprise Linux Server release 7.7 (Maipo) Use the “oracle-database-preinstall-19c” package to …
Cloning Oracle E-Business Suite R12.2.6 using 19c database Single PDB Read More »
1. Crontab Check If you want to take cold backup, first check-in Application Crontab Job scheduled or not Check the status of the crontab [applprod@r12prdappl ~]$ crontab -l #Report_archive 00 17 * * * . /home/applprod/scripts/report_archive.sh #Application_Binaries_backup 00 01 * * 1-5 sh /home/applprod/scripts/Prod_binaries.sh > /tmp/Prod_binaries_daily_bkp.log Disable the crontab [applprod@r12prdappl ~]$ …
Application Cold Backup of ORACLE R12.2 step by steps Read More »