Re: Oracle Reports and forms cant find my database

Remark the authentication line in sqlnet.ora; make it read: # SQLNET.AUTHENTICATION_SERVICES= (NTS) Retry - no luck? start tracing! Add
trace_level_client = 16 in sqlnet.ora. Then check sqlnet.trc for clues

Roelof wrote:

> 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 Mon Oct 23 2000 - 10:33:11 CDT