DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: error while creating 9i database manually

  1. #1
    Join Date
    Jun 2001
    Posts
    150

    error while creating 9i database manually

    i am using this script to create dabatabase in 9i on AIX 5.1
    create database ber02
    controlfile reuse
    logfile
    group 1 ('/oradata/test/vg03lv1/ber02/ber02_thr1_gr01_mem1.rdo',
    '/oradata/test/vg03lv2/ber02/ber02_thr1_gr01_mem2.rdo') size 5m,
    group 2 ('/oradata/test/vg04lv1/ber02/ber02_thr1_gr02_mem1.rdo',
    '/oradata/test/vg03lv1/ber02/ber02_thr1_gr02_mem2.rdo') size 5m,
    group 3 ('/oradata/test/vg03lv2/ber02/ber02_thr1_gr03_mem1.rdo',
    '/oradata/test/vg04lv1/ber02/ber02_thr1_gr03_mem2.rdo') size 5m
    maxlogfiles 60
    maxdatafiles 256
    datafile
    '/oradata/test/vg02lv1/ber02/ber02_system_01.dbf' size 200M
    character set WE8ISO8859P15 ;

    but i am getting this error message

    ERROR at line 1:
    ORA-01092: ORACLE instance terminated. Disconnection forced

    Any idea why?

    UKDBA

  2. #2
    Join Date
    Jun 2001
    Posts
    150
    I checked init.ora and discovered that dbca had put the following:
    remote_login_passwordfile=EXCLUSIVE
    into the init.ora. Well, I didn't have a password file, so,
    I commented it out, and everything went fine after that.

    Ta
    UKDBA

Posting Permissions

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


Click Here to Expand Forum to Full Width