Oracle Database Discussions

Hi,

I've searched through a lot of posts relating to TNS Protocol adapter errors but still haven't been able to resolve what I'm seeing.

I have Oracle 10g R2 installed on a laptop with DHCP enabled. I installed the Microsoft Loopback adapter as required for a DHCP install. I have disabled any firewalls.

Occasionally, when I reboot the laptop, the database instance fails to start properly. The TNS and Oracle Instance service reports as started. When I connect with sqlplus "/ as sysdba" I get connected to an idle instance and I can run startup to get it going again.

I have batch files that I can use to stop and start TNS and Oracle services. Maybe 50% of the time I repeatedly restart services, I get an idle instance.

I can't understand why it works one minute, then fails the next minute, only to work again. Is there a patch available that I have to install, can I change the BEQ protocol to TCP? It would be strange that there's something wrong with my configuration files given that it happens intermittently.

sqlnet.ora is reporting the following error message:

Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)
(ARGV0=oracleXYZ)(ARGS='(DESCRIPTION=(LOCAL=YES)
(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=XYZ)
(CID=(PROGRAM=C:\oracle\product\10.2.0\db_1\bin\oradim.exe)
(HOST=LAPTOP1)(USER=SYSTEM))))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
Time: 16-MAY-2006 09:53:06
Tracing not turned on.
Tns error struct:
ns main err code: 12560
TNS-12560: TNS:protocol adapter error
ns secondary err code: 0
nt main err code: 530
TNS-00530: Protocol adapter error
nt secondary err code: 2
nt OS err code: 0

Thanks,

Mark