Results 1 to 8 of 8

Thread: oracle on unix

  1. #1
    Join Date
    Jan 2003
    Location
    The Netherlands
    Posts
    149

    Thumbs up Unanswered: oracle on unix

    Hello,

    I want to install an oracle database on an oracleserver under unix. I have never worked with unix. I use a template to create the database.

    $ORACLE_HOME is defined as : /u01/app/oracle/product/9i
    $ORACLE_BASE is defined as : /u01/app/oracle

    Can I put my logfiles in : "/u02/oralog/[sid]" ?

    If I want to define my datatablespace [SID]_DATA as :
    /oradata01/db_[SID]/[SID]_data_01.ora

    Is this all possible while using a template (*.dbt)?

    thanx

    greetz Coen Dunnink

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    What template? dbca?
    If you are using dbca (or scripts) you can place your database under any path you wish.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    I just create the scripts by hand and then run them through commandline.
    Keeps everything very clear and then I know how everything was created.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  4. #4
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    With dbca you can either use template and/or create scripts which can be customized. I prefer creating the scripts with dbca and executing manually.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  5. #5
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    I will just let Oracle create its own (using dbca) and customize it for my needs after that.

  6. #6
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Quote Originally Posted by JMartinez
    I will just let Oracle create its own (using dbca) and customize it for my needs after that.
    Oracle dbca will create database on it's own standard path (file system) unless you customize the template you are using. Even so, the best is to generate the scripts for review (and maybe customization) before creating the database.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  7. #7
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    Allright, I will rephrase what I said.

    I will just let Oracle create its own database creation scripts (using dbca) and customize it for my needs after that.

  8. #8
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    Same as I had suggested in my post.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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