install – Monster Oasis

Protected: [archive] Install Oracle Database 11gR2 on Ubuntu 12.04

2017/01/12 by Monster

[note] install oracle 10g on ubuntu 910 steps

2015/02/122010/04/18 by Monster

root@ubuntu910:~# uname -a
Linux ubuntu910 2.6.31-20-generic-pae #58-Ubuntu SMP Fri Mar 12 06:25:51 UTC 2010 i686 GNU/Linux

安裝這些

apt-get update

apt-get upgrade

apt-get install gcc make binutils libaio1 gawk ksh libc6-dev rpm libmotif3 alien lsb-rpm libtool

root@ubuntu910:~# whereis awk

awk: /usr/bin/awk /usr/lib/awk /usr/share/awk /usr/share/man/man1/awk.1.gz

root@ubuntu910:~# whereis rpm

rpm: /usr/bin/rpm /usr/lib/rpm /usr/share/man/man8/rpm.8.gz

root@ubuntu910:~# whereis basename

basename: /usr/bin/basename /usr/share/man/man1/basename.1.gz

修正這些 bin 的 path , oracle 10g

ln -s /usr/bin/awk /bin/awk
ln -s /usr/bin/rpm /bin/rpm
ln -s /usr/bin/basename /bin/basename

設定帳號 / group 及建目錄

addgroup oinstall
addgroup dba
addgroup nobody
usermod -g nobody nobody
useradd --create-home --home-dir /home/oracle --gid dba --shell /bin/bash oracle
usermod --groups admin oracle
chown -R oracle:dba /home/oracle
mkdir -p /u01/app/oracle
chown -R oracle:dba /u01
chmod -R 755 /u01

# 改一下 oracle 的 password
passwd oracle

修改 LINUX OS 系統參數 /etc/sysctl.conf

fs.file-max = 65535
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65535
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144

及 /etc/security/limits.conf

oracle soft nproc 2047
oracle hard nproc 16383
oracle soft nofile 1023
oracle hard nofile 65535

vi ~oracle/.profile

#
#
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=orcl
#
PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin
export PATH
#
unset USERNAME
#
#

reboot ubuntu 讓 OS tunning 參數生效

用 oracle 帳號login

搞定 X window 或在 ubuntu 圖型界面下開始安裝 oracle

X window 參考: https://www.monster.com.tw/archives/1098

圖形界面參考: https://www.monster.com.tw/archives/1709

2015.0211 : OS X REF.: https://www.monster.com.tw/archives/7097

cd /database 後下:

./runInstaller -ignoreSysPrereqs

// ———————————————-

遇到這個問題

INFO: gcc: /usr/lib/libstdc++.so.5: No such file or directory

INFO: /u01/app/oracle/product/10.2.0/db_1/bin/genorasdksh: Failed to link liborasdkbase.so.10.2

INFO: make: *** [liborasdkbase] Error 1

cd /usr/lib

ls -l libstdc++*
lrwxrwxrwx 1 root root     19 2010-04-17 22:14 libstdc++.so.6 -> libstdc++.so.6.0.13
-rw-r--r-- 1 root root 962800 2010-01-10 23:53 libstdc++.so.6.0.13

#
ln -sf libstdc++.so.6.0.13 libstdc++.so.5

遇到這個問題

/u01/app/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole…. not found

oracle@ubuntu910:~$ netstat -an |grep LIST
tcp        0      0 127.0.0.1:6010          0.0.0.0:*               LISTEN
tcp        0      0 0.0.0.0:3938            0.0.0.0:*               LISTEN
tcp        0      0 0.0.0.0:1158            0.0.0.0:*               LISTEN
tcp        0      0 0.0.0.0:5520            0.0.0.0:*               LISTEN
tcp        0      0 0.0.0.0:1521            0.0.0.0:*               LISTEN
tcp        0      0 0.0.0.0:33044           0.0.0.0:*               LISTEN
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN
tcp        0      0 127.0.0.1:631           0.0.0.0:*               LISTEN
tcp6       0      0 ::1:6010                :::*                    LISTEN
tcp6       0      0 :::22                   :::*                    LISTEN
tcp6       0      0 ::1:631                 :::*                    LISTEN
unix  2      [ ACC ]     STREAM     LISTENING     4621     /var/run/cups/cups.sock
unix  2      [ ACC ]     STREAM     LISTENING     3998     @/var/run/hald/dbus-W4TPdf1r7s
unix  2      [ ACC ]     STREAM     LISTENING     2677     @/com/ubuntu/upstart
unix  2      [ ACC ]     STREAM     LISTENING     6110     /var/tmp/.oracle/sEXTPROC0
unix  2      [ ACC ]     STREAM     LISTENING     6108     /var/tmp/.oracle/s#1165.1
unix  2      [ ACC ]     STREAM     LISTENING     6112     /var/tmp/.oracle/s#1165.2
unix  2      [ ACC ]     STREAM     LISTENING     3610     @/var/run/hald/dbus-Empv97RMbr
unix  2      [ ACC ]     STREAM     LISTENING     3564     /var/run/dbus/system_bus_socket

PS note:

開機時自動啟動 oracle database 及 listener – http://www.akadia.com/services/ora_linux_install_10g.html
.

其他相關的檔案/設定:

monster@ubuntu910:~$ cat /etc/fstab
#
/dev/sdb1               none            swap            sw              0 0
/dev/sdc1 /u01 ext2 rw 0 0

monster@ubuntu910:~$ cat /etc/hosts
127.0.0.1       localhost
172.30.0.48     ubuntu910.monster.tw    ubuntu910

#

default 有這幾個 tablespace

SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME
------------------------------
SYSTEM
UNDOTBS1
SYSAUX
TEMP
USERS

99cd3e295eba3ae999545a00f1aff1c8

/u01 這個 partition 至少要 4.7G

所以最好另建一個 partition 來放 Oracle 11gR2 的 install package …

查主機溫度

2009/07/25 by Monster

cat /proc/acpi/thermal_zone/THRM/temperature

kernel 要把 I2O 編進去

裝新的 www.monster.com.tw 過程記錄

2009/09/112009/07/24 by Monster

2009.0724 emerge 這些 packages:

time emerge -av gentoo-sources lilo vim bind vixie-cron syslog-ng dhcpcd xfsprogs openssh samba net-fs/nfs-utils portmap postfix screen ntp cronolog net-mail/mpack app-arch/sharutils unzip net-dns/bind net-dns/bind-tools net-ftp/ftp net-misc/netkit-telnetd net-analyzer/trafshow net-analyzer/tcpdump net-analyzer/traceroute

kernel compile options

<*> Serial ATA (prod) and Parallel ATA (experimental) drivers —>
<*> Intel ESB, ICH, PIIX3, PIIX4 PATA/SATA support

CONFIG_ATA_PIIX:
This option enables support for ICH5/6/7/8 Serial ATA
and support for PATA on the Intel ESB/ICH/PIIX3/PIIX4 series
host controllers.

[*] Ethernet (1000 Mbit) —>
<*> Realtek 8169 gigabit ethernet support

oasis ~ # uname -a
Linux oasis 2.6.29-gentoo-r5 #3 SMP PREEMPT Mon Jul 27 11:39:51 CST 2009 x86_64 Intel(R) Atom(TM) CPU 330 @ 1.60GHz GenuineIntel GNU/Linux

oasis ~ # file /bin/bash
/bin/bash: ELF 64-bit LSB executable, x86-64, version 1 (SYSV), for GNU/Linux 2.6.9, dynamically linked (uses shared libs), stripped

make.conf

CFLAGS="-O2 -pipe"
CXXFLAGS="-O2 -pipe"

CHOST="x86_64-pc-linux-gnu"

USE="mmx sse sse2 -cups -ipv6 ssl apache2 berkdb cjk cli crypt curl gd gdbm iconv mysql mysqli ncurses nls pcre readline reflection session spell spl truetype unicode xml zlib ssl hash calendar json simplexml"

hdparm -tT /dev/sda

/dev/sda:

Timing cached reads: 1080 MB in 2.00 seconds = 539.97 MB/sec

Timing buffered disk reads: 196 MB in 3.01 seconds = 65.19 MB/sec

processor       : 3
vendor_id       : GenuineIntel
cpu family      : 6
model           : 28
model name      : Intel(R) Atom(TM) CPU  330   @ 1.60GHz
stepping        : 2
cpu MHz         : 1596.135
cache size      : 512 KB
physical id     : 0
siblings        : 4
core id         : 0
cpu cores       : 2
apicid          : 1
initial apicid  : 1
fpu             : yes
fpu_exception   : yes
cpuid level     : 10
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx lm constant_tsc arch_perfmon pebs bts rep_good pni dtes64 monitor ds_cpl tm2 ssse3 cx16 xtpr pdcm lahf_lm
bogomips        : 3192.15
clflush size    : 64
cache_alignment : 64
address sizes   : 32 bits physical, 48 bits virtual
power management:

gcc --version gcc (Gentoo 4.3.2-r3 p1.6, pie-10.1.5) 4.3.2 

php --version
PHP 5.2.10-pl0-gentoo (cli) (built: Aug  7 2009 19:23:18)
Copyright (c) 1997-2009 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2009 Zend Technologies

mysql --version
mysql  Ver 14.12 Distrib 5.0.67, for unknown-linux-gnu (x86_64) using readline 5.1
with
senna-1.1.4.tar.gz
tritonn-1.0.12-mysql-5.0.67.tar.gz

裝 dev-php5/pecl-memcache 有點問題

9d15a8d72725c3ef7655c96adb685696

解決:

在 /etc/portage/package.keywords 加上

dev-php5/pecl-memcache

Protected: sqlrelay server install / setup / SOP / 設定 / 啟動

2011/09/232009/04/12 by Monster