Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Personal Oracle 804 Hangs at Create database on NT

Status
Not open for further replies.

raygg

Technical User
Jun 14, 2000
397
US
On an NT workstation an install of Personal Oracle 804 failed at the time of the create control file and create database. A Dr Watson Oradim80.exe error occurred also. I know that oradim80 is the create database Oracle program. I was troubleshooting this problem and do not have a clue what the answer is.

This install failed for one of our employees so I did all the right things before attempting the install. I shut down all oher programs, I followed a 'clean machine' procedure to clean every vestige of Oracle from the Registry, Program Files, and Winnt. There was plenty of space on the hard disk for the install. Below is the script from the failed createdb.log.

Connected.
ORACLE instance started.
Total System Global Area 11721388 bytes
Fixed Size 47788 bytes
Variable Size 11190272 bytes
Database Buffers 409600 bytes
Redo Buffers 73728 bytes
create controlfile reuse set database oracle
*
ORA-01503: CREATE CONTROLFILE failed
ORA-00200: controlfile could not be created
ORA-00202: controlfile: 'd:\orant\DATABASE\ctl1ORCL.ora'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
alter database oracle open resetlogs
*
ORA-01507: database not mounted
Statement processed.
alter database oracle character set WE8ISO8859P1
*
ORA-01507: database not mounted
alter database oracle national character set WE8ISO8859P1
*
ORA-01507: database not mounted
create user PO8 identified by PO8
*
ORA-01109: database not open
grant dba to PO8
*
ORA-01109: database not open
COMMIT
*

Any ideas what went wrong? My only guess is disk fragmentation at this point.
 
create controlfile reuse set database oracle from above

usage s/b

CREATE CONTROLFILE [REUSE] [SET] DATABASE database
LOGFILE [options]
DATATFILE [options]


Unless your database name is oracle, you are missing the
database name in your script(s). Jim

oracle, vb
 
What you see is the generated code spooled to the createdb.log log file generated by Personal Oracle 8 (804) - it's not me that is entering the wrong syntax.... I ran this as a vanilla install. Have you ever run the Personal oracle 8 installation?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top