Genesys CTI User Forum
Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Vikas on August 08, 2011, 10:33:26 AM
-
Hi All,
We ran into this problem after installing the DB Server and config server. We are using Oracle 10g database and client is already installed on the server. We could connect to the oracle database using the oracle client. Eveyrhing is installed on the same server. I've already gone through the other posts [below], but everything looks okay.
http://www.sggu.com/smf/index.php?topic=1827.0
http://www.sggu.com/smf/index.php/topic,1761.0.html
Pasted below the the configuration file snippets and the error that we are seeing.
- DB Server config file
[dbserver]
host= localhost
port=4040
management-port =4581
dbprocesses_per_client=10
dbprocess_name=dbclient_oracle
#
oracle_name=./dbclient_oracle
informix_name=./dbclient_informix
msql_name=./dbclient_msql
sybase_name=./dbclient_sybase
db2_name=./dbclient_db2
postgre_name=./dbclient_postgre
#
connect_break_time=1200
tran_batch_mode=off
#
#---------- dbserver log options ----------
#
[log]
verbose=all
all=D:\GCTI\Logs\DBserver\ConfigDBserver_log
#
- Config Server config file
[confserv]
port =4050
management-port =4581
server = dbserver
encryption = false
encoding = utf-8
[log]
verbose = standard
all = stderr,D:\GCTI\Logs\Configserver\Configserver_log
[hca]
schema = none
[soap]
port = [ToBeChanged: soap_port]
[dbserver]
host = localhost
port = 4040
dbengine = oracle
dbserver = CTIDB
username = system
password = manager
server =
reconnect-timeout = 10
response-timeout = 600
- DBServer Log
04:25:32.351 Trc 04112 The Log Output of type 'D:\GCTI\Logs\DBserver\ConfigDBserver_log' has been created and opened
04:25:32.351 Trc 04100 Logging service started
04:25:32.351 Trc 06084 Configuration option set: 'dbserver':'port' = '4040'
04:25:32.351 Trc 06084 Configuration option set: 'dbserver':'host' = 'sasgen01'
04:25:32.351 Trc 06084 Configuration option set: 'dbserver':'management-port' = '4581'
04:25:32.351 Trc 06085 Configuration option set to default value: 'dbserver':'verbose' = '3'
04:25:32.351 Trc 06084 Configuration option set: 'dbserver':'dbprocesses_per_client' = '10'
04:25:32.351 Trc 06085 Configuration option set to default value: 'dbserver':'dbprocess_number' = '255'
04:25:32.351 Trc 06084 Configuration option set: 'dbserver':'dbprocess_name' = 'dbclient_oracle'
04:25:32.351 Trc 06085 Configuration option set to default value: 'dbserver':'db-request-timeout' = '0'
04:25:32.351 Trc 06085 Configuration option set to default value: 'dbserver':'oracle_name' = './dbclient_oracle'
04:25:32.351 Trc 06085 Configuration option set to default value: 'dbserver':'informix_name' = './dbclient_informix'
04:25:32.351 Trc 06085 Configuration option set to default value: 'dbserver':'postgre_name' = './dbclient_postgre'
04:25:32.351 Trc 06085 Configuration option set to default value: 'dbserver':'sybase_name' = './dbclient_sybase'
04:25:32.351 Trc 06085 Configuration option set to default value: 'dbserver':'db2_name' = './dbclient_db2'
04:25:32.351 Trc 06085 Configuration option set to default value: 'dbserver':'msql_name' = './dbclient_msql'
04:25:32.351 Trc 06085 Configuration option set to default value: 'dbserver':'stored_proc_result_table' = '0'
04:25:32.351 Trc 06085 Configuration option set to default value: 'dbserver':'connect_break_time' = '1200'
04:25:32.351 Trc 06085 Configuration option set to default value: 'dbserver':'tran_batch_mode' = '0'
04:25:32.351 Trc 06085 Configuration option set to default value: 'dbserver':'reconnect_timeout' = '3600'
04:25:32.351 Trc 06085 Configuration option set to default value: 'dbserver':'client_stop_timeout' = '30'
04:25:32.351 Trc 06085 Configuration option set to default value: 'lca':'lcaport' = '0'
04:25:32.351 Std 05060 Application started
Open server port: = (
"name" = "dbserver"
"server-type" = "46"
"port" = "4040"
)
04:25:33.430 Std 04525 Port 4040 opened for listening
GServer: new_client: fd=780, found server=784
04:25:37.805 Trc 04521 New client 2280 connected from '206.245.49.79'
04:25:37.821 Dbg 10745 'App: 206.245.49.79:2280' registered; protocol version '1.3' id '1'
04:25:37.821 Dbg 10734 Send message 'MSG_EXTPACKETS' to 'App: 1', request id '0'
04:25:37.821 Dbg 10750 Start client request, dbprocesses per client '1'
04:25:37.821 Dbg 10734 Send message 'MSG_CLIENTSTARTED' to 'App: 1', request id '2'
04:25:37.837 Std 05022 Process './dbclient_oracle' started
04:25:37.837 Dbg 10741 'App: 1' has put request id='4' into queue
04:25:37.915 Std 05020 Cannot start process './dbclient_oracle', error code 128
04:25:37.915 Dbg 10734 Send message 'MSG_CONNLOST' to 'App: 1', request id '4'
04:25:37.915 Dbg 10734 Send message 'MSG_DISCONNECTED' to 'App: 1', request id '-1'
Listener (port id = internal-0-0 fd = 572) 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: 1 is being closed. Current numofclients=1
/./dbclient_oracle
pid = 3504
id = 0
expiration_time = 2011-08-08T04:26:07
client copy = 0
DbClient name =
/Statistics
name = App: 1
req_rcvd = 4
req_sent = 4
data_rcvd = 170
data_send = 83
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 = 1
max_pending_queue_size = 23
Thanks,
-Vikas
-
What errors do you see on the Oarcle side? Are you using the 32 bit Oracle Client?
-
We are using 32 bit oracle client 10.2.0.1.0. We can connect to the server with oracle client and dont see any issues with that.
Cheers,
-Vikas
-
Are you using the correct version of dbclient_oracle?
To find out simply run ./dbclient_oracle at the command line (from the dbserver directory), it should return the Oracle versions it is compatible with.
-
Getting this when I execute the 'dbclient_oracle ',
The application has failed to start because OCI.dll was not found. Reinstalling the application may fix this problem.
We did reinstall of dbserver and config server couple of times. On the other hand we can connect to oracle database using the SQL* plus.
Thanks,
-Vikas
-
Google is your friend...
According to some post the main reason is that your ORACLE_HOME path is not correctly set up
-
We have both database and client on same machine the oracle home refers to the oracle server path and not client. We reisntalled the oracle cleint as well. Now when we execute the 'dbclient_oracle' we get the message. "The application is failed to initialize properly [hex code] Click ok to terminate the application.
We were getting these even before reinstalling the client.
-
I think you should read the DBServer guide and specially the Oracle part. I do remember my first time with Oracle also had some bad time but then solved it by going step by step.
-
When you connect with the client, how do you do it? sqlplus username/password@CTIDB?
Also you are getting an error OCI.dll not found, does it exist? Does "cd $ORACLE_HOME"[sup]1[/sup] get you to the same place?
[sup]1[/sup] I think it is "cd %ORACLE_HOME%" on windows machines.
-
We are able to connect using "sqlplus username/password@CTIDB"
OCI.dll exists in bin folder of client. %ORACLE_HOME% references to the server location [till BIN folder, tried with one level below as well] on the same machine.
And one correction; we are using 64 bit windows 2003 with oracle client 64 bit.
-
The error details are,
Level
Standard
Text
Cannot start process [process name], error code [error code]
Attributes
[process name]
Process name
[error code]
Error code
Description
Reports insufficient permission to start a process.
Alarm Advisory
Indicates abnormal conditions. You might consider setting an Alarm Condition for this event.
The correct Cancel Event is 00-05022.
Actions
Check user permissions.
Does this gives any hints???
-
I don't believe the 64 bit Oracle Client works with DBServer.
Try installing the 32 bit Oracle Client.
-
Thanks Ben et all,
I installed the oracle client 32 bit on local machine and copied the dbclient_oracle there. And after running this file got the result as mentioned by Steve. Now installing the 32 bit oracle client on server to test the DB server. Just wondering if thats the case then why it is not there in any document.
-
[RESOVED]
For the benefit of others.
The issue is resolved after installing the Oracle cleint 32 bit on the local machine. In addition, as referenced in the DB Server user guide ORACLE_HOME should point to the client and ORACLE_SID must be set. And set the PATH to client location till BIN folder
Thanks,
-Vikas