-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|