Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2002
    Posts
    2

    Unanswered: Create Oracle 9i Database on Win2kPro

    I have downloaded and installed Oracle 9i Database Server on Windows 2000 Professional. When trying to create a new database using "Database Configuration Assistant", I failed because the new empty database needed 1144 MB (more than 1 GB !) on HDD. I tried with different templates but the result is the same.
    So, I tried to use a CREATE DATABASE statement for setting the dimensions of the files to smaller values. I checked the documentation (Oracle 9i Database Administrator's Guide, cap. 1 Postinstallation Database Creation, Creating a Database Manually) and follow the steps described there:
    - I have created the file "init.ora"
    - I have created a service using oradim (and the service started)
    - I have set ORACLE_SID
    - I have launched sqlplus with "/nolog"
    Then, I can't connect to ... (to what ?):
    - with "connect / as sysdba" I get "ERROR ORA-01031: insufficient privileges"
    - with "connect sys/change_on_install as sysdba" I get "ERROR ORA-01017: invalid username/password; logon denied".
    Later (in another sqlplus session), I get "ERROR ORA-24314: service handle not initialized".
    Is there a way to create a database without having to buy a new HDD ?

  2. #2
    Join Date
    Apr 2002
    Posts
    1
    1.Using the Password File Authentication
    And set the Set the REMOTE_LOGIN_PASSWORDFILE initialization parameter to EXCLUSIVE in the init.ora file

    2.Run the regedt
    Choose the \HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0
    And set the ORACLE_ID to your database name

    Then....Ǻ,you know.............................................. ................
    ....................................

    Ŷ
    The order: set ORACLE_ID=... is not usefull,don`t use it
    That`s OK
    Last edited by Entermaner; 04-19-02 at 11:07.

  3. #3
    Join Date
    Apr 2002
    Location
    beijing,china
    Posts
    20
    1 you need to create a windows service with oradim
    2 set ORACLE_SID in windows registry or Env Variable
    3. create password file with orapwd
    4. setup initSID.ora file
    5. create your database

    in fact,you can create database use dbca with "new dataabse" template to create a customer database, I ever used it to create mini database
    whit 60M SGA and 600M datafiles

Posting Permissions

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