You didn't say what os you are using but here is some information for an
NT machine at home:
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
- 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=JUNK. 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).
- 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 JUNK -INTPWD INTERNAL
This creates the service named OracleServiceJUNK with the instance JUNK
with a password of INTERNAL for internal.
To get rid of the instance and service do this:
C:\......>oradim80 -DELETE -SID JUNK
C:\......>oradim80 -DELETE -SRVC ORACLESERVICEJUNK
To create an instance as well as two oracle services OracleServiceSID
and OracleStartSID do this:
C:\......>oradim80 -NEW -SID JUNK -INTPWD INTERNAL -STARTMODE AUTO
-PFILE G:\ORANT8\INITJUNK.ORA
This creates the services named OracleServiceJUNK and OracleStartJUNK
with the instance JUNK and a password of INTERNAL for internal.
To get rid of the instance and services do this:
C:\.....>oradim80 -DELETE -SID JUNK
C:\.....>oradim80 -DELETE -SRVC ORACLESERVICEJUNK
C:\.....>oradim80 -DELETE -SRVC ORACLESTARTJUNK
There are other options that you can see by running oradim80 with no
flags:
C:\.....>oradim80
But once you've created the basic services it's probably easier to
manipulate them in control panel/services
- Start an Instance Then Create the Database
Startup Svrmgr73 and type
connect internal_at_2:JUNK where JUNK is your sid
password: internal or whatever you set it to when you created the
services
startup nomount pfile=full path and name of pfile including the .ora
suffix
At this point you can type in your create database commands or run one
or more scripts to create the database. Oracle has a set of sample
scripts that you can look at in buildall.sql. Search for that file.
- Post-Creation
There are a number of scripts that should be run after database
creation. You’ll probably see most of
these in buildall.sql. You should also run pupbld.sql as user System to
set up SQL+ properly. Otherwise you’ll get an error message every time
you connect using SQL+.
- Connections
Edit your tnsnames.ora, listener.ora and sqlnet.ora files as necessary.
Van
actionis_at_hotmail.com wrote:
> Hi
>
> I have installed Oracle 8 on my machine about 1/2 an hour ago.
>
> The problem I am having is:-
>
> 1) most proberly easy to solve for you, but not me
>
> 2) how do I start the server ???
>
> I have a couple of years experience of coding SQL to Access DB through
>
> a VB interface. As you may or may not know, Access does all the work
> for you.
>
> I want to run a oracle database on my PC as a standalone.
> I have figured out the connection has something to do with sqlnet.ora
> & tnsnames.ora files. But my Oracle experience is limited to half an
> hour and I have no clue to how the files should be coded
>
> I have tried to connect with Net* Assistant with the following info
> tcp 127.0.0.1
> port 1521
> SID ORCL
>
> But the test cannot connect.
>
> SQL Plus won't login (No suprise)
>
> I thank you for any help to get this started
>
> Action
Received on Sat Feb 27 1999 - 11:56:58 CST