Issue# 20:
Running autoconfig on DB failed:
[ordpro@r12upgdb ~]$ cd $ORACLE_HOME/appsutil/bin
[ordpro@r12upgdb bin]$ ./adconfig.sh contextfile=/oracle/dpro/db/tech_st/11.2.0.4/appsutil/DPRO_r12upgdb.xml appspass=apps
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /oracle/dpro/db/tech_st/11.2.0.4
ERROR: OA_JRE_TOP isn't available at either of the following locations
JDK - /oracle/dpro/db/tech_st/11.2.0.4/jre/1.4.2
JRE - /oracle/dpro/db/tech_st/11.2.0.4/jre/1.4.2
Pass option 'java' on command line
ERROR: OA_JRE_TOP isn't available at either of the following locations
JDK - /oracle/dpro/db/tech_st/11.2.0.4/jre/1.4.2
JRE - /oracle/dpro/db/tech_st/11.2.0.4/jre/1.4.2
Pass option 'java' on command line
ERROR in setting Environment variable ADJREOPTS [ordpro@r12upgdb bin]$
[ordpro@r12upgdb bin]$
Solution:
- Update DB context file with the correct JRE location:
[ordpro@r12upgdb bin]$ grep "1.4.2" /oracle/dpro/db/tech_st/11.2.0.4/appsutil/DPRO_r12upgdb.xml
<dbrollbacksegs oa_var="s_db_rollback_segs">(_SYSSMU43_3529004921$,_SYSSMU42_589451780$,_SYSSMU41_722330751$,_SYSSMU40_2241649266$,_SYSSMU39_2469208343$,_SYSSMU38_1304639107$,_SYSSMU37_1155828530$,_SYSSMU36_3257347055$,_SYSSMU35_286740745$,_SYSSMU34_4196539157$)</dbrollbacksegs>
<JDK_TOP oa_var="s_jdktop">/oracle/dpro/db/tech_st/11.2.0.4/jre/1.4.2</JDK_TOP>
<JRE_TOP oa_var="s_jretop">/oracle/dpro/db/tech_st/11.2.0.4/jre/1.4.2</JRE_TOP>
<ADJVAPRG oa_var="s_adjvaprg" osd="UNIX">/oracle/dpro/db/tech_st/11.2.0.4/jre/1.4.2/bin/java</ADJVAPRG>
<JAVA_HOME oa_var="s_db_java">/oracle/dpro/db/tech_st/11.2.0.4/jre/1.4.2</JAVA_HOME>
[ordpro@r12upgdb bin]$
[ordpro@r12upgdb bin]$
[ordpro@r12upgdb bin]$ cp /oracle/dpro/db/tech_st/11.2.0.4/appsutil/DPRO_r12upgdb.xml /oracle/dpro/db/tech_st/11.2.0.4/appsutil/DPRO_r12upgdb.xml_org
[ordpro@r12upgdb bin]$ vi /oracle/dpro/db/tech_st/11.2.0.4/appsutil/DPRO_r12upgdb.xml
[ordpro@r12upgdb bin]$ diff /oracle/dpro/db/tech_st/11.2.0.4/appsutil/DPRO_r12upgdb.xml /oracle/dpro/db/tech_st/11.2.0.4/appsutil/DPRO_r12upgdb.xml_org
113,114c113,114
< <JDK_TOP oa_var="s_jdktop">/oracle/dpro/db/tech_st/11.2.0.4/jre</JDK_TOP>
< <JRE_TOP oa_var="s_jretop">/oracle/dpro/db/tech_st/11.2.0.4/jre</JRE_TOP>
---
> <JDK_TOP oa_var="s_jdktop">/oracle/dpro/db/tech_st/11.2.0.4/jre/1.4.2</JDK_TOP>
> <JRE_TOP oa_var="s_jretop">/oracle/dpro/db/tech_st/11.2.0.4/jre/1.4.2</JRE_TOP>
116c116
< <ADJVAPRG oa_var="s_adjvaprg" osd="UNIX">/oracle/dpro/db/tech_st/11.2.0.4/jre/bin/java</ADJVAPRG>
---
> <ADJVAPRG oa_var="s_adjvaprg" osd="UNIX">/oracle/dpro/db/tech_st/11.2.0.4/jre/1.4.2/bin/java</ADJVAPRG>
128c128
< <JAVA_HOME oa_var="s_db_java">/oracle/dpro/db/tech_st/11.2.0.4/jre</JAVA_HOME>
---
> <JAVA_HOME oa_var="s_db_java">/oracle/dpro/db/tech_st/11.2.0.4/jre/1.4.2</JAVA_HOME>
[ordpro@r12upgdb bin]$
- Link old MT to the new DB server. Originally, on the old Env. both MT and DB were sharing the same server:
[apdpro@dbmig ~]$ cp $CONTEXT_FILE $CONTEXT_FILE.org
[apdpro@dbmig ~]$ vi $CONTEXT_FILE
[apdpro@dbmig ~]$ diff $CONTEXT_FILE $CONTEXT_FILE.org
27c27
< <TIER_DB oa_var="s_isDB">NO</TIER_DB>
---
> <TIER_DB oa_var="s_isDB">YES</TIER_DB>
65c65
< <dbhost oa_var="s_dbhost">r12upgdb</dbhost>
---
> <dbhost oa_var="s_dbhost">dbmig</dbhost>
305c305
< <jdbc_url oa_var="s_apps_jdbc_connect_descriptor"/>
---
> <jdbc_url oa_var="s_apps_jdbc_connect_descriptor">jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=dbmig.alarkan.com)(PORT=1531)))(CONNECT_DATA=(SID=dpro)))</jdbc_url>
[apdpro@dbmig ~]$
No comments:
Post a Comment