I had to type in the connection identifier in the install screen. Your log
shows "Failed to validate AR DB user exists" meaning the installer was unable
to connect to the database.
Last I had heard there was a bug in the installer somewhere that mixed up
connection identifier and service name/SID. That's why I have an additional
entry in the tnsnames.ora file so the bug has no effect.
Technically the tnsnames.ora entry is:
ConnectionIdentifier =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = serverhostname.company.com)(PORT =
1521))
)
(CONNECT_DATA =
(SERVICE_NAME = servicename) <<-- OR (SID = sid) depending on how your
database is set up
)
)
That's why I put an additional entry in the file where the ConnectionIdentifier
value = the ServiceName/SID value I am working with.
Fred
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of D Dussie
Sent: Tuesday, February 07, 2012 1:49 PM
To: [email protected]
Subject: Re: Installation questions
Thanks Fred,
tnsnames.ora, db uses ldap to authenticate
In the install screen doesnot put "servicename" in the Connection
Identifier,but does in ServiceName/SID. Doesnot populate the port which is
different from 1521, and hostname.
Another, interesting case - (is this the conflict, can the application not
connect to servicename, excluding the SID; because tnsping SID will resolve
Currentprod?)
Current Remedy_p, has servicename_p = sid_p on port 1521
New Remedy_d, has servicename_d != sid_d not on port 1521, but sid_d=sid_p
tnsnames.ora file:
EXTPROC_CONNECTION_DATA.company.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
SID.company.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = serverhostname.company.com)(PORT =
1521))
)
(CONNECT_DATA =
(SERVICE_NAME = servicename)
)
)
____ Looking at the install log, note only installing Arsystem not the ARDC,
etc components..(working with each errors, as experienced is prior upgrade)
Feb 06 2012 06:02:31.958 PM
-0500),SEVERE,com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerDBAUserInputValidationTask,
THROWABLE EVENT {Description=[Failed to validate AR DB user exists]},
Throwable=[java.sql.SQLException: ORA-00942: table or view does not exist
oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:133)
oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:115)
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:221)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:467)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:417)
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1084)
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:1032)
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:1139)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1471)
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3874)
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3944)
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:3613)
com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerDBAUserInputValidationTask.validateARDBOracleUserExists(ARServerDBAUserInputValidationTask.java:2337)
com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerDBAUserInputValidationTask.performValidation(ARServerDBAUserInputValidationTask.java:171)
com.bmc.install.task.ValidationTask.execute(ValidationTask.java:53)
com.bmc.install.task.InstallationTask.run(InstallationTask.java:79)
java.lang.Thread.run(Thread.java:799)]
----------------------------------------
Feb 06 2012 06:02:37.995 PM
-0500),SEVERE,com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerDBAUserInputValidationTask,
THROWABLE EVENT {Description=[Failed to retrieve oracle system file path]},
Throwable=[java.sql.SQLException: Listener refused the connection with the
following error:
ORA-12505, TNS:listener does not currently know of SID given in connect
descriptor
The Connection descriptor used by the client was:
serveralias:port:servicename
oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:119)
oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:115)
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:221)
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:648)
oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:454)
oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:493)
oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:198)
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:29)
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:502)
java.sql.DriverManager.getConnection(DriverManager.java:562)
java.sql.DriverManager.getConnection(DriverManager.java:186)
com.bmc.install.utility.jdbc.impl.OracleDatabaseHelperImpl.getConnection(OracleDatabaseHelperImpl.java:74)
com.bmc.install.utility.jdbc.DatabaseHelper.getConnection(DatabaseHelper.java:233)
com.bmc.install.utility.jdbc.DatabaseHelper.getConnection(DatabaseHelper.java:196)
com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerDBAUserInputValidationTask.getOracleSystemFilePath(ARServerDBAUserInputValidationTask.java:2160)
com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerDBAUserInputValidationTask.performValidation(ARServerDBAUserInputValidationTask.java:243)
com.bmc.install.task.ValidationTask.execute(ValidationTask.java:53)
com.bmc.install.task.InstallationTask.run(InstallationTask.java:79)
java.lang.Thread.run(Thread.java:799)]
-----------------------------------------
(Feb 06 2012 06:04:40.165 PM
-0500),SEVERE,com.bmc.install.builder.installanywhere.InstallationPanel,
THROWABLE EVENT {Description=[ERROR_CREATING_INSTALLATION_PANEL_DELEGATE]},
Throwable=[java.lang.NumberFormatException: For input string: ""
java.lang.NumberFormatException.forInputString(NumberFormatException.java:63)
java.lang.Integer.parseInt(Integer.java:502)
java.lang.Integer.parseInt(Integer.java:531)
com.bmc.install.product.arsuitekit.platforms.arsystemservers.midtier.ui.MidTierUpgradeTomcatInstallPanelDelegate.conditionsMet(MidTierUpgradeTomcatInstallPanelDelegate.java:136)
com.bmc.install.builder.installanywhere.InstallationPanel.conditionsMet(InstallationPanel.java:1065)
com.bmc.install.builder.installanywhere.InstallationPanel.setupUI(InstallationPanel.java:110)
com.zerog.ia.installer.AAMgr.a(DashoA10*..)
com.zerog.ia.installer.AAMgr.a(DashoA10*..)
com.zerog.ia.installer.AAMgrBase.e(DashoA10*..)
com.zerog.ia.installer.AAMgrBase.n(DashoA10*..)
com.zerog.ia.installer.AAMgr.actionPerformed(DashoA10*..)
java.awt.Button.processActionEvent(Button.java:419)
java.awt.Button.processEvent(Button.java:387)
java.awt.Component.dispatchEventImpl(Component.java:3996)
java.awt.Component.dispatchEvent(Component.java:3844)
java.awt.EventQueue.dispatchEvent(EventQueue.java:545)
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:268)
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:197)
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:191)
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:183)
java.awt.EventDispatchThread.run(EventDispatchThread.java:144)]
_________________________
(Feb 06 2012 06:28:02.074 PM
-0500),CONFIG,com.bmc.install.task.InstallationPropertiesHelper,
LOG EVENT {Description=[SET PROPERTY
VALIDATION_ERROR_RESULT],Detail=[INVALID_OCI_LIB_PERMISSION[String:ORACLE]]}
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
