Installing Oracle11gR2_64bit on Oracle Solaris 10
9/10_X86_64bit
msn:jieshiyeskey@hotmail.com
@查看内存大小:
-bash-3.00# /usr/sbin/prtconf |grep "Memory size"
Memory size: 2048 Megabytes
@查看SWAP空间大小
-bash-3.00# /usr/sbin/swap –l
交换文件 dev swaplo
blocks free
/dev/dsk/c1t0d0s1 30,1 8 8401984 8401984
@查看硬件位数:
-bash-3.00# /bin/isainfo -kv
64-bit amd64 kernel modules
@查看操作系统版本:
-bash-3.00# uname -r
5.10
查看操作系统的release号:
-bash-3.00# cat /etc/release
Oracle Solaris 10 9/10 s10x_u9wos_14a X86
Copyright (c) 2010, Oracle and/or its affiliates. All rights
reserved.
Assembled 11 August 2010
开启root 远程登入:
-bash-3.00# cat /etc/ssh/sshd_config |grep
PermitRootLogin
PermitRootLogin yes
-bash-3.00# svcadm restart ssh
改用 bash SHELL:
-bash-3.00# cat /etc/passwd |grep root
root:x:0:0:Super-User:/:/bin/bash
禁用ntp和sendmail:
-bash-3.00# svcadm disable ntp
-bash-3.00# svcadm disable sendmail
图像界面和字符界面切换:
@在图形界面下:
-bash-3.00# /usr/dt/bin/dtconfig -d (禁用)
-bash-3.00# /usr/dt/bin/dtconfig -e (开启)
@在字符界面下启动图形界面:
-bash-3.00# /usr/dt/bin/dtsession
-bash-3.00# /usr/dt/bin/dtlogin
@ 安装Oracle所需要的软件包:
· SUNWarc
· SUNWbtool
· SUNWhea
· SUNWlibC
· SUNWlibm
· SUNWlibms
· SUNWsprot
· SUNWtoo
· SUNWi1of
· SUNWi1cs (ISO8859-1)
· SUNWi15cs (ISO8859-15)
· SUNWxwfnt
· SUNWcsl
-bash-3.00# pkginfo -i SUNWarc SUNWbtool SUNWhea SUNWlibC
SUNWlibm SUNWlibms \ SUNWsprot SUNWtoo SUNWi1of SUNWi1cs SUNWi15cs SUNWxwfnt
SUNWcslsystem SUNWarc Lint Libraries
(usr)
system SUNWbtool CCS tools bundled with SunOS
system SUNWcsl Core Solaris, (Shared
Libs)
system SUNWhea SunOS Header Files
system SUNWi15cs X11 ISO8859-15 Codeset Support
system SUNWi1cs X11 ISO8859-1 Codeset Support
system SUNWi1of ISO-8859-1 (Latin-1) Optional Fonts
system SUNWlibC Sun Workshop Compilers Bundled libC
system SUNWlibm Math & Microtasking
Library Headers & Lint Files (Usr)
system SUNWlibms Math & Microtasking Libraries (Usr)
system SUNWsprot Solaris Bundled tools
system SUNWtoo Programming Tools
system SUNWxwfnt X Window System platform required fonts
-bash-3.00# vi /etc/system
set noexec_user_stack=1
set semsys:seminfo_semmni=100
set semsys:seminfo_semmns=1024
set semsys:seminfo_semmsl=256
set semsys:seminfo_semvmx=32767
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmni=100-bash-3.00
set max_nprocs = 30000
set maxuprc = 16384
# reboot
-bash-3.00# mkdir -p /storage/u01/app/oracle
-bash-3.00# chown -R oracle:oinstall /storage/u01/
-bash-3.00# mkdir -p /export/home/oracle
-bash-3.00# chown -R oracle:oinstall /export
-bash-3.00# groupadd oinstall
-bash-3.00# groupadd dba
-bash-3.00# useradd -g oinstall -G dba -s
/usr/bin/bash -d /export/home/oracle oracle
-bash-3.00# passwd oracle
新口令:
请重新输入新口令:
passwd:oracle 的口令已成功更改
-bash-3.00$ id
uid=100(oracle) gid=100(oinstall)
-bash-3.00$ pwd
/export/home/oracle
-bash-3.00$ vi .bash_profile
###################For
Oracle11gR2##############
ORACLE_SID=vmware; export ORACLE_SID
ORACLE_BASE=/storage/u01/app/oracle;export
ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1;
export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib;export
LD_LIBRARY_PATH
stty erase ^h
alias sqlplus='/usr/local/bin/rlwrap sqlplus'
alias rman='/usr/local/bin/rlwrap rman'
NLS_LANG=AMERICAN_AMERICA.UTF8; export NLS_LANG
DISPLAY=192.168.1.10:0.0; export DISPALY
-bash-3.00$ source .bash_profile
-bash-3.00$ env |grep ORA
ORACLE_SID=vmware
ORACLE_BASE=/storage/u01/app/oracle
ORACLE_HOME=/storage/u01/app/oracle/product/11.2.0/dbhome_1
-bash-3.00$ id
uid=100(oracle) gid=100(oinstall)
-bash-3.00$ ls -l
总数 4588914
drwxr-xr-x 3
oracle oinstall 512 4月 16日 16:06 app
-rw-r--r-- 1
oracle oinstall
1342890396 4月 16日 17:04
solaris.x64_11gR2_database_1of2.zip
-rw-r--r-- 1
oracle oinstall
1005450726 4月 16日 17:02
solaris.x64_11gR2_database_2of2.zip
-bash-3.00$ unzip solaris.x64_11gR2_database_1of2.zip
-bash-3.00$ unzip solaris.x64_11gR2_database_2of2.zip
-bash-3.00$ pwd
/storage/u01/database
-bash-3.00$ ./runInstaller
-bash-3.00$ netca
-bash-3.00$ dbca
-bash-3.00# gunzip readline-5.1-solaris-x86.gz
-bash-3.00# gunzip rlwrap-solaris-x86.gz
-bash-3.00# pkgadd -d readline-5.1-solaris-x86
-bash-3.00# pkgadd -d rlwrap-solaris-x86
-bash-3.00# cp /usr/local/lib/libreadline* /lib
-bash-3.00# cp /usr/local/lib/libreadline* /usr/lib
-bash-3.00$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Sat Apr 16 20:55:09
2011
Copyright (c) 1982, 2009, Oracle. All rights
reserved.
SQL> conn /as
sysdba
Connected to an idle instance.
SQL>
startup
ORACLE instance started.
Total System Global Area 855982080 bytes
Fixed
Size 2215824 bytes
Variable
Size 532676720 bytes
Database
Buffers 314572800 bytes
Redo
Buffers 6516736 bytes
Database mounted.
Database opened.
SQL> select * from
dual;
DUM
---
X
开机自启:
-bash-3.00# vi /var/opt/oracle/oratab
vmware:/storage/u01/app/oracle/product/11.2.0/dbhome_1:Y
-bash-3.00$ vi
/storage/u01/app/oracle/product/11.2.0/dbhome_1/bin/dbstart
#!/usr/bin/bash
ORACLE_HOME_LISTNER=$ORACLE_HOME
-bash-3.00$ vi
/storage/u01/app/oracle/product/11.2.0/dbhome_1/bin/dbshut
#!/usr/bin/bash
ORACLE_HOME_LISTNER=$ORACLE_HOME
-bash-3.00# cat /etc/init.d/start_db.sh
#!/usr/bin/bash
su - oracle -c
"/storage/u01/app/oracle/product/11.2.0/dbhome_1/bin/dbstart"
-bash-3.00# chmod 755 /etc/init.d/start_db.sh
-bash-3.00# cat /etc/init.d/stop_db.sh
#!/usr/bin/bash
su - oracle -c
"/storage/u01/app/oracle/product/11.2.0/dbhome_1/bin/dbshut"
-bash-3.00# chmod 755 /etc/init.d/stop_db.sh
-bash-3.00# ln -s /etc/init.d/start_db.sh
/etc/rc3.d/S99start_db
-bash-3.00# ln -s /etc/init.d/stop_db.sh /etc/rcS.d/K99stop_db