Re: No Listener

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 27 May 2001 10:31:33 +0200
Message-ID: <th1en9296mn1f4@beta-news.demon.nl>

"PASCOELEE" <pascoelee_at_aol.com> wrote in message news:20010527032832.25343.00001602_at_ng-ma1.aol.com...
> I am having problems installing personal 81(8.1.5),
> the database seems to have loaded but when I try and connect to it via
> sql prompt I get the message "no Listener" I have tried to fix this via
the
> easy net configuration without success,could someone please give me
advice.
> I am running on win98.
>
> Thanks,
>
> Lee.

Easy net configuration will not resolve this. You'll need the net8 configuration assistant and you'll need to configure both a listener and 'local names'
Preferably you should use 'localhost' (without quotes) as hostname. You'll need to enter the line
127.0.0.1 localhost
in c:\windows\hosts
in order to get that working.

Contrary to the advice of Hans Noordhoek, you'll need to type lsnrctl start
to start the listener.

The strange thing though is, it should work without listener. Do you have a variable called ORACLE_SID somewhere in hkey\local_machine\software\oracle ?

The usual adminition to read manuals applies to this post.

Regards,

Sybrand Bakker, Oracle DBA Received on Sun May 27 2001 - 03:31:33 CDT