Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Look for good install/tech book on Oracle 8
Here's a quick outline for NT
Creating in NT
To create a database in NT we need to make a pfile, create the NT services,
create the database, and build the connections to use SQL+ and other
utilities against the database.
The steps below are a guideline. There is an even more complete set of
information in the NT specifics book section Creating a New Database. If
you don’t have this book download it from the Oracle technical documentation
site – choose “by platform” and Oracle Server 7.3 (or whatever) for WinNT 4
1. Preliminary Work
First, you should shut down any existing databases and back them up. It
would be a major problem if you accidentally overwrote part of an existing
database.
Next you need to set the environment variable for the new database. Open a
DOS box and type
set Oracle_Sid=PLAY. Then exit.
Set up a directory structure to hold the new database, its control file,
its init.ora file, its redo logs etc.
Create a new pfile for use with the new database. Here are some
guidelines. The shared pool should be 10-20% of available memory. The
db_block_buffers should be 30-40% of available memory. The overall SGA
should be small enough to prevent paging.
Oracle provides a sample create database file called buildall.sql (which
calls build_db.sql). You can make copies of these samples, edit them and
use the to create your new database. Remember to look for the extraneous
comma after the last logfile – an error in some versions.
Oracle 8 also has a utility called the Oracle database assistant. This
utility provides a fair degree of flexibility, but not as much as creating
your own creation script(s).
2. Creating the NT Services
When Oracle for NT (in the database assistant or as part of the install)
creates a database it creates two services. The first is called
OracleServiceSID and the second is OracleStartSID. You can see them in
control panel/services. If you are creating your own database you can create
these services yourself using the utility Oradim80. First build your
init.ora or pfile.
To create an instance as well as the OracleServiceSID do this:
C:\......>oradim80 -NEW -SID PLAY -INTPWD INTERNAL
This creates the service named OracleServicePLAY with the instance PLAY with
a password of INTERNAL for internal.
To get rid of the instance and service do this:
C:\......>oradim80 -DELETE -SID PLAY
C:\......>oradim80 -DELETE -SRVC ORACLESERVICEPLAY
To create an instance as well as two oracle services OracleServiceSID and
OracleStartSID do this:
C:\......>oradim80 -NEW -SID PLAY -INTPWD INTERNAL -STARTMODE AUTO -PFILE
G:\ORANT8\INITPLAY.ORA
This creates the services named OracleServicePLAY and OracleStartPLAY with
the instance PLAY and a password of INTERNAL for internal.
To get rid of the instance and services do this:
C:\.....>oradim80 -DELETE -SID PLAY C:\.....>oradim80 -DELETE -SRVC ORACLESERVICEPLAY C:\.....>oradim80 -DELETE -SRVC ORACLESTARTPLAYThere are other options that you can see by running oradim80 with no flags: C:\.....>oradim80
protocol tcp/ip host name: van port 1521 SID Play
(ADDRESS =
(PROTOCOL = TCP)
(Host = van)
(Port = 1521)
)
Van
indy_powers_at_my-dejanews.com wrote in message
<7dts2n$b1s$1_at_nnrp1.dejanews.com>...
>I'm getting ready to do an install of Oracle 8 and was wondering if there
is a
>good book/web resource for info on how to do this smoothly? > >thanks in advance for any input. > >Chris Powers > >christopher_powers_at_yahoo.com > >-----------== Posted via Deja News, The Discussion Network ==---------- >http://www.dejanews.com/ Search, Read, Discuss, or Start Your OwnReceived on Thu Apr 01 1999 - 18:14:16 CST