Results 1 to 2 of 2

Thread: create database

  1. #1
    Join Date
    Sep 2002
    Location
    NJ
    Posts
    139

    Unanswered: create database

    hi:

    I have recently installed Oracle8i on my Unix machine.

    How do you invoke OEM, or Oracle Database config Assistant in Unix so I can create a new db?

    when I installed Oracle, I thought I had created a db. However, I am running into all kinds of little problems I have been able to solved with the exception of one. When I started the db, could not mount because it did not find the controlfiles. The controlfiles were not created during the installation. I so I am trying to crete them, but I have the problem bellow:

    Enter user-name: internal
    Connected to an idle instance.

    SQL> startup nomount
    ORACLE instance started.

    Total System Global Area 104669344 bytes
    Fixed Size 73888 bytes
    Variable Size 55787520 bytes
    Database Buffers 48627712 bytes
    Redo Buffers 180224 bytes
    SQL> CREATE CONTROLFILE REUSE DATABASE "rich" RESETLOGS ARCHIVELOG
    2 MAXLOGFILES 32
    3 MAXLOGMEMBERS 2
    4 MAXDATAFILES 32
    5 MAXINSTANCES 16
    6 MAXLOGHISTORY 1815
    7 LOGFILE
    8 GROUP 1 '/export/home/oracle/oradata/rich/REDO03.LOG' SIZE 1M,
    9 GROUP 2 '/export/home/oracle/oradata/rich/REDO02.LOG' SIZE 1M,
    10 GROUP 3 '/export/home/oracle/oradata/rich/REDO02.LOG' SIZE 1M
    11 DATAFILE
    12 '/export/home/oracle/oradata/rich/system02.DBF',
    13 '/export/home/oracle/oradata/rich/rbs02.DBF',
    14 '/export/home/oracle/oradata/rich/temp02.DBF',
    15 '/export/home/oracle/oradata/rich/tools02.DBF',
    16 '/export/home/oracle/oradata/rich/indx02.DBF',
    17 '/export/home/oracle/oradata/rich/users02.DBF',
    18 '/export/home/oracle/oradata/rich/drsys02.DBF'
    19 CHARACTER SET WE8ISO8859P1
    20 ;
    CREATE CONTROLFILE REUSE DATABASE "rich" RESETLOGS ARCHIVELOG
    *
    ERROR at line 1:
    ORA-01503: CREATE CONTROLFILE failed
    ORA-01565: error in identifying file
    '/export/home/oracle/oradata/rich/system02.DBF'
    ORA-27037: unable to obtain file status
    SVR4 Error: 2: No such file or directory
    Additional information: 3


    SQL> shutdown immediate
    ORA-01507: database not mounted

    The first time I ran into this, I moved the the already existing datafiles into another directory and ran the create database command again to create new *.dbf files but I still get the above error.

    Then I am trying to invoke the Oracle Database config Assistant but can 't seen to be able to find it anywhere.

    Any thoughts?

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    look for a program dbca database configuration assist

    the controlfiles are named in a file called init.ora (init<ORA_SID>.ora)

    are your environments correctly set?
    $ORACLE_HOME
    $ORACLE_SID

    is the tnsnames o.k. and the listener started?

Posting Permissions

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