I Can't Connect to Oracle via TOAD - ORA-12545

I found two files:

listener.ora and LISTENER.ORA

Which one should i edit? I will go with the small cases one. However, what is the different
between them?

I edit them with my local IP 192.168.0.105

I typed the command, i get this error:

C:\Users\Fahmi>lsnrctl start

LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 13-OCT-2009 16:13
:22

Copyright (c) 1991, 2006, Oracle.  All rights reserved.

Starting tnslsnr: please wait...

TNS-12560: TNS:protocol adapter error
 TNS-00530: Protocol adapter error

--------------------------------------

I tried to connect via TOAD, i get this ORA-12541 TNS:No Listener

C:\Users\USER>lsnrctl start LISTENER

LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 13-OCT-2009 16:19
:20

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\USER>lsnrctl stat

LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 13-OCT-2009 16:18
:13

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=192.168.0.105)(PORT=1521
)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   32-bit Windows Error: 61: Unknown error

The listener was disabled. I made it automatic and started it. I get this:

C:\Users\Fahmi>lsnrctl stat

LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 13-OCT-2009 16:38
:51

Copyright (c) 1991, 2006, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 10.2.0.3.0 - Produ
ction
Start Date                13-OCT-2009 16:37:56
Uptime                    0 days 0 hr. 0 min. 55 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   D:\oracle\product\10.2.0\db_1\network\admin\listener.o
ra
Listener Log File         D:\oracle\product\10.2.0\db_1\network\log\listener.log

Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

--------------------------------------

I tried to connect via TOAD, i get this error:

ORA-12514:
      TNS:listener does not currently know of service requested in connect descriptor

I will try to figure it. Thanks for help...

I just decided to end this thread and install the express one temporarily. Anyhow, if you know the cause of this error
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor let me know.

Thanks

>>The listener was disabled. I made it automatic and started it. I get this:

Which is not what I suggested you do. You didn't mention what changed or what you tried.

It looks like your listener has now started, but the Oracle instance isn't registered. Normally it registers on its own, after a bit, but if it is not, try to add a static entry for the SID into listener.ora and restart.

Sample below uses DEV as the instance.

# listener.ora
# Generated by Oracle configuration tools.
 
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle\10.2.0)
      (PROGRAM = extproc)
    )
    (SID_DESC =(SID_NAME = DEV))
  )
 
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )
                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:

>>ORA-12514: TNS:listener does not currently know of service requested in connect descriptor let me know.

I think you are too hasty in closing the question. Please try my suggestion above.

I will give it a try and let you know....

Worked!

I replaced this:

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
  )

with

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle\10.2.0)
      (PROGRAM = extproc)
    )
    (SID_DESC =(SID_NAME = ORCL))
  )

Thanks.....

Is

Even though i didn't change my home path from C:\oracle\10.2.0 to D:\oracle\product\10.2.0\db_1, the problem is solved. Weird.