-
I have created a db using Database Configuration Assistant and I choose to save the scripts. After that deleted the database and tried to recreate it using the scripts generated by Oracle. It didn't work. Look what I found in the log files:
SQL> startup nomount pfile="C:\oracle\admin\orsp\scripts\init.ora";
ORACLE instance started.
Total System Global Area 63729356 bytes
Fixed Size 282316 bytes
Variable Size 41943040 bytes
Database Buffers 20971520 bytes
Redo Buffers 532480 bytes
SQL> CREATE DATABASE orsp
2 MAXINSTANCES 1
3 MAXLOGHISTORY 1
4 MAXLOGFILES 5
5 MAXLOGMEMBERS 5
6 MAXDATAFILES 100
7 DATAFILE 'C:\oracle\oradata\orsp\system01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
8 UNDO TABLESPACE "UNDOTBS" DATAFILE 'C:\oracle\oradata\orsp\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
9 CHARACTER SET WE8MSWIN1252
10 NATIONAL CHARACTER SET AL16UTF16
11 LOGFILE GROUP 1 ('C:\oracle\oradata\orsp\redo01.log') SIZE 100M,
12 GROUP 2 ('C:\oracle\oradata\orsp\redo02.log') SIZE 100M,
13 GROUP 3 ('C:\oracle\oradata\orsp\redo03.log') SIZE 100M;
CREATE DATABASE orsp
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> spool off
Could somebody jhelp me with this error message? Why it worked when run by Oracle and it didn't from the scripts?
Thank you.
-
Do the following:
1. Open the init.ora and replace remote_login_passwordfile=EXCLUSIVE with
remote_login_passwordfile=NONE.
2. startup nomount pfile="C:\oracle\admin\orsp\scripts\init.ora";
3. Run CREATE DATABASE ...
-
Thanks Julian, it worked.
Could you explain why I had to modify REMOTE_LOGIN_PASSWORDFILE?
I don't want the users to be OS authenticated, how can I switch to Oracle authentication after I create the db?
-
Originally posted by Mara
Thanks Julian, it worked.
Could you explain why I had to modify REMOTE_LOGIN_PASSWORDFILE?
Because of something in 9i what I call bug and Oracle calls feature :-)
I don't want the users to be OS authenticated, how can I switch to Oracle authentication after I create the db?
Create the password file with orapwd and then start the instance with REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE.
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
|