Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2003
    Posts
    11

    Unanswered: unable to create a new instance

    hi,
    I am attempting to create a new instance in my sun solaris 8 server.
    i have set the environment and prepared the scripts.i do not have gui to perform the db creation therefore i need to use the scripts and run from sqlplus.
    it's a 9.2.0.1 database.
    i have added in oratab.
    however when i run this script in sqlplus - i get the following error.
    SQL> @/oracle/ora01/app/oracle/admin/xmbdb/scripts/CreateDB.sql
    Connected to an idle instance.
    SQL> spool /oracle/ora01/app/oracle/product/9.2.0/assistants/dbca/logs/CreateDB.
    log
    SQL> startup nomount pfile="/oracle/ora01/app/oracle/admin/xmbdb/pfile/init.ora"
    ;
    LRM-00109: could not open parameter file '/oracle/ora01/app/oracle/admin/xmbdb/p
    file/init.ora'
    ORA-01078: failure in processing system parameters
    SQL> CREATE DATABASE xmbdb
    2 MAXINSTANCES 1
    3 MAXLOGHISTORY 1
    4 MAXLOGFILES 5
    5 MAXLOGMEMBERS 5
    6 MAXDATAFILES 100
    7 DATAFILE '/oracle/ora02/oradata/xmbdb/system01.dbf' SIZE 325M REUSE AUTOEXT
    END ON NEXT 10240K MAXSIZE UNLIMITED
    8 UNDO TABLESPACE "UNDOTBS" DATAFILE '/oracle/ora02/oradata/xmbdb/undotbs01.d
    bf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
    9 CHARACTER SET US7ASCII
    10 NATIONAL CHARACTER SET AL16UTF16
    11 LOGFILE GROUP 1 '/oracle/ora02/oradata/xmbdb/redo01.log') SIZE 100M,
    12 GROUP 2 ('/oracle/ora02/oradata/xmbdb/redo02.log') SIZE 100M,
    13 GROUP 3 ('/oracle/ora02/oradata/xmbdb/redo03.log') SIZE 100M;
    CREATE DATABASE xmbdb
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available

    SQL> spool off
    SQL> exit;
    Disconnected

    How can i rectify this problem? please advice.
    thanks.

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    it sounds that you didn't configure the init.ora properly ... or do not point to the right init.ora file
    or

    did you create a pwdfile in advance ..

    $ORACLE_HOME/dbs/orapwd file=orapw<SID> entries=...

  3. #3
    Join Date
    Nov 2002
    Posts
    833

    strange behavior while creatint reference ORA-02270

    hi folks,

    I've designed some tables and a relationship between them

    /*================================================= =============*/
    /* Table: RIC_REFERENZZINS */
    /*================================================= =============*/


    create table RIC_REFERENZZINS (
    ID_RIC_REFERENZZINS INTEGER not null,
    UPDATE_NO NUMBER(5) not null,
    ID_REFERENZZINS INTEGER not null,
    RIC_FREQUENZ INTEGER not null,
    FREQUENZ_EINHEIT VARCHAR2(3),
    ZEITRAUM_AB DATE,
    ZEITRAUM_BIS DATE,
    ID_DATENANBIETER INTEGER not null,
    ID_MARKTPLATZ INTEGER not null,
    USER_IK NUMBER(5),
    REC_STATUS VARCHAR2(1),
    VALID_FROM DATE,
    VALID_TO DATE
    )
    /


    /*================================================= =============*/
    /* Index: RIC_REFERENZZINS_PK */
    /*================================================= =============*/
    create unique index RIC_REFERENZZINS_PK on RIC_REFERENZZINS (
    ID_RIC_REFERENZZINS ASC,
    UPDATE_NO ASC
    )
    /


    create table ZINSSATZ (
    ID_ZINSSATZ INTEGER not null,
    UPDATE_NO NUMBER(5) not null,
    ZINSSATZ NUMBER(9,6),
    QUOTIERUNGSZEIT DATE,
    UEBERNAHMEZEIT DATE,
    ID_KURSART INTEGER not null,
    ID_RIC_REFERENZZINS INTEGER not null,
    USER_IK NUMBER(5),
    REC_STATUS VARCHAR2(1),
    VALID_FROM DATE,
    VALID_TO DATE
    )
    /


    /*================================================= =============*/
    /* Index: ZINSSATZ_PK */
    /*================================================= =============*/
    create unique index ZINSSATZ_PK on ZINSSATZ (
    ID_ZINSSATZ ASC,
    UPDATE_NO ASC
    )
    /

    alter table ZINSSATZ
    add constraint FK_ZINSSATZ_RELATIONS_RIC_REFE foreign key (ID_RIC_REFERENZZINS)
    references RIC_REFERENZZINS (ID_RIC_REFERENZZINS)
    /


    -- ****************** Error **************************************
    --
    -- references RIC_REFERENZZINS (ID_RIC_REFERENZZINS)
    -- *
    -- ERROR at line 3:
    -- ORA-02270: no matching unique or primary key for this column-list

    how to work around it in an Oracle enviroment as of 8.1.7.4 on Sun Solaris 2.8

    p.s. as for sybase design it works properly but not for ORCL why???

    Thanks

    osy45

  4. #4
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Thumbs up

    Try using ENABLE NOVALIDATE in the constraint clause.

    This ensures that all new DML operations on the constrained data comply with the constraint. This clause does not ensure that existing data in the table complies with the constraint and therefore does not require a table lock.

    I used on check constraint, might work of FK as well. Not sure..


    Hope that helps,

    clio_usa - OCP - DBA

    dbaclick.com

  5. #5
    Join Date
    Mar 2003
    Posts
    11
    Hi,
    I could start the instance however the CreateDB script would not fully run,it terminates prematurely.
    the action was as below:-
    $ export ORACLE_SID=xmbdb
    $ env
    _=/usr/bin/env
    HZ=100
    PATH=/usr/local/bin:/usr/ccs/bin:/usr/bin::/oracle/ora01/app/oracle/product/9.2.
    0/bin:.
    ORACLE_BASE=/oracle/ora01/app/oracle
    LOGNAME=oracle
    ORACLE_SID=xmbdb
    SHELL=/bin/ksh
    HOME=/export/home/oracle
    TERM=vt100
    ORACLE_HOME=/oracle/ora01/app/oracle/product/9.2.0
    PWD=/export/home/oracle
    TZ=Singapore
    $ sqlplus /nolog

    SQL*Plus: Release 9.2.0.1.0 - Production on Wed May 7 15:12:34 2003

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    SQL> conn system/manager as sysdba
    Connected to an idle instance.
    SQL> @/oracle/ora01/app/oracle/admin/xmbdb/scripts/CreateDB.sql
    Connected to an idle instance.
    SQL> spool /oracle/ora01/app/oracle/product/9.2.0/assistants/dbca/logs/CreateDB.
    log
    SQL> startup nomount pfile="/oracle/ora01/app/oracle/admin/xmbdb/scripts/init.or
    a";
    ORACLE instance started.

    Total System Global Area 135352820 bytes
    Fixed Size 455156 bytes
    Variable Size 109051904 bytes
    Database Buffers 25165824 bytes
    Redo Buffers 679936 bytes
    SQL> CREATE DATABASE xmbdb
    2 MAXINSTANCES 1
    3 MAXLOGHISTORY 1
    4 MAXLOGFILES 5
    5 MAXLOGMEMBERS 5
    6 MAXDATAFILES 100
    7 DATAFILE '/oracle/ora02/oradata/xmbdb/system01.dbf' SIZE 325M REUSE AUTOEXT
    END ON NEXT 10240K MAXSIZE UNLIMITED
    8 UNDO TABLESPACE "UNDOTBS" DATAFILE '/oracle/ora02/oradata/xmbdb/undotbs01.d
    bf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
    9 CHARACTER SET US7ASCII
    10 NATIONAL CHARACTER SET AL16UTF16
    11 LOGFILE GROUP 1 ('/oracle/ora02/oradata/xmbdb/redo01.log') SIZE 100M,
    12 GROUP 2 ('/oracle/ora02/oradata/xmbdb/redo02.log') SIZE 100M,
    13 GROUP 3 ('/oracle/ora02/oradata/xmbdb/redo03.log') SIZE 100M;
    CREATE DATABASE xmbdb
    *
    ERROR at line 1:
    ORA-01092: ORACLE instance terminated. Disconnection forced


    SQL> spool off
    SQL> exit;
    Disconnected from Oracle9i Release 9.2.0.1.0 - Production
    JServer Release 9.2.0.1.0 - Production

  6. #6
    Join Date
    Nov 2002
    Posts
    833
    I would prefer starting the scripts using the user sys . AFAIK sys has more rights than system
    otherwise it would be helpful if you post the create.sh script ...


    Originally posted by jeyagowri
    Hi,
    I could start the instance however the CreateDB script would not fully run,it terminates prematurely.
    the action was as below:-
    $ export ORACLE_SID=xmbdb
    $ env
    _=/usr/bin/env
    HZ=100
    PATH=/usr/local/bin:/usr/ccs/bin:/usr/bin::/oracle/ora01/app/oracle/product/9.2.
    0/bin:.
    ORACLE_BASE=/oracle/ora01/app/oracle
    LOGNAME=oracle
    ORACLE_SID=xmbdb
    SHELL=/bin/ksh
    HOME=/export/home/oracle
    TERM=vt100
    ORACLE_HOME=/oracle/ora01/app/oracle/product/9.2.0
    PWD=/export/home/oracle
    TZ=Singapore
    $ sqlplus /nolog

    SQL*Plus: Release 9.2.0.1.0 - Production on Wed May 7 15:12:34 2003

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    SQL> conn system/manager as sysdba
    Connected to an idle instance.
    SQL> @/oracle/ora01/app/oracle/admin/xmbdb/scripts/CreateDB.sql
    Connected to an idle instance.
    SQL> spool /oracle/ora01/app/oracle/product/9.2.0/assistants/dbca/logs/CreateDB.
    log
    SQL> startup nomount pfile="/oracle/ora01/app/oracle/admin/xmbdb/scripts/init.or
    a";
    ORACLE instance started.

    Total System Global Area 135352820 bytes
    Fixed Size 455156 bytes
    Variable Size 109051904 bytes
    Database Buffers 25165824 bytes
    Redo Buffers 679936 bytes
    SQL> CREATE DATABASE xmbdb
    2 MAXINSTANCES 1
    3 MAXLOGHISTORY 1
    4 MAXLOGFILES 5
    5 MAXLOGMEMBERS 5
    6 MAXDATAFILES 100
    7 DATAFILE '/oracle/ora02/oradata/xmbdb/system01.dbf' SIZE 325M REUSE AUTOEXT
    END ON NEXT 10240K MAXSIZE UNLIMITED
    8 UNDO TABLESPACE "UNDOTBS" DATAFILE '/oracle/ora02/oradata/xmbdb/undotbs01.d
    bf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
    9 CHARACTER SET US7ASCII
    10 NATIONAL CHARACTER SET AL16UTF16
    11 LOGFILE GROUP 1 ('/oracle/ora02/oradata/xmbdb/redo01.log') SIZE 100M,
    12 GROUP 2 ('/oracle/ora02/oradata/xmbdb/redo02.log') SIZE 100M,
    13 GROUP 3 ('/oracle/ora02/oradata/xmbdb/redo03.log') SIZE 100M;
    CREATE DATABASE xmbdb
    *
    ERROR at line 1:
    ORA-01092: ORACLE instance terminated. Disconnection forced


    SQL> spool off
    SQL> exit;
    Disconnected from Oracle9i Release 9.2.0.1.0 - Production
    JServer Release 9.2.0.1.0 - Production

  7. #7
    Join Date
    Nov 2002
    Posts
    833
    Originally posted by osy45
    I would prefer starting the scripts using the user sys . AFAIK sys has more rights than system
    otherwise it would be helpful if you post the create.sh script ...
    by default sys has change_on_install as pwd

Posting Permissions

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