Re: listener.ora not found.

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 4 Jan 2007 07:00:04 -0800
Message-ID: <1167922802.523824.181850@s34g2000cwa.googlegroups.com>

clement rajappa wrote:
> Hi
> The server is a test server and is not on the network.
> i tried tnslsnr status. The reply was:
> TNS 12541:No Listener
> TNS 12560:protocol adapter error.
> What is surprising is i can connect from Forms6i which is installed on
> the same machine under a different home without any connect string.
> thanks in advance for ur help
> clement

If you have ORACLE_SID set then perhaps you are getting a bequeath type connection

On a unix system you can stop the listener and still connect via ORACLE_SID to a local database ... it looks like this on unix ...

oracle 8862 8861 0 09:56:45 ? 0:00 oracleracdb1 (DESCRIPTION=(LOCAL
=YES)(ADDRESS=(PROTOCOL=beq)))

Evidently this also works on windows ( not a big believer in oracle on windows myself sorry ). Received on Thu Jan 04 2007 - 09:00:04 CST