Re: Help with Listener

>>
>> 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:07:47 CST