Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: listener.ora not found.

Re: listener.ora not found.

From: clement rajappa <clement.rajappa_at_gmail.com>
Date: 4 Jan 2007 07:15:49 -0800
Message-ID: <1167923749.066370.159640@51g2000cwl.googlegroups.com>


thank you so much.
By the way can u suggest a good book that i can follow to better understand oracle net concepts and tuning. clement

On Jan 4, 6:00 pm, "hpuxrac" <johnbhur..._at_sbcglobal.net> wrote:
> 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
> > clementIf 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:15:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US