upgrade is suggested. During the upgrade, the database objects and constraints (tables, views, indexes, primary and foreign keys) are created or updated. Once any necessary upgrades have been completed, the dbwriter installation creates two files:
■ A start script $SGE_ROOT/$SGE_CELL/common/sgedbwriter
■ A configuration file $SGE_ROOT/$SGE_CELL/common/dbwriter.conf. 21. Specify whether dbwriter should start at boot time. See lines 152 through 161 of
the Example dbwriter Installation. If you choose not to start dbwriter
automatically, the SMF will not be used. If you choose not to start dbwriter
automatically and you ran the installations script with the option -nosmf, RC scripts will not be created. To start the dbwriter manually, use one of the following commands:
# /etc/init.d/sgedbwriter start
# $SGE_ROOT/$SGE_CELL/common/sgedbwriter start
2.25.10 Example dbwriter Installation
The following example shows a complete dbwriter installation. The steps in this example are referred to from the dbwriter installation and configuration description at How to Install dbwriter.
Step 4 001 % su 002 password: 003 # cd $SGE_ROOT/dbwriter 004 # ./inst_dbwriter 005
006 Welcome to the Grid Engine ARCo dbwriter module 007 installation 007 --- 008 The installation will take approximately 5 minutes
009
Installing the Accounting and Reporting Console (ARCo)
Step 5
011 Checking $SGE_ROOT directory 012 --- 013
014 The Grid Engine root directory is: 015
016 $SGE_ROOT = /mydiskhome/myuser/sge62 017
018 If this directory is not correct (e.g. it may 019 contain an automounter
020 prefix) enter the correct path to this directory 021 or hit <RETURN>
022 to use default [/mydiskhome/myuser/sge62] >> 023
024 Your $SGE_ROOT directory: /mydiskhome/myuser/sge62 025
026 Hit <RETURN> to continue >> Step 6
027 Grid Engine cells 028 --- 029
030 Grid Engine supports multiple cells. 031
032 If you are not planning to run multiple Grid Engine clusters or if you don't 033 know yet what is a Grid Engine cell it is safe to keep the default cell name 034
035 default 036
037 If you want to install multiple cells you can enter a cell name now. 038
039 The environment variable 040
041 $SGE_CELL=<your_cell_name> 042
043 will be set for all further Grid Engine commands. 044
045 Enter cell name [default] >> 046
047 Using cell >default<. 048 Hit <RETURN> to continue >> Step 7
049 Java setup 050 --- 051
052 ARCo needs at least java 1.5 053
054 Enter the path to your java installation [/usr/java] >> Step 8
055 Dbwriter configuration file 056 --- 057
058 /mydiskhome/myuser/sge62/default/common/dbwriter.conf found. 059
Installing the Accounting and Reporting Console (ARCo)
Step 9
061 Setup your database connection parameters 062 --- 063
064 Enter your database type ( o = Oracle, p = PostgreSQL, m = MySQL ) [] >> o 065
066 Enter the name of your oracle database host [] >> ge4 067
068 Enter the port of your oracle database [1521] >> 069
070 Enter the name of your oracle database [arco] >> arco Step 10
071 Enter the name of the database user [arco_write] >> arco_write 072
073 Enter the password of the database user >> 074 Retype the password >>
Step 11
075 The arco_write must have permissions to create objects in the specified tablespace.
076
077 Enter the name of TABLESPACE for tables [USERS] >> 078
079 Enter the name of TABLESPACE for indexes [USERS] >> Step 12
080 Enter the name of the database schema [arco_write] >> arco_write 081
Step 13
082 The ARCo web application connects to the database with a user which has restricted
083 access. The name of this database user is needed to grant him access to the sge tables
084 and must be different from arco_write.
085 Enter the name of this database user [arco_read] >> arco_read 086
087 This user will also create the synonyms for the ARCo tables and views. 088
089 Enter the password of the database user >> 090 Retype the password >>
Step 14
091 Database connection test 092 --- 093
094 Searching for the jdbc driver oracle.jdbc.driver.OracleDriver 095 in directory /mydiskhome/myuser/sge62/dbwriter/lib
096
097 OK, jdbc driver found 098
099 Should the connection to the database be tested? (y/n) [y] >> 100
101
Installing the Accounting and Reporting Console (ARCo)
Step 15
103 Generic parameters 104 --- 105
106 Enter the interval between two dbwriter runs in seconds [60] >> Step 16
107 Enter the path of the dbwriter spool directory [/mydiskhome/myuser/sge62/default/spool/dbwriter]>> Step 17
108 Enter the file with the derived value rules
[/mydiskhome/myuser/sge62/dbwriter/database/oracle/dbwriter.xml] >> Step 18
109 The dbwriter can run with different debug levels 110 Possible values: WARNING INFO CONFIG FINE FINER FINEST 111 Enter the debug level of the dbwriter [INFO] >> Step 19
112 All parameters are now collected 113 --- 114 115 SGE_ROOT=/mydiskhome/myuser/sge62 116 SGE_CELL=default 117 JAVA_HOME=/opt/jdk1.5.0 (1.5.0_13) 118 DB_URL=jdbc:oracle:thin:@ge4:1521:orcl 119 DB_USER=arco_write 120 READ_USER=arco_read 121 TABLESPACE=USERS 122 TABLESPACE_INDEX=USERS 123 DB_SCHEMA=arco_write 124 INTERVAL=60 125 SPOOL_DIR=/mydiskhome/myuser/sge62/default/spool/dbwriter 126 DERIVED_ FILE=/mydiskhome/myuser/sge62/dbwriter/database/oracle/dbwriter.xml 127 DEBUG_LEVEL=INFO 128
129 Are these settings correct? (y/n) [y] >> Step 20
130 Database model installation/upgrade 131 ---
132 Query database version ... no sge tables found 133 New version of the database model is needed 134
135 Should the database model be upgraded to version 8? (y/n) [y] >> 136
137 Upgrade to database model version 8 ... Install version 6.0 (id=0) --- 138 Create table sge_job
139 Create index sge_job_idx0 140 .
141 . 142 .
143 Update version table 144 committing changes
Installing the Accounting and Reporting Console (ARCo)
146 OK
147 Create start script sgedbwriter in /mydiskhome/myuser/sge62/default/common 148
149 Create configuration file for dbwriter in /mydiskhome/myuser/sge62/default/common
150
151 Hit <RETURN> to continue >> Step 21
152 dbwriter startup script 153 --- 154
155 Do you want to start dbwriter automatically at machine boot? 156 NOTE: If you select "n" SMF will be not used at all! (y/n) [y] >> n 157
158 Creating dbwriter spool directory
/mydiskhome/myuser/sge62/default/spool/dbwriter 159 starting dbwriter
160 dbwriter started (pid=4714) 161 Installation of dbwriter completed
2.25.11 How to Install Reporting
Before You Begin
Before you begin, verify that the Sun Java Web Console is installed as explained in How to Install Sun Java Web Console.
Steps
1. Change directory to $SGE_ROOT/reporting.