How do I set ORACLE_SID in windows NT environment

Giganews Newsgroups
Subject: How do I set ORACLE_SID in windows NT environment
Posted by:  oraclegu…@lycos.com
Date: 10 Dec 2004

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

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
environment ?  The ORACLE_HOME is already properly set to point to the
10g DB Home.

Would appreciate an answer.

Thanks.

Suresh

Replies