CREATE DATABASE Manually ? - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: CREATE DATABASE Manually ?

  1. #11
    Join Date
    Oct 2002
    Posts
    284
    Ok...now i got the services started...then this is what i did..my pfile is copied from c:\oracle9i\ora92\admin\pfile\heatdb\initheatdb.ora to c:\oracle9i\ora92\database\heatdb.ora

    *********************************************************
    SQL> connect / as sysdba
    Connected to an idle instance.
    SQL>
    SQL>
    SQL>
    SQL> startup nomount
    ORA-01078: failure in processing system parameters
    LRM-00109: could not open parameter file 'C:\ORACLE9I\ORA92\DATABASE\INITCHEATDB.ORA'

    **********************************************************

    Why is it saying caouldnot open ?...any ideas...

    Thanks a lot for all your help

  2. #12
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    It is poiting to different pfile, i.e to " 'C:\ORACLE9I\ORA92\DATABASE\INITCHEATDB.ORA'"
    where as your pfile is "c:\oracle9i\ora92\database\heatdb.ora"

    try
    Code:
    startup nomount pfile=c:\oracle9i\ora92\database\heatdb.ora

  3. #13
    Join Date
    Oct 2002
    Posts
    284
    Thanks Sameer...Still having problems Creating DB...

    **************************************************

    SQL> startup nomount
    ORACLE instance started.

    Total System Global Area 135338868 bytes
    Fixed Size 453492 bytes
    Variable Size 109051904 bytes
    Database Buffers 25165824 bytes
    Redo Buffers 667648 bytes
    SQL> @c:\createdb.sql
    CREATE DATABASE heatdb
    *
    ERROR at line 1:
    ORA-01092: ORACLE instance terminated. Disconnection forced
    SQL>

    ***********************************

    Any ideas...

    thanks

  4. #14
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    This error can occur if the bdump destinations is incorrect or the database server does not have the correct permissions to write in that directory (alert.log file cannot be written)

    regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

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