5 Replies Latest reply: Jun 6, 2012 12:36 AM by Vinay Pedamkar RSS

    Installation of AR Server is failing

    Amit NameToUpdate

      Hi,

       

      i am installing AR Server on windows 2008 server, DB instance is oracle. In all my previous installation i selected oracle SID instead of oracle service name and provided the details. But in this installation whene i am selecting oracle sid and input the sid name then it give error " in valid database instance" while when i select service name in input the same (what i input suring selection of sid) then it goes to next installation screen succefully.

       

      Please suggest what can  be the issue. Also note  that i tried completing the installation using oracle service name but it got failed at last screen and gives following error.

       

      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:
      OD-VA-W-AD-22:1521:ITSMSGAR
      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(Unknown Source)
      java.sql.DriverManager.getConnection(Unknown Source)
      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:2216)
      com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerDBAUserInputValidationTask.performValidation(ARServerDBAUserInputValidationTask.java:270)
      com.bmc.install.task.ValidationTask.execute(ValidationTask.java:53)
      com.bmc.install.task.InstallationTask.run(InstallationTask.java:80)
      java.lang.Thread.run(Unknown Source)]
      =============================================

      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:
      OD-VA-W-AD-22:1521:ITSMSGAR
      oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:119)
      oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:115)

        • 1. Installation of AR Server is failing
          Shantanu Ballal

          Hi Amit,

           

          It seems that the SID name is not getting resolved. Do this lsnrctl <services> and check the output. Also check the tnsnames.ora file for the correct SID name.

           

          HTH

          Shantanu

          • 2. Installation of AR Server is failing
            Amit NameToUpdate

            Hi shantanu

             

            Please note the output of command  lsnrctl <services> is positive (state ready) and our dba said that it is working. Sending you tnsname.ora

             

            ITSMSGARC =
              (DESCRIPTION =
                (ADDRESS = (PROTOCOL = TCP)(HOST = OD-VA##########)(PORT = 1521))
                (CONNECT_DATA =
                  (SERVER = DEDICATED)
                  (SERVICE_NAME = ITSMSGARC)
                )
              )

             

             

            I tried re running the instalaltion and now i got following error can any one suggest

             

            THROWABLE EVENT {Description=[Failed to retrieve oracle system file path]}


            Throwable=[java.sql.SQLException: ORA-01017: invalid username/password; logon denied
            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.T4CTTIoer.processError(T4CTTIoer.java:467)
            oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:409)
            oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:401)
            oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:852)
            oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:427)
            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(Unknown Source)
            java.sql.DriverManager.getConnection(Unknown Source)
            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:2216)
            com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerDBAUserInputValidationTask.performValidation(ARServerDBAUserInputValidationTask.java:270)
            com.bmc.install.task.ValidationTask.execute(ValidationTask.java:53)
            com.bmc.install.task.InstallationTask.run(InstallationTask.java:80)
            java.lang.Thread.run(Unknown Source)]


            =========================================


              THROWABLE EVENT {Description=[Failed to retrieve oracle system file path]}


            Throwable=[java.sql.SQLException: ORA-01017: invalid username/password; logon denied
            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.T4CTTIoer.processError(T4CTTIoer.java:467)
            oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:409)
            oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:401)
            oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:852)
            oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:427)
            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(Unknown Source)
            java.sql.DriverManager.getConnection(Unknown Source)
            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:2216)
            com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerDBAUserInputValidationTask.performValidation(ARServerDBAUserInputValidationTask.java:300)
            com.bmc.install.task.ValidationTask.execute(ValidationTask.java:53)
            com.bmc.install.task.InstallationTask.run(InstallationTask.java:80)
            java.lang.Thread.run(Unknown Source)]

             

            • 3. Installation of AR Server is failing
              Shantanu Ballal

              Amit,

               

              Try giving SID in the tnsnames.ora and change the HOST to ip adress. Run the installer again.

               

              e.g.

               

               

              ITSMSGARC =
                (DESCRIPTION =
                  (ADDRESS = (PROTOCOL = TCP)(HOST = ipaddress)(PORT = 1521))
                  (CONNECT_DATA =
                    (SERVER = DEDICATED)
                    (SERVICE_NAME = ITSMSGARC)

                    (SID = ITSMGARC)
                  )
                )

               

               

              Let me know how it goes.

               

               

              Shantanu

              • 4. Re: Installation of AR Server is failing
                RM Raja

                Hi,

                 

                I would recomand you to re-install the Oracle DB and give a try installtion of Remedy. Please check the below links also.

                 

                https://communities.bmc.com/communities/message/245754#245754

                • 5. Installation of AR Server is failing
                  Vinay Pedamkar

                  Hi,

                   

                  are you able to login to the database using sqlplus?

                  if yes can you share the screenshot of the inputs givent for SID and the database details provided at the time of installation.

                   

                   

                  Regards,

                  Vinay

                  Vyom Labs Pvt. Ltd.

                  Expert BMC BSM Services ||Remedy ARS, ITSM, Blade Logic, CLM, BPPM, Control-M

                  Email: info@vyomlabs.com|| Web Site: www.vyomlabs.com

                  Follow Vyom Labs http://twitter.com/#!/vyomlabs || http://www.linkedin.com/company/vyom-labs