I hope indeed....
-----Original Message-----
From: Ankur Shah [mailto:[Email Address Removed] Friday, June 28, 2002 3:28 PM
To: LazyDBA.com Discussion
Subject: Re: 2 db ON 1 MACHINE
Regis -
Hope LAS_VEGAS is not a Oracle reserved word !
Never know what Larry wants to reserve for Oracle
:)
Ankur Shah
Oracle DBA
DHR-GA
----- Original Message -----
From: Regis Biassala <Regis.[Email Address Removed] LazyDBA.com Discussion <[Email Address Removed] June 28, 2002 9:12 AM
Subject: RE: 2 db ON 1 MACHINE
> Before doing 'startup nomount..' please set your oracle_sid first...
> for instance:
> You want to create a database called LAS_VEGAS
> 1. SET ORACLE_SID=LAS_VEGAS
> 2. sqlplus or svrmgrl and connect as internal or sys (as sysdba)
> 3. startup nomount...
> 4......
> 5....
>
> Regis
>
> -----Original Message-----
> From: lazy dba [mailto:[Email Address Removed] Sent: Friday, June 28, 2002 1:57 PM
> To: LazyDBA.com Discussion
> Subject: 2 db ON 1 MACHINE
>
>
> Hi gurus,
> I have one database created on win-2000 advanced server. Now I want to
> create one more database on the same machine. When I run the script it
says
> 'startup nomount pfile .......' It says first shutdown the already running
> instace.
> If I create new database after shutting down the current one, will I be
able
> to run both db simultaneously? And client and connect to which ever db
they
> want?
> How to do this? What all things I have to take care of? [services, new
home
> etc.......]
>
> Lazy junior Dba.
>
> _________________________________________________________
> There is always a better job for you at Monsterindia.com.
> Go now http://monsterindia.com/rediffin/
>
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
> *********************************************************************
> This electronic transmission is strictly confidential and intended solely
> for the addressee. It may contain information which is covered by legal,
> professional or other privilege. If you are not the intended addressee,
> you must not disclose, copy or take any action in reliance of this
> transmission. If you have received this transmission in error,
> please notify the sender as soon as possible.
> **********************************************************************
>
>
> --------
> Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
*********************************************************************
This electronic transmission is strictly confidential and intended solely
for the addressee. It may contain information which is covered by legal,
professional or other privilege. If you are not the intended addressee,
you must not disclose, copy or take any action in reliance of this
transmission. If you have received this transmission in error,
please notify the sender as soon as possible.
**********************************************************************
Oracle LazyDBA home page