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 Variable | Description | System |
|---|---|---|
| ORACLE_HOME | Location of Oracle software, top level directory. | Client only |
| XYV_PDM_DATABASE_SID | The Oracle SID used by the SDL Contenta database. | Client only |
| XYE_PDM_ODBC_DSN | The 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