ICS and Oracle 9i

General Discussion
1

Currently I am using ICS and oracle 8i. In oracle 8i I was able to use internal id to create mst_intercache table and few procedures. In 9i internal id is not available. Does anyone know what id should I use in 9i instead of “internal” id?

I can use sys id instead of internal id. but sys id can be used as sysdba in 9i. that is why I am not able use sys id.

pls help me.

Thanks in advance.

2

Hi,

Oracle 9.0 and 9.2 is officially supported by Genesys starting ICS 6.5.1 so you should be able to create mst_intercache table using SQL script provided with MS-TServer. Do you have troubles with that script?

René

3 Likes
3

my question is, what oracle id I should use to login before run the script?

Thanks.

4

You should create a new user and use that one to log in and create mst_intercache table. Later you have to use that user to allow ms_tserver access to mst_intercache table (connection parameters specified via DAP in Genesys Configuration).

René

5

i created new user and ran mstserver and received below error.. any idea how to fix the error?

2/12/06 21:25:53.532 Trace nes0ap02 MSTServer651 GCTI-00-04541 Message EndObjectsList received from 724 ( CfgServer )
@21:25:53.5320 [4541] EndObjectsList received from 724 (CfgServer) RedID=32
12/12/06 21:25:54.828 Standard nes0ap02 MSTServer651 GCTI-01-51018 ICache DB error 'ORA-01031: insufficient privileges
ORA-06512: at “ICSUSER.MST_CHECK”, line 225
ORA-06512: at line 2
'.
mstERROR: 21:25:54.8280 ICache DB error 'ORA-01031: insufficient privileges
ORA-06512: at “ICSUSER.MST_CHECK”, line 225
ORA-06512: at line 2
'.
mstERROR: 21:25:54.8280 Error Response: ExId=00001 DbRq=00005 T=2 R=0 W=1
Command: mst_Check ver=5, Rc=@out

12/12/06 21:25:54.844 Standard nes0ap02 MSTServer651 GCTI-01-51017 ICache error ‘Database failed’ during ‘error operation’. Action = Stop & Shutdown.

6

Vivek,

Your issue is caused by insufficient privileges granted to user “ISCUSER”. I found a solved ticket mentioning following permissions have to be granted:

Create Any Table
Create Procedure
Select Any Table

Could you check current permissions assigned to ICSUSER and try again with permissions above?

René

2 Likes
7

Thanks Rene.
Last night I was able to make it work as you suggested.

Thanks!!