Поднимаем Oracle в CentOS

0. Инструкция для OracleXE
1. качаем образ
2. качаем pendrivelinux
3. заливаем образ на флешку
4. загружаемся и выбираем network installation
5. адрес
    mirror.yandex.ru
    /centos/5.5/os/x86_64
6. набор пакетов server GUI
7. ставим пакеты:
    yum install mc
    yum install libaio-devel
    yum install unixODBC-devel
    yum install pdksh7. Создаем пользователя и добавляем его в sudoers
    useradd oracle
    passwd oracle
    visudo:
        oracle ALL=(ALL) ALL8. логинимся из под oracle
9. Oracle validated
    wget http://oss.oracle.com/el5/RPM-GPG-KEY-oracle (http://clck.ru/1c5g)
    rpm --import RPM-GPG-KEY-oracle
    wget http://oss.oracle.com/el5/oracle-validated/oracle-validated-1.0.0-22.el5.x86_64.rpm (http://clck.ru/1c4i)
    yum install oracle-validated-1.0.0-22.el5.x86_64.rpm
10. Tomcat
    wget http://www.sai.msu.su/apache//tomcat/tomcat-6/v6.0.29/bin/apache-tomcat-6.0.29.zip (http://clck.ru/1e_b)
    unzip apache-tomcat-6.0.29.zip11. Java
    wget http://cds.sun.com/is-bin/INTERSHOP.enfinity/WFS/CDS-CDS_Developer-Site/en_US/-/USD/VerifyItem-Start/jdk-6u21-linux-x64.bin?BundledLineItemUUID=6s2J_hCvUuYAAAErqyspGzz6&OrderID=ge6J_hCvZAAAAAErkyspGzz6&ProductID=xKiJ_hCySHIAAAEpT7wzBGsB&FileName=/jdk-6u21-linux-x64.bin (http://clck.ru/1e_d)
    mv jdk<tab> jdk
    chmod +x jdk
    ./jdk12. по sftp заливаем оракл, проверяем контрольные суммы и распаковываем
    cksum linux<tab>1of2.zip
    cksum linux<tab>2of2.zip
    unzip linux<tab>1of2.zip
    unzip linux<tab>2of2.zip13. Директории
    mkdir ora11
    mkdir oradb
    mkdir orainv10. возможно изменяем размер shm
    /etc/fstab
    tmpfs size=6G
11. убиваем selinux=disabled в файл /etc/selinux/config
12. заходим в гуй и открываем терминал
    startx
13. ставим бинарники
    ./database/runInstaller
    - db only
    - single
    - rus+eng
    - standart
    - base : oradb location : ora11
    - orainv
    -
    -
    - sudo ~/orainv/orainstRoot.sh
    - sudo ~/ora11/root.sh
14. поднимаем Listener
    ~/ora11/bin/netca
15. развертываем базу
    ~/ora11/bin/dbca
    - create
    - general
    - xe
    -
    - ********
    -
    -
    -
    -memory: 6144; processes: 500; characterset: CL8MSWIN125116. копируем файл настроек
    cp ~/oradb/admin/xe/pfile/init.ora<tab>
17. Стартуем базу
    lsnrctl start
    sqlplus
        startup
18. Заливаем в томкат необходимые либы и прописываем JAVA_HOME
19. Автоматический запуск сервисов

Ставим rlwrap

alias sqlp='rlwrap -f ~/.sqlplus sqlplus'
http://rpm.pbone.net/index.php3/stat/4/idpl/14484249/dir/redhat_el_5/com/rlwrap-0.37-1.el5.x86_64.rpm.html

Словарь

COPY PAUSE SHUTDOWN
DEFINE PRINT SPOOL
DEL PROMPT SQLPLUS
ACCEPT DESCRIBE QUIT START
APPEND DISCONNECT RECOVER STARTUP
ARCHIVE LOG EDIT REMARK STORE
ATTRIBUTE EXECUTE REPFOOTER TIMING
BREAK EXIT REPHEADER TTITLE
BTITLE GET RESERVED UNDEFINE
CHANGE HELP RESERVED VARIABLE
CLEAR HOST RUN WHENEVER
copy pause shutdown
define print spool
del prompt sqlplus
accept describe quit start
append disconnect recover startup
archive log edit remark store
attribute execute repfooter timing
break exit repheader ttitle
btitle get reserved undefine
change help reserved variable
clear host run whenever
ALL ALTER AND ANY ARRAY ARROW AS ASC AT
BEGIN BETWEEN BY
CASE CHECK CLUSTERS CLUSTER COLAUTH COLUMNS COMPRESS CONNECT CRASH CREATE CURRENT
DECIMAL DECLARE DEFAULT DELETE DESC DISTINCT DROP
ELSE END EXCEPTION EXCLUSIVE EXISTS
FETCH FORM FOR FROM
GOTO GRANT GROUP
HAVING
IDENTIFIED IF IN INDEXES INDEX INSERT INTERSECT INTO IS
LIKE LOCK
MINUS MODE
NOCOMPRESS NOT NOWAIT NULL
OF ON OPTION OR ORDEROVERLAPS
PRIOR PROCEDURE PUBLIC
RANGE RECORD RESOURCE REVOKE
SELECT SHARE SIZE SQL START SUBTYPE
TABAUTH TABLE THEN TO TYPE
UNION UNIQUE UPDATE USE
VALUES VIEW VIEWS
WHEN WHERE WITH
all alter and any array arrow as asc at
begin between by
case check clusters cluster colauth columns compress connect crash create current
decimal declare default delete desc distinct drop
else end exception exclusive exists
fetch form for from
goto grant group
having
identified if in indexes index insert intersect into is
like lock
minus mode
nocompress not nowait null
of on option or orderoverlaps
prior procedure public
range record resource revoke
select share size sql start subtype
tabauth table then to type
union unique update use
values view views