Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    1

    Unanswered: Command line to create an instance

    Is there a way to create an instance from the command line? (Solaris)
    I do not have permissions to start the Oracle Management Server.

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    yup.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Nov 2002
    Posts
    833
    create the db as follows
    connect to sqlplus or svrmgr if you are still on 8i

    connect SYS/change_on_install as SYSDBA
    set echo on
    spool /opt/oracle/9.0.1/assistants/dbca/logs/CreateDB.log
    startup nomount pfile="/opt/oracle/9.0.1/admin/ORCL/scripts/init.ora";
    CREATE DATABASE ORCL
    MAXINSTANCES 1
    MAXLOGHISTORY 1
    MAXLOGFILES 5
    MAXLOGMEMBERS 5
    MAXDATAFILES 100
    DATAFILE '/data/oracle/u02/ORCL/system01.dbf' SIZE 90M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
    UNDO TABLESPACE "UNDOTBS" DATAFILE '/data/oracle/u04/whyx/undotbs01.dbf' SIZE 60M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
    CHARACTER SET WE8ISO8859P1
    NATIONAL CHARACTER SET UTF8
    LOGFILE GROUP 1 ('/data/oracle/u02/ORCL/redo01.log') SIZE 5M,
    GROUP 2 ('/data/oracle/u03/ORCL/redo02.log') SIZE 5M,
    GROUP 3 ('/data/oracle/u04/ORCL/redo03.log') SIZE 5M;
    spool off
    exit;


    then follow with all the other stuff ::

    connect SYS/change_on_install as SYSDBA
    set echo on
    spool /opt/oracle/9.0.1/assistants/dbca/logs/CreateDBCatalog.log
    @/opt/oracle/9.0.1/rdbms/admin/catalog.sql;
    @/opt/oracle/9.0.1/rdbms/admin/catexp7.sql;
    @/opt/oracle/9.0.1/rdbms/admin/catblock.sql;
    @/opt/oracle/9.0.1/rdbms/admin/catproc.sql;
    @/opt/oracle/9.0.1/rdbms/admin/catoctk.sql;
    @/opt/oracle/9.0.1/rdbms/admin/catobtk.sql;
    @/opt/oracle/9.0.1/rdbms/admin/caths.sql;
    @/opt/oracle/9.0.1/rdbms/admin/owminst.plb;

Posting Permissions

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