" /> Interaction Server + Oracle not working properly - Genesys CTI User Forum

Author Topic: Interaction Server + Oracle not working properly  (Read 8429 times)

Prashant

  • Guest
Interaction Server + Oracle not working properly
« on: July 20, 2009, 03:06:22 PM »
Advertisement
I need to figure out why it is not working.
I want to work with Interaction Server for install Push Preview dialing mode.
Please help me ASAP.


[color=red]Genesys Database Server[/color], Version:'7.6.000.10'
Copyright (c) 1997-2007 Genesys Telecommunications Labs, Inc.
Component versions:
Commonlib:        7.5.000.39 C2
Loglib:          7.6.000.00
Gmessagelib:      7.5.000.01
GServicelib:      7.5.000.04
Mngmlib:          7.5.000.00
Confservlib:      7.6.000.05
Lcalib:          7.5.000.06
Build platform:  i686-winnt
Application name: IXN_DBServer_760
Application type: RealDBServer (46)
Command line:    multiserver.exe -host ORACLEPP -port 2020 -app IXN_DBServer_760
Host name:        ORACLEPP
DST:              TZ = 1, timeb = 1
Time zone:        18000, Eastern Standard Time, Eastern Daylight Time
UTC time:        2003-09-06T14:00:56.578
Local time:      2003-09-06T10:00:56.578
Start time (UTC): 2003-09-06T13:57:58
Running time:    0:00:02:58
Host info:        Windows 5.2.3790, 2, Service Pack 2, 2.0, 0112, 3
File:            (1) E:\GCTI\logs\IXN_DB.20030906_100056_563.log

10:00:56.578 Trc 04112 The Log Output of type 'E:\GCTI\logs\IXN_DB' has been created and opened
GServer: new_client: fd=1844, found server=1876
10:01:03.625 Trc 04521 New client 1206 connected from '192.168.1.119'
10:01:03.640 Dbg 10745 'App: 192.168.1.119:1206' registered; protocol version '1.3' id '12'
10:01:03.640 Dbg 10734 Send message 'MSG_EXTPACKETS' to 'App: 12', request id '0'
10:01:03.640 Dbg 10750 Start client request, dbprocesses per client '1'
10:01:03.640 Dbg 10734 Send message 'MSG_CLIENTSTARTED' to 'App: 12', request id '46'
10:01:03.640 Std 05022 Process './dbclient_oracle' started
GServer: new_client: fd=1824, found server=1856
10:01:03.656 Trc 04521 New client 1208 connected from '192.168.1.119'
10:01:03.656 Dbg 10745 './dbclient_oracle' registered; protocol version '1.3' id '12.1'
10:01:03.656 Dbg 10734 Send message 'MSG_OPENDB' to 'Oracle: 12.1', request id '47'
10:01:03.656 Dbg 10734 Send message 'MSG_EXTPACKETS' to 'App (InteractionServer_761,ORACLEPP,7006)', request id '0'
10:01:03.656 Dbg 10734 Send message 'MSG_EXTPACKET' to 'Oracle: 12.1', request id '0'
10:01:03.656 Dbg 10743 'Oracle: 12.1' is spare
10:01:03.703 Dbg 10739 Oracle: id='12.1' req='-1'
DBClient Oracle, Copyright (c) 1997-2007 Genesys Telecommunications Labs, Inc.
All Rights Reserved
Db Client version:        7.6.000.10
DB Common part version:    7.6.000.10
Vendor supported versions: "Oracle 8.x 9.2, 10.2"
Build on 'i686-winnt'
+0015  Connection to multiserver created, host 'ORACLEPP', port '1207', socket '112'
+0015  MSG_STARTDB status='12'
Oracle: id='12.1' req='47' Protocols versions: dbclient='00010003' dbserver='00010003' dblib='00010003'
+0000  Open DB: username = 'system', database = 'GENCONFI', dbserver = 'ORACLEPP'
+0047  ocierror: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

+0047  MSG_ERROR status='30' msg='ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
'

10:01:03.703 Dbg 10749 Forwarding response '47.1' from 'Oracle: 12.1' to 'App (InteractionServer_761,ORACLEPP,7006)'
10:01:03.703 Dbg 10734 Send message 'MSG_DISCONNECTED' to 'App (InteractionServer_761,ORACLEPP,7006)', request id '-1'
10:01:03.703 Dbg 10734 Send message 'MSG_DISCONNECTED' to 'Oracle: 12.1', request id '-1'
  /Statistics             
    name                      = Oracle: 12.1
    app_name                  = App (InteractionServer_761,ORACLEPP,7006)
    req_rcvd                  = 5
    req_sent                  = 3
    data_rcvd                = 1157
    data_sent                = 119
    msg_error                = 1
    msg_log                  = 1
Client Oracle: 12.1 is being closed. Current numofclients=0
Listener (port id = internal-0-0 fd = 1856) is being closed. Checking for clients on listener...
Listener with port id = internal-0-0 has been closed and deleted from list of current ports. Number of db app connections affected: 0
Client App (InteractionServer_761,ORACLEPP,7006) is being closed. Current numofclients=1
  /Statistics             
    name                      = App (InteractionServer_761,ORACLEPP,7006)
    req_rcvd                  = 5
    req_sent                  = 5
    data_rcvd                = 270
    data_send                = 232
    invalid_params            = 0
    abandoned_req            = 0
    abandon_req_fail          = 0
    error_start_client        = 0
    invalid_register_req      = 0
    msg_error                = 0
    pending_requests          = 0
    pending_queue_size        = 0
    max_pending_requests      = 0
    max_pending_queue_size    = 0
GServer (0xb2cb78) is being removed. numofclients = 0,current numofserveritems = 1
10:01:03.765 Std 05023 Process './dbclient_oracle' stopped
  /./dbclient_oracle       
    pid                      = 3628
    id                        = 11
    expiration_time          = 2003-09-06T10:01:33
    client copy              = 0
GServer: new_client: fd=1828, found server=1876
10:01:18.718 Trc 04521 New client 1210 connected from '192.168.1.119'
10:01:18.734 Dbg 10745 'App: 192.168.1.119:1210' registered; protocol version '1.3' id '13'
10:01:18.734 Dbg 10734 Send message 'MSG_EXTPACKETS' to 'App: 13', request id '0'
10:01:18.734 Dbg 10750 Start client request, dbprocesses per client '1'
10:01:18.734 Dbg 10734 Send message 'MSG_CLIENTSTARTED' to 'App: 13', request id '50'
10:01:18.734 Std 05022 Process './dbclient_oracle' started
GServer: new_client: fd=1868, found server=1856
10:01:18.750 Trc 04521 New client 1212 connected from '192.168.1.119'
10:01:18.750 Dbg 10745 './dbclient_oracle' registered; protocol version '1.3' id '13.1'
10:01:18.750 Dbg 10734 Send message 'MSG_OPENDB' to 'Oracle: 13.1', request id '51'
10:01:18.750 Dbg 10734 Send message 'MSG_EXTPACKETS' to 'App (InteractionServer_761,ORACLEPP,7006)', request id '0'
10:01:18.750 Dbg 10734 Send message 'MSG_EXTPACKET' to 'Oracle: 13.1', request id '0'
10:01:18.750 Dbg 10743 'Oracle: 13.1' is spare
10:01:18.796 Dbg 10739 Oracle: id='13.1' req='-1'
DBClient Oracle, Copyright (c) 1997-2007 Genesys Telecommunications Labs, Inc.
All Rights Reserved
Db Client version:        7.6.000.10
DB Common part version:    7.6.000.10
Vendor supported versions: "Oracle 8.x 9.2, 10.2"
Build on 'i686-winnt'
+0015  Connection to multiserver created, host 'ORACLEPP', port '1211', socket '112'
+0015  MSG_STARTDB status='13'
Oracle: id='13.1' req='51' Protocols versions: dbclient='00010003' dbserver='00010003' dblib='00010003'
+0000  Open DB: username = 'system', database = 'GENCONFI', dbserver = 'ORACLEPP'
+0047  ocierror: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

+0047  MSG_ERROR status='30' msg='ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
'

10:01:18.796 Dbg 10749 Forwarding response '51.1' from 'Oracle: 13.1' to 'App (InteractionServer_761,ORACLEPP,7006)'
10:01:18.796 Dbg 10734 Send message 'MSG_DISCONNECTED' to 'App (InteractionServer_761,ORACLEPP,7006)', request id '-1'
10:01:18.796 Dbg 10734 Send message 'MSG_DISCONNECTED' to 'Oracle: 13.1', request id '-1'
  /Statistics             
    name                      = Oracle: 13.1
    app_name                  = App (InteractionServer_761,ORACLEPP,7006)
    req_rcvd                  = 5
    req_sent                  = 3
    data_rcvd                = 1157
    data_sent                = 119
    msg_error                = 1
    msg_log                  = 1
Client Oracle: 13.1 is being closed. Current numofclients=0
Listener (port id = internal-0-0 fd = 1856) is being closed. Checking for clients on listener...
Listener with port id = internal-0-0 has been closed and deleted from list of current ports. Number of db app connections affected: 0
Client App (InteractionServer_761,ORACLEPP,7006) is being closed. Current numofclients=1
10:01:18.859 Std 05023 Process './dbclient_oracle' stopped
  /./dbclient_oracle       
    pid                      = 3280
    id                        = 12
    expiration_time          = 2003-09-06T10:01:48
    client copy              = 0
  /Statistics             
    name                      = App (InteractionServer_761,ORACLEPP,7006)
    req_rcvd                  = 5
    req_sent                  = 5
    data_rcvd                = 270
    data_send                = 232
    invalid_params            = 0
    abandoned_req            = 0
    abandon_req_fail          = 0
    error_start_client        = 0
    invalid_register_req      = 0
    msg_error                = 0
    pending_requests          = 0
    pending_queue_size        = 0
    max_pending_requests      = 0
    max_pending_queue_size    = 0
GServer (0xb2cb78) is being removed. numofclients = 0,current numofserveritems = 1
GServer: new_client: fd=1832, found server=1876
10:01:33.796 Trc 04521 New client 1217 connected from '192.168.1.119'
10:01:33.812 Dbg 10745 'App: 192.168.1.119:1217' registered; protocol version '1.3' id '14'
10:01:33.812 Dbg 10734 Send message 'MSG_EXTPACKETS' to 'App: 14', request id '0'
10:01:33.812 Dbg 10750 Start client request, dbprocesses per client '1'
10:01:33.812 Dbg 10734 Send message 'MSG_CLIENTSTARTED' to 'App: 14', request id '54'
10:01:33.812 Std 05022 Process './dbclient_oracle' started
GServer: new_client: fd=1864, found server=1856
10:01:33.828 Trc 04521 New client 1219 connected from '192.168.1.119'
10:01:33.828 Dbg 10745 './dbclient_oracle' registered; protocol version '1.3' id '14.1'
10:01:33.828 Dbg 10734 Send message 'MSG_OPENDB' to 'Oracle: 14.1', request id '55'
10:01:33.828 Dbg 10734 Send message 'MSG_EXTPACKETS' to 'App (InteractionServer_761,ORACLEPP,7006)', request id '0'
10:01:33.828 Dbg 10734 Send message 'MSG_EXTPACKET' to 'Oracle: 14.1', request id '0'
10:01:33.828 Dbg 10743 'Oracle: 14.1' is spare
10:01:33.875 Dbg 10739 Oracle: id='14.1' req='-1'
DBClient Oracle, Copyright (c) 1997-2007 Genesys Telecommunications Labs, Inc.
All Rights Reserved
Db Client version:        7.6.000.10
DB Common part version:    7.6.000.10
Vendor supported versions: "Oracle 8.x 9.2, 10.2"
Build on 'i686-winnt'
+0015  Connection to multiserver created, host 'ORACLEPP', port '1218', socket '112'
+0015  MSG_STARTDB status='14'
Oracle: id='14.1' req='55' Protocols versions: dbclient='00010003' dbserver='00010003' dblib='00010003'
+0000  Open DB: username = 'system', database = 'GENCONFI', dbserver = 'ORACLEPP'
+0047  ocierror: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

+0047  MSG_ERROR status='30' msg='ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
'

10:01:33.875 Dbg 10749 Forwarding response '55.1' from 'Oracle: 14.1' to 'App (InteractionServer_761,ORACLEPP,7006)'
10:01:33.875 Dbg 10734 Send message 'MSG_DISCONNECTED' to 'App (InteractionServer_761,ORACLEPP,7006)', request id '-1'
10:01:33.875 Dbg 10734 Send message 'MSG_DISCONNECTED' to 'Oracle: 14.1', request id '-1'
  /Statistics             
    name                      = Oracle: 14.1
    app_name                  = App (InteractionServer_761,ORACLEPP,7006)
    req_rcvd                  = 5
    req_sent                  = 3
    data_rcvd                = 1157
    data_sent                = 119
    msg_error                = 1
    msg_log                  = 1
Client Oracle: 14.1 is being closed. Current numofclients=0
Listener (port id = internal-0-0 fd = 1856) is being closed. Checking for clients on listener...
Listener with port id = internal-0-0 has been closed and deleted from list of current ports. Number of db app connections affected: 0
Client App (InteractionServer_761,ORACLEPP,7006) is being closed. Current numofclients=1
10:01:33.953 Std 05023 Process './dbclient_oracle' stopped
  /./dbclient_oracle       
    pid                      = 3472
    id                        = 13
    expiration_time          = 2003-09-06T10:02:03
    client copy              = 0
  /Statistics             
    name                      = App (InteractionServer_761,ORACLEPP,7006)
    req_rcvd                  = 5
    req_sent                  = 5
    data_rcvd                = 270
    data_send                = 232
    invalid_params            = 0
    abandoned_req            = 0
    abandon_req_fail          = 0
    error_start_client        = 0
    invalid_register_req      = 0
    msg_error                = 0
    pending_requests          = 0
    pending_queue_size        = 0
    max_pending_requests      = 0
    max_pending_queue_size    = 0
GServer (0xb2cb78) is being removed. numofclients = 0,current numofserveritems = 1
10:03:03.546 Std 02024 OS signal 'SIGINT' received
Listener (port id = default fd = 1876) is being closed. Checking for clients on listener...
Listener with port id = default has been closed and deleted from list of current ports. Number of db app connections affected: 0
10:03:03.656 Std 01000 DbServer Exiting
  /Process manager statistics
    name                      = ProcessStatistics
    error_start_count        = 0
    successfully_start_count  = 14
    error_stop_count          = 0
    successfully_stop_count  = 14
    unexpected_terminated    = 0
    time_expired_count        = 0
GServer (0xa94b14) is being removed. numofclients = 0,current numofserveritems = 0
10:03:03.656 Trc 04109 Logging service stopped





Application name: [color=red]InteractionServer_761[/color]
Application type: InteractionServer (111)
Command line:    interaction_server.exe -host ORACLEPP -port 2020 -app InteractionServer_761
Host name:        ORACLEPP
DST:              TZ = 1, timeb = 1
Time zone:        18000, Eastern Standard Time, Eastern Daylight Time
UTC time:        2003-09-06T14:00:13.156
Local time:      2003-09-06T10:00:13.156
Start time (UTC): 2003-09-06T13:58:15
Running time:    0:00:01:58
Host info:        Windows 5.2.3790, 2, Service Pack 2, 2.0, 0112, 3
File:            (1) E:\GCTI\logs\IXN_S.20030906_100013_157.log

10:00:13.156 Trc 04112 The Log Output of type 'E:\GCTI\logs\IXN_S' has been created and opened
10:00:18.359 Trc 04500 Connecting to primary DBServer 'IXN_DBServer_760' at host 'ORACLEPP', port 7005
10:00:18.375 Std 04503 Connected to primary DBServer 'IXN_DBServer_760' at host 'ORACLEPP', port 7005
10:00:18.375 Std 04503 Connected to IXN_DBServer_760 'oracle' at host 'ORACLEPP', port 7005
10:00:18.375 Std 25002 Trying to open database:'ORACLEPP:oracle', DBServer:'IXN_DBServer_760', DAP:'IXN_DAP_760'
10:00:18.437 Std 25005 Database:'ORACLEPP:oracle', DBServer:'IXN_DBServer_760', DAP:'IXN_DAP_760' is closed
10:00:18.437 Std 04504 Connection to primary DBServer 'IXN_DBServer_760' at host 'ORACLEPP', port 7005 lost
10:00:33.453 Trc 04500 Connecting to primary DBServer 'IXN_DBServer_760' at host 'ORACLEPP', port 7005
10:00:33.468 Std 04503 Connected to primary DBServer 'IXN_DBServer_760' at host 'ORACLEPP', port 7005
10:00:33.468 Std 04503 Connected to IXN_DBServer_760 'oracle' at host 'ORACLEPP', port 7005
10:00:33.468 Std 25002 Trying to open database:'ORACLEPP:oracle', DBServer:'IXN_DBServer_760', DAP:'IXN_DAP_760'
10:00:33.531 Std 25005 Database:'ORACLEPP:oracle', DBServer:'IXN_DBServer_760', DAP:'IXN_DAP_760' is closed
10:00:33.531 Std 04504 Connection to primary DBServer 'IXN_DBServer_760' at host 'ORACLEPP', port 7005 lost
10:00:48.531 Trc 04500 Connecting to primary DBServer 'IXN_DBServer_760' at host 'ORACLEPP', port 7005
10:00:48.546 Std 04503 Connected to primary DBServer 'IXN_DBServer_760' at host 'ORACLEPP', port 7005
10:00:48.546 Std 04503 Connected to IXN_DBServer_760 'oracle' at host 'ORACLEPP', port 7005
10:00:48.546 Std 25002 Trying to open database:'ORACLEPP:oracle', DBServer:'IXN_DBServer_760', DAP:'IXN_DAP_760'
10:00:48.609 Std 25005 Database:'ORACLEPP:oracle', DBServer:'IXN_DBServer_760', DAP:'IXN_DAP_760' is closed
10:00:48.609 Std 04504 Connection to primary DBServer 'IXN_DBServer_760' at host 'ORACLEPP', port 7005 lost
10:01:03.625 Trc 04500 Connecting to primary DBServer 'IXN_DBServer_760' at host 'ORACLEPP', port 7005
10:01:03.640 Std 04503 Connected to primary DBServer 'IXN_DBServer_760' at host 'ORACLEPP', port 7005
10:01:03.640 Std 04503 Connected to IXN_DBServer_760 'oracle' at host 'ORACLEPP', port 7005
10:01:03.640 Std 25002 Trying to open database:'ORACLEPP:oracle', DBServer:'IXN_DBServer_760', DAP:'IXN_DAP_760'
10:01:03.703 Std 25005 Database:'ORACLEPP:oracle', DBServer:'IXN_DBServer_760', DAP:'IXN_DAP_760' is closed
10:01:03.703 Std 04504 Connection to primary DBServer 'IXN_DBServer_760' at host 'ORACLEPP', port 7005 lost
10:01:18.718 Trc 04500 Connecting to primary DBServer 'IXN_DBServer_760' at host 'ORACLEPP', port 7005
10:01:18.734 Std 04503 Connected to primary DBServer 'IXN_DBServer_760' at host 'ORACLEPP', port 7005
10:01:18.734 Std 04503 Connected to IXN_DBServer_760 'oracle' at host 'ORACLEPP', port 7005
10:01:18.734 Std 25002 Trying to open database:'ORACLEPP:oracle', DBServer:'IXN_DBServer_760', DAP:'IXN_DAP_760'
10:01:18.796 Std 25005 Database:'ORACLEPP:oracle', DBServer:'IXN_DBServer_760', DAP:'IXN_DAP_760' is closed
10:01:18.796 Std 04504 Connection to primary DBServer 'IXN_DBServer_760' at host 'ORACLEPP', port 7005 lost
10:01:33.796 Trc 04500 Connecting to primary DBServer 'IXN_DBServer_760' at host 'ORACLEPP', port 7005
10:01:33.812 Std 04503 Connected to primary DBServer 'IXN_DBServer_760' at host 'ORACLEPP', port 7005
10:01:33.812 Std 04503 Connected to IXN_DBServer_760 'oracle' at host 'ORACLEPP', port 7005
10:01:33.812 Std 25002 Trying to open database:'ORACLEPP:oracle', DBServer:'IXN_DBServer_760', DAP:'IXN_DAP_760'
10:01:33.875 Std 25005 Database:'ORACLEPP:oracle', DBServer:'IXN_DBServer_760', DAP:'IXN_DAP_760' is closed
10:01:33.875 Std 04504 Connection to primary DBServer 'IXN_DBServer_760' at host 'ORACLEPP', port 7005 lost
10:01:48.640 Std 02024 OS signal 'Console closed' received
10:01:48.640 Std 01000 InteractionServer_761 Exiting
10:01:48.656 Trc 55014 Closing server port (connection 1444)...
10:01:48.656 Trc 55015 Server port has been closed (connection 1444)...
10:01:48.656 Std 04504 Connection to primary DBServer 'IXN_DBServer_760' at host 'ORACLEPP', port 7005 lost
10:01:48.687 Trc 04109 Logging service stopped



Great Thanks,
Have a nice time.

Offline René

  • Administrator
  • Hero Member
  • *****
  • Posts: 1832
  • Karma: 62
Re: Interaction Server + Oracle not working properly
« Reply #1 on: July 20, 2009, 04:28:07 PM »
  • Best Answer
  • Hi,

    Your issue is caused by wrong configuration - unknown TNS name - of DAP used by Interaction Server

    [i] +0000  Open DB: username = 'system', database = 'GENCONFI', dbserver = 'ORACLEPP'
    +0047  ocierror: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
    [/i]
    Please ensure that value of the attribute "DBMS Name" on "DB Info" tab is valid Oracle TNS Name.

    R.

    Prashant

    • Guest
    Re: Interaction Server + Oracle not working properly
    « Reply #2 on: July 20, 2009, 06:30:14 PM »
  • Best Answer
  • In configuration server and dbserver same configuration are there.
    It is running fine.
    Y it is not taking here.
    How I can make change in TNS name.

    Thanks,
    Have a nice time.

    Offline cavagnaro

    • Administrator
    • Hero Member
    • *****
    • Posts: 7641
    • Karma: 56330
    Re: Interaction Server + Oracle not working properly
    « Reply #3 on: July 21, 2009, 12:05:54 AM »
  • Best Answer
  • Talk to the Oracle guy to give you the correct values.

    Offline René

    • Administrator
    • Hero Member
    • *****
    • Posts: 1832
    • Karma: 62
    Re: Interaction Server + Oracle not working properly
    « Reply #4 on: July 21, 2009, 06:16:05 PM »
  • Best Answer
  • Prashant,

    There are two places you have to check. The first one is Genesys Configuration. The seconds one is Oracle TNS listener configuration.

    1/ CME
    Check that DAP used by Interaction Server is configured properly. I'm quite sure it isn't because specified TNS name - ORACLEPP - is the same as host name where Genesys DB Server is running. Such configuration is possible but not very common.

    [i]Oracle: id='12.1' req='47' Protocols versions: dbclient='00010003' dbserver='00010003' dblib='00010003'
    +0000  Open DB: username = 'system', database = 'GENCONFI', [b]dbserver = 'ORACLEPP'[/b][/i]

    2/ Oracle TNS
    If specified TNS name - ORACLEPP - is correct then you should check configuration of Oracle client on host where Genesys DB Server is running. Ask your Oracle admin to help you with that if you are not familiar with Oracle configuration.

    R.

    Prashant

    • Guest
    Re: Interaction Server + Oracle not working properly
    « Reply #5 on: July 22, 2009, 01:56:43 PM »
  • Best Answer
  • Thanks Rene,

    My Oracle_SID = GENCONFI
    MY ORACLE_HOSTNAME = ORACLEPP
    Now i am searching the dbserver.cfg file to make change in it.
    But only DBServer had that file but no other Interaction_DBSErver, OCS_DBServer had it.
    My Oracle Network had TNSNAME.ora file and the details it had are same which i am providing in my Interaction_DAP database DBINFO.
    Anything i m missing from myside. Please let me know.

    Thanks a lot ALL OF YOU.

    Prashant

    • Guest
    Re: Interaction Server + Oracle not working properly
    « Reply #6 on: July 22, 2009, 02:16:41 PM »
  • Best Answer
  • TNSNAME.ora

    # tnsnames.ora Network Configuration File: C:\Oracle\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.

    GENCONFI =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = ORACLEPP)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = genconfig)
        )
      )

    IXNDB =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = ORACLEPP)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = IXNDB)
        )
      )

    EXTPROC_CONNECTION_DATA =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
        )
        (CONNECT_DATA =
          (SID = PLSExtProc)
          (PRESENTATION = RO)
        )
      )

    LISTENER.ora
    # listener.ora Network Configuration File: C:\Oracle\network\admin\listener.ora
    # Generated by Oracle configuration tools.

    SID_LIST_LISTENER =
      (SID_LIST =
        (SID_DESC =
          (SID_NAME = PLSExtProc)
          (ORACLE_HOME = C:\Oracle)
          (PROGRAM = extproc)
        )
      )

    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
          (ADDRESS = (PROTOCOL = TCP)(HOST = ORACLEPP)(PORT = 1521))
        )
      )

    Am I missing something here.

    Thanks,
    Have a wonderful time.

    Offline René

    • Administrator
    • Hero Member
    • *****
    • Posts: 1832
    • Karma: 62
    Re: Interaction Server + Oracle not working properly
    « Reply #7 on: July 22, 2009, 02:42:21 PM »
  • Best Answer
  • Prashant,

    As I've written in my post you have to modify DAP. There is no dbserver.cfg file for DBServer that is client of Configuration Server.

    Here are the steps you have to do:

    1/ Open Genesys Configuration Manager (CME) and logs in
    2/ Find application named "IXN_DAP_760" and open properties of it
    3/ Go to tab "DB Info"
    4/ Set parameters as listed below:

        DBMS Name: IXNDB  [i]<--- this is TNS name defined in your tnsnames.ora file[/i]
        DBMS Type: oracle
        Database Name: <...leave empty...>  [i]<--- this attribute isn't used for Oracle DBMS[/i]

        User name: <...enter valid user name...>
        Password: <...enter valid password...>
        Re-enter Password: <...enter valid password...>

    5/ Apply changes by clicking "OK" button
    6/ Check that required database structure was created in the database IXNDB
    7/ Restart Interaction Server

    R.

    Prashant

    • Guest
    Re: Interaction Server + Oracle not working properly
    « Reply #8 on: July 22, 2009, 05:54:43 PM »
  • Best Answer
  • Thanks Gene,

    Now its working.
    DBMS Name: IXNDB  <--- here i made changes and it is working fine.
    DBMS Type: oracle
    Database Name: <...leave empty...>  <--- this attribute isn't used for Oracle DBMS

    Once again , thanks a lot.
    Have a wonderful time.