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 Sat Feb 17 2001 - 22:15:30 CST