topic Re: How to set another oracle database location ? in Server Management - Systems Insight Manager

How to set another oracle database location ?

FrItcH — Mon, 22 Nov 2010 15:54:53 GMT

Hi All,
I have an HP SIM configured with a database (called HPSIM) on a remote ORACLE server (called server A).
I have built a new oracle server (called server B) and imported the sim_manager schema inside the new HPSIM database.
My question is : How can I do to re-configure HPSIM ? How can I re-set the remote ORACLE database to server B ?
Nota : The name of the database is the same, like the 1521 port, and like the sim manager credentials.
Thank you in advance for you help,
Richard

Re: How to set another oracle database location ?

FrItcH — Fri, 26 Nov 2010 13:14:11 GMT

Hi
No one want to help me?
Thank you in advance for you answers.
Richard

Re: How to set another oracle database location ?

Change_happens — Tue, 30 Nov 2010 04:23:50 GMT

use mxoracleconfig command to do that.

Re: How to set another oracle database location ?

FrItcH — Fri, 03 Dec 2010 15:39:57 GMT

Hi
Thank you for you answer.
I'll try mxoracleconfig as soon as possible and I'll do a longer replpy...
Regards
Richard

Re: How to set another oracle database location ?

Jov — Fri, 03 Dec 2010 15:54:27 GMT

Do you or don't you want to keep the data?

If not you can just re-point the oracle client (TNS Name) to Server B, and then re-do discovery etc...

J

Re: How to set another oracle database location ?

Equipe_Micro — Wed, 08 Dec 2010 16:12:23 GMT

Hi all,
I tried this command :

mxoracleconfig -h server -n 1521 -d HPSIM -u dbauser -p passwd

with this result :

mxoracleconfig has already been executed before. Use the force flag to force a re-run.

and this command :

mxoracleconfig -h server -n 1521 -d HPSIM -u dbauser -p passwd -f

with this result :

Cannot run mxoracleconfig because either HP Systems Insight Manager has already been initialized or it is in the process of being upgraded to a newer version.

What may I try now ?

Thanks a lot for your answers,
Regards,
Richard

Re: How to set another oracle database location ?

Equipe_Micro — Fri, 10 Dec 2010 07:37:49 GMT

Hi
It don't work with tnsnames, it works with jdbc client, and I don't know where I can reconfigure the connection string on the HPSIM parameter files...
Finally I decided to completely uninstall HPSIM and reinstall. During the reinstall process, the database connection can be set...
During the ugrade it's impossible to modify the database connection settings.
I'm intersted on having the solution, perhaps I'll have the same need soon or one day.
Regards
Richard

Re: How to set another oracle database location ?

Change_happens — Sat, 11 Dec 2010 04:13:51 GMT

that means SIM is already configured and working.

my bad i didn't read you problem correctly.
So you already have 2 oracle servers and want to point to another DB.

SIM uses configuration file to connect to database which contains all necessary details regarding it. you can try seting that:

1) change new details to database.props file into config directory.
2) change datasource in hpsim-ds.xml in \jboss\server\hpsim\deploy folder.

let me know if it works.
i have tried with SQL server and it works well. lets see

Re: How to set another oracle database location ?

Change_happens — Sat, 11 Dec 2010 04:21:33 GMT

forgot to mention what you need to change in those above 2 files is :
1. Database name, username, host name in database.props.
2. in xml change hostname, databse name in connection url tag.