Thanks Fred/Thad/Joe.
I finally called BMC; with there assistance (gotten better),
1. recreated the tablespace
2. added the permissions to aradmin
3. Ran the installer with Oracle connection and service name = servicename.
4. Demo started, plugin didnot - change port due to fw, started.
5. Below tnsnames:
# TNSNAMES.ORA Network Configuration File:
/opt/oracle/sid/product/10.2.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
EXTPROC_CONNECTION_DATA.company.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ServiceName.company.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = XXXX))
)
(CONNECT_DATA =
(SERVICE_NAME = Service_name)
(INSTANCE_NAME = SID)
)
)
Grooms, Frederick W wrote:
>
> 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"
>
>
--
View this message in context:
http://old.nabble.com/Installation-questions-tp33275980p33289378.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
