Tom,

Add export ORACLE_SID=NEWDB in your DB creation script.


-Saji

-----Original Message-----
From: tom sauyer [mailto:[Email Address Removed] Friday, February 28, 2003 2:56 PM
To: LazyDBA.com Discussion
Subject: multiple ORACLE_SID on unix



hi friends,

i have the following entry in my .profile file for the oracle user oracle8

ORACLE_SID=fcclive; export ORACLE_SID

Please, how can i include another ORACLE_SID fcrgl to the file, 'cos i want
to create a database (manually with ORACLE_SID=fcrgl)

Thanks in advance.




_____

Do you Yahoo!?
Yahoo! <http://rd.yahoo.com/finance/mailtagline/*http://taxes.yahoo.com/>
Tax Center - forms, calculators, tips, and more

Oracle LazyDBA home page