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

Thread: Scripts vs. Configuration Assistant

  1. #1
    Join Date
    Jun 2000
    Location
    Toronto, ON, Canada
    Posts
    50
    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.

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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 ...

  3. #3
    Join Date
    Jun 2000
    Location
    Toronto, ON, Canada
    Posts
    50
    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?

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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
  •  


Click Here to Expand Forum to Full Width