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:arslist@ARSLIST.ORG] On Behalf Of D Dussie > Sent: Tuesday, February 07, 2012 1:49 PM > To: arslist@ARSLIST.ORG > 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"