NNMi 9.10 'migration' from PostgreSQL to Oracle DB (520 Views)
Reply
Honored Contributor
Remco D'haenen
Posts: 1,082
Registered: ‎04-16-2003
Message 1 of 5 (520 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

Please use plain text.
Honored Contributor
AndyKemp
Posts: 720
Registered: ‎05-17-2010
Message 2 of 5 (514 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
Please use plain text.
Honored Contributor
DJ Hogeweg
Posts: 288
Registered: ‎11-22-2010
Message 3 of 5 (506 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

Please use plain text.
Honored Contributor
DJ Hogeweg
Posts: 288
Registered: ‎11-22-2010
Message 4 of 5 (505 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
Please use plain text.
Honored Contributor
AndyKemp
Posts: 720
Registered: ‎05-17-2010
Message 5 of 5 (502 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
Please use plain text.
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