Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How do I set ORACLE_SID in windows NT environment

Re: How do I set ORACLE_SID in windows NT environment

From: Randy Harris <randy_at_SpamFree.com>
Date: Sat, 11 Dec 2004 00:22:38 GMT
Message-ID: <i5rud.7272$nE7.3710@newssvr17.news.prodigy.com>


<oracleguru_at_lycos.com> wrote in message
news:1102721593.532120.6740_at_f14g2000cwb.googlegroups.com...
> Hi,
>
> At my customer's windows 2003 server I installed 10g, 10.1.0.2 database
> with starter database orcl.
>
> I am basically a UNIX person.
>
> I have familiarized with most of the windows environment.
>
> I want to create a new database named xyz.
>
> I stopped the 2 oracle services for orcl from the windows services.
>
> On UNIX when you create a new database instance you issue
>
> set ORACLE_SID=xyx;export xyz
> set ORACLE_HOME=.....; export ORACLE_HOME

Which shell is that?

> then log into sql
>
> sqlplus / as sysdba
>
> startup nomount pfile=.....
>
> etc.
>
> My question is how do I set ORACLE_SID to xyz in the windows

set ORACLE_SID=xyz
(There's no export in windows)

> environment ? The ORACLE_HOME is already properly set to point to the
> 10g DB Home.
>
>
> Would appreciate an answer.
>
> Thanks.
>
>
> Suresh
>
Received on Fri Dec 10 2004 - 18:22:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US