Re: Databases on drives other than Oracle Home

From: <jtesta_at_my-dejanews.com>
Date: Tue, 15 Dec 1998 15:39:26 GMT
Message-ID: <755vrf$b7p$1@nnrp1.dejanews.com>

Murf, to do anything more than the generic setup(which you have already experienced), requires doing it manually. You will need to run data dictionary creation scripts, create tablespaces manually, etc. Once you have a db up and running, then you can use enterprise manager to create all of the extra tablespaces.

I have created db in the NT world where the oracle binaries are on one drive and all the database files are on another. feel free to email me direct and i'll send you some scripts on how to do it.

mailto:murf_at_oracle-dba.com

joe
http://www.oracle-dba.com

PS:dont send email to the acct listed here, it will just bounce.

In article <755spn$8gj$1_at_nnrp1.dejanews.com>, murf_at_cychilds.com wrote:
> This is in regards to an Oracle8
> Enterprise NT installation.
>
> Here at Cy Childs Software Developers we have nobody that we consider to
> be a DBA, but, we are trying to get Oracle8 Enterprise for NT up and
> running. This may go beyond installation support so please forward this
> e-mail if it does. I am confident that I have gotten Oracle8 Enterprise
> Edition installed properly and let the Oracle Home default to C:\orant\
> and selected the none option for building a database. I would like the
> Oracle to reside on the C:\ drive and its data to reside on the D:\
> (just another hard drive on our machine). I have created a database on
> the D:\ drive but I have no concept on what I need to do to configure
> things to be able to use the enterprise manager. Do I need to go out to
> DOS and use the server manager? What are all the issues that I may
> confront by trying to do this? Is this a rare case, or do many entities
> install Oracle at one place and have thedata reside in another?
>
> If you can point me in the right direction so that I can choose
> Enterprise Manager and enter a username of "administrator" and a
> password of my choosing I would be forever thankful. I realize this is
> a tall order, but we really need the help.
>
> Thanks!
>
> Mike Murphy
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Dec 15 1998 - 09:39:26 CST