Re: Simple Oracle database question.

2002-06-07 Thread Suzy Vordos
Yes, just make sure your ORACLE_SID is set correctly when creating or starting the new database. You can even have multiple databases each using a diff version of Oracle. Meomeo Nguyen wrote: Hi, Currently I have only one database running on a single host. Supposedly, I need to create

RE: Simple Oracle database question.

2002-06-07 Thread Jamadagni, Rajendra
On my dev box I have following databases running oraclei@orion ps -ef | grep pmonoraclei 13487 1 1 21:23:53 ? 2:27 ora_pmon_INTDEV oraclei 13529 1 1 21:23:57 ? 2:18 ora_pmon_INTSTAGE oraclef 1846 1 1 00:26:03 ? 0:14 ora_pmon_FINTEST oraclei 25861 1 1 07:41:40 ? 1:18

RE: Simple Oracle database question.

2002-06-07 Thread Johnson, Michael
If you are on Unix make sure your ORACLE_SID environment variable is set to the database you want to use. -Original Message-From: Meomeo Nguyen [mailto:[EMAIL PROTECTED]]Sent: Friday, June 07, 2002 3:28 PMTo: Multiple recipients of list ORACLE-LSubject: Simple Oracle

Re: Simple Oracle database question.

2002-06-07 Thread Rachel Carmichael
I currently have 4 databases running and am in the process of creating a 5th one. thisis on a solaris box. It is possible to run as many instances as disk space and memory will allow. It might not be good for performance but you can run more than one on the box. --- Meomeo Nguyen [EMAIL