Does anyone out there know the correct Oracle Client Software to install on IPIVR servers to allow connections from IPIVR to Oracle Databases?
I have succesful connections to SQL Server databases from our IPIVRs
I have also installed and tested an Oracle Client (Instaclient_11_2) on the Server and tested connectivity to the database in question via ODBC Administrator. I suspect this is the wrong type fo client for IPIVR interoperability.
I have linked the Microsoft ODBC for Oracle driver via this client to the database in question and tested outside of IPIVR o.k.
When I attempt to establish the database in IPIVR, I get an error.
"* One or more of the connection parameters (Datasource Name, User Name or Password) are invalid"
In the MADM logs I get the messages below.
Our Database experts can't help and Searches have turned up a blank apart from fleeting references to others with successful Oracle DB connections.
Anyone out there who can help?
6169: Sep 10 13:54:17.089 EST %MADM-ADM_CFG-7-UNK:EDBSController.writeDatasource() - Starting........................
6170: Sep 10 13:54:17.089 EST %MADM-ADM_CFG-7-UNK:EDBSController.writeDatasource() - datasourceOld:,datasource:TESTCLARIFY,userName:IPIVR,maxConnections:20
6171: Sep 10 13:54:17.089 EST %MADM-ADM_CFG-7-UNK:AppAdminUtil.attemptClusterMutex() - Thread :MADM_ADM_CFG_CLUSTERMUTEX-31-0-ADM_CFG_CLUSTERMUTEX renewing the cluster mutex.
6172: Sep 10 13:54:17.105 EST %MADM-ADM_CFG-7-UNK:EDBSController.writeDatasource() - ConfigNotFoundException occured
6173: Sep 10 13:54:17.105 EST %MADM-ADM_CFG-7-UNK:before trying to test connection
6174: Sep 10 13:54:17.105 EST %MADM-LIB_CLUSTER_CFG-6-MUTEX_SUCCESSFULLY_RENEWED:Mutex successfully renewed: owner=$$##$$%%--1378785257058 CRS Administration, node=1, id=4,usage=Cluster Mutex acquired by EDBS Update.,userInfo=37461,leaseDate=Tue Sep 10 13:55:47 EST 2013
6180: Sep 10 13:54:35.168 EST %MADM-ADM_CFG-3-ADM_EXCEPTION:Unknown ADM Exception: Exception=java.sql.SQLException: [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified
6181: Sep 10 13:54:35.168 EST %MADM-ADM_CFG-3-EXCEPTION:java.sql.SQLException: [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified
Yes, obviously, or I would not have been able to test the connection outside of IPIVR with the instaclient.
2) Did you configure the datasource on the IP IVR/UCCX Data sources page?
Yes, and failed with the error and log messages I posted.
The question I posed was, does anyone know the correct Oracle client to install?
As you know, unlike SQL Server, which does not require a special client, you need a client to get Oracle working, and there must be a specific client or clients which IPIVR expects. Do you know which one? That is the question I need answered. I'm also trying to find out the correct client via my Cisco support contacts, so if you don't know, that's o.k.
Are you getting this error “Installer User Interface Mode Not Supported. The installer cannot run in this UI mode. To specify the interface mode, use the -i command-line option, followed by the UI mode identifier. The value UI mode identifiers...
The below trick might come handy when you have to add a new node to a cluster but you don't have or is unsure of the security password for the publisher. This procedure has been around for ages.
1) Login into the CLI of the Publisher.