I run Oracle 8 on an NT standalone and have both bequeath and TCP
connections which work. I just set up the .ora files in the regular way.
Instructions are below.
Van
- 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).
- 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 ORACLESTARTPLAY
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:PLAY (where PLAY 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
Bequeath Connection
This is the simplest connection of all. It doesn’t require any listener to
be created and it doesn’t require any listener service to be started. You
can make one in a minute by filling in two or three simple pieces of
information in the Oracle Net8 EasyConfig utility.
TCP-IP Connection
Here’s how to build a TCP connection:
Go to your \windows\hosts\ file and add a line that looks like 127.0.0.1
localhost if it is needed. Also add one for 127.0.0.1 van (or whatever you
have named your computer)
Let’s say you want to create a connection with an alias of PlayTcp.world
that has these values:
protocol tcp/ip
host name: van
port 1521
SID Play
Here are the steps to take.
1) Use the Oracle Net8 Assistant to create a new listener. When the
assistant opens highlight the word listeners. Then go to the edit menu and
choose create... In the right pane you will see a drop-down list box with
the words Listening Locations filled in. There are four steps in the box
and you should go through them one at a time. Fill in the information for
Listening Locations first, the General Parameters and Database Locations.
Other Services is optional. When you try to exit the Net8 assistant it will
ask you whether you want to save the information for your new listener.
Save it if it is good. 2) Next go to control panel/services in WindowsNT
and start the Oracle TNSListener80 Service. Set it to start automatically
if that is what you wish.
3) Finally, go to the tnsnames.ora file and add a block for your new tcp
connection. You can see a prototype in the Net80\Admin\Sample folder. It
will look like this:
PLAYTCP.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = van)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = PLAY)
)
)
Finally, test your connection using SQL+ or the test button in the
OracleNet8 EasyConfig utility.
Christopher M. Day wrote in message
<36ED674A.6CEC26FB_at_rdbms.freeserve.co.uk>...
>John,
>
>This wouldn't solve the problem with the webserver though ....
>
>Chris
>
>John Haskins wrote:
>>
>> In SQL*Net Easy Config, just select a protocol of "Bequeath".
>>
>> Christopher M. Day wrote in message
>> <36ED61D5.394F349B_at_rdbms.freeserve.co.uk>...
>> >Simon,
>> >
>> >I take it you wish to use SQL*Net over TCP/IP at home ? In that case
>> >installed the 'MS Loopback Adapter' from within
>> >Control_Panel->Network->Adapter, this will provide a software nic. Then
>> >install TCP/IP over the 'MS Loopback Adapter'.
>> >
>> >I have this setup at home and it works fine (if anything, its a bit
>> >slower than my nic at work ;) which is probably a good thing.)
>> >
>> >Chris.
>> >
>> >Simon Redmond wrote:
>> >>
>> >> Does anyone know how to configure Oracle 8 on a standalone NT box?
What I
>> >> really mean is SQL*Net, the box isn't connected to any network and
>> doesn't
>> >> have any network cards etc installed. The machine is to be used to
work
>> >> from home, I need sqlnet installed because I want to also install WEB
>> sever.
>> >>
>> >> TIA
>> >> Simon Redmond
Received on Tue Mar 16 1999 - 20:08:11 CST
