Re: How do I set ORACLE_SID in windows NT environment

oracleguru_at_lycos.com wrote:
> 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.
>

Your customer knows this, hopefully. If not, you have done a great disservice to them.

> I have familiarized with most of the windows environment.
>

Apparently you're not familiar enough.

> I want to create a new database named xyz.
>
> I stopped the 2 oracle services for orcl from the windows services.
>

My question is: if you didn't want the ORCL instance why did you create it in the first place? If you knew you wanted instance 'xyz' why did you not simply prevent the installer from creating ANY database and, once the installation of the software was compete, invoke dbca and create your desired database? Is the installer that great of a challenge to you?

> On UNIX when you create a new database instance you issue
>
> set ORACLE_SID=xyx;export xyz
> set ORACLE_HOME=.....; export ORACLE_HOME
>

Usually, with bash or ksh, you simply type:

export ORACLE_SID=xyz

and you're done.

> then log into sql
>
> sqlplus / as sysdba
>
> startup nomount pfile=.....
>

I've never stopped at that point when creating a database ...

> 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.
>

Use set ORACLE_SID=xyz at a command prompt (lasting only as long as the command window exists), edit the environment variables in Windows through Control Panel->System) or edit the registry. Take your pick.

>
> Would appreciate an answer.
>

I cannot believe you have the unmitigated audacity to call yourself 'oracleguru' in your email address. It truly is a false claim and should be changed immediately. If this is all the better you can do, if this is the best quality of service to your customer you can muster, issue a prompt, courteous refund. Then learn more about UNIX, Linux, Windows and Oracle before you set out upon another such project. This one is clearly beyond your current abilities. David Fitzjarrell  

> Thanks.
>
>
> Suresh
Received on Sat Dec 11 2004 - 00:05:06 CST