Sign inSign up

jeffersonlab/ceddb

By jeffersonlab

•Updated 4 months ago

The CEBAF Element Database (CED)

Image
0

4.2K

jeffersonlab/ceddb repository overview

The repository contains ready-to use images of the CEBAF Element Database.

⁠Versions

TagOracle VersionComments
2.1-populated21cAdds populated ced3_hist schema, creates _test workspace
2.121cAdds workspace_info table to schema
2.0-populated21cCED content as of 2026-03-27
2.021cEquivalent to 1.3, except newer version of Oracle
1.318cAdds ApiTest schema
1.218cDeleted 2026-05-18
1.118cDeleted 2026-05-18
1.018cDeleted 2026-05-18

The -populated tagged images contain pre-populated ced3_ops and ced3_devl schemas, with workspace manager versioning enabled for ced3_devl. The -populated images are much larger in size, however their startup time is much faster because it bypasses data import and running the time-consuming enableCEDVersioning sql script.

⁠Direct Use in Docker

Example execution:

docker pull jeffersonlab/ceddb:2.1-populated
docker run --rm --name ceddb -it jeffersonlab/ceddb:2.1-populated .

Example usage

docker exec -it ceddb /bin/bash

bash-4.4$ sqlplus ced3_devl/dflTPassWD@//localhost/XEPDB1

SQL*Plus: Release 18.0.0.0.0 - Production on Fri Sep 15 21:16:11 2023
Version 18.4.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

Last Successful login time: Fri Sep 15 2023 20:51:50 +00:00

Connected to:
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0

SQL> exec dbms_wm.createworkspace('_dev');

PL/SQL procedure successfully completed.

SQL> exec dbms_wm.gotoworkspace('_dev');

PL/SQL procedure successfully completed.

SQL> select count(*) from cmpnt;

  COUNT(*)
----------
     10261

⁠Use with Docker Compose.

Example docker-compose.yaml

services:
    oracle:
        # We need full image to get dbms_wm package
        image: 'jeffersonlab/ceddb:2.1'
        hostname: oracle
        ports:
            - '${FORWARD_ORA_PORT:-1521}:1521'
        environment:
            ORACLE_PASSWORD: ${ORACLE_PASSWORD,-dflTPassWD}
            APP_USER: ${ORACLE_PASSWORD}
            APP_USER_PASSWORD: ${ORACLE_PASSWORD}
            CED3_OWNER: ${ORACLE_PASSWORD}
            CED3_DEVL: ${ORACLE_PASSWORD}
            CED3_OPS: ${ORACLE_PASSWORD}
            CED3_HIST: ${ORACLE_PASSWORD}
            APITEST: ${ORACLE_PASSWORD}
        volumes:
            # Keeps persistent oracle data in project run directory
            - './run/var/oracle/oradata:/opt/oracle/oradata'

And then

docker-compose up

Tag summary

Content type

Image

Digest

sha256:71279e1f7…

Size

4.1 GB

Last updated

4 months ago

docker pull jeffersonlab/ceddb:2.1-populated