Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    369

    Unanswered: File locations with Oracle 9i on Windows 2000

    Using the DBCA GUI tool on Windows 2000 Advanced Server with Oracle 9iR2 database.

    I am creating a new database, 20Gb in size with Oracle 9iR2 on Windows 2000 Advanced Server. Using DBCA tool. Problem is: I want to install Oracle binaries and the database files (redo, control files, logs, etc) on a different set of drives than what the DBCA tool defaults to. When I try to change the file locations for ORACLE_BASE and ORACLE_HOME files for example, DBCA will not let me do this. How can I change the location of these binaries for Oracle on Windows 2000? I am used to moving them on UNIX but first time done this in Windows 2000. Thanks.

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    DBCA will make the database files, but the Oracle binaries are already installed. You can change where you want the files (DBF,Redo,Control), but not the application stack. If you want to do that, reinstall the database software on your new drive. However, if you do that you will have two Oracle Homes (unless you uninstall the original stack).
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    May 2003
    Posts
    369

    thanks

    Ah I see well interesting. Oracle is similar to UDB in many ways. Thanks again for the help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •