Genesys CTI User Forum
Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Prashant on June 19, 2009, 09:18:30 PM
-
Hello Everybody,
Hope you are doing wonderful.
I need to install DB Server and Configuration Server in my vmware with OS as Win2003.
At the same moment I am using Oracle 10g as Database.
I had never done before so curious what i should take care before installing.
But still want to know how to continue installation of DB Server and Configuration server are connected without any error.
Thanks a lot,
Have a nice time.
-
Just install oracle client on your DBServer host and that is it, just follow the DBServer deployment guide.
-
Make sure you use the correct version of the Oracle Client, in the db-server directory run
[color=blue]dbclient_oracle_x_32 -v [/color]
do a dir to find all the values of x, I think there is a dbclient_oracle_d_32 & dbclient_oracle_s_32, but check
You will have different versions for both 32 and 64 bit operating systems, the -v option will tell you which Oracle version the file works with.
Then create a shortcut called [color=blue]dbclient_oracle[/color] pointing to the correct one. You can then refer to the shortcut in your .cfg file.
-
Hello Sir,
My DB Server gives me this error.
[color=red]+0000 ocierror: ORA-24324: service handle not initialized[/color]
and my Config Server is giving me this error.
11:32:23.562 Std 04503 Connected to DBServer '' at host 'WIN2003OS', port 4040
[color=red]11:32:23.625 Std 04504 Connection to DBServer '' at host 'WIN2003OS', port 4040
lost.[/color]
Please let me know .... what I am missing.
My OS is 32 bit system.
Thanks a lot,
Have a nice time.
-
I suggest you google for ORA-24324.
There are a variety of reason for this error, but all are based around the database and the listener not being started correctly.
-
This error is coming for all version 7.2,7.5 and 7.6.
I have check the google.
I had set the path ORACLE_HOME,ORACLE_SID.
Still it is giving me the same problem.
Please let me know , if something else is to be done.
Great Thanks,
Prashant.
-
Can you connect to the database from the DB-Server machine using SQL-Plus, using the same username and password that is in your confserv.cfg file?
-
Yes Sir,
I am not able to connect DBServer through same username & password.
I had also checked the confserv.conf file.
Thanks,
Prashant.
-
But I am able to start SQL*PLUS Oracle10g using the same username & password.
thanks,
Prashant.
-
Please post your dbserver and config server conf files.
-
Hello Sir,
DBSERVER.cfg
[dbserver]
host=WIN2003OS
port=4040
management-port =4581
dbprocesses_per_client=1
dbprocess_name=./dbclient_oracle
#
oracle_name=./dbclient_oracle
informix_name=./dbclient_informix
msql_name=./dbclient_msql
sybase_name=./dbclient_sybase
db2_name=./dbclient_db2
#
connect_break_time=1200
tran_batch_mode=off
#
#---------- dbserver log options ----------
#
[log]
verbose=standard
all=stderr
CONFIGSERVER.cfg
[confserv]
port =2020
management-port =2021
server = dbserver
encryption = false
encoding = utf-8
[log]
verbose = standard
all = stderr
[hca]
schema = none
[soap]
port = [ToBeChanged: soap_port]
[dbserver]
host =WIN2003OS
port =4040
dbengine =oracle
dbserver =WIN2003OS
username =system
password =oracle10g
server =
reconnect-timeout = 10
response-timeout = 600
Thanks a lot,
Have a nice day.
-
Your config files looks Ok
Turn the your dbserver logs like behind and restart it then take a look for errors in the DBServer Logfile
DBSERVER.cfg
[dbserver]
host=WIN2003OS
port=4040
management-port =4581
dbprocesses_per_client=1
dbprocess_name=./dbclient_oracle
#
oracle_name=./dbclient_oracle
informix_name=./dbclient_informix
msql_name=./dbclient_msql
sybase_name=./dbclient_sybase
db2_name=./dbclient_db2
#
connect_break_time=1200
tran_batch_mode=off
[color=red][b]verbose=3[/b][/color]
#
#---------- dbserver log options ----------
#
[color=red][b][log]
verbose=standard
expire=5
segment=5000
all=D:\Genesys-Logs\CfgDBServer,stderr[/b][/color]
(choose a valid directory for the logfile)
-
Genesys Database Server, 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: cfg_dbserver
Application type: RealDBServer (46)
Command line: multiserver.exe -host WIN2003OS -port 2020 -app cfg_dbserver
Host name: Win2003OS
DST: TZ = 1, timeb = 1
Time zone: 18000, Eastern Standard Time, Eastern Daylight Time
UTC time: 2009-07-02T13:32:17.703
Local time: 2009-07-02T09:32:17.703
Start time (UTC): 2009-07-02T13:32:16
Running time: 0:00:00:01
Host info: Windows 5.2.3790, 2, Service Pack 2, 2.0, 0112, 3
File: (1) C:\GCTI\DBServer_76\logDB.log.20090702_093217_704.log
09:32:17.703 Std 04106 Log Messages file 'RealDBServer.lms' successfully loaded
09:32:17.718 Std 05060 Application started
09:32:18.781 Std 04525 Port 4040 opened for listening
09:32:45.046 Std 05022 Process './dbclient_oracle' started
09:32:47.671 Std 05023 Process './dbclient_oracle' stopped
09:32:57.531 Std 05022 Process './dbclient_oracle' started
09:32:57.656 Std 05023 Process './dbclient_oracle' stopped
09:33:07.593 Std 05022 Process './dbclient_oracle' started
09:33:07.828 Std 05023 Process './dbclient_oracle' stopped
09:33:17.718 Std 05022 Process './dbclient_oracle' started
09:33:18.546 Std 05023 Process './dbclient_oracle' stopped
09:33:28.453 Std 05022 Process './dbclient_oracle' started
09:33:28.640 Std 05023 Process './dbclient_oracle' stopped
09:33:38.546 Std 05022 Process './dbclient_oracle' started
09:33:38.734 Std 05023 Process './dbclient_oracle' stopped
09:33:48.671 Std 05022 Process './dbclient_oracle' started
09:33:49.687 Std 05023 Process './dbclient_oracle' stopped
09:33:59.562 Std 05022 Process './dbclient_oracle' started
09:33:59.750 Std 05023 Process './dbclient_oracle' stopped
09:34:09.671 Std 05022 Process './dbclient_oracle' started
09:34:09.906 Std 05023 Process './dbclient_oracle' stopped
09:34:14.609 Std 02024 OS signal 'SIGINT' received
09:34:14.718 Std 01000 DbServer Exiting
-
This log isn't with verbose=all
Seems you've started your DBServer with the command line so the logs are turned to stderr
If you write your cfg file with this :
[code][color=red][b]verbose=3[/b][/color]
#
#---------- dbserver log options ----------
#
[log]
verbose=standard
expire=5
segment=5000
all=D:\Genesys-Logs\CfgDBServer,stderr[/code]
So you must find (and send us) a dbserver logfile under D:\Genesys-Logs
Ok ?
-
Sorry ...
Genesys Database Server, 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: cfg_dbserver
Application type: RealDBServer (46)
Command line: multiserver.exe -host WIN2003OS -port 2020 -app cfg_dbserver
Host name: Win2003OS
DST: TZ = 1, timeb = 1
Time zone: 18000, Eastern Standard Time, Eastern Daylight Time
UTC time: 2009-07-02T19:08:10.453
Local time: 2009-07-02T15:08:10.453
Start time (UTC): 2009-07-02T19:08:10
Running time: 0:00:00:00
Host info: Windows 5.2.3790, 2, Service Pack 2, 2.0, 0112, 3
File: (1) C:\GCTI\DBServer_76\logDB.log.20090702_150810_454.log
15:08:10.453 Trc 04112 The Log Output of type 'C:\GCTI\DBServer_76\logDB.log' has been created and opened
15:08:10.453 Trc 04112 The Log Output of type 'stderr' has been created and opened
15:08:10.453 Trc 04110 Option 'verbose' has been set to the value 'all'
15:08:10.453 Trc 04110 Option 'buffering' has been set to the value 'yes'
15:08:10.453 Trc 04110 Option 'expire' has been set to the value '5'
15:08:10.453 Trc 04110 Option 'segment' has been set to the value '5000'
15:08:10.453 Trc 04110 Option 'spool' has been set to the value ''
15:08:10.453 Trc 04110 Option 'keep-startup-file' has been set to the value 'no'
15:08:10.453 Trc 04110 Option 'MessageFile' has been set to the value 'RealDBServer.lms'
15:08:10.453 Trc 04110 Option 'time-format' has been set to the value 'time'
15:08:10.453 Trc 04110 Option 'time-convert' has been set to the value 'local'
15:08:10.453 Trc 04110 Option 'message-format' has been set to the value 'short'
15:08:10.453 Trc 04110 Option 'memory-storage-size' has been set to the value '2 Mb'
15:08:10.453 Trc 04110 Option 'compatible-output-priority' has been set to the value 'no'
15:08:10.453 Trc 04110 Option 'print-attributes' has been set to the value 'no'
15:08:10.453 Trc 04110 Option 'check-point' has been set to the value '1'
15:08:10.453 Trc 04110 Option 'memory' has been set to the value ''
15:08:10.453 Std 04106 Log Messages file 'RealDBServer.lms' successfully loaded
15:08:10.453 Trc 04112 The Log Output of type 'C:\GCTI\DBServer_76\logDB.log' has been created and opened
15:08:10.453 Trc 04112 The Log Output of type 'stderr' has been created and opened
15:08:10.453 Trc 04100 Logging service started
15:08:10.453 Trc 06084 Configuration option set: 'dbserver':'port' = '4040'
15:08:10.453 Trc 06084 Configuration option set: 'dbserver':'host' = 'WIN2003OS'
15:08:10.453 Trc 06084 Configuration option set: 'dbserver':'management-port' = '4581'
15:08:10.453 Trc 06085 Configuration option set to default value: 'dbserver':'verbose' = '3'
15:08:10.453 Trc 06085 Configuration option set to default value: 'dbserver':'dbprocesses_per_client' = '1'
15:08:10.453 Trc 06085 Configuration option set to default value: 'dbserver':'dbprocess_number' = '255'
15:08:10.453 Trc 06084 Configuration option set: 'dbserver':'dbprocess_name' = './dbclient_oracle'
15:08:10.453 Trc 06085 Configuration option set to default value: 'dbserver':'oracle_name' = './dbclient_oracle'
15:08:10.453 Trc 06085 Configuration option set to default value: 'dbserver':'informix_name' = './dbclient_informix'
15:08:10.453 Trc 06085 Configuration option set to default value: 'dbserver':'sybase_name' = './dbclient_sybase'
15:08:10.453 Trc 06085 Configuration option set to default value: 'dbserver':'db2_name' = './dbclient_db2'
15:08:10.453 Trc 06085 Configuration option set to default value: 'dbserver':'msql_name' = './dbclient_msql'
15:08:10.453 Trc 06085 Configuration option set to default value: 'dbserver':'stored_proc_result_table' = '0'
15:08:10.453 Trc 06085 Configuration option set to default value: 'dbserver':'connect_break_time' = '1200'
15:08:10.453 Trc 06085 Configuration option set to default value: 'dbserver':'tran_batch_mode' = '0'
15:08:10.453 Trc 06085 Configuration option set to default value: 'dbserver':'reconnect_timeout' = '3600'
15:08:10.453 Trc 06085 Configuration option set to default value: 'dbserver':'client_stop_timeout' = '30'
15:08:10.453 Trc 06085 Configuration option set to default value: 'lca':'lcaport' = '0'
15:08:10.468 Std 05060 Application started
Open server port: = (
"name" = "dbserver"
"server-type" = "46"
"port" = "4040"
)
15:08:11.468 Std 04525 Port 4040 opened for listening
GServer: new_client: fd=1872, found server=1880
15:08:54.187 Trc 04521 New client 3043 connected from '192.168.1.119'
15:08:54.187 Dbg 10745 'App: 192.168.1.119:3043' registered; protocol version '1.3' id '1'
15:08:54.187 Dbg 10734 Send message 'MSG_EXTPACKETS' to 'App: 1', request id '0'
15:08:54.187 Dbg 10750 Start client request, dbprocesses per client '1'
15:08:54.187 Dbg 10734 Send message 'MSG_CLIENTSTARTED' to 'App: 1', request id '2'
15:08:54.187 Std 05022 Process './dbclient_oracle' started
15:08:54.187 Dbg 10741 'App: 1' has put request id='4' into queue
GServer: new_client: fd=1844, found server=1860
15:08:54.203 Trc 04521 New client 3045 connected from '192.168.1.119'
15:08:54.203 Dbg 10745 './dbclient_oracle' registered; protocol version '1.3' id '1.1'
15:08:54.203 Dbg 10734 Send message 'MSG_OPENDB' to 'Oracle: 1.1', request id '3'
15:08:54.203 Dbg 10734 Send message 'MSG_EXTPACKETS' to 'App: 1', request id '0'
15:08:54.203 Dbg 10734 Send message 'MSG_EXTPACKET' to 'Oracle: 1.1', request id '0'
15:08:54.203 Dbg 10743 'Oracle: 1.1' is spare
15:08:54.281 Dbg 10739 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.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 'WIN2003OS', port '3044', socket '112'
+0015 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 = 'WIN2003OS'
+0078 ocierror: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
+0078 MSG_ERROR status='30' msg='ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
'
15:08:54.281 Dbg 10749 Forwarding response '3.1' from 'Oracle: 1.1' to 'App: 1'
15:08:54.281 Dbg 10734 Send message 'MSG_DISCONNECTED' to 'App: 1', request id '-1'
15:08:54.281 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 = 1157
data_sent = 135
msg_error = 1
msg_log = 1
Client Oracle: 1.1 is being closed. Current numofclients=0
Listener (port id = internal-0-0 fd = 1860) 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
15:08:54.343 Std 05023 Process './dbclient_oracle' stopped
/./dbclient_oracle
pid = 3272
id = 0
expiration_time = 2009-07-02T15:09:24
client copy = 0
/Statistics
name = App: 1
req_rcvd = 4
req_sent = 5
data_rcvd = 172
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 = 1
max_pending_queue_size = 23
GServer (0xb3cde8) is being removed. numofclients = 0,current numofserveritems = 1
GServer: new_client: fd=1848, found server=1880
15:09:04.296 Trc 04521 New client 3052 connected from '192.168.1.119'
15:09:04.296 Dbg 10745 'App: 192.168.1.119:3052' registered; protocol version '1.3' id '2'
15:09:04.296 Dbg 10734 Send message 'MSG_EXTPACKETS' to 'App: 2', request id '0'
15:09:04.296 Dbg 10750 Start client request, dbprocesses per client '1'
15:09:04.296 Dbg 10734 Send message 'MSG_CLIENTSTARTED' to 'App: 2', request id '6'
15:09:04.296 Std 05022 Process './dbclient_oracle' started
15:09:04.296 Dbg 10741 'App: 2' has put request id='8' into queue
GServer: new_client: fd=1856, found server=1860
15:09:04.312 Trc 04521 New client 3054 connected from '192.168.1.119'
15:09:04.312 Dbg 10745 './dbclient_oracle' registered; protocol version '1.3' id '2.1'
15:09:04.312 Dbg 10734 Send message 'MSG_OPENDB' to 'Oracle: 2.1', request id '7'
15:09:04.312 Dbg 10734 Send message 'MSG_EXTPACKETS' to 'App: 2', request id '0'
15:09:04.312 Dbg 10734 Send message 'MSG_EXTPACKET' to 'Oracle: 2.1', request id '0'
15:09:04.312 Dbg 10743 'Oracle: 2.1' is spare
15:09:04.359 Dbg 10739 Oracle: id='2.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 'WIN2003OS', port '3053', socket '112'
+0015 MSG_STARTDB status='2'
Oracle: id='2.1' req='7' Protocols versions: dbclient='00010003' dbserver='00010003' dblib='00010003'
+0000 Open DB: username = 'system', database = '', dbserver = 'WIN2003OS'
+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
'
15:09:04.359 Dbg 10749 Forwarding response '7.1' from 'Oracle: 2.1' to 'App: 2'
15:09:04.359 Dbg 10734 Send message 'MSG_DISCONNECTED' to 'App: 2', request id '-1'
15:09:04.359 Dbg 10734 Send message 'MSG_DISCONNECTED' to 'Oracle: 2.1', request id '-1'
/Statistics
name = Oracle: 2.1
app_name = App: 2
req_rcvd = 5
req_sent = 4
data_rcvd = 1147
data_sent = 135
msg_error = 1
msg_log = 1
Client Oracle: 2.1 is being closed. Current numofclients=0
Listener (port id = internal-0-0 fd = 1860) 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: 2 is being closed. Current numofclients=1
15:09:04.406 Std 05023 Process './dbclient_oracle' stopped
/./dbclient_oracle
pid = 388
id = 1
expiration_time = 2009-07-02T15:09:34
client copy = 0
/Statistics
name = App: 2
req_rcvd = 4
req_sent = 5
data_rcvd = 172
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 = 1
max_pending_queue_size = 23
GServer (0xb3cde8) is being removed. numofclients = 0,current numofserveritems = 1
GServer: new_client: fd=1852, found server=1880
15:09:14.375 Trc 04521 New client 3057 connected from '192.168.1.119'
15:09:14.375 Dbg 10745 'App: 192.168.1.119:3057' registered; protocol version '1.3' id '3'
15:09:14.375 Dbg 10734 Send message 'MSG_EXTPACKETS' to 'App: 3', request id '0'
15:09:14.375 Dbg 10750 Start client request, dbprocesses per client '1'
15:09:14.375 Dbg 10734 Send message 'MSG_CLIENTSTARTED' to 'App: 3', request id '10'
15:09:14.375 Std 05022 Process './dbclient_oracle' started
15:09:14.375 Dbg 10741 'App: 3' has put request id='12' into queue
GServer: new_client: fd=1864, found server=1860
15:09:14.390 Trc 04521 New client 3059 connected from '192.168.1.119'
15:09:14.390 Dbg 10745 './dbclient_oracle' registered; protocol version '1.3' id '3.1'
15:09:14.390 Dbg 10734 Send message 'MSG_OPENDB' to 'Oracle: 3.1', request id '11'
15:09:14.390 Dbg 10734 Send message 'MSG_EXTPACKETS' to 'App: 3', request id '0'
15:09:14.390 Dbg 10734 Send message 'MSG_EXTPACKET' to 'Oracle: 3.1', request id '0'
15:09:14.390 Dbg 10743 'Oracle: 3.1' is spare
15:09:14.437 Dbg 10739 Oracle: id='3.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 'WIN2003OS', port '3058', socket '112'
+0015 MSG_STARTDB status='3'
Oracle: id='3.1' req='11' Protocols versions: dbclient='00010003' dbserver='00010003' dblib='00010003'
+0000 Open DB: username = 'system', database = '', dbserver = 'WIN2003OS'
+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
'
15:09:14.437 Dbg 10749 Forwarding response '11.1' from 'Oracle: 3.1' to 'App: 3'
15:09:14.437 Dbg 10734 Send message 'MSG_DISCONNECTED' to 'App: 3', request id '-1'
15:09:14.437 Dbg 10734 Send message 'MSG_DISCONNECTED' to 'Oracle: 3.1', request id '-1'
/Statistics
name = Oracle: 3.1
app_name = App: 3
req_rcvd = 5
req_sent = 4
data_rcvd = 1148
data_sent = 135
msg_error = 1
msg_log = 1
Client Oracle: 3.1 is being closed. Current numofclients=0
Listener (port id = internal-0-0 fd = 1860) 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: 3 is being closed. Current numofclients=1
15:09:14.468 Std 05023 Process './dbclient_oracle' stopped
/./dbclient_oracle
pid = 2968
id = 2
expiration_time = 2009-07-02T15:09:44
client copy = 0
/Statistics
name = App: 3
req_rcvd = 4
req_sent = 5
data_rcvd = 172
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 = 1
max_pending_queue_size = 23
GServer (0xb3cde8) is being removed. numofclients = 0,current numofserveritems = 1
GServer: new_client: fd=1844, found server=1880
15:09:24.437 Trc 04521 New client 3063 connected from '192.168.1.119'
15:09:24.437 Dbg 10745 'App: 192.168.1.119:3063' registered; protocol version '1.3' id '4'
15:09:24.437 Dbg 10734 Send message 'MSG_EXTPACKETS' to 'App: 4', request id '0'
15:09:24.437 Dbg 10750 Start client request, dbprocesses per client '1'
15:09:24.437 Dbg 10734 Send message 'MSG_CLIENTSTARTED' to 'App: 4', request id '14'
15:09:24.437 Std 05022 Process './dbclient_oracle' started
15:09:24.437 Dbg 10741 'App: 4' has put request id='16' into queue
GServer: new_client: fd=1876, found server=1860
15:09:24.453 Trc 04521 New client 3065 connected from '192.168.1.119'
15:09:24.453 Dbg 10745 './dbclient_oracle' registered; protocol version '1.3' id '4.1'
15:09:24.453 Dbg 10734 Send message 'MSG_OPENDB' to 'Oracle: 4.1', request id '15'
15:09:24.453 Dbg 10734 Send message 'MSG_EXTPACKETS' to 'App: 4', request id '0'
15:09:24.453 Dbg 10734 Send message 'MSG_EXTPACKET' to 'Oracle: 4.1', request id '0'
15:09:24.453 Dbg 10743 'Oracle: 4.1' is spare
15:09:24.500 Dbg 10739 Oracle: id='4.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 'WIN2003OS', port '3064', socket '112'
+0015 MSG_STARTDB status='4'
Oracle: id='4.1' req='15' Protocols versions: dbclient='00010003' dbserver='00010003' dblib='00010003'
+0000 Open DB: username = 'system', database = '', dbserver = 'WIN2003OS'
+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
'
15:09:24.500 Dbg 10749 Forwarding response '15.1' from 'Oracle: 4.1' to 'App: 4'
15:09:24.500 Dbg 10734 Send message 'MSG_DISCONNECTED' to 'App: 4', request id '-1'
15:09:24.500 Dbg 10734 Send message 'MSG_DISCONNECTED' to 'Oracle: 4.1', request id '-1'
/Statistics
name = Oracle: 4.1
app_name = App: 4
req_rcvd = 5
req_sent = 4
data_rcvd = 1148
data_sent = 135
msg_error = 1
msg_log = 1
Client Oracle: 4.1 is being closed. Current numofclients=0
Listener (port id = internal-0-0 fd = 1860) 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: 4 is being closed. Current numofclients=1
15:09:24.546 Std 05023 Process './dbclient_oracle' stopped
/./dbclient_oracle
pid = 908
id = 3
expiration_time = 2009-07-02T15:09:54
client copy = 0
/Statistics
name = App: 4
req_rcvd = 4
req_sent = 5
data_rcvd = 172
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 = 1
max_pending_queue_size = 23
GServer (0xb3cde8) is being removed. numofclients = 0,current numofserveritems = 1
15:09:36.031 Std 02024 OS signal 'SIGINT' received
Listener (port id = dbserver fd = 1880) 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
15:09:36.140 Std 01000 DbServer Exiting
/Process manager statistics
name = ProcessStatistics
error_start_count = 0
successfully_start_count = 4
error_stop_count = 0
successfully_stop_count = 4
unexpected_terminated = 0
time_expired_count = 0
GServer (0xa94b14) is being removed. numofclients = 0,current numofserveritems = 0
15:09:36.140 Trc 04109 Logging service stopped
-
Hi,
Please check that the parameter "dbserver" is assigned valid Oracle TNS name in your "configserver.cfg"
[quote][dbserver]
host =WIN2003OS
port =4040
dbengine =oracle
[b]dbserver =WIN2003OS <-- PUT VALID ORACLE TNS NAME[/b]
username =system
password =oracle10g
server =
reconnect-timeout = 10
response-timeout = 600[/quote]
DBServer reports error that WIN2003OS isn't valid TNS name.
[quote]MSG_ERROR status='30' msg='ORA-12514: TNS:listener does not currently know of service requested in connect descriptor[/quote]
R.
-
I looks to me like the value
dbserver =WIN2003OS
is wrong. This should be the alias of your database as configured in the tnsnames.ora file, this is normally the SID, yours appears to be the server name.
This is a tnsnames extract -
GEN61.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = poller)(PORT = 1521))
(CONNECT_DATA = (SID = gen61))
so the value of dbserver in the confserv.conf would be gen61 and to test it via SQLPLUS -
sqlplus user/pass@gen61
-
Whole heartedly thanks you very much,
Now it is started properly.
Problem was with TNS NAME not specified in confserv.cfg.
Great thanks, once again.
Have a wonderful time.
Warm Regards,
Prashant.