Portal is installed by default with Derby database to store portal information. Portal uses following 6 databases to store different kind of information:
1. Release
2. Community
3. Customization
4. JCR
5. Feedback
6. Likeminds
Portal provides following 3 options while creating and transferring the databases:
1. Create one database and transfer all the databases to this single database
2. Create separate databases on the same server and transfer the portal data to them
3. Create separate databases on different server (distributed environment) and transfer the portal data to them.
This post will demonstrate how to transfer the portal databases to separate databases on the same server, but you can use the same steps to transfer the database to one database or databases created on separate servers.
After configuring your database server(s) by installing DB2 (or Oracle/MS SQL Server) and creating databases using the DB2 creation script you need to run the following to transfer the databases:
<wp_profile_root>\PortalServer\wizard\configwizard.bat
Running the above batch command will open the following screen:
Click on “Next” to go to next screen.
Select “Transfer data to other databases” and click next to go to next step.
Provide WebSphere Application Server username and password to start WebSphere_Portal server. Click “Next” to go to next screen.
Wizard will check if server is started or not. If server is not started then it will start the server before moving to next screen.
Select “IBM Derby” from the options to select the source database. Click “Next” to go to next screen.
Select “IBM DB2 Universal Database” to select the target database. Click “Next” to go to next screen
Specify database server name or provide IP address in “DbHostName” and “DbPort”. Also specify complete path for “DbLibrary” files. You need to specify the location for the jar files “db2jcc.jar” and “db2jcc_license_cu.jar”. Click “Next” to go to next screen.
Specify “DbName”, “DbUser” (having admin access) and “DbPassword” for “community” database. You can specify other custom information as well according to your need. Click “Next” to go to next screen.
Wizard will validate the information provided by you before moving to next screen. You just have to wait for it to finish verification to go to next screen.
Specify “DbName”, “DbUser” (having admin access) and “DbPassword” for “customization” database. You can specify other custom information as well according to your need. Click “Next” to go to next screen.
Specify “DbName”, “DbUser” (having admin access) and “DbPassword” for “FEEDBACK” database. You can specify other custom information as well according to your need. Click “Next” to go to next screen.
Specify “DbName”, “DbUser” (having admin access) and “DbPassword” for “jcr” database. You can specify other custom information as well according to your need. Click “Next” to go to next screen.
Specify “DbName”, “DbUser” (having admin access) and “DbPassword” for “likeminds” database. You can specify other custom information as well according to your need. Click “Next” to go to next screen.
Specify “DbName”, “DbUser” (having admin access) and “DbPassword” for “release” database. You can specify other custom information as well according to your need. Click “Next” to go to next screen.
Check all the information in that you specified in this screen. If everything is correct then click “Next” to start the transfer of the databases. You will get successful message if everything goes well without any error.
You can now start and stop the servers to propagate the changes. If servers start without any errors and you are able to login successfully using GUI then you have successfully transferred the databases.
No comments:
Post a Comment