Re: Configuring Oracle 8 on a standalone NT box

Van,

Simon's original posting was about getting Oracle to work with the web server on a standalone NT machine. The use of the bequeath driver will NOT give him a tcp/ip stack in which to use the web server.

The suggestion for the MS Loopback adapter with TCP/IP solves the connectivity issues on both Oracle and the Webserver.

Chris.

Van Messner wrote:
>
> 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
>
> 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 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
> 3. 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.
> 4. 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+.
> 5. 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 Wed Mar 17 1999 - 14:24:12 CST