Documentum XCP: 2015

Oracle 12C (1.0.2.0) installation on window 2012 R2 (64 bit) machine

Merge both zip folders in one single folder

SQL queries to create user and test DB

create user corp identified by corp;

If we are getting any error message (e.g. “SQL Error: ORA-65096: invalid common user or role name :--”) , the root cause could be some restrictions introduced in Oracle 12C. i.e.,

If you want to create a user that can admin any of the pluggable databases, prefix the username with C##. For example:

create user c##name identified by password;

To get rid off with this we have to alter the session by executing following SQL:

alter session set "_ORACLE_SCRIPT"=true;

create user corp identified by corp;

grant connect,resource,create view , create sequence to corp;

grant connect,create session, resource to corp;

grant create procedure, dba to corp;

Now change the expiration of user profile:

SELECT profile,username  FROM dba_users WHERE username = 'CORP'

select resource_name,resource_type, limit from dba_profiles where profile='DEFAULT';

select resource_name,resource_type, limit from dba_profiles where profile= 'DEFAULT' and resource_name='PASSWORD_LIFE_TIME';

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

Alter user corp identified by "corp";

In case user is lock, execute the following:

C:\>set ORACLE_SID=corp [Oracle service name]

C:\>sqlplus / as sysdba

SQL> alter user corp account unlock;

User altered.

"lsnrctl start" command or on Windows by starting the listener service.

select * from v$nls_parameters where parameter like '%CHARACTERSET%';

select * from system_privilege_map where name like '%PRIV%';

Select * from dba_users;

SELECT * FROM v$version;

SELECT * FROM v$version WHERE banner LIKE 'Oracle%';

CS 7.2 installation (Oracle 64 bit)

CS 7.2 P03 installation

Unzip the path file

xPlore (1.5 64-bit) Installation

Configuring PrimaryDSearch

Goto the following folder and click on configdsearch.bat

C:\xPlore\setup\dsearch

Now, test following URL:

http://localhost:9300/dsearch

http://localhost:9300/dsearchadmin

Configuring Index agent

Before configuring index agent, please make sure all the relevant services i.e. documentum services and PrimaryDsearch instance should in running state.

Goto the following folder and click on configIndexagent.bat

C:\xPlore\setup\indexagent