I had Vist32 and Oracle 10.2.0.1 running with no problems.
Then I have installed NOD32 3.0.624.
After that I could not start listener.
Started with pid=2868
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=pcdamir)(PORT=1521)))
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 38: Filename too long
Then I have disabled NOD (services and egui exe) and restart PC. Still have a problem with listener.
I'm 100% sure that NOD is the problem because just before installing the NOD all was running in a perfect order!
Any info how to overcome that (without removing NOD, because I'd like to have it on my PC) and have Oracle working...
Just to show that all seems to be OK, here are my configuration files....
Our Listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = xe.world)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(SID_NAME = XE)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = pcdamir)(PORT = 1521))
)
CONNECT_TIMEOUT_LISTENER=15
sqlnet.ora
NAMES.DIRECTORY_PATH= (TNSNAMES)
THX
Search tjhe metalink gave me no good answer (just some rookie advicess about network files).
P.S:
I do remember that something similar happend on the job. After installing NOD32 we have to reinstall the Oracle client which was having problems with onames (sometimes it could ping and sometimes not!)...
Please I'm sure that someone else had problems like we. I could reinstall Oracle but I'd like to understand what is going on....
THX2