This section includes detailed information about DBPrism CMS install scripts.
Files located into the scripts/ directory
| Name
|
Scripts SQL used
|
Enviroment Definitions
|
Comments
|
| install.[sh|bat]
|
create-schemas.sql
install-sec.sql
grants-sec.sql
create-syn.sql
install.sql
CallSpecs.sql
|
CMS_REPOSITORY
SYS_PASSWORD
CMS_USER_SEC
CMS_USER_SEC_PWD
CMS_OWNER
CMS_OWNER_PWD
CACHEHOST
CACHEPORT
|
shell script to install and upload DBPrism CMS database components.
|
| upload-dbprism-docs.[sh|bat]
|
file://$CMS_HOME/dbprism/xdocs/setupcms.xml
|
JAVA_HOME
CMS_HOME
|
shell script to upload DBPrism CMS Web Site documents.
|
| upload-demo-site.[sh|bat]
|
file://$CMS_HOME/demo/xdocs/setupcms.xml
|
JAVA_HOME
CMS_HOME
|
shell script to upload DBPrism CMS Demo Site documents.
|
| update.[sh|bat]
|
file://$CMS_HOME/demo/xdocs/updatecms.xml
|
JAVA_HOME
CMS_HOME
|
shell script to upload aditional CMS documents.
|
| enable-cache-sync.[sh|bat]
|
webcache.sql
|
CMS_OWNER
CMS_OWNER_PWD
CMS_REPOSITORY
CACHEHOST
CACHEPORT
|
shell script to install ESI invalidation database triggers.
|
| enable-context.[sh|bat]
|
enable-context.sql
|
CMS_OWNER
CMS_REPOSITORY
SYS_PASSWORD
|
shell script to enable virtual private database context.
|
| disable-context.[sh|bat]
|
disable-context.sql
|
CMS_OWNER
CMS_REPOSITORY
SYS_PASSWORD
|
shell script to disable virtual private database context.
|
| create-rep.[sh|bat]
|
create-rep.sql
grants-sec.sql
grants.sql
create-syn.sql
create-syn-pkg.sql
install.sql
create-context.sql
enable-context.sql
|
CMS_REPOSITORY
CMS_USER_SEC
CMS_USER_SEC_PWD
CMS_OWNER
CMS_OWNER_PWD
SYS_PASSWORD
|
shell script to create the CMS repository, it receives and username and
password used to create a new database schema, this new schema will have
the content assets of the CMS.
|
Enviroment setting
| Name
|
default value
|
Explanation
|
| CMS_REPOSITORY
|
cms
|
A valid database connect string defined into ORACLE_HOME/network/admin/tnsnames.ora file.
|
| SYS_PASSWORD
|
sys/change_on_install@$CMS_REPOSITORY as sysdba
|
A valid user name and password to connect to the CMS database instance with role DBA.
|
CMS_USER_SEC
CMS_USER_SEC_PWD
|
cms_user_sec
cms_user_sec
|
Database username and password used to install Virtual Private Database schema.
|
CMS_OWNER
CMS_OWNER_PWD
|
cms_owner
cms_owner
|
Database username and password used to install DBPrism CMS code and example tables.
|
CACHEHOST
CACHEPORT
|
cachehost
8888
|
Hostname and port where Cocoon is running, It means where (host) and which (port) is using
the Servlet container instance where DBPrism/Cocoon CMS will be deployed.
|
JAVA_HOME
ORACLE_HOME
|
/usr/local/jdk1.3
inherit from the caller envirment
|
Traditional Oracle/Jave setting, Check it before run ant script.
|
PRISM_HOME
CMS_HOME
|
$HOME/prism
$HOME/cms
|
Where DBPrism and DBPrism CMS where unziped, the scripts define it using Unix user's
home directory ($HOME) setting.
|
