Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Look for good install/tech book on Oracle 8

Re: Look for good install/tech book on Oracle 8

From: Van Messner <vmessner_at_netaxis.com>
Date: Thu, 1 Apr 1999 19:14:16 -0500
Message-ID: <M2UM2.786$88.30687@news14.ispnews.com>


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 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.

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 Own


Received on Thu Apr 01 1999 - 18:14:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US