Results 1 to 13 of 13
  1. #1
    Join Date
    Apr 2003
    Location
    Los Alamos/Santa Fe, NM
    Posts
    69

    Unanswered: ORA-01092 when creating d

    ORA-01092 when creating DB

    $ sqlplus /nolog

    SQL*Plus: Release 9.2.0.1.0 - Production on Wed Oct 22 16:10:59 2003

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

    Enter value for db_name: dsfa
    Enter value for user_name: sfa
    dsfa:sfa> conn / as sysdba
    Connected to an idle instance.
    dsfa:sfa> startup nomount
    ORACLE instance started.

    Total System Global Area 319784024 bytes
    Fixed Size 730200 bytes
    Variable Size 251658240 bytes
    Database Buffers 67108864 bytes
    Redo Buffers 286720 bytes
    dsfa:sfa> @create.sql
    create database michdev2
    *
    ERROR at line 1:
    ORA-01092: ORACLE instance terminated. Disconnection forced
    Michellea Southern-David

  2. #2
    Join Date
    Apr 2003
    Location
    Los Alamos/Santa Fe, NM
    Posts
    69

    create.sql file

    Here is the create.sql file
    create database michdev2
    MAXLOGFILES 20
    MAXDATAFILES 100
    NOARCHIVELOG
    character set "WE8ISO8859P1"
    NATIONAL CHARACTER SET AL16UTF16
    DATAFILE '/u01/oradata/michdev2/system.dbf'
    size 250M reuse autoextend on next 10240K maxsize unlimited
    extent management local
    DEFAULT TEMPORARY TABLESPACE TEMP
    TEMPFILE '/u01/oradata/temp.dbf'
    size 100M autoextend on next 20M MAXSIZE UNLIMITED
    UNDO TABLESPACE UNDO_TS
    datafile '/u02/oradata/michdev2/undo_ts0.dbf'
    SIZE 200M reuse autoextend on next 5120K maxsize unlimited
    LOGFILE
    GROUP 1 ('/u01/oradata/michdev2/michdev2_redo1a.dbf',
    '/u02/oradata/michdev2/michdev2_redo1b.dbf')
    SIZE 8M,
    GROUP 2 ('/u02/oradata/michdev2/michdev2_redo2a.dbf',
    '/u03/oradata/michdev2/michdev2_redo2b.dbf')
    SIZE 8M,
    GROUP 3 ('/u03/oradata/michdev2/michdev2_redo3a.dbf',
    '/u04/oradata/michdev2/michdev2_redo3b.dbf')
    SIZE 8M,
    GROUP 4 ('/u04/oradata/michdev2/michdev2_redo4a.dbf',
    '/u01/oradata/michdev2/michdev2_redo4b.dbf')
    SIZE 8M;
    Michellea Southern-David

  3. #3
    Join Date
    Apr 2003
    Location
    Jagdishpur
    Posts
    146
    Hi,
    First i would like to know on which platform u r creating ur oracle database. I could see that u r having oracle db 9.2. (R-2). The platform is necessary for me to know.

    I also faced the same issue & i was creating it on SUN Solaris (SPARC) 5.8 OS. We faced exactly the same issue..and it was issue of a database parameter i.e. my INIT.ORA. We were using pfile for creating database.

    Just for ur reference, the culprit parameter was RESOURCE_MANAGER_PLAN=SYSTEM_PLAN. It was having some conflict with OS resource manager.

    The parameter will not be supported thru. pfile. For that you have to create your database by using spfile and then you can alter your database for this parameter. That is, you may then set this parameter with appropriate scope.

    Hope, it helps you. In case anything more is needed, pls. do let me know.

    Regards,
    Kamesh Rastogi
    Oracle DBA.
    - KR

  4. #4
    Join Date
    Apr 2003
    Location
    Los Alamos/Santa Fe, NM
    Posts
    69

    server

    Solaris 5.8 ...Let me check my parameters
    Michellea Southern-David

  5. #5
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Check your INITxxx.ora file ... Ensure that the undo tablespace
    entry is the same as in the create database script...

    HTH
    Gregg

  6. #6
    Join Date
    Apr 2003
    Location
    Los Alamos/Santa Fe, NM
    Posts
    69

    parameters

    Thanks for everyones help!! Here is the init.ora file.

    db_name = michdev2
    instance_name = michdev2
    service_names = michdev2
    control_files = ("/u02/oradata/michdev2/control01.ctl","/u03/oradata/michdev2/control02.ctl")


    timed_statistics = False
    sql_trace = False
    max_dump_file_size = 1000


    #db_block_buffers depreciated in 10g use DB_CACHE_SIZE instead
    #db_block_buffers = 1000
    db_cache_size = 64M
    db_block_size = 8192
    db_cache_advice = on

    #new in 9i SQL_MAX_SIZE
    SGA_MAX_SIZE = 300M

    shared_pool_size = 48M
    java_pool_size = 16M
    large_pool_size = 21M

    #new in 9i pga_aggregate_target set size and workarea_size_policy
    workarea_size_policy = auto
    pga_aggregate_target = 100M

    log_checkpoint_interval = 10000
    log_checkpoint_timeout = 0
    processes = 100
    open_cursors = 500
    # new 9i cursor_sharing (similar, force, exact) how much alike do the cursors ha
    ve to be to share?
    cursor_sharing = similar


    # THis is for the auto on the UNDO with 9i
    undo_management = auto
    undo_tablespace = (undo_tbs0, undo_tbs1, undo_tbs2)
    undo_retention = 500
    # default undo_retention is 900
    #undo_supress_errors = True

    #sort_area_retained_size =
    #sort_area_size =


    db_file_multiblock_read_count = 8


    parallel_max_servers = 5
    #dml_locks = 200


    audit_trail = False
    #timed_statistics = False
    #new in 9i statistic_level (ready, off, or on)
    #statistic_level = ready

    #max_dump_file_size =



    #Uncommenting the line below will cause automatic archiving
    #if archiving has been enabled using
    #ALTER DATABASE ARCHIVELOG;


    log_archive_start = False
    log_buffer = 8192
    log_archive_dest = /opt/oracle/admin/michdev2/arch
    log_archive_format = michdev2%t%s.arc



    #If using public rollback segments, define how many rollback segments each insta
    nce will pick up
    #using the formula, number of rollback segments = transactions/ transactions_per
    _rollback_Segment
    #In this example each instance will grab 40/5 = 8;
    # transactions = 40
    # transactions_per_rollback_segment = 5



    utl_file_dir = /tmp
    background_dump_dest = /opt/oracle/admin/michdev2/bdump
    core_dump_dest = /opt/oracle/admin/michdev2/cdump
    user_dump_dest = /opt/oracle/admin/michdev2/udump


    os_authent_prefix = ""


    #job_queue_processes =
    #distributed_transactions =
    #open_links =



    #Uncomment the following line if you wish to enable the Oracle Trace product
    #to trace server activity. This enables scheduling of server collections
    #from Oracle Enterprise Manager Console.
    #Also, if the oracle_trace_collection_name parameter is non-null,
    #every session will write to the named collection, as well as enabling
    #you to schedule future collections from the console.
    # oracle_trace_enable = TRUE


    # remote_login_passwordfile = shared
    # text_enable = TRUE


    #The following parameters are needed for the Advanced
    #Replication Option
    # job_queue_processes = 2
    # job_queue_interval = 10


    # open_links = 4

    #The PLSQL_V2_COMPATIBILITY is by default set to true,
    #must set this to false to run the $ORACLE_HOME/dbms/admin/utlip.sql package
    # which includes STANDARD and DBMS_STANDARD. IF these pkgs do not
    # run, then PL/sQl statements do not run.

    #Parameter added by Data Migration Assistant
    compatible = 8.1.6
    db_domain = world
    query_rewrite_enabled = true
    Michellea Southern-David

  7. #7
    Join Date
    Apr 2003
    Location
    Los Alamos/Santa Fe, NM
    Posts
    69

    UNDO

    Did I set up the UNDO correctly? I have three UNDO files, but only one of them is created with the database.
    Michellea Southern-David

  8. #8
    Join Date
    Apr 2003
    Location
    Los Alamos/Santa Fe, NM
    Posts
    69

    more questions

    Does Compatibility need to be 9.2.0?? Is the UNDO parameter set up correctly?
    Michellea Southern-David

  9. #9
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    in your create database statement :

    UNDO TABLESPACE UNDO_TS

    in your initxxxx.ora file

    undo_tablespace = (undo_tbs0, undo_tbs1, undo_tbs2)


    HTH
    Gregg

  10. #10
    Join Date
    Apr 2003
    Location
    Los Alamos/Santa Fe, NM
    Posts
    69

    OH...

    OHHHHH..DUH. Thanks. Let me try that.
    Michellea Southern-David

  11. #11
    Join Date
    Apr 2003
    Location
    Los Alamos/Santa Fe, NM
    Posts
    69

    where did

    where did that www.images.com come from??? I didn't put it there.
    Michellea Southern-David

  12. #12
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Sorry ...

    I would also set the compatibility also ...

    Let me know if that worked

    Gregg

  13. #13
    Join Date
    Apr 2003
    Location
    Los Alamos/Santa Fe, NM
    Posts
    69

    Compatible parameter error

    I changed to create UNDO statement to UNDO_TS0 and change the parameter to undo_tablespace = undo_ts0. Then when I got the smae error, I changed parameter Compatible = 9.2.0.

    Picky, Picky, Picky. It was the Compatible parameter. When I changed it to 9.2.0 from 8, it worked. Amazing.

    Thanks for all your help.
    Michellea Southern-David

Posting Permissions

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