NNMi 9.10 'migration' from PostgreSQL to Oracle DB (676 Views)
Reply
Highlighted
Honored Contributor
Posts: 1,082
Registered: ‎04-16-2003
Message 1 of 5 (676 Views)

NNMi 9.10 'migration' from PostgreSQL to Oracle DB

Hi, 

I was wandering if anyone here ever 'migrated' an NNMi install from PostgreSQL to an external Oracle DB?

 

So, fresh install but with either a full backup or with a full configexport/import AND (most important), did that work?

 

Best regards

Remco

Honored Contributor
Posts: 834
Registered: ‎05-17-2010
Message 2 of 5 (670 Views)

Re: NNMi 9.10 'migration' from PostgreSQL to Oracle DB

Any particular reason you're going down this path ? The performance is actually worse under oracle.

Have a nice day :)

Andy Kemp,  CISSP
Honored Contributor
Posts: 291
Registered: ‎11-22-2010
Message 3 of 5 (662 Views)

Re: NNMi 9.10 'migration' from PostgreSQL to Oracle DB

Hi Andy,

 

Could you tell a little bit more about the worse performance of Oracle when used with NNMi? Regards,

 

DJ

Honored Contributor
Posts: 291
Registered: ‎11-22-2010
Message 4 of 5 (661 Views)

Re: NNMi 9.10 'migration' from PostgreSQL to Oracle DB

Hi Remco,

A database migration is not possible. What you should do is use nnmconfigexport.ovpl to save your configuration. Install/create an Oracle database and reinstall NNMi. With nnmconfigimport.ovpl you can restore your configuration. Not all your configuration will be restored, ie. node assignment to Security Groups is lost and you might run into some import issues (order is of importance here). Regards,

DJ
Honored Contributor
Posts: 834
Registered: ‎05-17-2010
Message 5 of 5 (658 Views)

Re: NNMi 9.10 'migration' from PostgreSQL to Oracle DB

We had a bake off in HP's labs in 2008 by the TSG AMS SW Pre-Sales (known as Enterprise Business group now).  Embeded won, Linux won, CISC won. Which DB, Hardware, OS won didnt make a difference as we have an ELA with Oracle and HP.

Have a nice day :)

Andy Kemp,  CISSP
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.