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