|
副标题[/!--empirenews.page--]
★★★____★☆★〓〓〓〓→
VMware vSphere Client6.0
https://10.20.4.200/
下载Vwmare
IP:10.20.4.200
-------账号：root
-------密码：password
---------------------------------------------
机器1:
root/bayaim
oracle/oracle
grid/grid
oracle:
统一设置sys,system,dbsnmp,sysman用户的密码为oracle
sys/bayaim
system/bayaim
ASM密码为：bayaim
查看数据库：
C:UsersAdministrator>sqlplus sys/[email?protected]_baydb as sysdba
[[email?protected] ~]$ sqlplus / as sysdba
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
racdb1 OPEN
SQL> SELECT a.NAME,a.DATABASE_ROLE,a.OPEN_MODE,a.LOG_MODE FROM V$DATABASE a;
alter user user1 account unlock;
?
2019年3月27日14:03:06
LC 科技RAC ——搭建
---------------------------------------------
1. 安装centos 选择语言：english / U.S.English 防止乱码
[[email?protected] database]$ export LANG=EN
echo $LANG
vi /etc/sysconfig/i18n
echo LANG=zh_CN.gbk
locale -a |grep en
export LANG=en_US
[[email?protected] ~]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
# rac1
10.20.4.215 rac1 --192.168.1.61 --dave1
10.20.4.217 rac1-vip --192.168.1.63
10.20.77.15 rac1-priv--192.168.1.62
# rac2
10.20.4.216 rac2 --192.168.1.71 --dave2
10.20.4.218 rac2-vip --192.168.1.73
10.20.77.16 rac2-priv --192.168.1.72
# scan-ip
10.20.4.219 scan-cluster --192.168.1.9
集群实例名：dave
bayaim:
-----------------
[[email?protected] ~]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
# rac1
10.20.4.215 rac1
10.20.4.217 rac1-vip
10.20.77.15 rac1-priv
# rac2
10.20.4.216 rac2
10.20.4.218 rac2-vip
10.20.77.16 rac2-priv
# scan-ip
10.20.4.219 scan-cluster
[[email?protected] ~]#
?
?
注意：修改了主机名后
vi /etc/sysconfig/network
---修改hostname
NETWORKING=yes
HOSTNAME=rac1
[[email?protected] ~]# hostname rac1
[[email?protected] ~]# hostname
rac1
-----------------
Centos6.5
关闭selinux:
永久有效：修改/etc/sysconfig/selinux
将文本中的SELINUX=enforcing，改为SELINUX=disabled。然后重启
即时有效：setenforce 0
查看状态：getenforce
关闭防火墙：
永久性生效：chkconfig iptables off,然后重启
即时生效：service iptables stop
打开、关闭GNOME 桌面：
[[email?protected] ~]# vi /etc/inittab
3 -- 为命令行
5 -- 为桌面
然后重启系统后
#init 3
?
-----------------
[[email?protected] named]# service network restart //重启网卡-----------
[[email?protected] ~]# ifconfig //查看IP-----------
// 修改网卡---------
[[email?protected] network-scripts]# pwd
/etc/sysconfig/network-scripts
[[email?protected]~]# vi /etc/resolv.conf
search localdomain
nameserver 114.114.114.114
service NetworkManager stop
service network restart
ifconfig
Lc!23Abc
---------------------------------------------------
挂载cdrom
# mkdir c
# mount /dev/cdrom /mnt/cdrom
或者
# mount /dev/cdrom /media/cdrom
安装本地光盘yum：
1.检查是否安装了yum
# rpm -qa |grep yum
redhat一般都默认安装了yum。
2.
[[email?protected] Server]# vi /etc/yum.repos.d/rhel-source.repo
[rhel-source]
name=localyum
baseurl=file:///mnt/cdrom/Server
enabled=1
gpgcheck=0
gpgkey=file:///mnt/cdrom/RPM-GPG-KEY-redhat-release
#这里指向了Server目录,如果还要软件,则还需建立指向Cluster,ClusterStorage,VT的baseurl.
3.清除缓存
[[email?protected] ~]# yum clean all
[[email?protected] ~]# yum makecache //把yum源缓存到本地，加快软件的搜索好安装速度
[[email?protected] ~]# yum list //列出了3780个包
4.安装测试
#yum -y install gcc
------------------------------------------------------------------
注意：asm磁盘如果用了asmlib就不能再设置成裸设备，不然在创建asm磁盘组的时候rac2的实例挂载磁盘会失败，要么就用裸设备，不用asmlib
把其他2块OCR磁盘和3块表决盘配置成裸设备,这5个每块均100M
设置asm磁盘，把3块10G的磁盘映射成VOL1、VOL2、VOL3，以后创建ASM磁盘组，存放数据文件
．禁用防火墙
[[email?protected] home]# service iptables status
[[email?protected] home]# service iptables stop
[[email?protected] home]# chkconfig iptables off
[[email?protected] home]# chkconfig iptables --list
-------------问题四：【更改字符集】-------------------------
./runInstaller
图形化出现乱码：
[[email?protected] database]$ export LANG=en_US
echo $LANG
vi /etc/sysconfig/i18n
echo LANG=zh_CN.gbk
locale -a |grep en
export LANG=en_US
#仅节点1执行
$export LANG=en_US
规划需要的共享磁盘个数及大小
[[email?protected] home]# fdisk -l | grep /dev/sd
3. 配置用户及用户组
groupadd oinstall
groupadd dba
groupadd oper
groupadd asmadmin
groupadd asmoper
groupadd asmdba
（编辑：宣城站长网）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
