Leave a Comment:
19 comments
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
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 🙁
Replyok .. 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)
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 ??
Replyyes 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.
ReplyHi 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
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.
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
GRC documentation is available with software in same location (edelivery) check link in post
Reply* 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@ 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
ReplyDear 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?
ReplyAs 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?
Replyhow much space it require to install the oracle finance R12 software.
ReplyAtul
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