Oracle connection error during first time installation of HP SIM

[Geert Van Pamel]

I am trying to install HP SIM 5.3 on a Windows Server 2003 with Oracle 9i.

I have already replaced the ojdbc14.jar file as explained in:

http://forums13.itrc.hp.com/service/forums/categoryhome.do?categoryId=455

The Oracle database is up and running. I have created a dedicated user account for HP SIM on Oracle. I can login to that account with sqlplus.

But I get the following error when trying to connect to the Oracle database from the HP SIM installation procedure:

Unknown database error 192

[JKytsi]

What db rights/permission do that SIM user have to oracle ?

[Geert Van Pamel]

I get the error "Unknown database error 192" just after selecting the database.

SEE ATTACHMENT.

select * from v$version

Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production

Before starting the installation, I performed the following:

grant connect, resource to hpsim

select * from user_role_privs

CONNECT
RESOURCE

select * from user_sys_privs

UNLIMITED TABLESPACE

I can create a table and insert records:

create table test (c1 date)

insert into test values (sysdate)

[JKytsi · Accepted solution]

Could you give a DBA role to sim user and try.

[Geert Van Pamel]

When the Oracle HP SIM user has DBA rights I get "Unknown database error 16448"

I have verified the Oracle ALERT file, I do not see a problem there.

[Aravindh Rajaram]

You'll have to have "Connect" and "DBA" role for the hp sim user with "Admin Option" and "Default" enabled.

[Geert Van Pamel]

The grant DBA "with admin option" was not necessary. A simple grant DBA to the HPSIM Oracle account was sufficient.

In the previous replies I attempted to use Oracle on a Windows Server.

When I connected to an Oracle 10g database on Tru64 UNIX, I got the following error:

Unsupported character set.
HP Systems Insight Manager requires unicode (AL32UTF8)

In the end, it was just a Characterset problem, both on Windows, and Tru64. HP SIM only supports Oracle Unicode AL32UTF8.

To solve the problem quickly, I just installed the Oracle 10g Express International edition on the local CMS (Central Management Server), because I did not want to invest the time and effort to install another "big" Oracle instance.

The kit is available from:

http://www.oracle.com/otn

http://www.oracle.com/technology/software/products/database/xe/htdocs/102xewinsoft.html

In attach you see how I connect. Note that I have chosen another port for the Oracle listener since the default port 1521 was already in use by another Oracle instance.

Thanks to all!