Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Autoconfig error on Database Upgrade from 9.2.0.8 to 11gR2

AthishJul 19 2011 — edited Jul 19 2011
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 24 2023
Added on Jul 19 2011
4 comments
628 views