How to set another oracle database location ?

[FrItcH]

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

[FrItcH]

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

[Change_happens]

use mxoracleconfig command to do that.

[FrItcH]

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

[Jov]

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

[Equipe_Micro]

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

[Equipe_Micro]

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

[Change_happens · Accepted solution]

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

[Change_happens]

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.