Previous     Contents     Index     Next     
iPlanet BuyerXpert 4.5 Installation Guide



Chapter 2   Installing Oracle Database


This chapter provides information about installing the Oracle 8.1.7 / 9i Database Server Standard or Enterprise Edition for Solaris 8 operating systems. You must install this software before installing BuyerXpert.

Detailed information regarding Oracle products can be found in the Oracle documentation set.


Note The following instructions are only guidelines for installing Oracle software. Your individual Oracle configuration may be different.




Hardware Requirements


Before installing Oracle, make sure that your hardware is sufficient. You should have the following on your system:

  • At least 128 MB of RAM

  • CD ROM drive

  • Swap space of at least 400MB or twice the RAM size

  • At least 1300 MB of disk space

This allows you to perform a typical installation to create a simple database for prototyping. A real implementation requires more RAM and more disk space.

The following assumptions are made for this example of an Oracle installation:

Table 2-1    Assumptions for Example of an Oracle Installation

ORACLE_HOME  

/expert/oracle8  

Oracle group  

dba  

Oracle user  

oracle  



Installing Oracle



Note The following steps are for installing Oracle 8.1.7 / 9i Database Server Enterprise Edition only.


  1. Start the installation process as root:

    %su -

  2. Create a directory for Oracle installation:

    %mkdir -p /export/oracle8

  3. Create a UNIX group that will be used by Oracle:

    %groupadd dba

  4. Create a UNIX user that will be the Oracle owner:

    %useradd -g dba -d /export/oracle8 -s /bin/csh oracle

  5. Change the ownership of the Oracle directory:

    %chown oracle:dba /export/oracle8

  6. Create a password for oracle user:

    %passwd oracle

  7. In any text editor, open the /etc/system file and append the following lines:

    set shmsys:shminfo_shmmax=4294967295

    set shmsys:shminfo_shmmin=1

    set shmsys:shminfo_shmmni=600

    set shmsys:shminfo_shmseg=100

    set semsys:seminfo_semmap=100

    set semsys:seminfo_semmns=4096

    set semsys:seminfo_semmnu=4096

    set semsys:seminfo_semume=100

    set semsys:seminfo_semmsl=100

    set semsys:seminfo_semopm=100

    set semsys:seminfo_semvmx=32767

    * -------------

    * Message Queue

    * --------------

    set msgsys:msginfo_msgmap=1024

    set msgsys:msginfo_msgmax=8192

    set msgsys:msginfo_msgmnb=65535

    set msgsys:msginfo_msgmni=1024

    set msgsys:msginfo_msgssz=2048

    set msgsys:msginfo_msgtql=1024

    set msgsys:msginfo_msgseg=4096

  8. Add the following lines to your .cshrc file:

    setenv ORACLE_BASE /export/oracle8

    setenv ORACLE_HOME /export/oracle8

    setenv ORACLE_SID BXpert

    setenv PATH $ORACLE_HOME/bin:$PATH

    setenv LD_LIBRARY_PATH/export/Oracle8/lib:$LD_LIBRARY_PATH

    setenv TNS_ADMIN /export/oracle8/network/admin

    setenv NLS_LANG AMERICAN_AMERICA.US7ASCII


    Note If you want to use character set UTF8, then change:

    NLS_LANG to AMERICAN_AMERICA.UTF8


  9. Enter the following commands to boot the system:

    %sync

    %sync

    %sync

    %reboot

  10. After the system is booted, change the user to Oracle:

    %su oracle

    %password: oracle

  11. Make sure that you have sourced the .cshrc file.

  12. Set the DISPLAY variable:

    %setenv DISPLAY <hostname>:0.0

  13. From a different terminal window (that does not have Oracle as the user), type:

    %xhost +

    This allows the database installation to display on your screen.

  14. From the Oracle CD, type:

    ./runInstaller

  15. When the welcome screen displays, click Next.

    The File Locations screen displays.



  16. Leave the Source field unchanged.

    The Destination field shows the ORACLE_HOME value that you have set in your environment.

  17. Click Next.

    The UNIX Group Name screen displays.

  18. Enter the name of the UNIX group you created earlier for Oracle (dba).

  19. Click Next.

    The Available Products screen displays.



  20. Choose Oracle8i Enterprise Edition 8.1.7.0.0.

  21. Click Next.

    The Installation Types screen displays.



  22. Select the Typical install to get a basic set of Oracle software installed.

  23. Click Next.

    The Database Identification screen displays.



  24. Enter the ORACLE_SID you are creating for both the Global Database Name and SID.

  25. Click Next.

    The Database File Location screen displays.



  26. Enter the directory you have created earlier to install Oracle.

  27. Click Next.

    The Summary screen displays.

  28. Review all the selections you have made to confirm that they are correct.

  29. Click Install.

    During installation, a Setup Privileges window displays.



    The installation pauses at this point, waiting for you to run a script as root.

  30. Follow the instructions and run the root.sh script as a root user.

  31. After executing the script, click OK.

  32. Click Next.

    When Oracle installation has completed, a screen displays the database information.

  33. Verify that information.

  34. Click OK.

    This is the end of Oracle Installation.

  35. Click Exit.

    During the installation, a default database instance is created. The instance is created in the name that you have provided in the Database Identification screen. You do not want to use this instance since it is not configured to BuyerXpert's specification.

  36. You need to remove this instance by executing dbassist from <ORACLE_HOME>/bin directory and select delete a database.

  37. Click Next.

  38. Select the database instance (there should only be one instance since you just created the database server).

  39. Click Finish.

    The database instance should now be deleted.



Create an Oracle Instance

The following procedures are to create an Oracle instance that is configured to BuyerXpert 4.5.

You now need to create an Oracle instance that is configured to the specification of BuyerXpert.

  1. Execute dbassist from <ORACLE_HOME>/bin directory.

    The Welcome screen displays.



  2. Select create a database.

  3. Click Next.

    The Select the type of database to create screen displays.

    To configure to BuyerXpert's specification, you need to customize the creation of the database instance.



  4. Select the custom option.

  5. Click Next.

    The Select the primary type of application that will be used within this database screen displays.



  6. Select Online Transaction Processing (OLTP).

  7. Click Next.

  8. When the next screen displays, enter the approximate number of users to be concurrently (simultaneously) connected to the database at any given time.

    Oracle Database Configuration Assistant uses this value and the information you provided about your database environment on the previous screen to set rollback information and various initialization file parameters.
    Note MTS is configured for you if you selected OLTP as your database environment and entered a value of 20 or more for the number of users to be concurrently connected to the database in the Create Typical Database screen.


    For BuyerXpert, you need at least 20 users.

  9. Click Next.

    The Select the mode in which you want your database to operate by default screen displays.



  10. Since only a small amount of BuyerXpert uses this instance, select Dedicated Server Mode.

  11. Click Next.

    The Select the options you want to configure for use in your database screen displays.



  12. Click the following checkboxes:

    • Oracle Time Series

    • Oracle Spatial

    • Oracle JServer

    • Oracle InterMedia

    • Oracle Visual Information Retrieval

    • SQL*Plus help

  13. Click Next.

    The Review the following database information screen displays.



  14. Enter the database name.

  15. Enter the SID.

    If your NLS_LANG is set to UTF-8, then the character set is UTF-8.

  16. If you want to change it, click Change Character Set...

    Make sure that the environment NLS_LANG is set to the character set that you selected.

  17. Click Next.

    The Review the following control file parameter information screen displays.


    Note The following steps create control, dbf, and log files in the oradata/ORACLE_SID directory.

    By default, the oradata directory is located in ORACLE_HOME.

    If you do not have enough disk space, consider creating an oradata/ORACLE_SID directory on a different disk and save the control, dbf, and log files there.




  18. Enter the location of the control files.

    The recommended parameters are:

    • Maximum Datafiles: 254

    • Maximum Log Files: 32

    • Maximum Log Members: 2

  19. Click Next.

    The System tablespace information screen displays.



  20. Enter the system tablespace information.

    The recommended parameters are:

    • Size (MB): 300

    • Auto Extend: OFF

    • Minimum Extent (KB): 128

    • %Increase: 0

    • Initial (KB): 128

    • Next (KB): 128

    • Min: 1

    • Max: 500

    Enter the location where you want to save the system01.dbf file.

  21. Click Next (or click the Tools tab).

    The Tools tablespace information screen displays.



  22. Enter the tools tablespace information.

    • The recommended parameters are:

    • Name: TOOLS

    • Size (MB): 8

    • Auto Extend: OFF

    • Minimum Extent (KB): 128

    • %Increase: 0

    • Initial (KB): 128

    • Next (KB): 128

    • Min: 1

    • Max: 100

  23. Enter the location where you want to save the tools01.dbf file.

  24. Click Next (or click the User tab).

    The User tablespace information screen displays.



  25. Enter the user tablespace information.

    The recommended parameters are:

    • Name: TS01

    • Size (MB): 500

    • Auto Extend: OFF

    • Minimum Extent (KB): 128

    • %Increase: 0

    • Initial (KB): 128

    • Next (KB): 128

    • Min: 1

    • Max: 500

  26. Enter the location where you want to save the ts01.dbf file.

  27. Click Next (or click the Rollback tab).

    The Rollback tablespace information screen displays



  28. Enter the rollback tablespace information.

    The recommended parameters are:

    • NAME: RBS

    • Size (MB): 200

    • Auto Extend: OFF

    • Minimum Extent (KB): 2048

    • %Increase: 0

    • Initial (KB): 1024

    • Next (KB): 1024

    • Min: 2

    • Max: 500

  29. Enter the location where you want to save rbs01.dbf file.

  30. Click Next (or click the Index tab).

    The Index tablespace information page displays.



  31. Enter the index tablespace information.

    The recommended parameters are:

    • Name: TS02

    • Size (MB): 200

    • Auto Extend: OFF

    • Minimum Extent (KB): 128

    • %Increase 0

    • Initial (KB): 128

    • Next (KB): 128

    • Min: 1

    • Max: 500

  32. Enter the location where you want to save the indx01.dbf file.

  33. Click Next (or click the Temporary tab).

    The Temporary tablespace information screen displays.



  34. Enter the temporary tablespace information.

    The recommended parameters are:

    • Name: TEMP

    • Size (MB): 100

    • Auto Extend: OFF

    • Minimum Extent (KB): 2048

    • Initial (KB): 1024

    • Next (KB): 1024

  35. Enter the location where you want to save the temp01.dbf file.

  36. Click Next (or click the interMedia tab).

    The interMedia tablespace information screen displays.



  37. Enter the interMedia tablespace information.

    The recommended parameters are:

    Name: DRSYS

    Size (MB): 300

    Auto Extend: OFF

    Minimum Extent (KB): 128

    %Increase 0

    Initial (KB): 128

    Next (KB): 128

    Min: 1

    Max: 500

  38. Enter the location where you want to save the drsys01.dbf file.

  39. Click Next.

    The redo log file screen displays.



  40. Enter the redo log file location.

  41. Enter the redo file size.

    The recommended file sizes are:

    • Redo Log 1 File Size (KB): 10240

    • Redo Log 2 File Size (KB): 10240

    • Redo Log 3 File Size (KB): 10240

  42. Click Next.

    The logging parameter information screen displays.



  43. Enter the login parameter information.

    The recommend parameters are:

    • Checkpoint Interval: 10000

    • Checkpoint Timeout (Sec): 1800

  44. Click Next.

    The SGA parameter information screen displays



  45. Enter the System Global Area (SGA) information.

    The recommended parameters are:

    • Shared Pool Size (Bytes): 115343336

    • Block Buffers: 10480

    • Log Buffer Size (Bytes): 163840

    • Processes: 100

    • Block Size (Bytes): 8192


      Note



      Note
      • Block size is very important - make sure you have at least 8192 bytes.

      • The parameters on this screen impact the System Global Area (SGA) of your database. Each time an Oracle8i database instance is started, the SGA is allocated in memory. The SGA is a group of shared memory structures that contain data and control information for one Oracle8i database system. If multiple users are concurrently connected to the same database instance, the data in the SGA is shared among the users.

        • The default values that appear here for the SHARED_ POOL_SIZE, DB_BLOCK_BUFFERS, DB_BLOCK_ SIZE, and PROCESSES parameters are based on the number of concurrent users and database environment type (OLTP, DSS, or Hybrid) that you selected on previous screens.


  46. Click Next.

    The Trace File Directory screen displays.



  47. Review the directory paths and make any appropriate changes.

  48. Click Next.

    The final create a database screen displays.



  49. Select Create Database Now.

  50. Click Finish.

    This process can take approximately 2-3 hours.

  51. After completion of creating the database instance, stop the Oracle instance by entering the following (if using Oracle 8.1.7):

    %svrmgrl

    %SVRMGRL> connect internal

    %SVRMGRL> shutdown immediate

    %SVRMGRL> quit

    Or, if using Oracle 9i, enter the following:

    %sqlplus /nolog

    %sqlplus> connect / as sysdba;

    %sqlplus> shutdown immediate;

    %sqlplus> quit

  52. To make sure listener is running, enter the following:

    %lsnrctl status

  53. If listener is not running, start the listener by entering:

    %lsnrctl start

  54. In the init<ORACLE_SID>.ora file located in ORACLE_HOME/admin/XXX/pfile directory, make the following modifications:

    #change open_cursors to 300

    open_cursors = 300

    #uncomment rollback_segments, where x can go up to 25

    rollback_segments = ( RBS0, RBS1, RBS2, RBS3, RBS4, RBS5, RBS6, ...RBSx )

    #modify or add optimizer_max_permutation and set it to 1000

    optimizer_max_permutations = 1000

    #Verify that remote login is commented

    #remote_login_passwordfile=exclusive

    #remove or comment out the line

    #NLS_NUMERIC_CHARACTER = ",."

  55. Restart the database instance by entering the following (if using Oracle 8.1.7):

    %svrmgrl

    %SVRMGRL> connect internal

    %SVRMGRL> startup

    %SVRMGRL> quit

    Or, if using Oracle 9i, enter the following:

    %sqlplus /nolog

    %sqlplus> connect / as sysdba;

    %sqlplus> startup

    %sqlplus> quit

    This concludes the Oracle installation.


Previous     Contents     Index     Next     
Copyright © 2002 Sun Microsystems, Inc. All rights reserved.

Last Updated June 10, 2002