Creating an External Notification Database on Oracle
This topic describes how to create and configure a database
for the Notification service on all supported versions of Oracle.
The script files referred to in the following steps are
found in
install_dir\alui\cns\1.0\sql\oracle on Windows installs and
install_dir/alui/cns/1.0/sql/oracle on Unix and Linux installs. In
this directory there are two subdirectories:
- If you are scripting an Oracle database on Windows, use the script
files in the windows directory.
- If you are scripting an Oracle database on Unix or Linux, use
the script files in the unix directory.
- Edit references to the PLUM10 SID in cns-server-create-table-space.sql, if necessary.
The cns-server-create-table-space.sql script
assumes your SID to be PLUM10. If your SID is different,
replace all occurrences of PLUM10 in the script file
with your SID.
- Run cns-server-create-table-space.sql.
- Set user and password values in cns-server-create-user.sql.
In the cns-server-create-user.sql script
replace the tokens @CNSDB_LOGIN@ and @CNSDB_PASSWORD_UNENCRYPTED@ with the user name and password, respectively, for the user you
are creating.
- Run cns-server-create-user.sql.
- As the user you just created, run cns-createTables.sql.
- As the user you just created, run cns-data.sql.