Re: 8i: no listener

Chris,

For some reason the listener was not turned on in the services window. I finally was able to get it working after a number of attempts. It seems that I have to start the listener service before the database service or else the listener will not recognize the database. Right now I am manually turning them on and off each time I boot up.

Thanks for the help, I'm glad to get it working to the point that it is.

Rich

On Tue, 29 Feb 2000 19:12:45 -0500, Christopher Maher <ChristopherMaher_at_Hotmail.com> wrote:

>I am running Oracle 8i on NT 4.0 sp6.
>
>When I installed Oracle it set up two services which start automatically
>for me:
>
>1. OracleOraHome81TNSListener (listens to tnsnames.ora)
>2. OracleServiceGLOBAL (this is my only database, called
>'global')
>
>Action: Check if both services are running on your machine.
>
>On my intallation, I have to enter three different net service names
>(host string), depending on the which application I am trying to start.
>For simplicity, say that I am logging on as system/manager with all three
>of these applications. Note that host name of my NT box is 'altura'.
>
> Application Service Name (Host)
> ------------- -----------------------
>1. SQL*Plus global
>2. SQL*Plus Worksheet altura:1521:global
>3. WebDB globalwebdb.world
>
>In my installation, WebDB is in a different Oracle home and uses a
>different tnsnames.ora file. That explains the different host name with
>WebDB. Having to supply the instance name 'global' when starting
>SQL*Plus is straightforward. But when starting SQL*Plus Worksheet (comes
>with Oracle Enterprise Manager), I am obliged to give it the full
><hostname>:<port>:<service>.
>
>Action: Check your tnsnames.ora file and experiment with host names when
>you log in.
>
>Let me know if this was of any help.
>
>Chris
>
>---------------------------
>
>Rich wrote:
>
>> I have 8i installed on my machine for training and am having problems
>> connecting to the database. When I run Net8 Easy Config I am told
>> that there is no error.
>>
>> 8i is installed on the same machine that I am trying to connect from,
>> so the server and client machine are the same.
>>
>> Any suggestions would be appreciated.
>>
>> Rich,
>> Newbie
>
Received on Wed Mar 01 2000 - 00:00:00 CST