Urgent : Stump in DB Creation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Urgent : Stump in DB Creation

  1. #1
    Join Date
    Nov 2000
    Posts
    416
    I really don't know what I am doing wrong. New NT machine , new 8i installation successful now try to create a new DB with configuration assistant although I login as NT admini account and permission is R/W for all folders this is what's happened :

    My question : WHY access denied ??? Please put lights.



    Echo ON
    SVRMGR> connect INTERNAL/oracle
    Connected.
    SVRMGR> startup nomount pfile="D:\Oracle8i\admin\TOQ07\pfile\init.ora"
    ORACLE instance started.
    Total System Global Area 206587148 bytes
    Fixed Size 70924 bytes
    Variable Size 55607296 bytes
    Database Buffers 150831104 bytes
    Redo Buffers 77824 bytes
    SVRMGR> CREATE DATABASE TOQ07
    2> LOGFILE 'D:\Oracle8i\oradata\TOQ07\redo01.log' SIZE 1024K,
    3> 'D:\Oracle8i\oradata\TOQ07\redo02.log' SIZE 1024K,
    4> 'D:\Oracle8i\oradata\TOQ07\redo03.log' SIZE 1024K
    5> MAXLOGFILES 32
    6> MAXLOGMEMBERS 2
    7> MAXLOGHISTORY 1
    8> DATAFILE 'D:\Oracle8i\oradata\TOQ07\system01.dbf' SIZE 58M REUSE AUTOEXTEND ON NEXT 640K
    9> MAXDATAFILES 254
    10> MAXINSTANCES 1
    11> CHARACTER SET WE8ISO8859P1
    12> NATIONAL CHARACTER SET WE8ISO8859P1;
    CREATE DATABASE TOQ07
    *
    ORA-01501: CREATE DATABASE failed
    ORA-00200: controlfile could not be created
    ORA-00202: controlfile: 'D:\Oracle8i\oradata\TOQ07\control01.ctl'
    ORA-27040: skgfrcre: create error, unable to create file
    OSD-04002: unable to open file
    O/S-Error: (OS 5) Access is denied.
    SVRMGR> spool off
    An ounce of prevention is worth a pound of cure

  2. #2
    Join Date
    Mar 2001
    Posts
    635
    Hi

    Check to see weather you have a control file allready existing by that name whichever you have specified for your parameter controlfiles in your initialisation file.If it exist give a different path to those file or use reuse option if you want to overwrite those control files in ur create database command.

    I think there is a control file by name control01.ctl allready over there.

    Regards
    Santosh

  3. #3
    Join Date
    Nov 2000
    Posts
    416
    No it's not , I'm sure. What else can cause the grief ?
    An ounce of prevention is worth a pound of cure

  4. #4
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    I thought all the functionality of svrmgr has come to SQLPLUS in Oracle 8i. Why create database from svrmgr?
    This does'nt answer your query though.
    Can you delete the MAXLOGHISTORY option and retry?

  5. #5
    Join Date
    Jul 2000
    Posts
    243
    Hi

    first thing you should check is the permissions to the directory/file
    also were any user trace files generated?

    hope this helps

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