Re: cant connect to database after developer suite install

"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 - 05:53:04 CST