Lemon installation

Lemon installation

oracle-xe

• install oracle rpms
• /etc/init.d/oracle-xe configure
  • this will prompt you for a passwd and will initilaise the db.
• connect to 127.0.0.1:8080/apex and add the lmon user and grant it dba role.
• create directory /var/oracle and do a chown oracle.dba /var/oracle
• initialise the environment and connect as user lemon to the XE db.

 . /etc/sysconfig/OraMonMachineSpecific
 sqlplus lemon@XE

• there run

 create tablespace LEMON_INDX logging datafile '/var/oracle/lemon_indx.dbf' size 500m autoextend on next 32m maxsize 2048m extent management local;
 create tablespace LEMON_DATA logging datafile '/var/oracle/lemon_data.dbf' size 1000m autoextend on next 32m maxsize 2048m extent management local;

• run (/etc/oramon-server.conf is generated by ncm-oramonserver)

 . /etc/sysconfig/OraMonMachineSpecific
 lemon-ora.admin --create-schema --file=/etc/oramon-server.conf --al

• modify /etc/php.ini

 memory_limit = 32M
 register_globals = On
 register_long_arrays = On

• /etc/init.d/lemonrd neds the correct oracle environment. use the same one as httpd.

 #ORACLE_HOME=/oracle
 . /etc/sysconfig/httpd