the easiest way to move db for HP operation orchestrator (PAS)
The easiest way to move db for HP operation orchestrator (PAS) that I’ve found is the following:
there are two config files that this information is located at:
1) in my case I have the following directory
/opt/Central-7.10/Central/conf/
location might vary, but its in Central/conf directory, file name is
Central.properties
in that file search for the following string:
hibernate.connection.url
this line defines your DB, port, type of connection and so on.
in my example I have:
hibernate.connection.url=jdbc:oracle:thin:@//pasdb.perfekt.net:1521/pas
and I need to change port to 3535 so I modify that entry to look like this:
hibernate.connection.url=jdbc:oracle:thin:@//pasdb.perfekt.net:3535/pas
2) second location of where there is reference to db is for Scheduler
and the same, look for its directory, in my case its the following location:
/opt/Central-7.10/Scheduler/conf/
there is config file called: quartz.properties
org.quartz.dataSource.schedulerDS.URL = jdbc:oracle:thin:@//pasdb.perfekt.net:1521/pas
modify it to look something like this:
org.quartz.dataSource.schedulerDS.URL = jdbc:oracle:thin:@//pasdb.perfekt.net:3535/pas
when you done editing those two configuration files just restart the whole PAS and you should be on your way connecting PAS to a new port. This move is only for switching to different port or the server, DB structure cannot be modified, version of DB cannot be changed and stuff, I mean you can change all of that but make sure you have all the backups and roll back plan since I don’t know if that will work for you or not. I was just simply changing port, none of the DB stuff was changed otherwise.
