DB SPI in Oracle RAC environment

[Fernando Vicentin]

Dear All,

I am facing a problem when I have installed DB SPI V 10.40 for ORACLE Database 10g Release 10.2.0.3.0 with Real Application Cluster (RAC) option.
In this environment, I have 02 linux red rad v 4.0 enterprise servers.

I have already installed the DB SPI in those server but the SPI agent is unable to connect to database instance.

In each server I have one database instance called "PWEB1" and another database instance in other server "PWEB2". I have also an virtual databse instance called "PWEB".

I have configured the SPI to connect to the "physical" oracle database isntance, such as, "PWEB1".

The "dbspicfg" file has been configured as follows :
------------------------------------------

SYNTAX_VERSION 4

ORACLE

HOME "/u/oracle/product/10.2.0/db_1"

DATABASE "PWEB1" CONNECT "hpopenview/vwhp"

--------------------------------------------

When I try to connect to the database Oracle instance :

dbspiadm conncheck -nw

I got the following error message :

* Verifying Oracle ...
Chacking instance: ´PWEB1´ @ ´/u/oracle/product/10.2.0/db_1´ :

04/07/08 10:56:41 ERRO dbspicao(10) PWEB1 [cola:ora_util.pc:234]: DBSPI10-23: Unable to connect to database ´PWEB1´ [ORA-12546: TNS:permission denied]
Connect: FAILED
--> Oracle connection check failed.

I have tried to run the connection to this database using SQLPLUS and it was OK.

I am suspect that it could be missing information in the DBSPICFG file.

have anybody an idea ???

Thanks

Regards,

Fernando Vicentin
Tivit - Brazil

[Steven E. Protter]

Shalom,

Suggestion:

Test the connection with tnsping.

Change tnsnames.ora until tnsping works and retry.

This is a basic oracle configuration debugging technique.

SEP

[Duncan Edmonstone]

Fernando,

Well I don't know anything about DBSPI, but as a starter I would ensure what you have entered will actually allow you to connect to the database. As whatever user you ran the above commands try running:

sqlplus hpopenview/vwhp@PWEB1

If that doesn't work and allow you to connect to the database you have Oracle connection/permission problems to resolve first.

HTH

Duncan

[patrik rybar_1]

dbspicfg -e >test.cfg
this show you config file and you can edit this in vi or joe ....

while it is on rac , check if you have set connect string in the cfg to the correct cluster ip or hostname

edit and import new config

dbspicfg -i

[Fernando Vicentin]

Dear All,

I have changed the config file as follows :

SYNTAX_VERSION 4
ORACLE
HOME "/u/oracle/product/10.2.0/db_1"
DATABASE "pweb1" CONNECT "user/password@pweb1"

Now it is working.

Thsnk you all your help and suggestions as well.

Regards,

Fernando