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"
