Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can't Connect to Oracle8 from Forms4.5
Darren,
You need to start the SQL*Net listener to solve this problem. You should already have TCP/IP on your machine, if you are connecting to any external sources (even the Internet). You may want to install Net8.
So set up listener.ora so that you can connect to your database. Then change tnsnames.ora so that you have a connection string available to use.
I have to agree that its kind of odd that Forms 4.5 does not recognize the bequeth protocol to Oracle 8. I've had this same problem with all my Oracle products, but I also use Cognos' Impromptu and that product will direct connect to the database without the listener being active.
Ian Abramson
Toronto, ON, Canada
Author of: Oracle8 Tuning (Oracle Press) Oracle8 Data Warehousing (Oracle Press - coming soon)
Darren Eccles <d.g.e_at_btinternet.com> wrote in article
<34FDE2C3.7595EC73_at_btinternet.com>...
> I've tried using SQL*Net 2.3 Easy Config but I always get message
> 'Ora-12545 TNS:name not found'. I assume this means that I have
> enterered the database instance name incorrectly. My init file is called
> initorcl.ora so I should be able to connect to a database instance
> called orcl, but I can't. Or is it possible that there's a problem with
> my TCP/IP. Any ideas?
>
> Thanks in advance
>
> Darren Eccles
>
>
Received on Fri Mar 06 1998 - 00:00:00 CST