Oracle Governance and Risk Compliance (GRC) Manager installation Overview

Oracle GRC Manager

This post covers installation overview of Oracle’s GRC Manager  (Governance and Risk Compliance Manager)  version 7.8 .

You can download Oracle’s GRC (Governance & Risk compliance Manager) from http://edelivery.oracle.com >> E-Business Suite >> 12.0.4 >> Download (Oracle Governance, Risk, and Compliance Manager 7.8 & Stellent UCM Content Server 7.5.2 )

.
GRC Manager requires :

i) Windows Server 2000 SP3 or Windows Server 2003 SP1 (as of today, You can’t install it on Unix)
ii) Microsoft .net framework 2.0
iii) Microsoft IIS (Web) Server 5.0, 5.1, 6.0
iv) Oracle (earlier Stellent) Content Server 7.5.2
v) Oracle Content Server database repository – MS SQL server (2000 SP4, 2005 SP3) or Oracle DB (9.2.0.7, 10.2.0.3)

.
Order of Installation for GRC Manager :

1. Install Oracle (Stellent) Content Server 7.5.2
1.1 Install Web Server for Content Server
1.2 Install Database for Content Server
1.3 Install Master Content Server
1.4Configure WebServer to use with content server (If not done during content Server Installation on step 1.3)
1.5 Configure Database to use with Content Server (If not done during content Server Installation on step 1.3)

.

2. Install GRC Manager
2.1 Install GRC Manager Component on Content Server 7.5.2
2.1.1 Install Component SoapDownloadPatch
2.1.2 Install Component e100SOA
2.1.3 Install Component OrgMapMailer
2.1.4 Install Component SoxSecurity
2.1.5 Install Component UserProxy
2.1.6 Install Component UserAliasInMetaData (Optional for ADSI Support)
2.1.7 Install Component IndexerPatch (Optional for ADSI Support)
2.1.8 Install Component SoxWsdls  (Optional for ADSI Support)
2.1.9 Install Component EmailPatch
 
2.2 Install GRC Manager Application
2.3 GRC Post Installation Task
2.4 Configure GRC Manager with Microsoft Active Directory & SSO (optional) 
 

.

Things good to know about Oracle (Stellent) Content Server 7.5.2

1. You can install Content Server on windows Server (2003, 2000 SP4), Sun Solaris, IBM AIX, HP UX, Red Hat Linux, SUSE Linux
2. Content Server support following Web Server – IIS, Apache, SunONE 6, Sun Java System Web Server
3.Repository for content Server can be MS Sql Server(2000 SP3, 2005), Oracle (9.2.0.7, 10.2.0.3), sybase, Informix or IBM DB2
4. Content Server software and repository could be on different server (recommended)
5. Content Server can be installed using Wizard (GUI), Command line or in silent mode
6.You can use defualt JVM shipped with Content Server or use customized JVM (already installed on machine)
7.Installation logs for Oracle (stellent) content server should be in $INSTALL_DIR/install directory with file name as log.txt
8.Default login page for content server is http://hostname.domain:webPort/stellent (sysadmin/idc)
9.Main configuration file for stellent content server is $INSTALL_DIR/config/config.cfg
 

To know more about Stellent (now Oracle) Universal Content Management Click Here

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Oracle Gold Partner specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

19 comments
indrajit agasti says September 1, 2008

hi Atul,

I’m facing an issue while installing GRCM 7.8 on Oracle UCM 10gR3.

During GRC Manager Application installation (more precisely Table updatations), it’s throwing an error “ORA-00947 : not enough values” .

Tried with SSOSDBSetupUtility .. had no luck ..
Update Tables is throwing the above error ..

Metalink and Google hits hardly return anything.

Do you have any idea wat sud be my approach to resolve this issue ??

Seems,in UCM 10gR3 there is some change in Table Structure :)

Thx in Advance,
Indrajit

Reply
Atul says September 1, 2008

Is GRC Manager certified with UCM 10gR3 ?

In my opinion install Content Server (7.5.2) and try again or check with Oracle Support.

Reply
indrajit agasti says September 1, 2008

hmmm .. ‘ll try with Stellent 7.5.2 .

But the fact is, Oracle has modified Stellent 7.5.2 to UCM 10gR3, thus there is no more existence of STELLENT .. Unforntunately, Oracle is yet to modify their docs :(

Reply
Atul says September 1, 2008

I tried with Stellenet content server 7.5.2 and GRMC manager on windows and I did manage to install it successfully.
If it doesn’t work with 7.5.2 update here with O.S. Version

Reply
indrajit agasti says September 1, 2008

ok .. Atul if u still have access to the UCM DB,can u kindly chk if any mismatch in the structure of below 9 tables:

(my config is Win Srvr 2003,Oracle DB 10.2.0.3,UCM 10gR3 )

SQL> desc DocMetaDefinition
Name Null? Type
—————————————– ——– ——————

DNAME NOT NULL VARCHAR2(30 CHAR)
DTYPE VARCHAR2(50 CHAR)
DISREQUIRED NOT NULL NUMBER(1)
DISENABLED NOT NULL NUMBER(1)
DISSEARCHABLE NOT NULL NUMBER(1)
DCAPTION VARCHAR2(50 CHAR)
DISOPTIONLIST NOT NULL NUMBER(1)
DOPTIONLISTKEY VARCHAR2(50 CHAR)
DDEFAULTVALUE VARCHAR2(50 CHAR)
DORDER NOT NULL NUMBER(38)
DOPTIONLISTTYPE VARCHAR2(8 CHAR)
DISPLACEHOLDERFIELD NOT NULL NUMBER(1)

SQL> desc DocTypes
Name Null? Type
—————————————– ——– ——————–

DDOCTYPE NOT NULL VARCHAR2(30 CHAR)
DDESCRIPTION VARCHAR2(80 CHAR)
DGIF VARCHAR2(50 CHAR)

SQL> desc OptionsList
Name Null? Type
—————————————– ——– ———————-

DKEY NOT NULL VARCHAR2(50 CHAR)
DOPTION NOT NULL VARCHAR2(50 CHAR)
DORDER NOT NULL NUMBER(38)

SQL> desc RoleDefinition
Name Null? Type
—————————————– ——– ——————–

DROLENAME NOT NULL VARCHAR2(30 CHAR)
DGROUPNAME NOT NULL VARCHAR2(30 CHAR)
DPRIVILEGE NOT NULL NUMBER(38)

SQL> desc SecurityGroups
Name Null? Type
—————————————– ——– ————————

DGROUPNAME NOT NULL VARCHAR2(30 CHAR)
DDESCRIPTION VARCHAR2(80 CHAR)

SQL> desc WorkflowAliases
Name Null? Type
—————————————– ——– ———————-

DWFSTEPID NOT NULL NUMBER(38)
DWFID NUMBER(38)
DALIAS NOT NULL VARCHAR2(50 CHAR)
DALIASTYPE NOT NULL VARCHAR2(20 CHAR)

SQL> desc WorkflowCriteria
Name Null? Type
—————————————– ——– ————————-

DWFID NOT NULL NUMBER(38)
DWFCRITERIANAME NOT NULL VARCHAR2(30 CHAR)
DWFCRITERIAOPERATOR VARCHAR2(8 CHAR)
DWFCRITERIAVALUE VARCHAR2(30 CHAR)

SQL> desc Workflows
Name Null? Type
—————————————– ——– ———————–

DWFNAME VARCHAR2(30 CHAR)
DWFID NOT NULL NUMBER(38)
DWFDESCRIPTION VARCHAR2(80 CHAR)
DCOMPLETIONDATE TIMESTAMP(6)
DSECURITYGROUP VARCHAR2(30 CHAR)
DWFSTATUS VARCHAR2(20 CHAR)
DWFTYPE VARCHAR2(20 CHAR)
DPROJECTID VARCHAR2(30 CHAR)
DISCOLLABORATION NOT NULL NUMBER(1)

SQL> desc WorkflowSteps
Name Null? Type
—————————————– ——– ————————-

DWFSTEPNAME VARCHAR2(30 CHAR)
DWFSTEPID NOT NULL NUMBER(38)
DWFID NUMBER(38)
DWFSTEPDESCRIPTION VARCHAR2(80 CHAR)
DWFSTEPTYPE VARCHAR2(20 CHAR)
DWFSTEPISALL NOT NULL NUMBER(1)
DWFSTEPWEIGHT NUMBER(38)

Reply
indrajit agasti says September 2, 2008

Hi Atul,

installation was successful with Stellent 7.5.2.

but i’m unable to launch GRCM.

Enter the URL to the Stellent Financial Compliance Director web server:

http://in-ccustelnt/oraclegrcmanager

isn’t it the URL to launch GRCM ??

Reply
Atul says September 2, 2008

This is right URL.

Did you do post installation steps ?

How about configuring IIS webserver ?

Is IIS forwarding requests to GRCM ?

Reply
indrajit agasti says September 2, 2008

yes the post installation part is taken care .

IIS configuration ?? sorry ! wat needs to be done ?

http://in-ccustelnt/OracleGRCManager returns
“The Web page can’t be found”

Atul, i unsinstalled GRCM and retried.. still same issue..

Enter the URL to the Stellent Financial Compliance Director web server: wat sud be this value ?? seems here i’m making some mistake.

Reply
indrajit agasti says September 10, 2008

Hi Atul,

i’m unable to view the Business Process.
It throws ORA-12704: character set mismatch

During installantion of Contenet Server,i’ve provided ‘file encoding’ as UTF8 while ‘database
field encoding’ as Native encoding .

Cud it b the reason ? (DB is 10.2.0.3)

Shall i need to provide the 1st entry as ‘default encoding’ ?

Thx..
Indrajit

Reply
Subhankar says December 5, 2008

I am getting the following message while navigating some of the menus in the Oracle GRC Manager

Exception
The ‘OraOLEDB.Oracle’ provider is not registered on the local machine.

Reply
dsharma says February 3, 2009

Hi Atul,
Where can I find the GRC Manager Admin and User guides. I tried on otn website and also on google but cudnt find. Actually I am trying to find out what relation does Access Manager has with GRC Manager. What can be done in between them ? Is there a way in which we can control OAM policies from GRC Manager ?? Please help out…. thanks

Reply
Atul Kumar says February 3, 2009

GRC documentation is available with software in same location (edelivery) check link in post

Reply
mmansour says September 29, 2009

* Can Oracle Content Server be replaced by another content management system, or it is a must for GRC Manager?

* Does Oracle Content Server need separate license with GRC Manager, or it is bundled with GRC Manager with the same license?

Reply
Atul Kumar says September 29, 2009

@ mmansour, as per GRCM 7.8 installation doc only certified content management system is Oracle Content Server 7.5.2 however you can use Microsoft SQL server or Oracle Database as Repository for Oracle Content Server.

For license , please contact your Oracle Sales representative

Reply
mmansour says November 21, 2009

Dear Atul,

It is possible to install more than one Content Server instance, but GRC Manager would be connected to only one Content Server instance, is it right?

If yes, what is the best practice to install a test environment and a production environment for Oracle GRC Manager on the same server?

Reply
mmansour says March 3, 2010

As mentioned in GRC_Suite_Support_Matrix, GRC Manager is not supported on Oracle RAC database

Is there a way to install GRC Manager with High Availabilty options?

And what is the best topology to install (Oracle Database, Content Server, and GRC Manager) to fulfill the High Availability option?

Reply
Sasikumars says February 11, 2011

Can i know the GRCC Updating tables list?

Reply
mahender says October 26, 2012

how much space it require to install the oracle finance R12 software.

Reply
Sasidhar says April 11, 2013

Atul
The above mentioned GRC path is not available now can u pls post the correct one i am not able to find what to download, GRC on edelivery has totally changed

Reply
Add Your Reply