The listener service is not created!
Even 'lsnrctl start' fails as shown below:
Code:C:\Users\dell>lsnrctl start LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 18-DEC-2008 12:38:55 Copyright (c) 1991, 2006, Oracle. All rights reserved. Starting tnslsnr: please wait... TNS-12560: TNS:protocol adapter error TNS-00530: Protocol adapter error C:\Users\dell>servicesOutput for tnsping is found below:HTML Code:C:\Users\dell>lsnrctl services LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 18-DEC-2008 12:39:58 Copyright (c) 1991, 2006, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 32-bit Windows Error: 2: No such file or directory Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=82.cx.com)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 32-bit Windows Error: 61: Unknown error C:\Users\dell>
I've installed Oracle Database 11g on Vista and also tried installing Oracle Database 10g (10.2.0.3) and facing the same issue with the Listener.Code:C:\Users\dell>tnsping orcl TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 18-DEC-2008 12:38:19 Copyright (c) 1997, 2006, Oracle. All rights reserved. Used parameter files: Y:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 82.cx.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl))) TNS-12541: TNS:no listener C:\Users\dell>
TIA.


Reply With Quote
Bookmarks