ICS and Oracle 9i

[vivek1]

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.

[René]

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é

[vivek1]

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

Thanks.

[René]

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é

[vivek1]

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.
-------------------------------------

[René]

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é

[vivek1]

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

Thanks!!