Re: Oracle on NT Help!
From: Sybrand Bakker <Sybrand.Bakker_at_Bentley.nl>
Date: 1995/09/18
Message-ID: <43j7eu$md0_at_sun630.bentley.com>#1/1
Date: 1995/09/18
Message-ID: <43j7eu$md0_at_sun630.bentley.com>#1/1
Steve,
Here's how to do it
- Use the NT Instance manager, there is a button New, which creates a new
instance for you, which means also creating a new NT service, called
OracleService<instance name>. After successful completion the services
are already started.
- Run sqldba71. This is a dos utility in the ora_home\bin directory
(probably in your ORA_NT\BIN directory)
- issue the command SET INSTANCE <the name of your new instance>
- connect as INTERNAL
- startup nomount pfile=init<instance name>.ora (or whatever you named the parameter file)
- create database <database name> controlfiles ... datafiles ... (look for the exact syntax in your manuals). Remember you already should have mentioned your controlfiles in your init<instance name>.ora files. If this succeeds your database is created and opened.
- run the script c:\ora_nt\rdbms71\admin\catalog.sql
- run the script c:\ora_nt\rdbms71\admin\catproc.sql
Hope this helps
Sybrand Bakker
Senior IS Analyst
Bentley Systems Europe
Hoofddorp, The Netherlands
All standard disclaimers apply Received on Mon Sep 18 1995 - 00:00:00 CEST