Re: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

"EdStevens" <quetico_man_at_yahoo.com> schreef in bericht news:1160054600.405370.312830_at_e3g2000cwe.googlegroups.com...
>
> old dirtbeard wrote:
> <snip>
>
>> ORCL =
>> (DESCRIPTION =
>> (ADDRESS = (PROTOCOL = TCP)(HOST = IOMORACLE.marshall.usc.edu)(PORT =
>> 1521))
>> (CONNECT_DATA =
>> (SERVER = DEDICATED)
>> (SERVICE_NAME = orcl)
>> )
>> )
>>
> <snip>
>
> Congratulations! You just exposed your db to the world! I timed out
> trying to reach it, but think that might have been the firewall at my
> end. RULE: *NEVER* expose a fully qualified host name or IP address
> when posting your TNSNAMES. While we need details and exact
> cut-n-paste text for most problem solving we generally don't need host
> names or IP addresses or passwords. These should always be masked.
>
> A few years ago, someone made the same mistake, but their domain was
> '.mil'. Quite a furor that he had exposed a database on a military
> computer. When called on it, he was rather blithe about it, claiming
> we didn't have enough information to do anything, whereupon another
> participant promptly demonstrated that we *did* have enough
> information.
>
> http://groups.google.com/group/comp.databases.oracle.server/browse_frm/thread/56e1f0cd01f7e3bb
>

But: if you CAN connect to the database, the problem is solved! A remote connection to the db is what the OP asked for!

Robbert Received on Thu Oct 05 2006 - 08:52:16 CDT