Re: OVOW DBSPI9-26 (432 Views)
Reply
Advisor
vasja_jancic
Posts: 19
Registered: ‎04-18-2007
Message 1 of 8 (667 Views)

OVOW DBSPI9-26

I have an Oracle cluster with the db instance named codb.
On the active node, I keep receiving the OVOW message:

DBSPI9-26: Logfile not found for instance 'codb'

When I check on the active node, I find this file there:
/app/oracle/ora102/admin/codb/bdump/alert_codb1.log

I wonder if the number '1' in the instance name is causing the problem? Where did it come from?
How can I tell the DBSPI to look for this file insted of alert_codb.log?

Vasja Jancic.
Advisor
Guru Ragavendra
Posts: 15
Registered: ‎09-26-2006
Message 2 of 8 (667 Views)

Re: OVOW DBSPI9-26

1.export current config using dbspicfg -e
do u find a line with LOGFILE entry there?

2. if not include a line to resemble as below

while u import the dbspicfg settings, include the line

ORACLE
DATABASE CONNECT "hp_dbspi/password@local_sid"
LOGFILE "exact path"

3. re import using dbspicfg -i <

4.chcek using dbspicao -l
this will return the logfile being monitored

Regular Advisor
Robs_3
Posts: 242
Registered: ‎10-10-2005
Message 3 of 8 (667 Views)

Re: OVOW DBSPI9-26

HI,
I am facing same problem with two nodes. I checked file and found that all things are correct. But still it is giving same error.
Please advise how can we fix it.

Thanks
Honored Contributor
Igor Moskovko_1
Posts: 371
Registered: ‎11-30-2007
Message 4 of 8 (667 Views)

Re: OVOW DBSPI9-26

Hello

there is change request in progress (State: Awaiting Decision )

QXCR1000744048 Oracle SPI should be able to handle rolling Oracle alert log file

Customer Symptoms Notes
(Created on 12/03/2007 18:51:43)
Customer visible
OVOW 7.50 with DBSPI 10.30

The Oracle SPI logfile monitoring fails with the following error:

DBSPI9-26: Logfile not found for instance ''

When checking the logfile on the node itself, it is called:

/app/oracle/ora102/admin/codb/bdump/alert_1.log

i.s.o.

/app/oracle/ora102/admin/codb/bdump/alert_.log

The DBSPI should be able to deal with Oracle RAC instances using logfiles alert_1.log,
alert_2.log, ....

reards,
igor
:-) IBM Tivoli Software Sales Representative
Regular Advisor
ANGIL
Posts: 197
Registered: ‎10-04-2007
Message 5 of 8 (667 Views)

Re: OVOW DBSPI9-26

If this fixed with DBSPI 10.40?

MGMTSV OVOU HP/UX = OVOU 8.29
Managed Nodes AIX = 5L 5.3
AIX OV agent = 8.17 HTTPS
DBSPI = 10.40
Valued Contributor
bharad
Posts: 208
Registered: ‎02-28-2008
Message 6 of 8 (667 Views)

Re: OVOW DBSPI9-26

We are using OMU 8.2 on HP-UX 11.2x

There is a Oracle RAC (on AIX) that we are monitoring but i keep getting the message

"DBSPI9-26: Logfile not found for instance 'xxxx'. from the source

"Message:DBSPI-Messages:DBSPI9-26: Logfile not found for instance '%s'"

When i check dbspicao -l i get the logfile path that is configured using dbspicfg.sh

I also verified the output of "dbspicfg -e"
and all the details provided there are correct. I even tried logging in to SQL Plus with the credentials configured and it works.

dbspicfg -e
SYNTAX_VERSION 4

ORACLE

HOME "/oracle/apps/product/10.2.0"
DATABASE "xxxx1" CONNECT "HP_DBSPI/pass@xxxx1"
LOGFILE "/archive/admin/xxxx1/bdump/alert_xxxx1.log"
LISTENER "LISTENER_xxxx1" CONNECT ""





wht else can be causing this?
Occasional Visitor
maricel_mmc
Posts: 1
Registered: ‎08-19-2013
Message 7 of 8 (450 Views)

Re: OVOW DBSPI9-26

I have the same problem too.. I tried changing the path in the local.cfg then import it. When I check it using dbspicfg -e, it give the correct path. But when I check it a few minutes later, it goes back to the old path set. :(

Trusted Contributor
UliD
Posts: 71
Registered: ‎05-21-2012
Message 8 of 8 (432 Views)

Re: OVOW DBSPI9-26

Hello Vasja,

 

Please have a look at:

 

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

 

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.