Try the following - please note that it is useful to give OS and Oracle
versions when posting requests for help
- Make sure the listener is started. On either NT or Unix, issue the
command
lsnrctl status
If on Unix, do this as the oracle user. If on NT, do this from a command
prompt (i.e DOS window)
You should see a report that states that the listener is started and has one
or more named services configured
- If the listener isn't started, you will need to start it
On NT, start the listner service from the Control Panel. It will have a name
like Ora???TNSListener or similar
On Unix, as the oracle user, issue the command
lsnrctl start
In both cases, test the listener did indeed start with the command
lsnrctl status
- If the listener did start, or was already started, and you still can't
connect, please post tnsnames.ora, sqlnet.ora and listener.ora as text. I
missed the earlier post where you may have sent these and can't find them on
deja
> From: mechhunter_at_rocketmail.com (Arthur)
> Newsgroups: comp.databases.oracle.server
> Date: Sun, 18 Feb 2001 04:15:30 GMT
> Subject: Re: Help with Listener
>
>
> I am still doing testing through Net8 Assistance and when I test the
> database connection, it keeps on saying 'No Listener' although I have
> configured a listener.
>
> I hope that give you a bit more clue.
>
> -Arthur
>
>>>>
>>>> Now, I am trying to get back into form and it does not work
>>>> anymore. I have check the TNSNAMES.ORA, LISTENER.ORA, SQLNET.ORA and
>>>> NAME.ORA and they are identitical on both the D:\ORAWIN95\NET80\ADMIN
>>>> and the D:\Oracle\Ora81\NETWORK\ADMIN.
>>>>
>>>> When I try to connect via Form builder, it is coming up with
>>>> this error: ORA-12154: TNS:could not resolve service name
>>>>
>>>
>>> What service name do you use to connect? (Notice that your sqlnet.ora
>>> has default domain name 'Oracle8' not 'Oracle'.)
>>
>> Hi Fad,
>> I am really hoping you could help me, didn't sleep all nite trying to
>> figure out why this has happened. I am using 'ORCL' to connect - none
>> of the files (4 of them in both the directorys) have been modify - at
>> least not manually by me.
>>
>>> Have you tried without using the Names server?
>>
>> What do you mean by the names server ? I am doing Development path
>> thus please forgive me for my ignorant.
>>
>>>>
>>>> (if I am on the internet)
>>>> When I test the connection via Net8 Assistance Connection
>>>> Test, I get this error: ORA-12541:TNS:no listener
>>>>
>>>
>>> Sounds like a IP routing problem.
>>
>> That's my initial thought but the problem is, the form builder client
>> and the main database are housed within the SAME computer thus
>> I do not think there is any routing occuring. Not in the hub -
>> external sense. But what really puzzle me is that I have not done
>> ANYTHING - not deleted or changed any IP or configure.
>>
>> -Arthur
>
Received on Sun Feb 18 2001 - 00:58:06 CST
