0 Replies Latest reply on Nov 22, 2007 10:42 AM by Giuliano Galifi

    Oracle instance using shared server

      BladeLogic default server method during a JDBC Connection is "DEDICATED", this kind of connection don't work with Oracle instance with default sessions set

       

      to "SHARED".

       

      Bladelogic's error is:

       

      "com.bladelogic.app.db.DBException:Message:io exception:End of TNS data channel SqlState:null ErrorCode 17002"

       

      To work out from this, I have done:

       

      1> set "SERVER = DEDICATED" in tnsnames.ora oracle file

      2> set database ConnectionString with the content of tnsnames.ora.

       

      Example:

       

      if your tnsnames.ora is this:

       

      PIPPO =

      (DESCRIPTION =

      (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1525))

      )

      (CONNECT_DATA =

      (SID = PIPPO)

      (SERVER = DEDICATED)

      )

      )

       

      well you have to change from blasadmin the database connectionstring.

       

      from: "ConnectionString: jdbc:oracle:thin:@xxx.xxx.xxx.xxx:1525:PIPPO"

       

      to: "ConnectionString: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1525)))(CONNECT_DATA=(SID=PIPPO)

       

      (SERVER=DEDICATED)))

       

      If you receive the error "com.bladelogic.app.db.DBException:Message :No more data to read from socket SQLState: null ErrorCode: 17410"

       

      check if the oracle "cursor_sharing" is set to "EXACT" in oracle configuration; if not use this command:

       

      alter system set cursor_sharing=exact

       

       

      By

       

      Giuliano Galifi & Fulvio Dalfelli