can't start nnmaction and can't connect to nnm interface

[Amine_brini]

Hi all,

I'm currently installing NNMi 9.10 on HP-UX and on HA environment.

I install the first NNMi 9.10 node. I have an issue with starting NNMi:

In nnm.0.0.log I have this error:

Nov 17, 2011 5:18:24.748 AM [ThreadID:10] INFO: com.hp.ov.persist.common.hibernate.HibernateSessionFactory : Connecting to database.

Nov 17, 2011 5:18:24.773 AM [ThreadID:10] SEVERE: com.hp.ov.nms.model.sar.NmsModel startService: Model failed to start : java.lang.AssertionError: No database ID found

        at com.hp.ov.persist.common.hibernate.HibernateSessionFactory.createPersistTables(HibernateSessionFactory.java:1879)

And In jbossServer.log we have:

2011-11-17 05:18:24,779 WARN  [org.jboss.system.ServiceController] Problem starting service com.hp.ov.nms:service=NmsModel

java.lang.AssertionError: No database ID found

        at com.hp.ov.persist.common.hibernate.HibernateSessionFactory.createPersistTables(HibernateSessionFactory.java:1879)

 _________________

[root@nnm1]/var/opt/OV/log/nnm # /opt/OV/bin/ovstatus -c

 Name                   PID  State          Last Message(s)

 OVsPMD                2602  RUNNING        -

 pmd                   3075  RUNNING        Initialization complete.

 nnmaction                -  NOT_RUNNING    Exit on signal 18 Exit(1)

 ovjboss               2635  RUNNING        Initialization complete.

Any idea to resolve this issue please

Regards,

Amine

[DJ Hogeweg]

Hi Amine,

Looks like NNMi can't establish a database connection. Do you use Oracle or the embedded database? You can check these settings at /opt/OV//nonOV/jboss/nms/server/nms/deploy/nms-ds.xml, tag "connection-url". Regards,

DJ

[Amine_brini]

Hi DJ Hogeweg,

Thank you for your answer. I use Oracle database.

on nms-ds.xml file, we have:

_____________________________________________________________

        <connection-url>jdbc:oracle:thin:@nnmdb:1521:nnmdb</connection-url>

_____________________________________________________________

We can test connetion to the db?

Regards,

Amine

[DJ Hogeweg]

Hi Amine,

"nnmdb" is your Oracle database instance id. Is that correct? Can you verify if the user/password combination is correct you entered during the NNMi installation? If you want to change the user/password combination you can do that with the command: nnmchangedbpw.ovpl

Regards,

DJ

[Amine_brini]

Yes exact, nnmdb is the oracle db id.

I try to connect manually to the database using oracle user/pwd:

___________________________________________________

[root@nnm1]/ # ssh nnmdb

##connection OK##

[root@nnm1]/ # $ORACLE_HOME/bin/sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 21 08:48:43 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Enter user-name: oracle
Enter password:
ERROR:
ORA-12547: TNS:lost contact

___________________________________________________

nnm.0.0.log:

Nov 21, 2011 8:47:32.441 AM [ThreadID:10] SEVERE: com.hp.ov.nms.model.sar.NmsModel startService: Model failed to start : java.lang.RuntimeException:
Failed to obtain database connection

___________________________________________________

Regards,

Amine

[Amine_brini]

An on incidentActions.0.0.log file, we have:

______________________________________________________________________________________

[root@nnm1]/var/opt/OV/log/nnm/public # cat incidentActions.0.0.log
Nov 21, 2011 8:49:38.530 AM [ThreadID:1] CONFIG: null init: Logging Handler initialized to log to file pattern: "/var/op                                    t/OV/log/nnm/public/incidentActions.%g.%u.log" up to a limit of 5 files of 1 MB each. Append to log until full:"false".
Nov 21, 2011 8:49:38.626 AM [ThreadID:10] WARNING: com.hp.ov.nms.events.actionlog.ActionLogger createActionServer: Faile                                    d to get port number from /var/opt/OV/tmp/actionServer.port due to java.io.FileNotFoundException. /var/opt/OV/tmp/action                                    Server.port (No such file or directory (errno:2))
Nov 21, 2011 8:49:38.628 AM [ThreadID:10] INFO: com.hp.ov.nms.events.actionlog.ActionLogger createActionServer: Will try                                     to read /var/opt/OV/tmp/actionServer.port file again after 60 seconds
Nov 21, 2011 8:50:38.630 AM [ThreadID:10] WARNING: com.hp.ov.nms.events.actionlog.ActionLogger createActionServer: Faile                                    d to get port number from /var/opt/OV/tmp/actionServer.port due to java.io.FileNotFoundException. /var/opt/OV/tmp/action                                    Server.port (No such file or directory (errno:2))
Nov 21, 2011 8:50:38.631 AM [ThreadID:10] INFO: com.hp.ov.nms.events.actionlog.ActionLogger createActionServer: Will try                                     to read /var/opt/OV/tmp/actionServer.port file again after 60 seconds
Nov 21, 2011 8:51:38.640 AM [ThreadID:10] WARNING: com.hp.ov.nms.events.actionlog.ActionLogger createActionServer: Faile                                    d to get port number from /var/opt/OV/tmp/actionServer.port due to java.io.FileNotFoundException. /var/opt/OV/tmp/action                                    Server.port (No such file or directory (errno:2))
Nov 21, 2011 8:51:38.643 AM [ThreadID:10] INFO: com.hp.ov.nms.events.actionlog.ActionLogger createActionServer: Will try                                     to read /var/opt/OV/tmp/actionServer.port file again after 60 seconds
Nov 21, 2011 8:52:38.654 AM [ThreadID:10] WARNING: com.hp.ov.nms.events.actionlog.ActionLogger createActionServer: Faile                                    d to get port number from /var/opt/OV/tmp/actionServer.port due to java.io.FileNotFoundException. /var/opt/OV/tmp/action                                    Server.port (No such file or directory (errno:2))
Nov 21, 2011 8:52:38.655 AM [ThreadID:10] INFO: com.hp.ov.nms.events.actionlog.ActionLogger createActionServer: Will try                                     to read /var/opt/OV/tmp/actionServer.port file again after 60 seconds
Nov 21, 2011 8:53:38.664 AM [ThreadID:10] WARNING: com.hp.ov.nms.events.actionlog.ActionLogger createActionServer: Faile                                    d to get port number from /var/opt/OV/tmp/actionServer.port due to java.io.FileNotFoundException. /var/opt/OV/tmp/action                                    Server.port (No such file or directory (errno:2))
Nov 21, 2011 8:53:38.665 AM [ThreadID:10] INFO: com.hp.ov.nms.events.actionlog.ActionLogger createActionServer: Will try                                     to read /var/opt/OV/tmp/actionServer.port file again after 60 seconds
Nov 21, 2011 8:54:38.673 AM [ThreadID:10] SEVERE: com.hp.ov.nms.events.actionlog.ActionLogger main: Failed to initalize                                     the action server

______________________________________________________________________________________

Any solution?

thx for your help,

Amine

[DJ Hogeweg]

I see an error "ORA-12547: TNS:lost contact", are you sure your database is available for NNMi? The fact that nnmaction won't start is because not all services of ovjboss are started probably due to database malfunctioning. Regards,

DJ

[Amine_brini]

Hi DJ,

Can you please help me to understand this point:

On “HP Network Node Manager I Software Deployment Reference” document (page 313), it’s mentioned :

___________________________________

Set up the NNMi dependency on the Oracle HA resource group.

For specific instructions, see the HA product documentation

 ___________________________________

what kind of dependency to set up?

Thx,

Amine

[DJ Hogeweg]

Hi Amine,

Sorry but my knowledge about HA is nill. But when reading the page my feeling tells me that probably it's possible to configure a HA solution with the fact that NNMi is dependend on the availability of an Oracle database. Regards,

DJ

[Amine_brini · Accepted solution]

Hi DJ,

It's ok now. the problem is fixed by grant the correct privilege to oracle user.

• Create sequence
• Create session
• Create table
• Create view
• FLASHBACK ANY TABLE

thank you for your help.

Regards,

Amine