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

Content Database 10.2.0.0.0
Install the 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

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.

13 thoughts on “ContentDB installation”

Don Burleson October 24, 2007 at 15:58

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”?
Laurent Schneider Post authorOctober 24, 2007 at 16:15

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 ❓
Marco Gralike October 24, 2007 at 18:41

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.
Hector Gabriel Ulloa Ligarius October 30, 2007 at 01:47

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
Laurent Schneider Post authorOctober 30, 2007 at 09:28

I love when my readers point those tiny syntax errors ! Thanks a lot 😎
Florin Barbalau December 13, 2007 at 17:58

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
Laurent Schneider Post authorDecember 13, 2007 at 18:30

I have not checked auditting.

About certification, you mean db 10gR1 is not supported on x86_64?

I will have a look
Florin Barbalau December 14, 2007 at 16:30

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
Florin Barbalau December 14, 2007 at 16:41

well and in the table 27 at
http://www.oracle.com/technology/software/products/ias/files/idm_certification_101401.html#BABIDJBH

for Intel EM64T processor the app server is certified for windows xp 32 bit and 64 bit but for windows 2003 we can have only the 64 bit OS. now, I wonder if this is exactly the case or if a mistake exists ?!
Andrey K. April 22, 2009 at 18:23

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?
Anonymous May 7, 2009 at 10:32

@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.
Laurent Schneider Post authorMay 7, 2009 at 12:07

thanks for help Andrey, I have not done much in ContentDB since this post …
Niranjan October 21, 2010 at 09:24

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?

Comments are closed.