Wednesday, December 22, 2010

Opatch failed WITH error code 73

1. Opatch failed WITH error code 73.

You may get below message FOR the above error code
Running prerequisite CHECK..
prerequistie CHECK "CheckActiveFilesandExecutables" failed.
Following executables are active
/u0/abcd/db/tech_st/11.2.0/bin/oracle
UtilSession failed:prerequisite CHECK "CheckActiveFilesandExecutables" failed.
Opatch failed WITH error code 73.

To Fix this Issue:

CHECK
ps -ef | grep oracle
ps -ef | grep tns
oracle process may be running.
KILL the Oracle process.
KILL -9 process-id

2. ORA-12162 : TNS: net service name IS incorrectly specified

Sqlplus '/as sysdba'
The error message ORA-12162 IS very misleading, AS it suggests there IS a problem WITH the tnsnames.ora FILE CONTENTS.

To Fix this Issue:

export ORACLE_HOME=/u01/abcd/db/tech_st/11.1.0
export ORACLE_SID=ABCD (Your SID)

Tuesday, December 21, 2010

CHANGE HOSTNAME OR IP-Address OR DOMAIN NAME ON APPS-TIER OR DB-TIER in R12


Autoconfig Frequently asked Question : 218089.1
For any queries related to below mentioned steps Question Number from 23 onwards will help you.

Steps to change hostname or domain name or port number of Database.
Doc-id : 338003.1

1. Login to DB-Tier as oracle user
2. start the database if not up and running.
3. De-register the current database server.
As the database hostname and/or port will be changed, the current database server node needs to be de-registered
$ perl adgentns.pl appspass=apps contextfile=$ORACLE_HOME/appsutil/Contextfilename.xml -removeserver
4. Take a backup of your context file Edit contextfile i.e SID_hostname.xml file $ORACLE_HOME/appsutil
Replace all old domain entries to newdomain/hostname use vi to edit for e.g changing hostname from abc.com to xyz.com using vi editor
esckey :%s/abc.com/xyz.com/g
Note : Before Running autoconfig Change Hostname or domain name in /etc/hosts and or relevant files.
5. Execute AutoConfig for dbTier
cd $ORACLE_HOME/appsutil/bin
./adconfig.sh contextfile=$ORACLE_HOME/appsutil/SID_hostname.xml

Steps to change hostname or domain name of Application Tier using Auto-config .
Doc-id: 341322.1

1. Login to Apps-Tier  as apps user
2. Stop application services.
3. De-register the current apps server
As the Applications hostname will be changed, the current Applications server node needs to be de-registered.
$ perl $AD_TOP/bin/adgentns.pl appspass=apps contextfile=$ INST_TOP/appl/admin/SID_hostname.xml
–removeserver
4. Take a backup of your context file Edit contextfile i.e SID_hostname.xml
Replace all old domain entries to newdomain/hostname use vi to edit for e.g changing hostname from abc.com to xyz.com using vi editor
esckey :%s/abc.com/xyz.com/g
5. Execute AutoConfig for appTier
cd $AD_TOP/bin
./adconfig.sh contextfile=$INST_TOP/appl/admin/SID_hostname.xml appspass=apps

Finishing Tasks

1. As oracle user, do the following:
$ sqlplus apps/apps
sql> update icx_parameters set session_cookie_domain=' newdomain.com';
sql> conn applsys/apps
sql> select profile_option_value from fnd_profile_option_values where profile_option_value

like '%oldhost%'; if not correct then update it accordinly with the correct one
sql> update fnd_profile_option_values set profile_option_value='newhost' where profile_option_value like '%oldhost%';
sql> exit;

Done. You can startup AppTier now and access E-Business Suite login page at http://newhost.newdomain.com:8000/
 

Monday, December 13, 2010

Find Components version in R12 ?

Apache Version

$cd $IAS_ORACLE_HOME/Apache/Apache/bin
$httpd -version
o/p:
Server version: Oracle-Application-Server-10g/10.1.3.4.0 Oracle-HTTP-Server
Server built:   Jul 16 2008 05:34:34

Forms Version

$ cd $ORACLE_HOME/bin
$ frmcmp_batch |grep Forms| grep Version
O/p:
Forms 10.1 (Form Compiler) Version 10.1.2.3.0

Forms Communication mode

cat $FORMS_WEB_CONFIG_FILE|grep serverURL=echo
If the serverURL parameter has no value then Forms is implemented in socket mode else it is servlet

Report version

$ORACLE_HOME/bin
$rwrun | grep Release
O/p:
Report Builder: Release 10.1.2.3.0

Perl Version

$IAS_ORACLE_HOME/perl/bin/perl -v|grep built

Apps Version

sql> select release_name from apps.fnd_product_groups;

Patch Level Version

sql > select PATCH_LEVEL from fnd_product_installations;

Patch Level Version of AD

sql > select PATCH_LEVEL from fnd_product_installations where PATCH_LEVEL like '%AD%';

o/p:

PATCH_LEVEL
------------------------------
R12.AD.B.1





 

Sunday, December 12, 2010

Autoconfig, Patching , Clone,Install and other logs in R12

Autoconfig, Patching , Clone,Install and other logs in R12

Log files related to cloning in R12:

Preclone (adpreclone.pl) log files in source instance

i) Database Tier-$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/(StageDBTier_<time>.log)
ii) Apps Tier     - $INST_TOP/apps/$CONTEXT_NAME/admin/log/ (StageAppsTier_<time>.log)

 Post-Clone (Adcfgclone.pl) log files in target instance

 i) Database Tier- $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTier_<time>.log
ii) Apps Tier    - $INST_TOP/apps/$CONTEXT_NAME/admin/log/ApplyAppsTier_<time>.log

Patching related log files in R12  :

i) Application Tier-- adpatch log - $APPL_TOP/admin/<SID>/log/
ii) Developer (Developer/Forms & Reports 10.1.2) Patch   - $ORACLE_HOME/.patch_storage
iii) Web Server (Apache) patch - $IAS_ORACLE_HOME/.patch_storage
iv) Database Tier opatch log - $RDBMS_ORACLE_HOME/.patch_storage

Autoconfig related log files in R12  :

i) Database Tier Autoconfig log :

$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/<MMDDHHMM>/adconfig.log
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/<MMDDHHMM>/NetServiceHandler.log

ii) Application Tier Autoconfig log -
$INST_TOP/apps/$CONTEXT_NAME/admin/log/<MMDDHHMM>/adconfig.log

R12 Installation Logs  :

Database Tier Installation logs:
$RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/<MMDDHHMM>.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTechStack_<MMDDHHMM>.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ohclone.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/make_<MMDDHHMM>.log
$RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/installdbf.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/adcrdb_<SID>.log
$RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDatabase_<MMDDHHMM>.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/<MMDDHHMM>/adconfig.log
$RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/<MMDDHHMM>/NetServiceHandler.log

Application Tier Installation logs :
$INST_TOP/logs/<MMDDHHMM>.log
$APPL_TOP/admin/$CONTEXT_NAME/log/ApplyAppsTechStack.log
$INST_TOP/logs/ora/10.1.2/install/make_<MMDDHHMM>.log
$INST_TOP/logs/ora/10.1.3/install/make_<MMDDHHMM>.log
$INST_TOP/admin/log/ApplyAppsTechStack.log
$INST_TOP/admin/log/ohclone.log
$APPL_TOP/admin/$CONTEXT_NAME/log/installAppl.log
$APPL_TOP/admin/$CONTEXT_NAME/log/ApplyAppltop_<MMDDHHMM>.log
$APPL_TOP/admin/$CONTEXT_NAME/log/<MMDDHHMM>/adconfig.log
$APPL_TOP/admin/$CONTEXT_NAME/log/<MMDDHHMM>/NetServiceHandler.log

Inventory Registration logs :
<Global Inventory_location>/logs/cloneActions<timestamp>.log
<Global Inventory_location>/logs/oraInstall<timestamp>.log
<Global Inventory_location>/logs/silentInstall<timestamp>.log

 Other log files in R12:

1) Database Tier
1.1) Relink Log files :
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME /<MMDDHHMM>/ make.log
1.2) Alert Log Files :
$ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log
1.3) Network Logs :
$ORACLE_HOME/network/admin/$SID.log
1.4) OUI Inventory Logs :
$ORACLE_HOME/admin/oui/$CONTEXT_NAME/oraInventory/logs