Re: Oracle Reports and forms cant find my database

Hi

I would suggest that you copy tnsnames.ora from your oracle_home for 8i (/oracle/ora81/network/admin) to your oracle_home for forms (orant/net80/admin by default IIRC).
I rather suspect that this will cure your ills. You *may* also have to copy your sqlnet profile (sqlnet.ora).Both SQLPlus and the net8 easy config are run from the 8i home suggesting that this home is configured correctly.

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Roelof" <pit_at_wxs.nl> wrote in message
news:LuIH5.23707$%e4.435793_at_amoeba1.srv.nld.sonera.net...


> 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

> > > >

> > > >

> > > >

> > > >

> >

>

>