Hi Everyone,
Oracle has released Life sciences Data Hub (LSH) version 2.2 this week.
LSH is data warehouse which integrates Clinical Data Management Systems(eg. Oracle Clinical), TMS(Oracle Treasures Management System), Clinical Trial Management Systems(e.g Oracle Siebel Clinical), Adverse Event Reporting Systems(eg. Oracle Argus Safety Systems, Oracle AERS) and non clinical systems say Financial(eg. Oracle EBS) in which data from all the sources can be analyzed and reported.
LSH 2.2 is based on Oracle EBS R12.
Oracle EBS R12 will act as unified repository which will have adapters for other data sources.
R12.1.3 will spliced with new top CDR_TOP (for LSH).
LSH TechStack:
Oracle Database 11.2.0.2
Oracle Apps R12.1.3
Oracle TMS 4.6.1
Oracle Reports 10.1.2.3.0
Oracle Clinical 4.6 or 4.5.1
Oracle BI Publisher 10.1.3.4.1
OBIEEE 11.1.1.3.0
SAS 8.2, SAS 9.1.3, SAS 9.2
Character set must be UTF8 !!.
Will cover more on this.
skip to main |
skip to sidebar
APPLICATIONS DBA ARENA
Search This Blog
Cloud Articles
- RDS Enhancements
- Terraforming: RDS tained Resource
- AWS Cross Account Encrypted RDS DB Cloning
- RDS Troubleshooting
- AWS and Azure Quick Reference
- Cost Optimization Oracle RDS
- Exadata Exodus to Cloud
- Cloud Migration: Network Consideration
- Cloud Migration IO considerations
- Maximum Security Architecture Oracle RDS
- Archiving Oracle Database Backup to S3 Glacier
- Oracle RDS Tracing ORA- errors
- AWS for OCI Architects
- DB Engines and Default ports
- Beginners guide on Oracle RDS on AWS
- EBS to Cloud: FNDFS Failure
- Compute Classic Instance Timezone Change
HIGH AVAILABILITY
Databases
- Restricting Users during maintenance
- 19c: Tuning Simplified
- Automatic Archivelog Purge Scripts
- Resolved: High CPU Load on DB Server
- 19c: Out of synch DR database? Easy way to Fix
- 19c: Upgrade Performance Solution
- Delete Archive Logs Applied on Standby
- Log File Sync Wait Event Resolution
- RMAN: Error Creating Controlfile Backup
- Prod Performance Resolution
- RMAN Setup after upgrades
- DB auto restart
- Library Cache: Mutex X Concurrent Manager
- Library cache pin on Revokes
- Library Cache pin wait
- Tracing ORA Errors
- Monitoring CPU usage of multiple oracle databases running on Shared server
- Recovery using Backup controlfile
- Beware killing sessions with Immediate option
- Beware commit on exit
- Error opening Database
- SQL Tuning using Profiles
- SQL Server DB Clone Part1
- MySQL Quick Reference for Oracle DBAs
SQL Server
Oracle DEMANTRA
- R12-Demantra Integration Overview
-
R12-Demantra Integration Part II
-
R12-Demantra Integration Part III
-
R12-Demantra Integration Part IV
-
R12-Demantra Integration Part V
-
11i: Demantra with DB Vault
-
11g and Demantra R12 - Access Control List (ACL)
-
R12-Demantra Integration patches
-
Vista and Demantra
- R12.1.1 with Demantra 7.3
Oracle Life Sciences
About Me
 | Specialized in Databases. Led, mentored many DBAs and Developers on best practices in database design and performance tuning. Specialized in multiple database engines, Oracle E-Business Suite Setup, Upgrades, Backup and Recovery, Cloning Optimizations, Cloud Migrations, Replication and Disaster Recovery. You can reach me at meet.lsuresh at gmail.com |
| Suresh Lakshmanan, USA View my profile here. | |
Oracle DB POSTS
- 19c: Tuning Simplified
- ORA-600 qksvcGetGuardCol
- 11g Grid with lower DB version
- 12C-DeprecatedCursor_sharing=similar
- 11g: Oracle Multimedia
- 11g: Active Data guard
- 11g: Incident Service Packaging
- 11g: Killing sessions in other RAC instances
- 11g: Snapshot Stanby for EBS R12/11i
- 11g: Invisible Indexes
- 11g: Password Case Sensitivity
- 11g Automatic memory management
- 11G: RAC ADRCI usage
- 11g: Automatic Diagnostic Repository
- 11g: Alert Log location Change
- 11g Online Patching/Rollup Patching
- RDBMS patching in 11g RAC
- DR corruption real world scenario
Oracle 11i POSTS
- Configuring Discoverer SSL with Ebiz - Part III
- Configuring Discoverer SSL with Ebiz - Part II
- Configuring Discoverer SSL with Ebiz - Part I
-
SQL: Workflow Service components Status
- Java for Ebiz 64bit vs 32 bit
- Removing Credentials from cloned system
- FNDCPASS utility changes for DB Vault
- Unlock orcladmin Account
Tools,Books
Oracle R12 POSTS
- R12.2 SSL Setup Debugging
- OAM stops working after SSL
- R12.1 AFPASSWD
- R12: IP/Host name change
- R12: Concurrent Manager Status R12: INST_TOP on NAS
- R12: Novice Apps DBA
- R12: SSL in multinode EBS
- R12 Spam workflow notification emails
- R12 eMC vs 11i eMC
- R12: Isolating DB and Apps Tier from Single User Installation
- R12 Certified DBA
- Why R12 Upgrade
- R12: R12.1.1 Post installation issues
- R12: R12.1.1 - RPM issues with OEL
- R12: R12 or 12i
- R12: opmnctl long option
- R12.1: Autoconfig
- R12: Where is my Context XML
- R12 :CDATA in Context XML
- R12: Appcasts
- R12: No Passwords in appltop
- R12: Integration with BPEL
- R12: OC4J Overview
- R12 and Application Server
- R12: Rapidwiz
- R12: Shared Appltier - Sun JRE 1.5.0.13 upgrade
- R12: Where is my Jinitiator
- R12 Service Management - OPMN
- R12.0.4 FNDCPASS USERMIGRATE
- R12 Installation-In depth Discussion
- R12 Single Node,Single User Installation
- R12:Beware executing rm -rf $COMMON_TOP/_pages/*
- What is new in R12 SSL
- R12 distributed AD
- Unveiled R12 INST TOP
- R12 techstack inventory Report
- R12 XML Publisher/BI Publisher
- R12 Init.ora settings
- R12-Loading Apps User to OID
- R12 with OID/SSO
- INST_TOP in R12
- R12 Architecture
- R12 Intro
4 comments:
Can anyone refer any available books on LSH? Any available training opportunities out there? Any comment greatly appreciated. Thanks.
Hi Anonymous,
Please mention your name while giving comment to address you. Thank you.
No books currently available. You can refer the documents available in edelivery.oracle.com
Hope this helps you.
Suresh
HI Suresh
Is LSH a good for Oracle APPS DBAs. I have 3 years of Oracle apps DBA Experience. For last 10 Months I have been working on different Oracle Health science applications like OC, Argus,AERS, Siebel Clinical and moreover LSH. I Use to install, configure and manage these application from technical point. WIll it be good for me to continue with LSH or to go back to general apps DBA.
Hi Anonymous,
Great to hear you have mix of experience. Oracle Apps is being used many customers, you have the flexibility to move around for your location preference etc, Where as Mix of experience will give you edge over others to stay in same place. Opinion differs.
Drop me an email, we can continue talking offline - would be interested to have you on my contact list.
Suresh
Post a Comment