LINUX+ORACLE 11G所有安装命令-优快云博客

按照oracle官方网站配置，我配置了一下oracle11g，绝对是权威的资料。不带个人色彩。

由于时间匆匆，没有做每个步骤说明，如果读者需要问个明白请和我联系。

QQ 149196034

$ xhost somehost.us.example.com

$ telnet fully_qualified_remote_host_name

On Linux x86:
At least 1 GB of RAM
[root@primary ~]# grep MemTotal /proc/meminfo
MemTotal: 4147052 kB

RAM Swap Space
Between 1 GB and 2 GB 1.5 times the size of RAM
Between 2 GB and 16 GB Equal to the size of RAM
More than 16 GB 16 GB

On Linux x86-64:
■ At least 4 GB of RAM
To determine the RAM size, enter the following command:
# grep MemTotal /proc/meminfo

RAM Swap Space
Between 4 GB and 8 GB 2 times the size of RAM
Between 8 GB and 32 GB 1.5 times the size of RAM
More than 32 GB 32 GB

# grep SwapTotal /proc/meminfo

# free

/dev/shm greater of memeory_max_target memory_target
ora-00845 erro
sga pga

MEMORY_MAX_TARGET and MEMORY_TARGET cannot be used
when LOCK_SGA is enabled or with HugePages on Linux.

db_name(8 character),db_unique_name (global name)

# mount -t tmpfs shmfs -o size=7g /dev/shm
vi /etc/fstab
shmfs /dev/shm tmpfs size=7g 0

uname -m

[root@primary shm]# cat /proc/version
Linux version 2.6.9-89.ELsmp (mockbuild@builder10.centos.org) (gcc version 3.4.6 20060404 (Red Hat 3.4.6-11
)) #1 SMP Mon Jun 22 12:32:43 EDT 2009

For Linux x86
■ On Oracle Linux 4 and Red Hat Enterprise Linux 4:
2.6.9 or later
■ On Asianux Server 3, Oracle Linux 5, and Red Hat Enterprise Linux 5:
2.6.18 or later
■ On SUSE Linux Enterprise Server 10:
2.6.16.21 or later
■ On SUSE Linux Enterprise Server 11:
2.6.27.19 or later
For Linux x86-64
■ On Oracle Linux 4 and Red Hat Enterprise Linux 4:
2.6.9 or later
■ On Oracle Linux 5 Update 5 and Red Hat Enterprise Linux 5 Update 5:
– The Unbreakable Enterprise Kernel based on the 2.6.32 stable kernel
– The Red Hat compatible kernel for strict Red Hat compatibility
Refer to "About Oracle Unbreakable Enterprise Kernel for Linux" on page 1-4
■ On Asianux Server 3, Oracle Linux 5 Update 2, and Red Hat Enterprise Linux 5
Update 2:
2.6.18 or later
■ On SUSE Linux Enterprise Server 10:
2.6.16.21 or later
■ On SUSE Linux Enterprise Server 11:
2.6.27.19 or later
To determine whether the required kernel is installed, enter the following command:

uname -r
[root@primary shm]# uname -r
2.6.9-89.ELsmp

additional software requirements
oracle odbc drives
oracle jdbc/oci drivers
linux-pam library
oracle messaging gateway
browser requirements
preinstallation requirement for oracle database vault

To use ODBC on Linux x86, the following additional 32-bit ODBC RPMs are required:
■ On Oracle Linux 4 and Red Hat Enterprise Linux 4:
unixODBC-2.2.11 (32 bit) or later
unixODBC-devel-2.2.11 (32 bit) or later
■ On Asianux Server 3, Oracle Linux 5, and Red Hat Enterprise Linux 5:
unixODBC-2.2.11 (32 bit) or later
unixODBC-devel-2.2.11 (32 bit) or later
■ On SUSE 10:
unixODBC-32bit-2.2.11 (32 bit) or later
unixODBC-devel-32bit-2.2.11 (32 bit) or later
■ On SUSE 11:
unixODBC-32bit-2.2.12 (32-bit) or later
unixODBC-devel-32bit-2.2.12 (32 bit) or later
To use ODBC on Linux x86-64, the following additional ODBC RPMs are required:
■ On Oracle Linux 4 and Red Hat Enterprise Linux 4:
unixODBC-2.2.11 (32 bit) or later
unixODBC-devel-2.2.11 (64 bit) or later
unixODBC-2.2.11 (64 bit ) or later
■ On Asianux Server 3, Oracle Linux 5, and Red Hat Enterprise Linux 5:
unixODBC-2.2.11 (32 bit) or later
unixODBC-devel-2.2.11 (64 bit) or later
unixODBC-2.2.11 (64 bit) or later
■ On SUSE 10:
unixODBC-32bit-2.2.11 (32 bit) or later
unixODBC-2.2.11 (64 bit ) or later
unixODBC-devel-2.2.11 (64 bit) or later
■ On SUSE 11:
unixODBC-2.2.12 or later
unixODBC-devel-2.2.12 or later
unixODBC-32bit-2.2.12 (32 bit) or later

Enabling Core File Creation
/proc/sys/kernel/suid_dumpable
/proc/sys/fs/suid_dumpable
/proc/sys/kernel/core_setuid_ok

1. Use a text editor to open the /etc/profile file of the Oracle Grid Infrastructure
installation owner, and find the following line:
ulimit –S –c 0 > /dev/null 2>&1
Change it to the following:
ulimit -S -c unlimited > /dev/null 2>&1
2. Use a text editor to open /etc/sysctl.conf, and find the following line:
kernel.core_uses_pid
Confirm that it is set to 1. This setting appends the PID to the generated core file,
which allows multiple core file dumps.
If kernel.core_uses_pid is missing, then add the following line:
kernel.core_uses_pid = 1

3. Find the following line:
fs.suid_dumpable
By default, this value is set to 0. Change it to 1.
If fs.suid_dumpable is not in the sysctl.conf file, then add the following
line:
fs.suid_dumpable = 1
4. Save /etc/sysctl.conf, and use the following command to reload settings:
# sysctl -p

安装环境检查工具 cvuqdisk
# rpm -qi cvuqdisk
# rpm -e cvuqdisk

$ ORACLE_HOSTNAME=somehost.us.example.com
$ export ORACLE_HOSTNAME

grep oinstall /etc/group

/usr/sbin/groupadd oinstall

/usr/sbin/groupadd -g 502 dba

/usr/sbin/groupadd -g 506 asmdba
# /usr/sbin/groupadd -g 505 asmoper

useradd -u 502 -g oinstall -G dba,asmdba,asmoper oracle

/etc/security/limits.conf

vi /etc/security/limits.conf
最后面加
#
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
oracle hard stack 32768

Configuring Kernel Parameters for Linux
/etc/sysctl.conf

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586

生效:
SUSE Linux
# /sbin/chkconfig boot.sysctl on
redhat:
# /sbin/sysctl -p

oracle BASE directory
# mkdir -p /u01/app/oracle
# chown -R oracle:oinstall /u01/app/oracle
# chmod -R 775 /u01/app/oracle

■ Bourne, Bash, or Korn shell:
$ ORACLE_SID=+ASM
$ export ORACLE_SID
$ ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid
$ export ORACLE_HOME
■ C shell:
% setenv ORACLE_SID +ASM
% setenv ORACLE_HOME /u01/app/oracle/product/11.2.0/grid

installing oracle database

unzip file_name.zip
$ gunzip filename.cpio.gz
$ cpio -idcmv < filename.cpio

# mount -t iso9660 /dev/dvd /mnt/dvd

$ ./runInstaller

xmanager3
首先
vi /home/oracle/.bash_profile
export DISPLAY=192.168.0.101:0.0
1:
vi /etc/X11/xdm/Xservices
192.168.0.101:0 foreign
2:
vi /etc/X11/xdm/xdm-config
DisplayManager.requestPort: 0
DisplayManager.*startup:/etc/X11/xdm/Startup
DisplayManager.*reset:/etc/X11/xdm/Reset
3:
[root@primary xdm]# vi Startup

sessreg -a -l $DISPLAY -x /usr/X11R6/lib/x11/xdm/Xservers $USER
4:
vi Xaccess
*#any host can get a login window
5:
[root@primary xdm]# vi Reset
sessreg -a -l $DISPLAY -x /usr/X11R6/lib/x11/xdm/Xservers $USER

6:
vi /etc/inittab
id:5:initdefault:
x:5:respawn:/etc/X11/prefdm -nodaemon

Administrative password
pengPENG1234

[root@primary /]# sh /oracle/oraInventory/orainstRoot.sh
[root@primary /]# sh /oracle/product/11.2.0/root.sh

lsnrctl start

sqlplus /nolog
conn /as sysdba;
startup

create user peng identified by peng2011
grant sysdba to peng;
grant resource,connect,dba to peng;

ORACLE 11g 成功完成，接下来要配置DATAGUARD

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22934571/viewspace-1046025/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22934571/viewspace-1046025/