Experts,
I am losing my mind...
I can not start dbserver and configserver using Oracle. Below are the log files... I have been troubleshooting this for two weeks..
Please help with what you can... any ideas would help.. thx
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 -host maria.mired.com -port 2020 -app cfg_dbserver
Host name: maria
DST: TZ = 1, timeb = 0
Time zone: 25200, MST, MDT
UTC time: 2009-10-30T17:53:20.623
Local time: 2009-10-30T10:53:20.623
Start time (UTC): 2009-10-30T17:53:20
Running time: 0:00:00:00
Host info: Linux, maria, 2.6.18-128.el5, #1 SMP Wed Jan 21 10:44:23 EST 2009, i686
File: (1) /LOGS/dbserver.20091030_105320_623.log
10:53:20.623 Trc 04112 The Log Output of type '/LOGS/dbserver' has been created and opened
10:53:20.621 Trc 04110 Option 'verbose' has been set to the value 'all'
10:53:20.621 Trc 04110 Option 'buffering' has been set to the value 'no'
10:53:20.621 Trc 04110 Option 'expire' has been set to the value 'no'
10:53:20.621 Trc 04110 Option 'segment' has been set to the value 'no'
10:53:20.621 Trc 04110 Option 'spool' has been set to the value ''
10:53:20.621 Trc 04110 Option 'keep-startup-file' has been set to the value 'no'
10:53:20.621 Trc 04110 Option 'MessageFile' has been set to the value 'RealDBServer.lms'
10:53:20.621 Trc 04110 Option 'time-format' has been set to the value 'time'
10:53:20.621 Trc 04110 Option 'time-convert' has been set to the value 'local'
10:53:20.621 Trc 04110 Option 'message-format' has been set to the value 'short'
10:53:20.621 Trc 04110 Option 'memory-storage-size' has been set to the value '2 Mb'
10:53:20.621 Trc 04110 Option 'compatible-output-priority' has been set to the value 'no'
10:53:20.621 Trc 04110 Option 'print-attributes' has been set to the value 'no'
10:53:20.621 Trc 04110 Option 'check-point' has been set to the value '1'
10:53:20.621 Trc 04110 Option 'memory' has been set to the value ''
10:53:20.622 Std 04106 Log Messages file 'RealDBServer.lms' successfully loaded
10:53:20.623 Trc 04112 The Log Output of type '/LOGS/dbserver' has been created and opened
10:53:20.624 Trc 04100 Logging service started
10:53:20.624 Trc 06084 Configuration option set: 'dbserver':'port' = '4040'
10:53:20.624 Trc 06084 Configuration option set: 'dbserver':'host' = 'maria'
10:53:20.624 Trc 06084 Configuration option set: 'dbserver':'management-port' = '4041'
10:53:20.624 Trc 06085 Configuration option set to default value: 'dbserver':'verbose' = '3'
10:53:20.624 Trc 06085 Configuration option set to default value: 'dbserver':'dbprocesses_per_client' = '1'
10:53:20.624 Trc 06085 Configuration option set to default value: 'dbserver':'dbprocess_number' = '255'
10:53:20.624 Trc 06084 Configuration option set: 'dbserver':'dbprocess_name' = 'dbclient_oracle'
10:53:20.624 Trc 06085 Configuration option set to default value: 'dbserver':'oracle_name' = './dbclient_oracle'
10:53:20.624 Trc 06085 Configuration option set to default value: 'dbserver':'informix_name' = './dbclient_informix'
10:53:20.624 Trc 06085 Configuration option set to default value: 'dbserver':'sybase_name' = './dbclient_sybase'
10:53:20.624 Trc 06085 Configuration option set to default value: 'dbserver':'db2_name' = './dbclient_db2'
10:53:20.624 Trc 06085 Configuration option set to default value: 'dbserver':'msql_name' = './dbclient_msql'
10:53:20.624 Trc 06085 Configuration option set to default value: 'dbserver':'stored_proc_result_table' = '0'
10:53:20.624 Trc 06085 Configuration option set to default value: 'dbserver':'connect_break_time' = '1200'
10:53:20.624 Trc 06085 Configuration option set to default value: 'dbserver':'tran_batch_mode' = '0'
10:53:20.624 Trc 06085 Configuration option set to default value: 'dbserver':'reconnect_timeout' = '3600'
10:53:20.624 Trc 06085 Configuration option set to default value: 'dbserver':'client_stop_timeout' = '30'
10:53:20.624 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 maria port 4999
10:53:20.625 Std 05060 Application started
Open server port: = (
"name" = "dbserver"
"server-type" = "46"
"port" = "4040"
)
10:53:20.625 Std 04525 Port 4040 opened for listening
GServer: new_client: fd=8, found server=7
10:53:24.588 Trc 04521 New client 54511 connected from '192.168.0.80'
10:53:24.589 Dbg 10745 'App: 192.168.0.80:54511' registered; protocol version '1.3' id '1'
10:53:24.589 Dbg 10734 Send message 'MSG_EXTPACKETS' to 'App: 1', request id '0'
10:53:24.589 Dbg 10750 Start client request, dbprocesses per client '1'
10:53:24.589 Dbg 10734 Send message 'MSG_CLIENTSTARTED' to 'App: 1', request id '2'
10:53:24.594 Std 05022 Process './dbclient_oracle' started
10:53:24.594 Dbg 10741 'App: 1' has put request id='4' into queue
GServer: new_client: fd=10, found server=9
10:53:24.632 Trc 04521 New client 30351 connected from '192.168.0.80'
10:53:24.632 Dbg 10745 './dbclient_oracle' registered; protocol version '1.3' id '1.1'
10:53:24.632 Dbg 10734 Send message 'MSG_OPENDB' to 'Oracle: 1.1', request id '3'
10:53:24.632 Dbg 10734 Send message 'MSG_EXTPACKETS' to 'App: 1', request id '0'
10:53:24.632 Dbg 10734 Send message 'MSG_EXTPACKET' to 'Oracle: 1.1', request id '0'
10:53:24.635 Dbg 10743 'Oracle: 1.1' is spare
10:53:24.820 Dbg 10739 Unknown: id='' req='-1' ORACLE_HOME is '/opt/oracle/product/11.1.0/db_1'.
+0000
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'
Oracle: id='1.1' req='-1' Connection to multiserver created, host 'maria', port '59447', 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 = 'maria.mired.com'
+0185 ocierror: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
+0185 MSG_ERROR status='30' msg='ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
'
10:53:24.820 Dbg 10749 Forwarding response '3.1' from 'Oracle: 1.1' to 'App: 1'
10:53:24.820 Dbg 10734 Send message 'MSG_DISCONNECTED' to 'App: 1', request id '-1'
10:53:24.820 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 = 136
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
10:53:24.857 Std 02024 OS signal 'SIGCHLD' received
10:53:24.857 Std 05023 Process './dbclient_oracle' stopped
/./dbclient_oracle
pid = 15326
id = 0
expiration_time = 2009-10-30T10:53:54
client copy = 0
/Statistics
name = App: 1
req_rcvd = 4
req_sent = 5
data_rcvd = 173
data_send = 212
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 (0x9cac108) is being removed. numofclients = 0,current numofserveritems = 1
GServer: new_client: fd=8, found server=7
10:53:34.822 Trc 04521 New client 7109 connected from '192.168.0.80'
10:53:34.822 Dbg 10745 'App: 192.168.0.80:7109' registered; protocol version '1.3' id '2'
10:53:34.822 Dbg 10734 Send message 'MSG_EXTPACKETS' to 'App: 2', request id '0'
10:53:34.823 Dbg 10750 Start client request, dbprocesses per client '1'
10:53:34.823 Dbg 10734 Send message 'MSG_CLIENTSTARTED' to 'App: 2', request id '6'
10:53:34.840 Std 05022 Process './dbclient_oracle' started
10:53:34.840 Dbg 10741 'App: 2' has put request id='8' into queue
GServer: new_client: fd=10, found server=9
10:53:34.875 Trc 04521 New client 43278 connected from '192.168.0.80'
10:53:34.876 Dbg 10745 './dbclient_oracle' registered; protocol version '1.3' id '2.1'
10:53:34.876 Dbg 10734 Send message 'MSG_OPENDB' to 'Oracle: 2.1', request id '7'
10:53:34.876 Dbg 10734 Send message 'MSG_EXTPACKETS' to 'App: 2', request id '0'
10:53:34.876 Dbg 10734 Send message 'MSG_EXTPACKET' to 'Oracle: 2.1', request id '0'
10:53:34.876 Dbg 10743 'Oracle: 2.1' is spare
10:53:34.950 Dbg 10739 Unknown: id='' req='-1' ORACLE_HOME is '/opt/oracle/product/11.1.0/db_1'.
+0000
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'
Oracle: id='2.1' req='-1' Connection to multiserver created, host 'maria', port '24732', socket '4'
+0001 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 = 'maria.mired.com'
+0073 ocierror: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
+0074 MSG_ERROR status='30' msg='ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
'
10:53:34.950 Dbg 10749 Forwarding response '7.1' from 'Oracle: 2.1' to 'App: 2'
10:53:34.950 Dbg 10734 Send message 'MSG_DISCONNECTED' to 'App: 2', request id '-1'
10:53:34.950 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 = 136
msg_error = 1
msg_log = 1
Client Oracle: 2.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: 2 is being closed. Current numofclients=1
10:53:35.032 Std 02024 OS signal 'SIGCHLD' received
10:53:35.033 Std 05023 Process './dbclient_oracle' stopped
/./dbclient_oracle
pid = 15343
id = 1
expiration_time = 2009-10-30T10:54:04
client copy = 0
10:53:35.834 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
10:53:35.835 Std 01000 DbServer Exiting
/Statistics
name = App: 2
req_rcvd = 4
req_sent = 5
data_rcvd = 173
data_send = 212
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 (0x9cac108) is being removed. numofclients = 0,current numofserveritems = 0
/Process manager statistics
name = ProcessStatistics
error_start_count = 0
successfully_start_count = 2
error_stop_count = 0
successfully_stop_count = 2
unexpected_terminated = 0
time_expired_count = 0
GServer (0x9ca4c38) is being removed. numofclients = 0,current numofserveritems = 0
10:53:35.835 Trc 04109 Logging service stopped
