Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Create DB Script

edited Jun 28, 2013 10:16AM in Database Install/Upgrade/Opatch (MOSC) 6 commentsAnswered
Hi,

  I have to setup a Oracle 7 database server for testing migration use.  I installed Oracle 7.3.4 on Windows NT 4.0 and try to create a new database by some create db scripts shown as follows:

-- CREATES THE TEST INSTANCE

\orant\bin\oradim73 -new -sid TEST -intpwd TEST -startmode auto -pfile \ORADATA\TEST\initTEST.ora

-- BUILDS THE TEST INSTANCE

startup nomount pfile=D:\ORADATA\TEST\INITTEST.ORA

CREATE database TEST
CHARACTER SET WE8ISO8859P1
CONTROLFILE REUSE
logfile GROUP 1 ('d:\oradata\test\log11.dbf','d:\oradata\test\log12.dbf') SIZE 2m reuse ,
GROUP 2 ('d:\oradata\test\log21.dbf','d:\oradata\test\log22.dbf') SIZE 2m reuse ,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center