8821ce linux驱动(rtl8821ce linux驱动)

8821ce linux驱动(rtl8821ce linux驱动)span id Label3 p oracle 安装 p 安装 virtualbox yum install gcc kernel devel kernel headers yum install virtualbox 5 etc init d vboxdrv setup nbsp span

大家好,我是讯享网,很高兴认识大家。



 <span id="Label3"><p>oracle安装</p> 

讯享网

  1. 安装virtualbox:

# yum install gcc kernel-devel kernel-headers

# yum install virtualbox-5….

# /etc/init.d/vboxdrv setup&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 手动编译内核模块,安装时自动完成

# usermod -G vboxusers root

  1. 安装linux:

创建虚拟机:

名称:oracle11gR2_OEL6.4_x64

类型:linux 64bit

内存:2048MB

硬盘大小:100GB

&nbsp;

设置:

启动顺序:硬盘,网络

网络:网卡1,桥接eth0

去除声音、usb设备

&nbsp;

安装:desktop方式

主机名:node1.test.com,ip使用192.168.0.1/24,swap 4GB,其余给/

  1. 调整linux系统:

关闭防火墙:

# service iptables stop

# service ip6tables stop

# chkconfig iptables off

# chkconfig ip6tables off

管理工具中disabled防火墙

关闭selinux:

# vi /etc/selinux/config

SELINUX=disabled

配置yum:

# rm -f /etc/yum.repos.d/

//# wget ftp://172.16.8.100/rhel6.repo -P /etc/yum.repos.d/

或者:

# vi /etc/yum.repos.d/rhel6.repo

[Server]

name=Server

baseurl=file:///media/“RHEL_6.5 x86_64 Disc 1”/Server

enabled=1

gpgcheck=0

安装vb增强功能:

cd /media/OL6.4

# yum -y install gcc kernel-uek-devel

# ln -s /usr/src/kernels/2.6.32-431.el6.x86_64/ /usr/src/linux

&nbsp;

设备–&gt;安装增强功能

右键eject弹出光盘

&nbsp;

  1. 确认root身份:

# id

  1. 硬件配置:

# grep MemTotal /proc/meminfo//查看内存大小

# grep SwapTotal /proc/meminfo//查看交换控件

# vi /etc/fstab(永久修改)//修改共享内存为自己物理内存大小

tmpfs&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /dev/shm&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tmpfs&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; defaults,size=2G&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 0 //defaults后加size=多少G&nbsp; 等于自己物理内存大小

# mount -o remount /dev/shm//启用修改

临时修改

# mount -t tmpfs shmfs -o size=2g /dev/shm

&nbsp;

# uname -m //检查系统位数

# df -h

&nbsp;

cd /media/ole.https://www.u72.net/Packages/

yum install oracle-rdbms -server-11gR2…..

可用次快捷工具代替以下6789四个步骤,但是第7步添加用户最好自己添加

  1. rpm检查并安装:

# cat /etc/redhat-release //检查系统版本

# uname -r 内核版本查看

&nbsp;

# rpm -qa | grep glibc 检查glibc已安装相关包版本

# yum install glibc&nbsp; //默认64位

# yum install glibc.i686 /带.XX为32位

&nbsp;

binutils-2.20.51.0.2-5.11.el6 (x86_64)

compat-libcap1-1.10-1 (x86_64)

compat-libstdc++-33-3.2.3-69.el6 (x86_64)

compat-libstdc++-33-3.2.3-69.el6.i686

gcc-4.4.4-13.el6 (x86_64)

gcc-c++-4.4.4-13.el6 (x86_64)

glibc-2.12-1.7.el6 (i686)

glibc-2.12-1.7.el6 (x86_64)

glibc-devel-2.12-1.7.el6 (x86_64)

glibc-devel-2.12-1.7.el6.i686

ksh

libgcc-4.4.4-13.el6 (i686)

libgcc-4.4.4-13.el6 (x86_64)

libstdc++-4.4.4-13.el6 (x86_64)

libstdc++-4.4.4-13.el6.i686

libstdc++-devel-4.4.4-13.el6 (x86_64)

libstdc++-devel-4.4.4-13.el6.i686

libaio-0.3.107-10.el6 (x86_64)

libaio-0.3.107-10.el6.i686

libaio-devel-0.3.107-10.el6 (x86_64)

libaio-devel-0.3.107-10.el6.i686


讯享网

make-3.81-19.el6

sysstat-9.0.4-11.el6 (x86_64)

  1. 创建用户:

# groupadd -g 1000 oinstall//创建组

# groupadd -g 1001 dba//创建组

# groupadd -g 1002 oper//创建组

# useradd -u 1000 -g oinstall -G dba,oper oracle //创建oracle用户,所属组oinstall,副组dba,oper

# passwd oracle

  1. 修改内核参数:

# vi /etc/sysctl.conf

fs.aio-max-nr =

fs.file-max =

kernel.shmall =

kernel.shmmax =

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default =

net.core.rmem_max =

net.core.wmem_default =

net.core.wmem_max =

# sysctl -p//让修改生效

  1. 修改资源限制:

# vi /etc/security/limits.conf

oracle&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; soft&nbsp;&nbsp;&nbsp; nofile&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1024

oracle&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hard&nbsp;&nbsp;&nbsp; nofile&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 65536

oracle&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; soft&nbsp;&nbsp;&nbsp; nproc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2047

oracle&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hard&nbsp;&nbsp;&nbsp; nproc&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;16384

oracle&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; soft&nbsp;&nbsp;&nbsp; stack&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10240

oracle&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hard&nbsp;&nbsp;&nbsp; stack&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 32768

  1. 创建目录:

# mkdir -p /u01/app/oracle //创建oracle基目录&nbsp;&nbsp; 只需创建oracle目录,安装oracle时自动创建home+目录

# chown -R oracle:oinstall /u01 //修改用户和组所属

# chmod -R 775 /u01 //修改权限

  1. 修改概要文件://设置oracle工作环境

# vi ~oracle/.bash_profile

export ORACLE_SID=orcl

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=\(ORACLE_BASE/product/11.2.0/db_1</p> <p>export ORACLE_HOSTNAME=node1.test.com</p> <p>export ORACLE_UNQNAME=orcl</p> <p>export PATH=\)PATH:\(ORACLE_HOME/bin</p> <p>export LD_LIBRARY_PATH=\)ORACLE_HOME/lib:/lib:/usr/lib

export CLASSPATH=\(ORACLE_HOME/JRE:\)ORACLE_HOME/jlib:\(ORACLE_HOME/rdbms/jlib</p> <p>export NLS_LANG=american_america.AL32UTF8</p> <p>export NLS_DATE_FORMAT=‘yyyy-mm-dd hh24:mi:ss‘</p> <p>export EDITOR=vi</p> <p>export LANG=C</p> <ol> <li>使用hosts文件解析主机名:</li> </ol> <p># hostname</p> <p>node1.test.com</p> <p># vi /etc/hosts</p> <p>192.168.0.1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; node1.test.com&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; node1</p> <p># ping node1</p> <p># ping node1.test.com</p> <p>&nbsp;</p> <p>安装包所在目录共享给虚拟机然后解压缩</p> <p>mkdir /installation</p> <p>mount -t ...</p> <p>cd /installation</p> <p>unzip&nbsp; p1040..</p> <p>unzio p1040...</p> <ol> <li>解压缩安装包:</li> </ol> <p># cd /installation</p> <p># unzip p__Linux-x86-64_[12]of7.zip</p> <p>或者:</p> <p>在物理主机中解压缩2个安装包,然后共享给虚拟机,命令如下:</p> <p># mkdir /database</p> <p># mount -t vboxsf database /database</p> <ol> <li>图形界面安装:</li> </ol> <p># xhost +</p> <p># su - oracle</p> <p>\) cd /database/

\( https://www.u72.net/daima/runInstaller</p> <p>略</p> <p>以root身份执行两个脚本 //安装到最后会提示root安装脚本 切换root用户运行即可</p> <ol> <li>创建监听和数据库:</li> </ol> <p>图形界面下创建监听,oracle执行:</p> <p>\) netca

\( lsnrctl status</p> <p>\) netstat -tlnp | grep 1521

图形界面创建db,oracle执行:

\( dbca</p> <p>通用或事务处理 orcl/orcl</p> <p>sys 权限最高</p> <p>system 权限略低</p> <p>DBSNMP 只能查看数据库状态 不设计客户信息</p> <p>SYSMAN 业务操作</p> <p>数据库字符集选中uft8</p> <ol> <li>测试:</li> </ol> <p>sqlplus测试:</p> <p>\) sqlplus sys/sys@orcl as sysdba

$ sqlplus / as sysdba

SQL&gt; show user

SQL&gt; select count() from hr.employees;

SQL&gt; exit

浏览器测试:

https://192.168.0.1:1158/em

sys/password&nbsp; sysdba

&nbsp;

安装rlwrap://安装后可支持在sql命令行中上下键切换

root身份安装

# yum install rlwrap-0.42-1.el6.x86_64.rpm

# vi ~oracle/.bashrc

alias sqlplus=‘rlwrap sqlplus‘

alias rman=‘rlwrap rman‘

&nbsp;

# su - oracle

\( sqlplus / as sysdba</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>root身份安装</p> <p># yum install flash-plugin-11.2.202.508-release.x86_64.rpm</p> <p>&nbsp;</p> <p>sqldeveloper测试:</p> <p>root身份安装</p> <p># yum install jdk-8u51-linux-x64.rpm</p> <p># yum install sqldeveloper-4.1.1.19.59-1.noarch.rpm</p> <p>&nbsp;</p> <p># /usr/local/bin/sqldeveloper</p> <p>输入jdk的路径 /usr/java/jdk1.8.0_51/</p> <p>&nbsp;</p> <p>点左上角+号,创建新连接:</p> <p>sys/password,连接类型:basic,角色:sysdba</p> <p>192.168.0.1&nbsp;&nbsp; 端口1521&nbsp;&nbsp; sid:orcl</p> <p>测试,保存。</p> <p>&nbsp;</p> <ol> <li>添加启动脚本:</li> </ol> <p># vi /etc/oratab&nbsp; 把N改为Y</p> <p>orcl:/u01/app/oracle/product/11.2.0/db_1:Y</p> <p>&nbsp;</p> <p># vi /etc/rc.d/init.d/oracle</p> <p>&nbsp;</p> <p>#!/bin/bash</p> <p>#chkconfig:35 99 01</p> <p>case "\)1” in

&nbsp; start)

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; echo -n “Starting Oracle Database & Listener:”

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; su - oracle -c ‘dbstart \(ORACLE_HOME‘ &gt;/dev/null</p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; echo "[ ok ]"</p> <p>&nbsp;</p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; echo -n "Starting Oracle EM dbconsole:"</p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; su - oracle -c "emctl start dbconsole"&gt;/dev/null</p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; echo "[ ok ]"</p> <p>&nbsp;</p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; touch /var/lock/subsys/oracle</p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ;;</p> <p>&nbsp; stop)</p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; echo -n "Shutting Down Oracle EM dbconsole:"</p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; su - oracle -c "emctl stop dbconsole"&gt;/dev/null</p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; echo "[ ok ]"</p> <p>&nbsp;</p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; echo -n "Shutting Down Oracle Database &amp; Listener:"</p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; su - oracle -c ‘dbshut \)ORACLE_HOME‘ &gt;/dev/null

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; echo “[ ok ]”

&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rm -f /var/lock/subsys/oracle

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ;;

&nbsp; *)

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; echo “Usage: oracle {start|stop}”

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; exit 1

esac

&nbsp;

&nbsp;

# chmod 755 /etc/rc.d/init.d/oracle

# chkconfig –add oracle

# chkconfig –list oracle

&nbsp;

  1. 删除口令有效期:

# su - oracle

$ sqlplus / as sysdba

SQL&gt; alter profile default limit PASSWORD_LIFE_TIME unlimited;

  1. 修改virtualbox的网络设置(可选):

全局设置à添加hostonly网络,设置ip为:192.168.0.253,取消dhcp(linux only)

虚拟机网络改为hostonly

虚拟机中将网卡的ip改为静态,192.168.0.1

# vi /etc/sysconfig/network-scripts/ifcfg-eth0

BOOTPROTO=none

IPADDR=192.168.0.1

PREFIX=24

# ifdown eth0;ifup eth0

# vi /etc/hosts

192.168.0.1&nbsp;&nbsp;&nbsp;&nbsp; node1.test.com&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; node1

上课笔记

小讯
上一篇 2025-06-02 10:36
下一篇 2025-05-24 15:21

相关推荐

版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容,请联系我们,一经查实,本站将立刻删除。
如需转载请保留出处:https://51itzy.com/kjqy/182854.html