Documentation Center

Oracle database

For storage of SDL Contenta data; the database server is the system on which the Oracle database software is installed.

When storing SDL Contenta data in an Oracle database note the following:

Variables:

Required VariableDescriptionSystem
ORACLE_HOMELocation of Oracle software, top level directory.Client only
XYV_PDM_DATABASE_SIDThe Oracle SID used by the SDL Contenta database.Client only
XYE_PDM_ODBC_DSNThe ODBC DSN used by the SDL Contenta database.Client and Server
Processes:
  • ora_pmon
  • ora_dbw0oracle
  • ora_lgwr
  • ora_ckpt
  • ora_smon
  • ora_reco
  • tnslsnr LISTENER -inherit

Verification:

To check or verify that the processes are running, at UNIX prompt type:
ps -ef |grep ora

Example system response:

oracle 27191 1 2 13:50:45 ? 0:00 ora_j000_bird
oracle 26057 1 0 07:00:03 ? 0:01 ora_dbw0_bird
oracle 26077 1 0 07:00:15 ? 0:05 ora_mmon_bird
oracle 10475 1 0 Jan 08 ? 0:01 /oracle/Ora10g/bin/tnslsnr LISTENER -inherit
oracle 26053 1 0 07:00:03 ? 0:00 ora_pmon_bird
oracle 26069 1 0 07:00:04 ? 0:00 ora_d000_bird
oracle 26067 1 0 07:00:04 ? 0:01 ora_cjq0_bird
oracle 26075 1 0 07:00:13 ? 0:00 ora_qmnc_bird
oracle 26055 1 0 07:00:03 ? 0:00 ora_mman_bird
oracle 26059 1 0 07:00:03 ? 0:03 ora_lgwr_bird
oracle 8483 1 0 Jan 08 ? 0:05 /oracle/Ora10g/bin/ocssd.bin
oracle 26071 1 0 07:00:04 ? 0:00 ora_s000_bird
oracle 26063 1 0 07:00:04 ? 0:05 ora_smon_bird
oracle 26079 1 0 07:00:15 ? 0:00 ora_mmnl_bird
oracle 26065 1 0 07:00:04 ? 0:00 ora_reco_bird
oracle 27126 1 0 13:47:52 ? 0:00 ora_q000_bird
oracle 26061 1 0 07:00:04 ? 0:17 ora_ckpt_bird