Note: Below are general instructions for an Oracle 8 install, should they prove useful –

Setup Instructions for Oracle8: Database Administration (on NT Servers)

Hardware Requirements:

1. A Pentium PC.
2. Minimum 64 MB of RAM.
3. Minimum of 50 MB of Hard Disk space for the course material.
4. Minimum of 183 MB of Hard Disk space for Oracle 8 Enterprise Edition. Allow additional 80 MB for the documentation (Optional).

Software Requirements.

1. Windows NT 4.0 (Workstation or Server) + Service Pack 3 or higher
2. Oracle 8.0.5 Enterprise Edition with:
1. Typical install.
2. The Objects option.
3. The Partitioning option.
4. The pre-configured sample database “ORCL”.
3. Web browser to view the documentation.
4. WinZip to extract the courseware
5. MS Power Point for the class notes.

Note: Before starting the setup, decide on where you want to install the courseware and other materials (Decide on the drive to be used for the material). If drive “C” is to be used, there will be not many changes to the script files.

Course Material Setup

1. Log on to NT as an NT Administrator.

2. (Optional) Create NT user using NT User Manager (Startà ProgramsàAdministrative ToolsàUser Manager) as follows:
• Create an NT user account with the following name and password DBA/oracle.
• Create an NT local group called ORA_DBA and add the DBA user to this group.

Note: Step 2 is required only when setting up the course in a lab environment

3. Using WinZip, open file (o8_dba_nt.zip). Extract the file to “?:\oracourse”, where “?” is the drive letter you chose for this class. The “?:\oracourse” will be referred to by other script files as CLASS_SOURCE.

4. If you chose to install the course material on Drive “C” and if Oracle Server is installed on drive “C”, you can go to step 8.

5. Edit the file “80DBA.CMD” located in (?:\oracourse\80dba\setup) using any Text Editor (Ex. Notepad). Drive letters are referenced in the following parameters:
• CLASS_SOURCE=c:\oracourse (See step 3 above)
• ORACLE_HOME=c:\orant (The directory where Oracle Server was installed)
• CLASS_HOME=c:\oraclass (The location where all the course material will be created)

6. Edit the file “INIT.DBA” located in (?:\oracourse\80dba\setup). Use any Text Editor (Ex. Notepad).
• compatible=8.0.4. Change the value from 8.0.4 to 8.0.5

If other than drive “C” is used, change the following:

• control_files= C:\oraclass\data\disk1\control01.con.
• background_dump_dest= C:\oraclass\bdump.
• user_dump_dest= C:\oraclass\udump.

7. Edit the file “CREDB.SQL” file located in (?:\oracourse\80dba\setup). Use any Text Editor (Ex. Notepad). Drive letters are referenced in the following parameters:
• DATAFILE ‘C:\oraclass\data\disk1\system01.dbf’
• LOGFILE ‘C:\oraclass\data\disk3\log1a.rdo’
• ‘C:\oraclass\data\disk3\log2a.rdo’

Change the path in the above parameter to reflect your setup.

8. Run the script file as follow:
• Open a DOS Window (Startà Programsà Command Prompt).
• Change the directory to (?:\oracourse\80dba\setup) where ? is the drive letter chosen for your setup.

(Ex. At the command prompt, type: cd c:\oracourse\80dba\setup)

• Submit the 80dba.cmd script by typing its name and hitting the Enter key.
• When prompt for a password, enter “oracle”.

9. Add the following User Environment variables to NT: “ORACLE_SID=DBA”, “CLASS_HOME=?:\ORACLASS” where ‘?’ is the drive letter where you installed the class material. You can follow these steps to add the variables:
• Login to NT using the User Name that will be used for this class (DBA/ORACLE). See step 2 above for more details.
• Right click on My Computer icon on the desktop and select Properties. In the System Properties dialog box displayed, click the Environment tab. Click the User Variable for Administration box.
• Type ORACLE_SID in the Variable field. Type DBA in the Value field. Click the Add button.
• Type CLASS_HOME in the Variable field. Type ?:\ORACLASS in the Value field, where ‘?’ is the drive letter. Click the Add button.
• Click the OK button in the System Properties dialog box.

Net8 Configuration.

If you are unfamiliar with using any of Net8 configuration utilities, follow these steps to configure your environment.

1. Edit “LISTENER.ORA” file as follows:
1. For backup purposes, rename “LISTENER.ORA” file located in “?:\orant\net80\admin”.
2. Using a text editor, open the “LISTENER.ORA” file located “?:\oracourse\80dba\setup” where ? is the drive letter chosen for your setup.
3. Replace any occurrence of “XXXXX” with your Computer Name. See note below on how to obtain the Computer Name.
4. Save and copy the file to “?:\orant\net80\admin”.

Note: Right click Network Neighborhood icon on your desktop. Select Properties. In the Network dialog box, select the Identification tab. Copy the Computer Name.

2. Edit “TNSNAMES.ORA” file as follows:
1. For backup purposes, rename “TNSNAMES.ORA” file located in “?:\orant\net80\admin”
2. Using a text editor, open the “TNSNAMES.ORA” file located “?:\oracourse\80dba\setup” where ? is the drive letter chosen for your setup.
3. Replace any occurrence of “CLASSROOM_WORKSTATION” with your Computer Name. See note below on how to obtain the Computer Name.
4. Save and copy the file to “?:\orant\net80\admin”.

Testing The Configuration

Note:

1. Before performing the test, you should restart the machine so that all changes will take effect.
2. Logon to NT as the user who will be using the setup. Ex. “dba/oracle”.
3. (To Dr. Callan) The testing is copied from item 12 in the Setup document provided with the courseware (setupforOracle8forNT.txt).

1. Open a DOS box and start Server Manager line mode.

C:>svrmgr30

2. Connect as the internal user with a password of oracle.

SVRMGR >connect internal/oracle

Connected.

3. Shutdown the database.

SVRMGR> shutdown

Database closed.

Database dismounted.

ORACLE instance shut down.

SVRMGR >

4. Startup the database. Note that you will have to specify the path of the “initDBA.ora” file, which may differ in your setup.

SVRMGR> startup pfile=c:\oraclass\database\initDBA.ora

ORACLE instance started.

Total System Global Area 7652636 bytes

Fixed Size 35748 bytes

Variable Size 6457720 bytes

Database Buffers 1126400 bytes

Redo Buffers 32768 bytes

Database mounted.

Database opened.

SVRMGR>

5. Start the NET8 listener and ensure it's listening for connection request to the DBA instance. In a DOS box type the following.

C:\>lsnrctl80 start (Many lines will scroll down the screen but at end you should see the following).

Services Summary

DBA has 1 service handler(s)

6. Test DBA service name in “tnsnames.ora” by connecting with SQL*Plus. In a DOS box type the following and verify that the connection is successful.

C:\>sqlplus system/manager@DBA