Re: Oracle- DB SPI- Error (436 Views)
Reply
Trusted Contributor
Posts: 160
Registered: ‎10-19-2010
Message 1 of 5 (652 Views)

Oracle- DB SPI- Error

Hi All,

 

I am trying to add DB SPI monitoring fr HP UX- Oracle node. Discover poiicy is succesful and I am able to see the DB's.

When I check with the DB connection manager I get the below status

Oracle Server Manager Release 3.1.7.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.4.0 - 64bit Production
SVRMGR> Connected.
SVRMGR> select instance_name, status from v$instance
ORA-01034: ORACLE not available
SVRMGR> ORA-01034: ORACLE not available
SVRMGR> Server Manager complete.

Please advise.

Trusted Contributor
Posts: 160
Registered: ‎10-19-2010
Message 2 of 5 (645 Views)

Re: Oracle- DB SPI- Error

* Verifying Oracle ... /var/opt/OV/bin/instrumentation/dbspicao[622]: /var/opt/OV/bin/instrumentation/dbspicao80: not found Checking instance: 'XXX' @ '/opt/oracle/products/9.2.0.5': 2013-01-31T01:32:52 ERROR dbspicao(10) XX [cola:ora_util.pc:246]: DBSPI10-23: Unable to connect to database 'XXX' [ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist HP-UX Error: 2: No such file or directory].

 

See Instruction text or User's Guide for details. Connect: FAILED /var/opt/OV/bin/instrumentation/dbspicao[622]: /var/opt/OV/bin/instrumentation/dbspicao80: not found --> Oracle connection check failed. logout root

Occasional Visitor
Posts: 1
Registered: ‎11-04-2013
Message 3 of 5 (485 Views)

Re: Oracle- DB SPI- Error

Hi All,

 

im  facing also a problem with DBSPI.

 

I deployed "dbspi" on a server, and I increased the alert threshold to 20% on tablespaces that are full to test the configuration (if I'll get alerts)

but I get nothing.

and on the file / var / opt / OV / dbspi / log / dbspierror, I find the following errors:

************************************************** *********

 

2013-11-03T01:33:05 ERROR dbspicao(10) XXX [cola:ora_util.pc:242]: DBSPI10-23: Unable to connect to database 'XXX' [ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
IBM AIX RISC System/6000 Error: 2: No such file or]. See Instruction text or User's Guide for details.
2013-11-03T01:38:01 ERROR dbspicao(10) XXX [cola:ora_util.pc:242]: DBSPI10-23: Unable to connect to database 'XXX' [ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
IBM AIX RISC System/6000 Error: 2: No such file or]. See Instruction text or User's Guide for details.

 

*************************************************************

 

could you please help me/

 

Thank you

 

Best regards,

nana

Honored Contributor
Posts: 656
Registered: ‎04-21-2011
Message 4 of 5 (477 Views)

Re: Oracle- DB SPI- Error

It looks like the connection failure  ..

 

Refer the below KB which you helps on the same :

 

http://support.openview.hp.com/selfsolve/document/KM547192

- Vidyasagar Machani -

Tell me and I forget. Teach me and I remember. Involve me and I learn. -- Benjamin Franklin
Trusted Contributor
Posts: 71
Registered: ‎05-21-2012
Message 5 of 5 (436 Views)

Re: Oracle- DB SPI- Error

Hello Amarnath,

 

It looks like you are still trying to monitor Oracle 8i. Please be aware that this version is not supported any more by the SPI and by Oracle for quite some time already:

 

http://www.orafaq.com/wiki/Oracle_8i

 

History and Support Status

Desupport End Dates:

 

• Error Correction Support (ECS): 31-DEC-2003

• Extended Support (ES): 31-DEC-2006

 

Latest patch-sets: 8.1.5.1, 8.1.6.3 and 8.1.7.4

 

Hth,

Uli

HP Support

If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.