ContentDB installation

Yesterday I installed ContentDB. The installation is fairly straightforward.

Download and install Oracle Identity Management

  • OID 10.1.4.0.1
  • Install the Infrastructure, with the Identity Management and Repository, including Internet Directory, Single Sign-on, Delegated Administration Services and Directory provisioning

This will create a 10.1.0.5 database. The default parameters are too low for contentDB.


alter system set
  processes=250
    scope=spfile
  sga_max_size=629145600
    scope=spfile
  shared_pool_size=184549376
    scope=spfile
  java_pool_size=125829120
    scope=spfile
  db_cache_size=150994944
    scope=spfile
  db_file_multiblock_read_count=32
    scope=spfile
  db_create_file_dest='/u02/oradata'
    scope=spfile
  job_queue_processes=10
    scope=spfile
  session_max_open_files=50
    scope=spfile
  open_cursors=400
    scope=spfile
  star_transformation_enabled=true
    scope=spfile
  pga_aggregate_target=203423744
    scope=spfile;

It is recommended to stop the application server infrastructure before restarting the database to make the parameters above effective.

$ $ORACLE_HOME/bin/emctl stop iasconsole
$ $ORACLE_HOME/opmn/bin/opmnctl stopall
$ sqlplus / as sysdba
SQL> shutdown immediate
SQL> startup
$ $ORACLE_HOME/opmn/bin/opmnctl startall
$ $ORACLE_HOME/bin/emctl start iasconsole

It is now possible to install ContentDB in this database. Of course the ContentDB could be installed in a separate database, it does not have to be the same as the infrastructure database.

Now, download and install Oracle ContentDB

That’s all. There now two application server instances, one for the infrastructure and one for the content database.

To launch the Content Database web interface, just go to the http server of the ContentDB installation, something like http://server:7779.

$ /app/oracle/product/10.1.2/cdb_1/bin/opmnctl status -l

Processes in Instance: CONTENTDB01.srv01
-------------------+----------+------------------------
ias-component      | status   | ports
-------------------+----------+------------------------
DSA                | Down     | N/A
HTTP_Server        | Alive    | http1:7779,http2:7202
LogLoader          | Down     | N/A
dcm-daemon         | Alive    | N/A
OC4J               | Alive    | ajp:12503,rmi:12403,...
WebCache           | Alive    | http:7778,invalidati...
WebCache           | Alive    | administration:9400
Content            | Alive    | node_dms_http:53900,...
Content            | Alive    | node_manager_locator...

Login with user ORCLADMIN and the password you specified for IAS_ADMIN.

ContentDB interface let you upload and download files. You can use it to keep your documentation in a single location. It has versioning capabilities too.

screenshot

13 thoughts on “ContentDB installation”

  1. Hi Laurent,

    Is contentDB for more than dragging and dropping files, or is it just a glorified FTP?

    Does this relate to the questionable “collaboration suite”?

  2. Hi Don,
    ContentDB is a versioning tool too. That is, you can keep in the database multiple version of your Word documents. It is probably not as efficient as CVS for minimizing disk usage…

    According to the collaboration suite documentation
    Please note that the Oracle Collaboration Suite Database is
    completely separate from the Oracle Content Database. The Oracle
    Content Database belongs to a different product line.

    Well, it is probably related, but I cannot tell how :?:

  3. As far as I know, but I am not completely up to date with the PR stuff anymore, started it as IFS (the Oracle Internet File System). This was then embedded into the collaboration suite (and it lost my interest because it had functionality I wasn’t interested in). Then Oracle got the IFS part out off Collaboration Suite and was called “ContentDB”. I think that was a good move.

    It probably can more then the following:

    NFS (?), HTTP(s), FTP(s), WebDav access. So direct connections via explorer. With excellent search capabilties via embedded Oracle text and search. Embedded versioning. It should be able to compress things (alter table …) etc. In all it should be an formidable product (fileserver alternative).

    …but as said, it is a long time that I played with it…

    M.

  4. Hi Laurent

    Your text…
    $ $ORACLE_HOME/bin/emnctl stop iasconsole

    Fixed
    $ $ORACLE_HOME/bin/emctl stop iasconsole

    ;)

    See you …

    Regards
    Hector Gabriel Ulloa Ligarius
    http://www.ligarius.com

  5. Hello Laurent,

    nice to hear that you installed this option of the database. did you manage to find how to use/see the audit information ? in the statement of direction Oracle says something about offering audit trail.
    I think in the beginning there was iFS-> Oracle Content Management SDK -> Oracle Files (Oracle Collaboration Suite/Oracle Content Services) -> Oracle Content DB.
    in the meantime (end of 2006) Oracle bought Stellent and they have also Universal Content Management. now probably they want to change the repository of the former Stellent product to ContentDB ?!

    I also tried to install and find the certified components for this installation of Content DB. one question would be how come that there is such ambiguity in the certified OS and hardware between metalink certify tab and the documents with certification information publicly available on the Oracle website. for example how come that the db 10.1.0.5 which comes with the AS infrastructure is supported on EM64T Intel processor and on the certify metalink tab this database (which is 10gR1) as a standalone product is not supported ?

    thanks,
    Florin

  6. yes, for example, for the Windows OS :
    on the Certify tab:

    Certify – Product Version and Other Selections: Oracle Database – Enterprise Edition On Microsoft Windows 2003 (AMD6
    4/EM64T)
    General Notes For Oracle Database – Enterprise Edition On Microsoft Windows 2003 (AMD64/EM64T):

    32-bit and 64-bit Information
    o There is no 64-bit version of 9iR2 nor 10gR1 for 64-bit Windows on AMD64/EM64T hardware
    o Running 32-bit applications on a 64-bit operating system is generally referred to as “Compatibility-Mode” by many AMD64/EM64T hardware vendors. Irrespective of this terminology, 32-bit Oracle Database server is *not* certified
    on Windows x64. For the 32-bit Oracle database client, check the certification
    matrix for more details.”

    then in the certification of the app server 10.1.4.0.1 in table 29 at
    http://www.oracle.com/technology/software/products/ias/files/idm_certification_101401.html#BABIDJBH

    for the platform Intel EM64T 64 bit Windows 2003 R1 (64 bit OS)
    10.1.0.4 or higher (in the 10.1 product line) – Y

  7. Laurent,
    Can i enter in the ContentDb without entering login and password? Maybe i can set guest login and password in some config file, or pass then in the address string?

  8. @Andrey K.
    on oracle metalink you could see the following note:
    Doc ID: 400683.1 Type: HOWTO
    How to enable Public Access to Files and Folders over HTTP(S) in Oracle Content Services / Content DB
    Goal
    How to grant ‘Public Access’ to files and/or folders in Oracle Content Services / Oracle Content DB so that end-users no longer have to login to access public items.

  9. Hi Laurent,

    We installed content server (Collaboration suite 10.1.2) & we want to integrate with Ebiz R12.1.1. Can you guide us how to do it?

Leave a Reply

Your email address will not be published.


*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>