Re: HELP! Can not connect to local database from Form Designer.

Xiaotong Zhang wrote:
>
> Hi, everybody,
>
> I can not connect to my database in Form Designer. After I entered scott
> and tiger as the username and the password, I got the following message:
>
> ORA-12203: TNS: unable to connect to destination.
>
> Please let me know how I can solve this problem. (I am running Beta
> version Personal Oracle 7 in Windows 95).
>
> Thanks a lot.
>
> Zhang
Zhang,

that's not so easy to do it via news. Let's try.

You have to install the Oracle Client stuff (SQL-Net...). check your listener process whether it is running or not.

In the directory ORACLE_HOME/network/admin rsides a file called TNSNAMES.ORA. In this file you must have an entry like this:

anyname.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = host name)
          (Port = 1521)
        )

This entry depends on the communication you have installed. (Named Pipes TCP-IP or whatever). Normaly you can attach Oracle without any service name if it runs local.

In older Oracle Verions you have an oracle.ini file in the windows directory (only 16Bit Version). In this file you've got an entry for your local Database (I guess the Beta of Personal Oracle is 16 Bit, isn't it).
Check those entries.

If this all does not help :
remove the ini file and the oracle RDBMS and reinstall it. Better :
purchase a trial version of Oracle Server 7.3.3.

Hope this helps.

-- 
Detlev Goebel

mailto:detlev.goebel_at_gzs.de
---------------------------