Re: cant connect to database after developer suite install

Hi!

The service probably started, but for some reason it failed to start the Oracle instance.
Could be because the service has specified a non-existent location for pfile for example. When you issue a normal startup, the spfile in default location is used.

When you're logged on to database as an administrator with sqlplus, type show parameter background, then go to the directory returned, and read from the alertXXXX.log to for LRM- or ORA- errors. This might give you some information.

Tanel.

"Ryan" <rgaffuri_at_cox.net> wrote in message news:AWFaa.172868$4F3.10885865_at_news2.east.cox.net...
>
> "Eve Hoellwarth" <hoellwarth-e_at_gmx.at> wrote in message
> news:t19m6vg3kod9vsm7tg5kmcojfhge1mgsuf_at_4ax.com...
> > "Ryan" <rgaffuri_at_cox.net> wrote
> >
> > >"Anton Buijs" <aammbuijs_at_xs4all.nl> wrote
> >
> > >> Less easy to manage is the sqlnet configuration. You have to
> > >configurations:
> > >> 1. V9.2 based in <9ihome>\network\admin
> > >> 2. V8.0 based in <developerhome>\net80\admin
> > >> Which is to be used then depends on the selected Oracle home. The
> Oracle
> > >> Home selector lets you choose the default. And it looks like you are
> > >mixing
> > >> V8.0 and V9.2 syntax (V8.0 does not recognize the encryption
> parameters, I
> > >> doubt you need them).
> > >>
> > >> Personally I am in favour of using 1 configuration and set it up as
> > >follows.
> > >> With 9i there is an admin directory where the database administration
> > >files
> > >> are stored, something like
> > >> C:\oracle\admin\ORCL\bdump, udump, pfile
> > >> I would create C:\oracle\admin\network\etc and store sqlnet.ora,
> > >> tnsnames.ora and listener.ora there
> > >> Direct log- and trace files to C:\oracle\admin\network\log, trc.
> > >> Create a new registry string key in both the HOME0 and HOME1 registry
> > >keys:
> > >> TNS_ADMIN=C:\oracle\admin\network\etc
> > >> Now both Oracle homes will use the same sqlnet configuration files.
> > >>
> > >> It's obvious you will have to work "client/server" on your host
because
> of
> > >> the 2 oracle homes.
> > >> So you must start the 9i database and a listener from the 9i home.
When
> > >you
> > >> start Developer it must be able to resolve the service name from the
> > >connect
> > >> string, reading it's tnsnames.ora.
> > >> If you want to make that service name default, create the registry
key
> > >LOCAL
> > >> in the Developer home and set it to the service name you use.
> > >The rest of the stuff is done. What do you mean by:
> > >
> > >If you want to make that service name default, create the registry key
> LOCAL
> > >> in the Developer home and set it to the service name you use.
> > >
> > >string = LOCAL
> > >value = instance name of the database?
> > >
> > >Also, when I take out this value from my sqlnet.ora
> > >
> > >SQLNET.ENCRYPTION_CLIENT = requested
> > >
> > >I get:
> > >
> > >ORA-01034: Oracle Not available
> > >ORA-27101: Shared Memory Realm not avaible
> > >
> > >Now the service is started. I did not change any of my init.ora
> parameters
> > >from the default database set up on install.
> > >
> > >anyone know what is going on?
> >
> > Did you select the right $ORACLE_HOME in your home selector
> > before connecting to the instance?
> >
> > kind regards
> > Eve
>
> thanks fixed it. Connected as SYSDBA and did 'startup'
>
> anyone know why the Windows services couldnt start it automatically?
>
>
>
>
Received on Sun Mar 09 2003 - 06:08:38 CST