Skip to content

Oracle

Jump to bottom
Kosha Ruparel edited this page Jun 14, 2022 · 16 revisions

Oracle is our clinical database. Oracle is hosted on PMACS, supports our Clinical team for integrating participant enrollment information, contact information, medications, and all tracking related to an IRB protocol study.

How to Access

  • https://bbldm.pmacs.upenn.edu

    • This is the production server hosted by PMACS
    • This server is protected and cannot be assessed without being on specific network
      • On campus: Connect to the Penn Medicine network
      • Off campus/remote: Connect to UPHS VPN using the F5/BIG-IP VPN Client

  • https://bbldm-dev-web.pmacs.upenn.edu/bblmain/Clinics

    • This is the testing server hosted by PMACS
    • Only designated users on the testing team are able to access this server
    • This server also requires specific PMACS network

  • Development Server

    • Lan's laptop- macbook pro is the development server.

Oracle Applications

List of the Oracle Applications.

Server Architecture

There are four servers: bbldm-dev-web,bbldm-dev-db, bbldm-prd-web, and bbldm-prd-db.

Software Stack

Bbldm-prd-web

  • Apache 2.4
  • OpenJDK 1.8
  • Oracle client 1.2
  • Tomcat 8.5

Bbldm-prd-db

  • Oracle Database Server 12C
    • Service name - bbldmprd

Bbldm-dev-web

  • Apache 2.4 wth self-signed TLS certificate
  • OpenJDK 1.8
  • Oracle client 1.2
  • Tomcat 8.5

Bbldm-dev-db

  • Oracle 12cR2
    • SID - BBLDMDEV

Server Backup

Backup for Bbldm-prd-db

  • RMAN runs at 1 am (cronjobs)
  • Datapump runs at 10 pm (cronjobs)

Oracle Data Dictionary

External Backup

Servers are backed up nightly using an industry-standard backup product (currently Commvault). The backup servers and storage are in the Pennovations datacenter on campus, offsite from all the production servers. Nightly backups are kept for at least two weeks, and longer if resources allow. Monthly backups are kept for a year, and yearly backups are kept for 5 years. Other retention policies are also in place for departments that request them.

Contact Persons

Oracle Manual and Training

Oracle Updates/Changes

  • May 2021

    • Updated FullScreen Short MRI to include Female specific questions related to pregnancy and IUD
    • Redcap Clinical Interview: Added Assessment_Method and Dropdown, Changed varname to protocol_assessment to battery_assessment, Fixed the collateral bug
    • Gender identify Updated with following drop down options: Female, Male, Transgender woman/trans woman/male-to-female (MTF), Transgender man/trans man/female-to-male (FTM), Non-binary/Genderqueer/gender nonconforming neither exclusively male nor female, Other gender category, Decline to answer

  • May 21 2021

    • Redcap report push fail error message
    • Redcap fixed subject_id issues
    • Retrieve from redcap works
    • link to go to redcap directly works

  • Jun 4 2021

    • Adaptive project done
    • Add Redcap return id new feature

  • Sept 3 2021

    • add common to C2look
    • removed the rule for collateral. Now we don't check the enrollment of collateral. we can generate redcap scales for collateral
    • Changed the pop up message for collateral family members

  • Nov 18 2021

    • developed a new app to collect demographic data. It doesn't need to associate with protocol
    • remove gender_identity, gender_hx in subject table
    • remove gender_identity, gender_hx in quickscreen table

  • Nov 24 2021

    • use a new order in adaptive app
    • added two links for adaptive

  • Nov 30 2021

    • fixed bug in adaptive link
    • fixed bug to get most recently mom_lname from existing demo data
    • fixed bug in fulscreen_mri long form iup_type

  • Jan 21 2022

    • fixed bug in study visits
    • released redcap online screen app

  • Fed 14 2022

    • deployed fullscreen
    • deployed mri screen

  • Mar 1 2022

    • deployed online screen
    • fixed adaptive link for battery_cat
Clone this wiki locally