SQL installation scripts for WebCenter Content 11g

As part of the installation of WebCenter Content 11g (UCM or URM), one of the main functions is to run the Repository Creation Utility (RCU) to establish the database schema and tables.   This is pretty helpful because it runs all the scripts you need to have without having to manually set anything up in the database.  

In UCM 10g and earlier, the installation  itself would establish the database tables if you wanted it to.  Otherwise, the SQL scripts were available to be run independently ahead of time.  For DBAs who wanted to understand what was being done to the database for the application, this was helpful for them.  But in 11g, that is all masked now in RCU.  You don't get to see the scripts at all as part of it's establishing the tables. 

But if you comb through the directories for RCU, you can track them down.  They are in the  /rcuHome/rcu/integration/contentserver11/sql/ directories.  And to understand the order in which they are run, you can open up the /rcuHome/rcu/integration/contentserver11/contentserver11.xml file and see how they are run there.  The order in which they are run are:

  • contentserverrole.sql
  • contentserveruser.sql
  • intradoc.sql
  • workflow.sql
  • formats.sql
  • users.sql
  • default.sql
  • contentprocedures.sql 

If you are installing WebCenter Records (URM), it will run some additional scripts between the formats.sql and users.sql :

  • MetadataSet.sql
  • UIEnhancements.sql
  • RecordsManagement.sql
  • RecordsManagement_default.sql
  • ClassifiedEnhancements.sql
  • ClassifiedEnhancements_default.sql

In addition to the scripts being available within the RCU install directories, they are also available from within the Content Server UI.  If you go to Administration -> DataStoreDesign SQL Generation, this page can allow you to download these various SQL scripts.  

DataStoreDesign

 From here, you can select your particular database type and which components to include.  Several components make changes dynamically to the database when they are enabled, so these scripts give you a way to inspect what is being run during that startup time.  Once selected, click Generate and you now can either view or download the scripts from the Actions menu.

DISCLAIMER:  Installations are ONLY supported when done with the Repository Creation Utility.  These scripts are for reference only and not supported to be run manually.

Comments:

Are you saying we don't need to download RCU and then patch the machine to install and run it and then configure it, execute it once and then discard it?

Yay!

Oh wait, the disclaimer. Don't want to put those RCU guys out of work eh.

Posted by webmonkeymagic on November 16, 2011 at 11:04 AM CST #

Now that UCM is part of bigger Suite of products may be Oracle wants to keep similar install and configure steps.

Posted by Deepak on December 08, 2011 at 07:27 AM CST #

Hi Kyle
Can you please recommend a learning approach , any good books or online material to integrate Oracle UCM 11g with webcenter portal, external applications with UCM 11g , integrations with Fat Wire and UCM.

I have several years of experience with UCM but very new to portal and webcenter suite technologies. Any suggestions will be greatly appreciated.

Thanks!

Posted by guest on February 27, 2012 at 12:53 PM CST #

For learning and training, I would first recommend the book: The Definitive Guide to Stellent Content Server Development (http://www.amazon.com/Definitive-Stellent-Content-Server-Development/dp/1590596846/ref=sr_1_1?ie=UTF8&qid=1330530581&sr=8-1). Even though it is several years old, it still is a very good reference to how the Content Server within WebCenter Content (UCM) is put together and how to integrate with it.
Then for online documentation, I would refer to the Development Guide (http://docs.oracle.com/cd/E21764_01/doc.1111/e10807/c09_ridc.htm#BJFIHEHI). And if you are doing Java based integrations, our recommended approach is to use the Remote Intradoc Client (RIDC).

Hope that helps!
Thanks,
-Kyle

Posted by guest on February 29, 2012 at 10:11 AM CST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Kyle Hatlestad is a Solution Architect in the WebCenter Architecture group (A-Team) who works with WebCenter Content and other products in the WebCenter & Fusion Middleware portfolios. The WebCenter A-Team blog can be found at: https://blogs.oracle.com/ ateam_webcenter/

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today