Clear the contents of Oracle database
tables whenever you reinstall Presence Server.
Optionally, you can also perform this task when uninstalling Presence Server.
Before you begin
Verify that the following file exists n the database server in
was_root/installableApps/presence/scripts/dbScripts/presence:
Note: was_root is
the installation root directory for
WebSphere® Application Server
Network Deployment.
By default, this directory is:
/usr/IBM/WebSphere/AppServer
/opt/IBM/WebSphere/AppServer
About this task
The following command should be run for each database you have created
for Presence Server.
- Stop all application servers in the cluster on which Presence Server is running.
- Log in to the Oracle server
as a database administrator.
- Switch to the following directory: was_root/installableApps/presence/scripts/dbScripts/presence.
- Run the following command to clean the contents
of the Presence Server database
tables:
Supply values for the parameters as follows:
- dbName
- The name of the database, for example PSDB.
- dbUser
- User ID for the authorized user (the ID with which you are logged in),
for example dbadmin.
- dbUserPW
- Password for the authorized user.
- ddlFile
- Path to the data definition language (ddl) file used to clean the database
tables: DeleteContentOracle.dll.
Example
For example:
./RunConfigOracle.sh dbName=PSDB dbUser=dbadmin dbUserPW=password
ddlFile=DeleteContentOracle.dll
Note: Enter the entire command
on one line.
What to do next
When the script completes, the following database tables are cleaned
of their contents:
- PUBLISH
- FULLDOC
- MANAGING_SERVERS
- WATCHERS
- PRESENCE_AUTH_RULES