Re: NNMi 9.10 'migration' from PostgreSQL to Oracle DB (563 Views)
Reply
Honored Contributor
Remco D'haenen
Posts: 1,082
Registered: ‎04-16-2003
Message 1 of 5 (581 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
AndyKemp
Posts: 751
Registered: ‎05-17-2010
Message 2 of 5 (575 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
DJ Hogeweg
Posts: 288
Registered: ‎11-22-2010
Message 3 of 5 (567 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
DJ Hogeweg
Posts: 288
Registered: ‎11-22-2010
Message 4 of 5 (566 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
AndyKemp
Posts: 751
Registered: ‎05-17-2010
Message 5 of 5 (563 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.