Lemon installation

From T2B Wiki
Jump to navigation Jump to search

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


Template:TracNotice