Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle Reports and forms cant find my database

Re: Oracle Reports and forms cant find my database

From: Roelof <pit_at_wxs.nl>
Date: Fri, 20 Oct 2000 22:03:59 +0200
Message-ID: <Ll1I5.25920$%e4.451980@amoeba1.srv.nld.sonera.net>

I tried it, it did not work. Thanks for your help

Roelof

"frank" <fbortel_at_home.nl> schreef in bericht news:39F0839D.F0585A4E_at_home.nl...
> 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 - 15:03:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US