Re: Oracle Reports and forms cant find my database

What Nial said: different products in different homes have different locations for (network-) configuration files. One solution may be to introduce tns_admin in your registry (all homes under HKLM\Software\Oracle) and make it point to the diry that contains the (correct) param files. In your case that would be the oracle8i_home\network\admin

hth,
Frank

Roelof wrote:

> When I start forms I click connect. A logon screen appears. I logon with
> scott/tiger.
> Then: ORA-01034 Oracle not available.
>
> Logging on with SQL-plus is OK. ORACLE NET8 Easy config also OK.
> All programs (forms 6/reports6/Oracle8i) are fresh installed. At
> installation I had a problem.
> During setup I had to specify my home dir. Oracle would not accept his own
> default (Oracle\ora81). Choosing default stopped installation with a
> registry error. Uninstalling en installing again with as dir Oracle was
> acceptable. This deliverd a succesfull installation. Programm runs OK. But
> no loggin on onto database.
> Someone in Oracle newsgroup suggested ODBC connection. Is this an option?
> slow?
>
> Please help.
>
> Thanks.
>
> Roelof
>
> "frank" <fbortel_at_home.nl> schreef in bericht
> news:39EF3FDF.11C05D27_at_home.nl...
> > And stop x-posting - I just asked the same question in another ng
> >
> > Niall Litchfield wrote:
> >
> > > Hi
> > >
> > > Forms and reports go into a different oracle home than ythe database. I
> > > therefore would expect that your tnsnames file for forms/reports does
 not
> > > include a correct alias for your db. If this is not the cas eplease
 could
> > > you respond with the exact error message I'd expect something like
> > > ORA-012505 and a description.
> > > --
> > > Niall Litchfield
> > > Oracle DBA
> > > Audit Commission UK
> > > "Roelof" <pit_at_wxs.nl> wrote in message
> > > news:aZlH5.21360$%e4.413212_at_amoeba1.srv.nld.sonera.net...
> > > > I have a problem. Oracle 8i Persanal is running OK. I installed
 reports
 and
> > > > forms. When I try to log on to my database with those programs they
 say
> > > > "Oracle is not running". But in the same time I can see my tables with
 SQL
> > > > plus.
> > > >
> > > > I am a newbie, please help me.
> > > >
> > > > Tnx.
> > > >
> > > > Roelof
> > > >
> > > >
> > > >
> > > >
> >
Received on Fri Oct 20 2000 - 12:39:37 CDT