-
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
-
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
-
No it's not , I'm sure. What else can cause the grief ?
-
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?
-
Hi
first thing you should check is the permissions to the directory/file
also were any user trace files generated?
hope this helps
