Re: Oracle/Windows Help

"Jake" <me_at_heyjay.com> wrote in message
news:aqnbka$812$1_at_bob.news.rcn.net...
> One last gotcha,
>
> After you:
> set ORACLE_SID=yourInstance
>
> you have to use " if you want to use sqlplus to login as sysdba
> a la:
>

Well, you don't exactly "have" to.

C:\>sqlplus /nolog
SQL>connect / as sysdba

But yes, if you want to do it all in one go, then the quotes are required.

Regards
HJR
> sqlplus "system/manager as sysdba"
>
>
> "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
> news:OSmz9.73663$g9.206369_at_newsfeeds.bigpond.com...
> >
> > "Chucky" <chuck.carson_at_syrrx.com> wrote in message
> > news:3DCD9475.9060109_at_syrrx.com...
> > >
> > > I have been a Unix only DBA for a few years and have now been stuck
with
> > > a Window server.
> > >
> > > Just a few questions:
> > > Does oracle on Windows use the ORACLE_HOME and ORACLE_SID variables?
> > >
> >
> > Yes. Except that by default they are set by registry entries (do a
start -
> > run programs thent ype in regedt32 to launch the registry editor. You
need
> > to look at the HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE keys).
> >
> > However, they do not need to be set in the registry: when you open a DOS
> > window, you can type them in pretty much identically to what you'd be
used
> > to in Unix (except that you type SET ORACLE_SID=BLAH, not EXPORT
> > ORACLE_SID=BLAH).
> >
> > > If I have more than one instance on a Windows box, how do a work with
> > > different SID's (assuming there is no ORACLE_SID variable)
> > >
> >
> > Well, since the assumption is wrong, hopefully the answer is clear!
> >
> > Don't forget that in Windows, due to its multi-threaded nature, you have
> to
> > use ORADIM.EXE to create different services for each Instance. Starting
> the
> > service usually starts the Instance for you as well. And stopping the
> > service kills the Instance (by default, it does a shutdown abort). But
> you
> > can start and stop the Instance within sqlplus, without doing anything
to
> > the service, and without a shutdown or startup implying the starting or
> > stopping of the service.
> >
> > > I just installed 8.1.7 and had it create a starter database just to
see
> > > the file layout. However, there does not seem to be any ORACLE_XXX
vars
> > > defined.
> > >
> >
> > That's a starter database, and so all the variables are set in the
> registry.
> > But they can be over-ridden by typing 'SET' commands in a DOS window, or
> by
> > setting the appropriate variables using the Control Panel - System
applet.
> >
> > Regards
> > HJR
> >
> >
> > > Thx for any help,
> > > CC
> > >
> > >
> > >
> > > -----------== Posted via Newsfeed.Com - Uncensored Usenet News
> > ==----------
> > > http://www.newsfeed.com The #1 Newsgroup Service in the
World!
> > > -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers
> > =-----
> >
> >
>
>
Received on Sun Nov 10 2002 - 23:36:24 CST