Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    218

    Unanswered: create database - automation

    Hi,

    I am using oracle9i R2 on win2k platform. My question is: How do we automate database creation in oracle 9i. Lets say our client is not too keen on creating the db using DBCA.. I however, used DBCA to generate scripts and have modified it accordingly eg: ORACLE_HOME, ORACLE_BASE etc. But, I am getting ORA-01092 error constantly.

    Just wanted to know if anyone has tried to automate this before. If so, could you please let me know.

    Thanks in advance.

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    what about your ORACLE_SID and the location and name or init.ora and controlfiles?

    I've always gone doing DBCA once with a new version and then cloning from the scripts new instances ...

    what error messages are your alert.log posting additionally?

Posting Permissions

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