Re: Forms 6i start-up... HELP

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sat, 30 Jun 2001 21:59:24 -0700
Message-ID: <3B3EAE2C.816C62D0@exesolutions.com>

Brad Leach wrote:

> I am having MAJOR problems attempting to open my database from Forms
> Builder.
> Everything else works okay... the database is started, the Listener is
> started, and I have just reviewed the tables in SQL+. But when I go to build
> forms, I can't go any further.
> OS: Win '98SE
> db: Personal Oracle 8i
>
> Within FormsBuilder,when I enter the username & password at the CONNECT
> screen, I receive the following error:
> ORA-01034, "ORACLE not available."
>
> I have tried my username & password, and the SYS username & password. No
> luck.
>
> Any ideas?
> Thanks for the assistance.
> Brad

Not sure if this is your problem ... but Forms and Reports use their own Oracle Home with their own copy of TNSNAMES.ORA. Did you copy the TNSNAMES.ORA that is working for SQL*Plus into the new NETWORK\ADMIN or NET80\ADMIN directory?

Daniel A. Morgan Received on Sat Jun 30 2001 - 23:59:24 CDT