Home » RDBMS Server » Server Administration » 10.2.0.4 Upgrade issues (oracle database 10.2.0.3 , Linux)
10.2.0.4 Upgrade issues [message #319296] Fri, 09 May 2008 11:49 Go to next message
Nick_01
Messages: 36
Registered: March 2008
Member
Hi,

I have a problem during upgrade 10.2.0.3 to 10.2.0.4..the lsinventory output is attached below.I think the inventory is corrupted..If so how to proceed.

-bash-2.05b$ opatch lsinventory -all
Invoking OPatch 10.2.0.3.2

Oracle interim Patch Installer version 10.2.0.3.2
Copyright (c) 2007, Oracle Corporation. All rights reserved..


Oracle Home : /opt/oracle/product/10.2.0/db_1
Central Inventory : /opt/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.3.2
OUI version : 10.2.0.3.0
OUI location : /opt/oracle/product/10.2.0/db_1/oui
Log file location : /opt/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2008-05-09_09-45-58AM.log

org.xml.sax.SAXParseException: <Line 9502, Column 21>: XML-20122: (Fatal Error) '=' missing in attribute.
at oracle.xml.parser.v2.XMLError.flushErrorHandler(XMLError.java:415)
at oracle.xml.parser.v2.XMLError.flushErrors1(XMLError.java:284)
at oracle.xml.parser.v2.NonValidatingParser.parseAttrValue(NonValidatingParser.java:1591)
at oracle.xml.parser.v2.NonValidatingParser.parseAttr(NonValidatingParser.java:1496)
at oracle.xml.parser.v2.NonValidatingParser.parseAttributes(NonValidatingParser.java:1429)
at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1277)
at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:326)
at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:293)
at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:209)
at oracle.sysman.oii.oiii.OiiiInstallXMLReader.readComps(OiiiInstallXMLReader.java:271)
at oracle.sysman.oii.oiii.OiiiInstallInventory.getCompOHListElement(OiiiInstallInventory.java:1531)
at oracle.sysman.oii.oiii.OiiiAreaInventory.getAllCompsVect(OiiiAreaInventory.java:1052)
at oracle.opatch.OracleHomeInventory.load(OracleHomeInventory.java:2312)
at oracle.opatch.LsInventorySession.loadAndPrintInventory(LsInventorySession.java:360)
at oracle.opatch.LsInventorySession.process(LsInventorySession.java:314)
at oracle.opatch.OPatchSession.main(OPatchSession.java:1060)
at oracle.opatch.OPatch.main(OPatch.java:529)
org.xml.sax.SAXParseException: <Line 9502, Column 21>: XML-20122: (Fatal Error) '=' missing in attribute.
at oracle.xml.parser.v2.XMLError.flushErrorHandler(XMLError.java:415)
at oracle.xml.parser.v2.XMLError.flushErrors1(XMLError.java:284)
at oracle.xml.parser.v2.NonValidatingParser.parseAttrValue(NonValidatingParser.java:1591)
at oracle.xml.parser.v2.NonValidatingParser.parseAttr(NonValidatingParser.java:1496)
at oracle.xml.parser.v2.NonValidatingParser.parseAttributes(NonValidatingParser.java:1429)
at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1277)
at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:326)
at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:293)
at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:209)
at oracle.sysman.oii.oiii.OiiiInstallXMLReader.readComps(OiiiInstallXMLReader.java:271)
at oracle.sysman.oii.oiii.OiiiInstallInventory.getCompOHListElement(OiiiInstallInventory.java:1531)
at oracle.sysman.oii.oiii.OiiiAreaInventory.getAllCompsVect(OiiiAreaInventory.java:1052)
at oracle.opatch.OracleHomeInventory.load(OracleHomeInventory.java:2312)
at oracle.opatch.LsInventorySession.loadAndPrintInventory(LsInventorySession.java:360)
at oracle.opatch.LsInventorySession.process(LsInventorySession.java:314)
at oracle.opatch.OPatchSession.main(OPatchSession.java:1060)
at oracle.opatch.OPatch.main(OPatch.java:529)
java.io.IOException: <Line 9502, Column 21>: XML-20122: (Fatal Error) '=' missing in attribute.
at oracle.sysman.oii.oiii.OiiiInstallXMLReader.readComps(OiiiInstallXMLReader.java:277)
at oracle.sysman.oii.oiii.OiiiInstallInventory.getCompOHListElement(OiiiInstallInventory.java:1531)
at oracle.sysman.oii.oiii.OiiiAreaInventory.getAllCompsVect(OiiiAreaInventory.java:1052)
at oracle.opatch.OracleHomeInventory.load(OracleHomeInventory.java:2312)
at oracle.opatch.LsInventorySession.loadAndPrintInventory(LsInventorySession.java:360)
at oracle.opatch.LsInventorySession.process(LsInventorySession.java:314)
at oracle.opatch.OPatchSession.main(OPatchSession.java:1060)
at oracle.opatch.OPatch.main(OPatch.java:529)
Inventory load failed... OPatch cannot load inventory for the given Oracle Home.
Possible causes are:
Oracle Home dir. path does not exist in Central Inventory
Oracle Home is a symbolic link
Oracle Home inventory is corrupted
LsInventorySession failed: OracleHomeInventory::load() gets a null Vector of installed products

OPatch failed with error code 73

Thank you, I appreciate if anyone could help me asap.
Re: 10.2.0.4 Upgrade issues [message #319535 is a reply to message #319296] Mon, 12 May 2008 02:12 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Have a look OracleŽ Universal Installer and OPatch User's Guide
Re: 10.2.0.4 Upgrade issues [message #321307 is a reply to message #319535] Mon, 19 May 2008 19:42 Go to previous messageGo to next message
Nick_01
Messages: 36
Registered: March 2008
Member
Hi,

Tried all options like -silent -response and also tried attach home option too. nothing seems to be working to recover or attach home to Central Inventory.Checked the Inventory.xml everything looks fine.

Attachinge the log contents below.

Using paramFile: /opt/oracle/patch/Disk1/install/oraparam.ini


Checking installer requirements...

Checking operating system version: must be redhat-3, SuSE-9, SuSE-10, redhat-4, redhat-5, UnitedLinux-1.0, asianux-1, asianux-2 or a
sianux-3
Passed


All installer requirements met.


The commandline for unzip:
/opt/oracle/patch/Disk1/install/unzip -qqqo ../stage/Components/oracle.swd.jre/1.4.2.14.0/1/DataFiles/\*.jar -d /tmp/OraInstall2008-
05-19_04-43-23PM
The commandline for unzip:
/opt/oracle/patch/Disk1/install/unzip -qqqo ../stage/Components/oracle.swd.oui/10.2.0.4.0/1/DataFiles/\*.jar -d /tmp/OraInstall2008-
05-19_04-43-23PM
The commandline for unzip:
/opt/oracle/patch/Disk1/install/unzip -qqqo ../stage/Components/oracle.swd.oui.core/10.2.0.4.0/1/DataFiles/\*.jar -d /tmp/OraInstall
2008-05-19_04-43-23PM

The number of files bootstrapped for the jre is 613.

The number of files bootstrapped for the oui is 66.
No umask is available from oraparam.ini. Using the default value '007'.

Execvp of the child jre : the cmdline is /tmp/OraInstall2008-05-19_04-43-23PM/jre/1.4.2/bin/java, and the argv is
/tmp/OraInstall2008-05-19_04-43-23PM/jre/1.4.2/bin/java
-Doracle.installer.library_loc=/tmp/OraInstall2008-05-19_04-43-23PM/oui/lib/linux
-Doracle.installer.oui_loc=/tmp/OraInstall2008-05-19_04-43-23PM/oui
-Doracle.installer.bootstrap=TRUE
-Doracle.installer.startup_location=/opt/oracle/patch/Disk1/install
-Doracle.installer.jre_loc=/tmp/OraInstall2008-05-19_04-43-23PM/jre/1.4.2
-Doracle.installer.nlsEnabled="TRUE"
-Doracle.installer.prereqConfigLoc=/tmp/OraInstall2008-05-19_04-43-23PM/prereq
-Doracle.installer.unixVersion=2.4.21-37.ELhugemem
-mx150m
-cp
/tmp/OraInstall2008-05-19_04-43-23PM:/tmp/OraInstall2008-05-19_04-43-23PM/oui/jlib/OraInstaller.jar:/tmp/OraInstall2008-05-19_04-43-
23PM/oui/jlib/oneclick.jar:/tmp/OraInstall2008-05-19_04-43-23PM/oui/jlib/xmlparserv2.jar:/tmp/OraInstall2008-05-19_04-43-23PM/oui/jl
ib/srvm.jar:/tmp/OraInstall2008-05-19_04-43-23PM/oui/jlib/share.jar:/tmp/OraInstall2008-05-19_04-43-23PM/oui/jlib/OraInstallerNet.ja
r:/tmp/OraInstall2008-05-19_04-43-23PM/oui/jlib/xml.jar:/tmp/OraInstall2008-05-19_04-43-23PM/oui/jlib/orai18n-collation.jar:/tmp/Ora
Install2008-05-19_04-43-23PM/oui/jlib/orai18n-mapping.jar:/tmp/OraInstall2008-05-19_04-43-23PM/oui/jlib/emCfg.jar:/tmp/OraInstall200
8-05-19_04-43-23PM/oui/jlib/ojmisc.jar:/tmp/OraInstall2008-05-19_04-43-23PM/oui/jlib/InstImages.jar:/tmp/OraInstall2008-05-19_04-43-
23PM/oui/jlib/InstHelp.jar:/tmp/OraInstall2008-05-19_04-43-23PM/oui/jlib/InstHelp_de.jar:/tmp/OraInstall2008-05-19_04-43-23PM/oui/jl
ib/InstHelp_es.jar:/tmp/OraInstall2008-05-19_04-43-23PM/oui/jlib/InstHelp_fr.jar:/tmp/OraInstall2008-05-19_04-43-23PM/oui/jlib/InstH
elp_it.jar:/tmp/OraInstall2008-05-19_04-43-23PM/oui/jlib/InstHelp_ja.jar:/tmp/OraInstall2008-05-19_04-43-23PM/oui/jlib/InstHelp_ko.j
ar:/tmp/OraInstall2008-05-19_04-43-23PM/oui/jlib/InstHelp_pt_BR.jar:/tmp/OraInstall2008-05-19_04-43-23PM/oui/jlib/InstHelp_zh_CN.jar
:/tmp/OraInstall2008-05-19_04-43-23PM/oui/jlib/InstHelp_zh_TW.jar:/tmp/OraInstall2008-05-19_04-43-23PM/oui/jlib/oracle_ice.jar:/tmp/
OraInstall2008-05-19_04-43-23PM/oui/jlib/help4.jar:/tmp/OraInstall2008-05-19_04-43-23PM/oui/jlib/help4-nls.jar:/tmp/OraInstall2008-0
5-19_04-43-23PM/oui/jlib/ewt3.jar:/tmp/OraInstall2008-05-19_04-43-23PM/oui/jlib/ewt3-swingaccess.jar:/tmp/OraInstall2008-05-19_04-43
-23PM/oui/jlib/ewt3-nls.jar:/tmp/OraInstall2008-05-19_04-43-23PM/oui/jlib/swingaccess.jar:/tmp/OraInstall2008-05-19_04-43-23PM/oui/j
lib/classes12.jar::/tmp/OraInstall2008-05-19_04-43-23PM/oui/jlib/OraPrereq.jar:/tmp/OraInstall2008-05-19_04-43-23PM/oui/jlib/jewt4.j
ar:/tmp/OraInstall2008-05-19_04-43-23PM/oui/jlib/jewt4-nls.jar
oracle.sysman.oii.oiic.OiicInstaller
-scratchPath
/tmp/OraInstall2008-05-19_04-43-23PM
-sourceLoc
/opt/oracle/patch/Disk1/install/../stage/products.xml
-sourceType
network
-timestamp
2008-05-19_04-43-23PM
-silent
-responseFile
/tmp/patchset.rsp
INFO: Environment Variables:

INFO: ORACLE_HOME = /opt/oracle/product/10.2.0/db_1

INFO: PATH = /usr/bin:/usr/ccs/bin:/opt/oracle/product/10.2.0/db_1/bin:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin:/sbin:/etc:/usr/s
bin:.:/opt/oracle/patch/Disk1/install

INFO: CLASSPATH =

INFO: Username:oracle

INFO: Install area Control created with access level 1

INFO: Oracle Universal Installer version is 10.2.0.4.0

INFO: This installation is being performed using response file /tmp/patchset.rsp.
INFO: Setting variable 'UNIX_GROUP_NAME' to 'oinstall'. Received the value from response file.
INFO: Setting variable 'FROM_LOCATION' to '/opt/oracle/patch/Disk1/stage/products.xml'. Received the value from response file.
INFO: Setting variable 'ORACLE_HOME' to '/opt/oracle/product/10.2.0/db_1'. Received the value from response file.
INFO: Setting variable 'ORACLE_HOME_NAME' to 'OraDb10g_home1'. Received the value from response file.
INFO: Setting variable 'SHOW_WELCOME_PAGE' to 'false'. Received the value from response file.
INFO: Setting variable 'SHOW_CUSTOM_TREE_PAGE' to 'false'. Received the value from response file.
INFO: Setting variable 'SHOW_COMPONENT_LOCATIONS_PAGE' to 'false'. Received the value from response file.
INFO: Setting variable 'SHOW_SUMMARY_PAGE' to 'false'. Received the value from response file.
INFO: Setting variable 'SHOW_INSTALL_PROGRESS_PAGE' to 'true'. Received the value from response file.
INFO: Setting variable 'SHOW_REQUIRED_CONFIG_TOOL_PAGE' to 'false'. Received the value from response file.
INFO: Setting variable 'SHOW_CONFIG_TOOL_PAGE' to 'false'. Received the value from response file.
INFO: Setting variable 'SHOW_RELEASE_NOTES' to 'false'. Received the value from response file.
INFO: Setting variable 'SHOW_ROOTSH_CONFIRMATION' to 'true'. Received the value from response file.
INFO: Setting variable 'SHOW_END_SESSION_PAGE' to 'false'. Received the value from response file.
INFO: Setting variable 'SHOW_EXIT_CONFIRMATION' to 'false'. Received the value from response file.
INFO: Setting variable 'NEXT_SESSION' to 'false'. Received the value from response file.
INFO: Setting variable 'NEXT_SESSION_ON_FAIL' to 'false'. Received the value from response file.
INFO: Setting variable 'NEXT_SESSION_RESPONSE' to '/tmp/install.rsp'. Received the value from response file.
INFO: Setting variable 'SHOW_DEINSTALL_CONFIRMATION' to 'false'. Received the value from response file.
INFO: Setting variable 'SHOW_DEINSTALL_PROGRESS' to 'false'. Received the value from response file.
INFO: Setting variable 'RESTART_SYSTEM' to 'false'. Received the value from response file.
INFO: Setting variable 'OUI_HOSTNAME' to 'intrl-diag-db.dgosvc-priv.com'. Received the value from response file.
INFO: Setting variable 'PREREQ_CONFIG_LOCATION' to '/tmp/OraInstall2008-05-19_04-43-23PM/prereq'. Received the value from variable a
ssociation.
INFO: Setting variable 'SHOW_XML_PREREQ_PAGE' to 'false'. Received the value from response file.
INFO: Setting variable 'SHOW_END_OF_INSTALL_MSGS' to 'true'. Received the value from response file.
INFO: Setting variable 'ACCEPT_LICENSE_AGREEMENT' to 'false'. Received the value from response file.
INFO: Setting variable 'TOPLEVEL_COMPONENT' to 'oracle.patchset.db,10.2.0.4.0'. Received the value from response file.
INFO: Setting variable 'SHOW_SPLASH_SCREEN' to 'false'. Received the value from response file.
INFO: Reader/Writer 'oracle.sysman.oii.oiic.OiicGlobalContextXMLReaderWriter' was created.
INFO:
*** Welcome Page***
INFO: Initializing install inventory
INFO: Setting up install inventory
INFO:
*** Specify Source Location Page***
INFO: Setting the 'SourceLocation ( FROM_LOCATION )' property to '/opt/oracle/patch/Disk1/stage/products.xml'. Received the value fr
om response file.
INFO: Initializing OUI Shiphome access setup
INFO: DefaultifyLangiages : Value of oracle.installer.defaultifyLanguages : false
INFO: fetch the file: /opt/oracle/patch/Disk1/stage/shiphomeinfo.properties
INFO: Performing operation for OUI Shiphome access setup
INFO:
*** Select a Product to Install Page***
INFO: Setting the 'TopLevelComp ( ToplevelComp )' property to 'oracle.patchset.db, 10.2.0.4.0, >10.2.0.4.0, [ ][OH:2]'. Received the
value from the default settings.
INFO:
*** Select Installation Type Page***
INFO: Setting the 'InstallType ( DEP_MODE )' property to 'Custom'. Received the value from the default settings.
INFO: Setting the 'TopLevelInstallType ( TLDepModes )' property to 'Custom'. Received the value from the default settings.
INFO: install properties filename: /tmp/OraInstall2008-05-19_04-43-23PM/oracle.patchset.db_Custom.properties
INFO:
*** Specify Home Details Page***
INFO: Setting the 'OracleHome ( ORACLE_HOME )' property to '/opt/oracle/product/10.2.0/db_1'. Received the value from response file.

INFO: Setting the 'OracleHomeName ( ORACLE_HOME_NAME )' property to 'OraDb10g_home1'. Received the value from response file.
INFO: Initializing OUI Oracle Home access setup
INFO: Setting variable 'ORACLE_HOME' to '/opt/oracle/product/10.2.0/db_1'. Received the value from response file.
INFO: Loading shiphomepropertiesfrom /tmp/OraInstall2008-05-19_04-43-23PM/shiphomeproperties.xml
INFO: DefaultifyLangiages : Value of oracle.installer.defaultifyLanguages : false
INFO: Setting the PROD_HOME variable of 'oracle.rdbms.rat_10.2.0.4.0' to '/opt/oracle/product/10.2.0/db_1/oracle_prod'. Received the
value from the variable calculation.
INFO: Setting the PROD_HOME variable of 'oracle.sysman.ccr_10.2.7.1.0' to '/opt/oracle/product/10.2.0/db_1/ccr'. Received the value
from the variable calculation.
INFO: Setting the PROD_HOME variable of 'oracle.jdk_1.4.2.14.0' to '/opt/oracle/product/10.2.0/db_1/jdk'. Received the value from th
e variable calculation.
INFO: Setting the PROD_HOME variable of 'oracle.odbc.ic_10.2.0.4.0' to '/opt/oracle/product/10.2.0/db_in'. Received the value from t
he variable calculation.
INFO: Setting the PROD_HOME variable of 'oracle.swd.oui_10.2.0.4.0' to '/opt/oracle/product/10.2.0/db_1/oui'. Received the value fro
m the variable calculation.
INFO: Setting the PROD_HOME variable of 'oracle.swd.oui.core_10.2.0.4.0' to '/opt/oracle/product/10.2.0/db_1/oui'. Received the valu
e from the variable calculation.
INFO: Setting the PROD_HOME variable of 'oracle.swd.opatch_10.2.0.4.0' to '/opt/oracle/product/10.2.0/db_1/OPatch'. Received the val
ue from the variable calculation.
INFO: Setting the PROD_HOME variable of 'oracle.swd.jre_1.4.2.14.0' to '/opt/oracle/product/10.2.0/db_1/jre/1.4.2'. Received the val
ue from the variable calculation.
INFO: Performing operation for OUI Oracle Home access setup
INFO: Unable to read inventory information for the home: /opt/oracle/product/10.2.0/db_1.
SEVERE: Abnormal program termination. An internal error has occured. Please provide the following files to Oracle Support :

"/opt/oracle/oraInventory/logs/installActions2008-05-19_04-43-23PM.log"
"/opt/oracle/oraInventory/logs/oraInstall2008-05-19_04-43-23PM.err"
"/opt/oracle/oraInventory/logs/oraInstall2008-05-19_04-43-23PM.out"
INFO: User Selected: Yes/OK

I appreciate your suggestions..
Re: 10.2.0.4 Upgrade issues [message #321320 is a reply to message #319296] Mon, 19 May 2008 20:41 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I appreciate your suggestions..

Please provide the following files to Oracle Support :

"/opt/oracle/oraInventory/logs/installActions2008-05-19_04-43-23PM.log"
"/opt/oracle/oraInventory/logs/oraInstall2008-05-19_04-43-23PM.err"
"/opt/oracle/oraInventory/logs/oraInstall2008-05-19_04-43-23PM.out"
INFO: User Selected: Yes/OK

Re: 10.2.0.4 Upgrade issues [message #322218 is a reply to message #321320] Thu, 22 May 2008 15:50 Go to previous message
Nick_01
Messages: 36
Registered: March 2008
Member
I am attaching the install*.log file the client donot have OSS. To manage the database upgraded to 10.2.0.4, I have followed an alternate method of installing the oracle binaries in new oracle home (10.2.0.1) and upgrade the binaries and bring the database in 10.2.0.4.

I had the following warnings/errors pasted below and was solved.I had "Oracle supports installations on systems with DHCP-assigned public IP addresses" error that doesnot occur after increasing the swap I didnot see any error. and now Iam struck with OUI-10152:A runtime exception occured during the execution of this query.


Checking kernel parameters
Checking for ip_local_port_range=1024 - 65000; found ip_local_port_range=32768 - 61000. Failed <<<<
Check complete. The overall result of this check is: Failed <<<<
Problem: The kernel parameters do not meet the minimum requirements (see above).
Recommendation: Perform operating system specific instructions to update the kernel parameters.
=======================================================================

Checking available swap space requirements ...
Expected result: 12018MB
Actual Result: 3082MB
Check complete. The overall result of this check is: Failed <<<<
Problem: The system does not have the required swap space.
Recommendation: Make more swap space available to perform the install.
=======================================================================

please explain and share the knowledge..
Previous Topic: Database Connection
Next Topic: DB doesn't go down.
Goto Forum:
  


Current Time: Fri Sep 06 14:00:08 CDT 2024