Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: San on August 06, 2009, 06:51:58 AM

Title: UCS user permission
Post by: San on August 06, 2009, 06:51:58 AM

Hi,
 I want my UCS DAP to access Oracle DB. Wht kind of permission does the user have to access it. Kindly help me.

Thanks,
San

Title: Re: UCS not starting
Post by: San on August 06, 2009, 09:43:39 AM

Hi,
I am getting the below error while starting UCS...I am using Oracle for the DAP connection

05:39:59.074 Trc 21284 [Ucs-Main] JDBC: com.inet.ora.af: [OraDriver] #3 Connection refused from server. Please check if the Oracle database instance 'DV12.dal' is running.
<(DESCRIPTION=(TMP=)(VSNNUM=169870336)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))>
05:39:59.074 Trc 21284 [Ucs-Main] JDBC: at com.inet.ora.aq.a(Unknown Source)
05:39:59.074 Trc 21284 [Ucs-Main] JDBC: at com.inet.ora.aq.a(Unknown Source)
05:39:59.074 Trc 21284 [Ucs-Main] JDBC: at com.inet.ora.aq.a(Unknown Source)
05:39:59.074 Trc 21284 [Ucs-Main] JDBC: at com.inet.ora.s.j(Unknown Source)
05:39:59.074 Trc 21284 [Ucs-Main] JDBC: at com.inet.ora.s.<init>(Unknown Source)
05:39:59.074 Trc 21284 [Ucs-Main] JDBC: at com.inet.ora.m.<init>(Unknown Source)
05:39:59.074 Trc 21284 [Ucs-Main] JDBC: at com.inet.ora.aq.a(Unknown Source)
05:39:59.074 Trc 21284 [Ucs-Main] JDBC: at com.inet.ora.OraDriver.connect(Unknown Source)
05:39:59.074 Trc 21284 [Ucs-Main] JDBC: at com.inet.ora.OraDataSource.getConnection(Unknown Source)
05:39:59.074 Trc 21284 [Ucs-Main] JDBC: at com.inet.ora.PDataSource.getPooledConnection(Unknown Source)
05:39:59.074 Trc 21284 [Ucs-Main] JDBC: at com.inet.pool.g.b(Unknown Source)
05:39:59.074 Trc 21284 [Ucs-Main] JDBC: at com.inet.pool.PoolManager.a(Unknown Source)
05:39:59.074 Trc 21284 [Ucs-Main] JDBC: at com.inet.pool.PoolManager.getConnection(Unknown Source)
05:39:59.074 Trc 21284 [Ucs-Main] JDBC: at com.inet.ora.PDataSource.getConnection(Unknown Source)
05:39:59.074 Trc 21284 [Ucs-Main] JDBC: at com.genesyslab.util.sql.DataSource.getDatabaseInfo(Unknown Source)
05:39:59.074 Trc 21284 [Ucs-Main] JDBC: at com.genesyslab.util.sql.SeroptoDataSource.<init>(Unknown Source)
05:39:59.074 Trc 21284 [Ucs-Main] JDBC: at com.genesyslab.util.sql.NewDataSourceFactory.createDataSource(Unknown Source)
05:39:59.074 Trc 21284 [Ucs-Main] JDBC: at com.genesyslab.util.sql.NewDataSourceFactory.createDataSource(Unknown Source)
05:39:59.074 Trc 21284 [Ucs-Main] JDBC: at com.genesyslab.icc.contactserver.ContactServerEngine.byte(Unknown Source)
05:39:59.074 Trc 21284 [Ucs-Main] JDBC: at com.genesyslab.icc.contactserver.ContactServerEngine.a(Unknown Source)
05:39:59.074 Trc 21284 [Ucs-Main] JDBC: at com.genesyslab.icc.contactserver.ContactServerEngine.access$400(Unknown Source)
05:39:59.074 Trc 21284 [Ucs-Main] JDBC: at com.genesyslab.icc.contactserver.ContactServerEngine$5.run(Unknown Source)
05:39:59.074 Trc 21284 [Ucs-Main] JDBC: at java.lang.Thread.run(Unknown Source)
05:39:59.074 Trc 21284 [Ucs-Main] JDBC: [OraDriver] #3 Connection.close
05:39:59.074 Std 05066 Initialization of UCS DAP failed, reason 'DataAccessPoint registration failed: [OraDriver] #3 Connection refused from server. Please check if the Oracle database instance 'DV12.dal' is running.
<(DESCRIPTION=(TMP=)(VSNNUM=169870336)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))>'
05:39:59.074 Trc 21007 [Ucs-Main] LCA Status changed to 'Service Unavailable'.


Any pointer to solve this problem wud be helpfull

Title: Re: UCS user permission
Post by: ecki on August 06, 2009, 10:11:44 AM

Hi,

Have you checked the database and/or connection strings in DAP as the log is suggesting?
Have you tried to use the same database credentials and log in to your database using sqlplus from the host, where UCS is installed?

e.