" /> UCS user permission - Genesys CTI User Forum

Author Topic: UCS user permission  (Read 4581 times)

San

  • Guest
UCS user permission
« on: August 06, 2009, 06:51:58 AM »
Advertisement
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

San

  • Guest
Re: UCS not starting
« Reply #1 on: August 06, 2009, 09:43:39 AM »
  • Best Answer
  • 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

    Offline ecki

    • Sr. Member
    • ****
    • Posts: 329
    • Karma: 8
    Re: UCS user permission
    « Reply #2 on: August 06, 2009, 10:11:44 AM »
  • Best Answer
  • 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.