/u01/db/ERPPROD/tech_st/11.2.
0/
export ORACLE_BASE=/u01/db/ERPPROD/tech_st
export ORACLE_SID=ERPPROD
export ORACLE_HOME=/u01/db/ERPPROD/tech_st/11.2.0
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/perl/bin:$ORACLE_HOME/OPatch:$PATH
export TNS_ADMIN=$ORACLE_HOME/network/admin/ERPPROD_stgerpapp01
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export ORA_NLS10=$ORACLE_HOME/nls/data/9idata
export PERL5LIB=$ORACLE_HOME/perl/lib/5.10.:$ORACLE_HOME/perl/lib/site_perl/5.10.0
export OPATCH_HOME=$ORACLE_HOME/OPatch
export
ORA_TZFILE='/u01/db/ERPPROD/tech_st/11.2.0/oracore/zoneinfo/timezlrg_14.dat'
***********************************************************************************
****
export PATH=$PATH:$HOME/bin
export ORACLE_BASE=/u01/db/ERPPROD/tech_st
export ORACLE_SID=ERPPROD
export ORACLE_HOME=/u01/db/ERPPROD/tech_st/12.1.0/dbhome_1
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/perl/bin:$ORACLE_HOME/OPatch:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export TNS_ADMIN=$ORACLE_HOME/network/admin/ERPPROD_stgerpapp01
export PERL5LIB=$ORACLE_HOME/perl/lib/5.8.3:$ORACLE_HOME/perl/lib/site_perl/5.8.3
export OPATCH_HOME=$ORACLE_HOME/OPatch
export ORA_TZFILE='/u01/db/ERPPROD/tech_st/11.2.0/oracore/zoneinfo/timezlrg_14.dat'
***********************************************************************************
****
issue:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 2
ORA-00904: "I"."UNUSABLEBEGINNING#": invalid identifier
Process ID: 13900
Session ID: 201 Serial number: 13545
solution:
SQL> startup upgrade
********************************************************************************
issue:
How to retrieve SYSADMIN password in 11i/R12
solution:
STEP 1: Login to sqlplus APPS/<PASSWORD>
SQL> CREATE OR REPLACE PACKAGE APPS.XXARTO_GET_PWD AS
FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)
RETURN VARCHAR2;
END XXARTO_GET_PWD;
/
Package created.
SQL> CREATE OR REPLACE PACKAGE BODY APPS.XXARTO_GET_PWD AS
FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)
RETURN VARCHAR2 AS
LANGUAGE JAVA NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt
(java.lang.String,java.lang.String) return java.lang.String';
END XXARTO_GET_PWD;
/
Package body created.
SQL> SELECT Usr.User_Name,
Usr.Description,
XXARTO_GET_PWD.Decrypt (
(SELECT (SELECT XXARTO_GET_PWD.Decrypt (
Fnd_Web_Sec.Get_Guest_Username_Pwd,
Usertable.Encrypted_Foundation_Password)
FROM DUAL)
AS Apps_Password
FROM applsys.Fnd_User Usertable
WHERE Usertable.User_Name =
(SELECT SUBSTR (
Fnd_Web_Sec.Get_Guest_Username_Pwd,
1,
INSTR (Fnd_Web_Sec.Get_Guest_Username_Pwd,
'/')
- 1)
FROM DUAL)),
Usr.Encrypted_User_Password)
Password
FROM applsys.Fnd_User Usr
WHERE Usr.User_Name = '&User_Name';
Enter value for user_name: SYSADMIN
old 21: WHERE Usr.User_Name = '&User_Name'
new 21: WHERE Usr.User_Name = 'SYSADMIN'
USER_NAME DESCRIPTION PASSWORD
---------------- --------------------------
SYSADMIN System Administrator Welcome123
********************************************************************************
HOW TO FIND THE HOME_URL/LOGIN PAGE OF THE APPLICATIONS
following two methods can be used to find the HOME_URL/LOGIN PAGE
SQL> select home_url from icx_parameters;
$grep login_page $CONTEXT_FILE
HOW TO FIND THE WEBLOGIC URL FROM CONTEXT FILE
grep -i .wls_admin. $CONTEXT_FILE
********************************************************************************
linux commands
find its used for searching a file in the directories
grep
********************************************************************************
https://support.oracle.com/epmos/faces/DocumentDisplay?
_afrLoop=157083814060881&parent=EXTERNAL_SEARCH&sourceId=BULLETIN&id=1057802.1&_afr
WindowMode=0&_adf.ctrl-state=1dftudmz6r_53
https://support.oracle.com/epmos/faces/DocumentDisplay?
_afrLoop=157085974609448&parent=EXTERNAL_SEARCH&sourceId=TROUBLESHOOTING&id=104452.
1&_afrWindowMode=0&_adf.ctrl-state=1dftudmz6r_94
https://support.oracle.com/epmos/faces/DocumentDisplay?
_afrLoop=157116244339599&parent=EXTERNAL_SEARCH&sourceId=FAQ&id=105133.1&_afrWindow
Mode=0&_adf.ctrl-state=1dftudmz6r_151
https://support.oracle.com/epmos/faces/DocumentDisplay?
_afrLoop=157568566001536&parent=DOCUMENT&sourceId=105133.1&id=1304305.1&_afrWindowM
ode=0&_adf.ctrl-state=1dftudmz6r_249
https://support.oracle.com/epmos/faces/DocumentDisplay?
_afrLoop=157229694417345&parent=EXTERNAL_SEARCH&sourceId=HOWTO&id=343575.1&_afrWind
owMode=0&_adf.ctrl-state=1dftudmz6r_200
Getting Started with Oracle E-Business Suite on Oracle Cloud Infrastructure (Doc ID
2517025.1) Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone (Doc ID
1383621.1)
********************************************************************************
$ echo $FILE_EDITION
<shows which file edition you are using, run or patch>
$ echo $RUN_BASE
<shows absolute path to run file system>
$ echo $PATCH_BASE
<shows absolute path to patch file system>
$ echo $NE_BASE
<shows absolute path to non-edition file system>
$ echo $APPL_TOP_NE
<non-editioned appl_top path. Equivalent to $NE_BASE/EBSapps/appl>
$ echo $LOG_HOME
<Application Instance Specific Log Directory>
$ echo $ADOP_LOG_HOME
<Online patching Specific Log Directory. Equivalent to $NE_BASE/EBSapps/log/adop>
$ echo $IAS_ORACLE_HOME
<FMW Web Tier Home Directory>
$ echo $ORACLE_HOME
< 10.1.2 ORACLE_HOME>
$ echo $CONTEXT_FILE
<Source for information populating template files (autoconfig)>
$ echo $EBS_DOMAIN_HOME
<WLS Deployment of Oracle E-Business Suite 12.2 Domain (instance specific)>
$ echo $ADMIN_SCRIPTS_HOME
<Shell scripts to control processes associated to the Applications Instance>
$ echo $EBS_ORACLE_HOME
<Oracle E-Business Suite 12.2 FMW Deployment directory>
$ echo $RW
<10.1.2 reports directory>
$ echo $HOSTNAME
<hostname without domain name>
$ echo $APPS_VERSION
<to get the EBS version>
