Is SIM 5.1 Compatible with Oracle RAC?

[Richard Kendall]

Is SIM 5.1 compatible with Oracle RAC?
I executed the "mxoracleconfig" with the host names of both our rac server names. I encounter the following error:

[root@server1 bin]# ./mxoracleconfig
Host: rac01,rac02
Port[1521]:
Database name: SIM51DB
Username: hpsim
Password:
Oracle driver jar file: /archive/classes12.jar
Force[N]:
Copying oracle driver jar file...
Checking connectivity...
Unable to connect to the database.
The database may not be ready or one or more of the values provided for host, port, database, user, or password is incorrect.
See Oracle error text below for more details:
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:
rac01,rac02:1521:SIM51DB

[Daniel Leblanc]

HP SIM supports the use of several databases:

Microsoft SQL Server Desktop Engine (MSDE) or Microsoft SQL Server 2000 is supported on a Windows CMS. HP SIM ships with MSDE, but you can choose to use Microsoft SQL Server 2000, which provides more advanced enterprise features. SQL Server 2005 running on Windows Server 2003 is supported. SQL Server 2005 Express Edition is NOT supported.

Oracle 10g and Oracle 9i Release 2 are supported on all platforms.




NOTE: You must create the Oracle database using Unicode (AL32UTF8) as the character set before installing HP SIM. You must also specify the thin client .jar file location. HP SIM requires Oracle database and Transparent Network Substrate (TNS) listener services to be up and running when system is restarted. Oracle by itself does not start the Oracle database and TNS listener automatically. An Oracle database administrator (DBA) must set these services to be restarted when the server is reset. See the Oracle documentation for details on how to auto start these services at http://download-east.oracle.com/docs/html/A96167_01/post-inst.htm#sthref548. Access to this link requires registration, which is free. The Oracle DBA who manages the Oracle installation must perform this task. You must install the Oracle JDBC driver, version 10.1.0.2.0. You can download this driver from the Oracle website at http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html.

[Richard Kendall]

What syntax should I use in the "Host" portion of the "mxoracleconfig" command? I used the host names rac01 and rac02 separated by a comma. I also tried a space between the two rac server names. Neither work. What do you suggest?

[Daniel Leblanc]

http://docs.hp.com/en/5991-4498/ch04s02.html