I Checked, the Log File and i found this
TNSLSNR for 32-bit Windows: Version 220.127.116.11.0 - Production on 06-FEB-01 17:05:33
Copyright (c) Oracle Corporation 1994. All rights reserved.
System parameter file is d:\orant\network\admin\listener.ora
Log messages written to d:\orant\network\log\listener.log
Trace information written to d:\orant\network\trace\listener.trc
Trace level is currently 0
Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\oracle.worldipc))
Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\ORCLipc))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
This Listener start 06-FEB and yestarday I Restart.
what do you mean about that?
Is your instance in the shared mode? It looks like that it is failing to start the dedicated server process. First make sure that the listener.ora set up is correct. Then go ahead and confirm that the protocol that you are using is installed correctly. If your instance is in the shared server, then add the following SERVER=DEDICATED after the SID in the tnsnames.ora file also,
One of the other thing that it is worth the notice was why not you do the TCP instead of IPC. I presume that TCP is more secured than IPC.
Try it. Good luck,
Life is a journey, not a destination!
Ok, How I Know, when my Listener.ora is correct, I have a server, but I have many application that use the Database, they are connect. then I have to write tnsnames.ora (SERVER=DEDICATED)
Click Here to Expand Forum to Full Width