Server Management - Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

How to set another oracle database location ?

SOLVED
Go to solution
FrItcH
Occasional Contributor

How to set another oracle database location ?

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
8 REPLIES
FrItcH
Occasional Contributor

Re: How to set another oracle database location ?

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

Re: How to set another oracle database location ?

use mxoracleconfig command to do that.
FrItcH
Occasional Contributor

Re: How to set another oracle database location ?

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

Re: How to set another oracle database location ?

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
Occasional Visitor

Re: How to set another oracle database location ?

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
Occasional Visitor

Re: How to set another oracle database location ?

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
Honored Contributor
Solution

Re: How to set another oracle database location ?

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
Honored Contributor

Re: How to set another oracle database location ?

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.