Changes between Version 5 and Version 6 of Obsolete/Doc/Monitoring/Lemon

Timestamp:

Nov 19, 2007, 3:25:39 PM (18 years ago)

Author:

/C=BE/O=BEGRID/OU=ULB-VUB/OU=IIHE/CN=Shkelzen Rugovac

Comment:

--

Obsolete/Doc/Monitoring/Lemon

@@ -169 +169 @@
 }}}
 
-=== Server post-install ===
+== Server post-install ==
+
+=== Configure Oracle-XE ===
+
+ * Run the configure command. Just put the same values that you have already set in your QWG templates.
+{{{
+$ /etc/init.d/oracle-xe configure
+
+Oracle Database 10g Express Edition Configuration
+-------------------------------------------------
+This will configure on-boot properties of Oracle Database 10g Express
+Edition.  The following questions will determine whether the database should
+be starting upon system boot, the ports it will use, and the passwords that
+will be used for database accounts.  Press <Enter> to accept the defaults.
+Ctrl-C will abort.
+
+Specify the HTTP port that will be used for Oracle Application Express [8080]:
+
+Specify a port that will be used for the database listener [1521]:
+
+Specify a password to be used for database accounts.  Note that the same
+password will be used for SYS and SYSTEM.  Oracle recommends the use of
+different passwords for each database account.  This can be done after
+initial configuration:
+Confirm the password:
+
+Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]:
+
+Starting Oracle Net Listener...Done
+Configuring Database...Done
+Starting Oracle Database 10g Express Edition Instance...Done
+Installation Completed Successfully.
+To access the Database Home Page go to "http://127.0.0.1:8080/apex"
+}}}
+ From now you have access the Database Home Page by either directly running a webbroswer on the lemon box or from another machine using tunneling[[BR]][[BR]]
+  '''Example''' (from your laptop):
+  * Run this ssh command
+{{{
+ssh -L 18080:localhost:8080 root@lemon.box
+}}}
+  * Then go to "http://localhost:18080/apex"
+
+=== Initiate Databases ===
+
+ * Set the Oracle environment:
+{{{
+source /etc/lemon/lemon-ora.admin_env.sh
+}}}
+
+ * Create databases:
+{{{
+$ sqlplus system@XE
+
+SQL*Plus: Release 10.2.0.1.0 - Production on Mon Nov 19 15:05:58 2007
+
+Copyright (c) 1982, 2005, Oracle.  All rights reserved.
+
+Enter password:
+
+Connected to:
+Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
+
+SQL>create tablespace LEMON_INDX  logging datafile '/var/oracle/lemon_indx.dbf' size 500m autoextend on next 32m maxsize 2048m extent management local;
+SQL>create tablespace LEMON_DATA logging datafile '/var/oracle/lemon_data.dbf' size 1000m autoextend on next 32m maxsize 2048m extent management local;
+SQL>exit;
+}}}
+
+ * You can now initialize databases
+{{{
+lemon-ora.admin --file=/etc/oramon-server.conf --create-schema
+lemon-ora.admin --file=/etc/oramon-server.conf --all
+}}}
+
+ * Start services:
+{{{
+/etc/init.d/OraMon start
+/etc/init.d/lemonnrd start
+}}}
+
+
+ * Edit {{{/etc/php.ini}}}
+{{{
+register_globals = On
+memory_limit = 32M
+register_long_array = on
+}}}
+
+ * Remove following functions from {{{/var/www/html/lrf/oracle.inc}}} :
+{{{
+batchUpdate
+batchUpdateNC
+batchQuery
+}}}
+
+ * Restart Apache
+{{{
+/etc/init.d/httpd restart
+}}}