tail -50 listener.log 05-NOV-2007 22:47:14 * (CONNECT_DATA=(SID=rbt)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.31.252.11)(PORT=59335)) * establish * rbt * 0 [root@rbtora1 log]# cat start.log TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 12-JUL-2007 06:55:32 Copyright (c) 1991, 2005, Oracle. All rights reserved. System parameter file is /opt/home/oracle/product/10.2.0/db_1/network/admin/listener.ora Log messages written to /opt/home/oracle/product/10.2.0/db_1/network/log/start.log Trace information written to /opt/home/oracle/product/10.2.0/db_1/network/trace/start.trc Trace level is currently 0 Started with pid=10295 TNS-01151: Missing listener name, start, in LISTENER.ORA # ./lsnrctl services LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 05-NOV-2007 22:50:42 Copyright (c) 1991, 2005, Oracle. All rights reserved. Message 1053 not found; No message file for product=network, facility=TNSTNS-12541: Message 12541 not found; No message file for product=network, facility=TNS TNS-12560: Message 12560 not found; No message file for product=network, facility=TNS TNS-00511: Message 511 not found; No message file for product=network, facility=TNS Linux Error: 111: Connection refused $ ./lsnrctl services LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 05-NOV-2007 22:54:21 Copyright (c) 1991, 2005, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rbtora.bhtelecom.ba)(PORT=1521))) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER Service "RBT" has 1 instance(s). Instance "RBT", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:302 refused:0 LOCAL SERVER The command completed successfully