Autoconfig error on Database Upgrade from 9.2.0.8 to 11gR2
AthishJul 19 2011 — edited Jul 19 2011Hi Friends,
My environment:
OS version : Oracle Enterprise Linux 4U5
Application Version : *11.5.10.2*
Db Upgrade from : *9.2.0.8 to 11.2.0.1*
Document which Followed For Upgrade:
Interoperability Notes Oracle EBS 11i with Oracle Database 11gR2 (11.2.0.1) [ID 1265268.1]
Complete Checklist for Manual Upgrades to 11gR2 [ID 837570.1]
I did database upgrade form 9.2.0.8 to 11.2.0.1, While enabling autoconfig on the 11gR2 database am getting the following error in the autoconfig log file,
[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:
<filename> <phase> <return code where appropriate>
[APPLY PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /ebiz/oracle/visiondb/11.2.0/appsutil/install/VISION_vision
adcrobj.sh INSTE8_APPLY 1
txkcreateACL.sh INSTE8_APPLY 1
AutoConfig is exiting with status 2
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Executing script in InstantiateFile:
/ebiz/oracle/visiondb/11.2.0/appsutil/install/VISION_vision/adcrobj.sh
script returned:
****************************************************
Executing adcrobj.sh
adcrobj.sh started at Mon Jul 18 13:56:07 IST 2011
Parameters passed are : -nopromptmsg
The environment settings are as follows ...
ORACLE_HOME : /ebiz/oracle/visiondb/11.2.0
ORACLE_SID : VISION
TWO_TASK :
PATH : /usr/bin:/ebiz/oracle/bin:/ebiz/oracle/visiondb/11.2.0/jdk/bin:/ebiz/oracle/visiondb/11.2.0/bin:/usr/bin:/usr/sbin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/kerberos/bin:/usr/X11R6/bin:/ebiz/oracle/visiondb/11.2.0/perl/bin:/ebiz/oracle/bin:/ebiz/oracle/visiondb/11.2.0/OPatch:/ebiz/oracle/visiondb/11.2.0/jdk/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:.
LD_LIBRARY_PATH : /ebiz/oracle/visiondb/11.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/ebiz/oracle/visiondb/11.2.0/ctx/lib
SQLPLUS Executable : /ebiz/oracle/visiondb/11.2.0/bin/sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 18 13:56:09 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
begin
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
ERROR:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0
Disconnected
adcrobj.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END
You are running txkcreateACL.sh version 115.1
The environment settings are as follows ...
ORACLE_HOME : /ebiz/oracle/visiondb/11.2.0
ORACLE_SID : VISION
PATH : /usr/bin:/ebiz/oracle/bin:/ebiz/oracle/visiondb/11.2.0/jdk/bin:/ebiz/oracle/visiondb/11.2.0/bin:/usr/bin:/usr/sbin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/kerberos/bin:/usr/X11R6/bin:/ebiz/oracle/visiondb/11.2.0/perl/bin:/ebiz/oracle/bin:/ebiz/oracle/visiondb/11.2.0/OPatch:/ebiz/oracle/visiondb/11.2.0/jdk/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:.
Executable : /ebiz/oracle/visiondb/11.2.0/bin/sqlplus
Executing txkcreateACL.sql
SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 18 13:56:10 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
DECLARE
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
ERROR:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0
Disconnected
txkcreateACL.sh: exiting with status 1
Kindly suggests me to move forward :)
Thanks
Athish
Edited by: 808617 on Jul 19, 2011 5:43 AM
Edited by: 808617 on Jul 19, 2011 5:44 AM