Hello Experts,
Can not start dbserver and confserv 7.6 using Oracle.
Please help... I am losing my mind... I am not sure what's happening...
Systems:
dbserver and confserver on guest linux OS (VMware2)
Oracle 11g resides on remote machine (linux OS)
I am able to connect to Oracle via sqlplus successfully.
Oracle variables have been set:
ORACLE_HOME=/instantclient
ORACLE_SID=donna
listener started successfuly
here is my configuration:
[dbserver]
host=192.168.0.77
port=4040
management-port=4041
dbprocesses_per_client=1
dbprocess_name=./dbclient_oracle
#
oracle_name=./dbclient_oracle
informix_name=./dbclient_informix
sybase_name=./dbclient_sybase
db2_name=./dbclient_db2
#
connect_break_time=1200
tran_batch_mode=off
verbose=3
#
#---------- dbserver log options ----------
#
[log]
verbose=all
all=/genesys_logs/dbserver
buffering=false
segment=10mb
#
[lca]
lcaport=4999
----------------- confserv --------------------
[confserv]
port = 2020
management-port = 2021
server = dbserver
encryption = false
encoding = utf-8
[log]
verbose=all
all=/genesys_logs/confserv
[hca]
schema = none
[soap]
port = [pending]
[dbserver]
host = 192.168.0.77
port = 4040
dbengine = oracle
dbserver = donna
# dbname = <required_except_for_oracle>
username = system
password = donna (yes, same as instance)
server =
reconnect-timeout = 10
response-timeout = 600
---------------- LOGS [pls ignore timestamp] ---------------
Build information :
Description : (Content freeze)
Timestamp : Nov 19 2008 13:00:11
Components :
Configuration library v.7.6.000.05
Common library v.7.5.000.38 C2
Service library v.7.5.000.04 MT
Message library v.7.5.000.01
Log library v.7.6.000.00 MT
LCA library v.7.5.000.06
Thread library v.7.6.000.00
DBServer library v.7.5.000.02
Genesys License library v.7.5.000.00 MT
License library v.FLEXLm 9.50
Stat Script library v.7.5.000.00
Application name: confserv
Application type: ConfigurationServer (21)
Command line:
Host name: localhost.localdomain
DST: TZ = 1, timeb = 0
Time zone: 25200, MST, MDT
UTC time: 2009-09-29T18:58:16.655
Local time: 2009-09-29T11:58:16.655
Start time (UTC): 2009-09-29T18:58:16
Running time: 0:00:00:00
Host info: Linux, localhost.localdomain, 2.6.18-128.el5, #1 SMP Wed Jan 21 10:44:23 EST 2009, i686
File: (1) /genesys_logs/confserv.20090929_115816_654.log
11:58:16.655 Trc 04112 The Log Output of type '/genesys_logs/confserv' has been created and opened
11:58:16.655 Std 22110 Encoding [utf-8] is set successfully.
11:58:16.655 Std 05060 Application started
11:58:16.655 Std 22100 Genesys Configuration Server. Version 7.6.000.20
11:58:16.655 Std 22101 Copyright (c) 1997-2008 Genesys Telecommunications Laboratories, Inc.
11:58:16.655 Std 22102 Server application name is set to [confserv]
11:58:16.656 Std 22915 Server mode is set to [PRIMARY]
11:58:16.656 Std 22900 Objectset [main-cfgset] is being loaded ...
11:58:17.119 Std 22901 Objectset [main-cfgset] : XML schema is loaded
11:58:17.287 dbserver_manager with alias main-dbserver has being registered for the socket 6, reference counter 3
11:58:17.287 Trc 04500 Connecting to DBServer '' at host '192.168.0.77', port 4040
11:58:17.287 Std 04503 Connected to DBServer '' at host '192.168.0.77', port 4040
11:58:17.288 Trc 24400 Trying to open database [donna] ,SQL server [donna]
11:58:17.301 Std 04504 Connection to DBServer '' at host '192.168.0.77', port 4040 lost
11:58:17.301 dbserver_manager with alias main-dbserver is about to unregister form socket 6, reference counter 3 (reason - exception)
11:58:22.884 Std 02024 OS signal 'SIGTERM' received
Shutdown timer has being set to finalize network activity, delay - 5 sec
11:58:27.302 dbserver_manager with alias main-dbserver has being registered for the socket 6, reference counter 3
11:58:27.302 Trc 04500 Connecting to DBServer '' at host '192.168.0.77', port 4040
11:58:27.302 Std 04502 Cannot connect to DBServer 'DBServer' at host '192.168.0.77', port 4040, reason 'Server not found'
Main loop has ended
11:58:27.884 Std 05063 Normal termination
11:58:27.911 dbserver_manager with alias main-dbserver is about to unregister form socket -1, reference counter 2 (reason - disconnect)
11:58:27.911 Std 04505 Disconnected from DBServer ''
11:58:27.911 Trc 04109 Logging service stopped
************** DB server logs **********************
Genesys Database Server, Version:'7.6.000.09'
Copyright (c) 1997-2007 Genesys Telecommunications Labs, Inc.
Component versions:
Commonlib: 7.5.000.36 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.03
Lcalib: 7.5.000.06
Build platform: i686-linux-rhe3
Application name: cfg_dbserver
Application type: RealDBServer (46)
Command line: ./multiserver localhost.localdomain -port 2020 -app cfg_dbserver
Host name: localhost.localdomain
DST: TZ = 1, timeb = 0
Time zone: 25200, MST, MDT
UTC time: 2009-09-29T18:58:07.511
Local time: 2009-09-29T11:58:07.511
Start time (UTC): 2009-09-29T18:58:07
Running time: 0:00:00:00
Host info: Linux, localhost.localdomain, 2.6.18-128.el5, #1 SMP Wed Jan 21 10:44:23 EST 2009, i686
File: (1) /genesys_logs/dbserver.20090929_115807_511.log
11:58:07.511 Trc 04112 The Log Output of type '/genesys_logs/dbserver' has been created and opened
11:58:07.509 Trc 04110 Option 'verbose' has been set to the value 'all'
11:58:07.509 Trc 04110 Option 'buffering' has been set to the value 'no'
11:58:07.509 Trc 04110 Option 'expire' has been set to the value 'no'
11:58:07.509 Trc 04110 Option 'segment' has been set to the value '10mb'
11:58:07.509 Trc 04110 Option 'spool' has been set to the value ''
11:58:07.509 Trc 04110 Option 'keep-startup-file' has been set to the value 'no'
11:58:07.509 Trc 04110 Option 'MessageFile' has been set to the value 'RealDBServer.lms'
11:58:07.509 Trc 04110 Option 'time-format' has been set to the value 'time'
11:58:07.509 Trc 04110 Option 'time-convert' has been set to the value 'local'
11:58:07.509 Trc 04110 Option 'message-format' has been set to the value 'short'
11:58:07.509 Trc 04110 Option 'memory-storage-size' has been set to the value '2 Mb'
11:58:07.509 Trc 04110 Option 'compatible-output-priority' has been set to the value 'no'
11:58:07.509 Trc 04110 Option 'print-attributes' has been set to the value 'no'
11:58:07.509 Trc 04110 Option 'check-point' has been set to the value '1'
11:58:07.509 Trc 04110 Option 'memory' has been set to the value ''
11:58:07.511 Std 04106 Log Messages file 'RealDBServer.lms' successfully loaded
11:58:07.511 Trc 04112 The Log Output of type '/genesys_logs/dbserver' has been created and opened
11:58:07.512 Trc 04100 Logging service started
11:58:07.512 Trc 06084 Configuration option set: 'dbserver':'port' = '4040'
11:58:07.512 Trc 06084 Configuration option set: 'dbserver':'host' = '192.168.0.77'
11:58:07.512 Trc 06084 Configuration option set: 'dbserver':'management-port' = '4041'
11:58:07.512 Trc 06085 Configuration option set to default value: 'dbserver':'verbose' = '3'
11:58:07.512 Trc 06085 Configuration option set to default value: 'dbserver':'dbprocesses_per_client' = '1'
11:58:07.512 Trc 06085 Configuration option set to default value: 'dbserver':'dbprocess_number' = '255'
11:58:07.512 Trc 06084 Configuration option set: 'dbserver':'dbprocess_name' = './dbclient_oracle'
11:58:07.512 Trc 06085 Configuration option set to default value: 'dbserver':'oracle_name' = './dbclient_oracle'
11:58:07.512 Trc 06085 Configuration option set to default value: 'dbserver':'informix_name' = './dbclient_informix'
11:58:07.512 Trc 06085 Configuration option set to default value: 'dbserver':'sybase_name' = './dbclient_sybase'
11:58:07.512 Trc 06085 Configuration option set to default value: 'dbserver':'db2_name' = './dbclient_db2'
11:58:07.512 Trc 06085 Configuration option set to default value: 'dbserver':'msql_name' = './dbclient_msql'
11:58:07.512 Trc 06085 Configuration option set to default value: 'dbserver':'stored_proc_result_table' = '0'
11:58:07.512 Trc 06085 Configuration option set to default value: 'dbserver':'connect_break_time' = '1200'
11:58:07.512 Trc 06085 Configuration option set to default value: 'dbserver':'tran_batch_mode' = '0'
11:58:07.512 Trc 06085 Configuration option set to default value: 'dbserver':'reconnect_timeout' = '3600'
11:58:07.512 Trc 06085 Configuration option set to default value: 'dbserver':'client_stop_timeout' = '30'
11:58:07.512 Trc 06084 Configuration option set: 'lca':'lcaport' = '4999'
Open LCALayer on port=4999
LCA Library version 7.5.000.06
Cannot connect to LCA on host localhost.localdomain port 4999
11:58:07.513 Std 05060 Application started
Open server port: = (
"name" = "dbserver"
"server-type" = "46"
"port" = "4040"
)
11:58:07.513 Std 04525 Port 4040 opened for listening
GServer: new_client: fd=8, found server=7
11:58:17.286 Trc 04521 New client 41599 connected from '192.168.0.77'
11:58:17.287 Dbg 10745 'App: 192.168.0.77:41599' registered; protocol version '1.3' id '1'
11:58:17.287 Dbg 10734 Send message 'MSG_EXTPACKETS' to 'App: 1', request id '0'
11:58:17.287 Dbg 10750 Start client request, dbprocesses per client '1'
11:58:17.287 Dbg 10734 Send message 'MSG_CLIENTSTARTED' to 'App: 1', request id '2'
11:58:17.291 Std 05022 Process './dbclient_oracle' started
11:58:17.291 Dbg 10741 'App: 1' has put request id='4' into queue
GServer: new_client: fd=10, found server=9
11:58:17.297 Trc 04521 New client 55754 connected from '192.168.0.77'
11:58:17.297 Dbg 10745 './dbclient_oracle' registered; protocol version '1.3' id '1.1'
11:58:17.298 Dbg 10734 Send message 'MSG_OPENDB' to 'Oracle: 1.1', request id '3'
11:58:17.298 Dbg 10734 Send message 'MSG_EXTPACKETS' to 'App: 1', request id '0'
11:58:17.298 Dbg 10734 Send message 'MSG_EXTPACKET' to 'Oracle: 1.1', request id '0'
11:58:17.299 Dbg 10743 'Oracle: 1.1' is spare
11:58:17.299 Dbg 10739 Unknown: id='' req='-1' ORACLE_HOME is '/usr/lib/oracle'.
+0000 Cannot load libary libclntsh.so, "libclntsh.so: cannot open shared object file: No such file or directory"
Oracle: id='1.1' req='-1'
DBClient Oracle, Copyright (c) 1997-2007 Genesys Telecommunications Labs, Inc.
All Rights Reserved
Db Client version: 7.6.000.09
DB Common part version: 7.6.000.09
Vendor supported versions: "Oracle 8.x 9.2, 10.2"
Build on 'i686-linux-rhe3'
+0000 Connection to multiserver created, host '192.168.0.77', port '37449', socket '4'
+0001 MSG_STARTDB status='DBM_SUCCESS'
Oracle: id='1.1' req='3' Protocols versions: dbclient='00010003' dbserver='00010003' dblib='00010003'
+0000 Open DB: username = 'system', database = '', dbserver = 'donna'
+0000 OCI function OCIInitialize not invoked, oci initialization error
+0000 OCI function OCIEnvInit not invoked, oci initialization error
+0000 Cannot initialize OCI.
+0000 MSG_ERROR status='30'
11:58:17.299 Dbg 10749 Forwarding response '3.1' from 'Oracle: 1.1' to 'App: 1'
11:58:17.299 Dbg 10734 Send message 'MSG_DISCONNECTED' to 'App: 1', request id '-1'
11:58:17.299 Dbg 10734 Send message 'MSG_DISCONNECTED' to 'Oracle: 1.1', request id '-1'
/Statistics
name = Oracle: 1.1
app_name = App: 1
req_rcvd = 5
req_sent = 4
data_rcvd = 1100
data_sent = 127
msg_error = 1
msg_log = 1
Client Oracle: 1.1 is being closed. Current numofclients=0
Listener (port id = internal-0-0 fd = 9) is beingGenesys Database Server, Version:'7.6.000.09'
Copyright (c) 1997-2007 Genesys Telecommunications Labs, Inc.
Component versions:
Commonlib: 7.5.000.36 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.03
Lcalib: 7.5.000.06
Build platform: i686-linux-rhe3
Application name: cfg_dbserver
Application type: RealDBServer (46)
Command line: ./multiserver localhost.localdomain -port 2020 -app cfg_dbserver
Host name: localhost.localdomain
DST: TZ = 1, timeb = 0
Time zone: 25200, MST, MDT
UTC time: 2009-09-29T18:58:07.511
Local time: 2009-09-29T11:58:07.511
Start time (UTC): 2009-09-29T18:58:07
Running time: 0:00:00:00
Host info: Linux, localhost.localdomain, 2.6.18-128.el5, #1 SMP Wed Jan 21 10:44:23 EST 2009, i686
File: (1) /genesys_logs/dbserver.20090929_115807_511.log
11:58:07.511 Trc 04112 The Log Output of type '/genesys_logs/dbserver' has been created and opened
11:58:07.509 Trc 04110 Option 'verbose' has been set to the value 'all'
11:58:07.509 Trc 04110 Option 'buffering' has been set to the value 'no'
11:58:07.509 Trc 04110 Option 'expire' has been set to the value 'no'
11:58:07.509 Trc 04110 Option 'segment' has been set to the value '10mb'
11:58:07.509 Trc 04110 Option 'spool' has been set to the value ''
11:58:07.509 Trc 04110 Option 'keep-startup-file' has been set to the value 'no'
11:58:07.509 Trc 04110 Option 'MessageFile' has been set to the value 'RealDBServer.lms'
11:58:07.509 Trc 04110 Option 'time-format' has been set to the value 'time'
11:58:07.509 Trc 04110 Option 'time-convert' has been set to the value 'local'
11:58:07.509 Trc 04110 Option 'message-format' has been set to the value 'short'
11:58:07.509 Trc 04110 Option 'memory-storage-size' has been set to the value '2 Mb'
11:58:07.509 Trc 04110 Option 'compatible-output-priority' has been set to the value 'no'
11:58:07.509 Trc 04110 Option 'print-attributes' has been set to the value 'no'
11:58:07.509 Trc 04110 Option 'check-point' has been set to the value '1'
11:58:07.509 Trc 04110 Option 'memory' has been set to the value ''
11:58:07.511 Std 04106 Log Messages file 'RealDBServer.lms' successfully loaded
11:58:07.511 Trc 04112 The Log Output of type '/genesys_logs/dbserver' has been created and opened
11:58:07.512 Trc 04100 Logging service started
11:58:07.512 Trc 06084 Configuration option set: 'dbserver':'port' = '4040'
11:58:07.512 Trc 06084 Configuration option set: 'dbserver':'host' = '192.168.0.77'
11:58:07.512 Trc 06084 Configuration option set: 'dbserver':'management-port' = '4041'
11:58:07.512 Trc 06085 Configuration option set to default value: 'dbserver':'verbose' = '3'
11:58:07.512 Trc 06085 Configuration option set to default value: 'dbserver':'dbprocesses_per_client' = '1'
11:58:07.512 Trc 06085 Configuration option set to default value: 'dbserver':'dbprocess_number' = '255'
11:58:07.512 Trc 06084 Configuration option set: 'dbserver':'dbprocess_name' = './dbclient_oracle'
11:58:07.512 Trc 06085 Configuration option set to default value: 'dbserver':'oracle_name' = './dbclient_oracle'
11:58:07.512 Trc 06085 Configuration option set to default value: 'dbserver':'informix_name' = './dbclient_informix'
11:58:07.512 Trc 06085 Configuration option set to default value: 'dbserver':'sybase_name' = './dbclient_sybase'
11:58:07.512 Trc 06085 Configuration option set to default value: 'dbserver':'db2_name' = './dbclient_db2'
11:58:07.512 Trc 06085 Configuration option set to default value: 'dbserver':'msql_name' = './dbclient_msql'
11:58:07.512 Trc 06085 Configuration option set to default value: 'dbserver':'stored_proc_result_table' = '0'
11:58:07.512 Trc 06085 Configuration option set to default value: 'dbserver':'connect_break_time' = '1200'
11:58:07.512 Trc 06085 Configuration option set to default value: 'dbserver':'tran_batch_mode' = '0'
11:58:07.512 Trc 06085 Configuration option set to default value: 'dbserver':'reconnect_timeout' = '3600'
11:58:07.512 Trc 06085 Configuration option set to default value: 'dbserver':'client_stop_timeout' = '30'
11:58:07.512 Trc 06084 Configuration option set: 'lca':'lcaport' = '4999'
Open LCALayer on port=4999
LCA Library version 7.5.000.06
Cannot connect to LCA on host localhost.localdomain port 4999
11:58:07.513 Std 05060 Application started
Open server port: = (
"name" = "dbserver"
"server-type" = "46"
"port" = "4040"
)
11:58:07.513 Std 04525 Port 4040 opened for listening
GServer: new_client: fd=8, found server=7
11:58:17.286 Trc 04521 New client 41599 connected from '192.168.0.77'
11:58:17.287 Dbg 10745 'App: 192.168.0.77:41599' registered; protocol version '1.3' id '1'
11:58:17.287 Dbg 10734 Send message 'MSG_EXTPACKETS' to 'App: 1', request id '0'
11:58:17.287 Dbg 10750 Start client request, dbprocesses per client '1'
11:58:17.287 Dbg 10734 Send message 'MSG_CLIENTSTARTED' to 'App: 1', request id '2'
11:58:17.291 Std 05022 Process './dbclient_oracle' started
11:58:17.291 Dbg 10741 'App: 1' has put request id='4' into queue
GServer: new_client: fd=10, found server=9
11:58:17.297 Trc 04521 New client 55754 connected from '192.168.0.77'
11:58:17.297 Dbg 10745 './dbclient_oracle' registered; protocol version '1.3' id '1.1'
11:58:17.298 Dbg 10734 Send message 'MSG_OPENDB' to 'Oracle: 1.1', request id '3'
11:58:17.298 Dbg 10734 Send message 'MSG_EXTPACKETS' to 'App: 1', request id '0'
11:58:17.298 Dbg 10734 Send message 'MSG_EXTPACKET' to 'Oracle: 1.1', request id '0'
11:58:17.299 Dbg 10743 'Oracle: 1.1' is spare
11:58:17.299 Dbg 10739 Unknown: id='' req='-1' ORACLE_HOME is '/usr/lib/oracle'.
+0000 Cannot load libary libclntsh.so, "libclntsh.so: cannot open shared object file: No such file or directory"
Oracle: id='1.1' req='-1'
DBClient Oracle, Copyright (c) 1997-2007 Genesys Telecommunications Labs, Inc.
All Rights Reserved
Db Client version: 7.6.000.09
DB Common part version: 7.6.000.09
Vendor supported versions: "Oracle 8.x 9.2, 10.2"
Build on 'i686-linux-rhe3'
+0000 Connection to multiserver created, host '192.168.0.77', port '37449', socket '4'
+0001 MSG_STARTDB status='DBM_SUCCESS'
Oracle: id='1.1' req='3' Protocols versions: dbclient='00010003' dbserver='00010003' dblib='00010003'
+0000 Open DB: username = 'system', database = '', dbserver = 'donna'
+0000 OCI function OCIInitialize not invoked, oci initialization error
+0000 OCI function OCIEnvInit not invoked, oci initialization error
+0000 Cannot initialize OCI.
+0000 MSG_ERROR status='30'
11:58:17.299 Dbg 10749 Forwarding response '3.1' from 'Oracle: 1.1' to 'App: 1'
11:58:17.299 Dbg 10734 Send message 'MSG_DISCONNECTED' to 'App: 1', request id '-1'
11:58:17.299 Dbg 10734 Send message 'MSG_DISCONNECTED' to 'Oracle: 1.1', request id '-1'
/Statistics
name = Oracle: 1.1
app_name = App: 1
req_rcvd = 5
req_sent = 4
data_rcvd = 1100
data_sent = 127
msg_error = 1
msg_log = 1
Client Oracle: 1.1 is being closed. Current numofclients=0
Listener (port id = internal-0-0 fd = 9) 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
11:58:17.341 Std 02024 OS signal 'SIGCHLD' received
11:58:17.341 Std 05023 Process './dbclient_oracle' stopped
/./dbclient_oracle
pid = 12567
id = 0
expiration_time = 2009-09-29T11:58:47
client copy = 0
/Statistics
name = App: 1
req_rcvd = 4
req_sent = 5
data_rcvd = 164
data_send = 133
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
GServer (0x8ae1e70) is being removed. numofclients = 0,current numofserveritems = 1
11:58:24.464 Std 02024 OS signal 'SIGINT' received
Listener (port id = dbserver fd = 7) is being closed. Checking for clients on listener...
Listener with port id = dbserver has been closed and deleted from list of current ports. Number of db app connections affected: 0
11:58:24.464 Std 01000 DbServer Exiting
/Process manager statistics
name = ProcessStatistics
error_start_count = 0
successfully_start_count = 1
error_stop_count = 0
successfully_stop_count = 1
unexpected_terminated = 0
time_expired_count = 0
GServer (0x8adab08) is being removed. numofclients = 0,current numofserveritems = 0
11:58:24.464 Trc 04109 Logging service stopped
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
11:58:17.341 Std 02024 OS signal 'SIGCHLD' received
11:58:17.341 Std 05023 Process './dbclient_oracle' stopped
/./dbclient_oracle
pid = 12567
id = 0
expiration_time = 2009-09-29T11:58:47
client copy = 0
/Statistics
name = App: 1
req_rcvd = 4
req_sent = 5
data_rcvd = 164
data_send = 133
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
GServer (0x8ae1e70) is being removed. numofclients = 0,current numofserveritems = 1
11:58:24.464 Std 02024 OS signal 'SIGINT' received
Listener (port id = dbserver fd = 7) is being closed. Checking for clients on listener...
Listener with port id = dbserver has been closed and deleted from list of current ports. Number of db app connections affected: 0
11:58:24.464 Std 01000 DbServer Exiting
/Process manager statistics
name = ProcessStatistics
error_start_count = 0
successfully_start_count = 1
error_stop_count = 0
successfully_stop_count = 1
unexpected_terminated = 0
time_expired_count = 0
GServer (0x8adab08) is being removed. numofclients = 0,current numofserveritems = 0
11:58:24.464 Trc 04109 Logging service stopped
