ORACLE 11G单机实例Word格式.docx
- 文档编号:20792011
- 上传时间:2023-01-25
- 格式:DOCX
- 页数:37
- 大小:2.18MB
ORACLE 11G单机实例Word格式.docx
《ORACLE 11G单机实例Word格式.docx》由会员分享,可在线阅读,更多相关《ORACLE 11G单机实例Word格式.docx(37页珍藏版)》请在冰豆网上搜索。
packageunixODBCisnotinstalled
packageunixODBC-develisnotinstalled
/#安装Oracle缺损RPM包(rm-f/var/run/yum.pid结束yum占用)
yuminstallbinutils*-y
yuminstallcompat-libstdc++-33*-y
yuminstallelfutils-libelf*-y
yuminstallelfutils-libelf-devel*-y
yuminstallgcc*-y
yuminstallgcc-c++*-y
yuminstallglibc*-y
yuminstallglibc-common*-y
yuminstallglibc-devel*-y
yuminstallglibc-headers*-y
yuminstallkernel-headers*-y
yuminstallksh*-y
yuminstalllibaio*-y
yuminstalllibaio-devel*-y
yuminstalllibgcc*-y
yuminstalllibgomp*-y
yuminstalllibstdc++*-y
yuminstalllibstdc++-devel*-y
yuminstallmake*-y
yuminstallnumactl-devel*-y
yuminstallsysstat*-y
yuminstallunixODBC*-y
yuminstallunixODBC-devel*-y
二、建立oracle系统用户和安装目录
1、创建一个主组oracle和一个副组dba
[root@localhost~]#groupaddoinstall
[root@localhost~]#groupadddba
[root@localhost~]#useradd-goinstall-Gdbaoracle
[root@localhosthome]#passwdoracle
Changingpasswordforuseroracle.
NewUNIXpassword:
RetypenewUNIXpassword:
passwd:
allauthenticationtokensupdatedsuccessfully.
2、修改oracle用户换机变量
[oracle@localhost~]$vi.bash_profile
#.bash_profile
#Getthealiasesandfunctions
if[-f~/.bashrc];
then
.~/.bashrc
fi
#Userspecificenvironmentandstartupprograms
PATH=$PATH:
$HOME/bin
exportPATH
ORACLE_BASE=/u01/app
ORACLE_HOME=$ORACLE_BASE/oracle
ORACLE_SID=ORCL
PATH=$ORACLE_HOME/bin:
$PATH:
$HOME/bin
exportORACLE_BASEORACLE_HOMEORACLE_SIDPATH
~
系统参数配置
[root@node1~]#vi/etc/sysctl.conf
[root@node1~]#sysctl-p
net.ipv4.ip_forward=0
net.ipv4.conf.default.rp_filter=2
net.ipv4.conf.default.accept_source_route=0
kernel.sysrq=0
kernel.core_uses_pid=1
net.ipv4.tcp_syncookies=1
kernel.msgmnb=65536
kernel.msgmax=65536
kernel.shmmax=68719476736
kernel.shmall=4294967296
fs.aio-max-nr=1048576
fs.file-max=6815744
kernel.shmmax=4294967295
kernel.shmall=2097152
kernel.shmmni=4096
kernel.sem=25032000100128
net.ipv4.ip_local_port_range=900065500
net.core.rmem_default=4194304
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048586
[root@node1~]#vi/etc/security/limits.conf
oraclesoftnofile1024
oraclehardnofile65536
oraclesoftnproc2047
oraclehardnproc16384
[root@node1~]#vi/etc/pam.d/login
session
required
/lib64/security/pam_limits.so
3、设置主机名IP地址
[root@localhost~]#vim/etc/hosts
[root@localhost~]#vim/etc/sysconfig/network
4、创建安装目录oracleAPP和oraInventory
[root@oracle/]#mkdir/u01
[root@oracle/]#mkdir/u01/app
[root@oracle/]#chown-Roracle:
oinstall/u01/
[root@oracleu01]#mkdiroraInventory
[root@oracleu01]#chown-Roracle:
oinstalloraInventory/
[root@localhost~]#mkdir/oracleAPP
[root@localhost~]#chown-Roracle:
oinstalloracleAPP
[root@localhost~]#mkdir/oraInventory
oinstalloraInventory
#上传oracle安装文件解压安装
三、图形界面安装Oracle
1、
[oracle@oracledatabase]$exportDISPLAY=192.168.219.1:
0.0
[oracle@oracledatabase]$./runInstaller
2、
3、
4、
5、
6、
7、
8、
9、
[root@oracleCVU_11.2.0.1.0_oracle]#./runfixup.sh
Responsefilebeingusedis:
./fixup.response
Enablefilebeingusedis:
./fixup.enable
Logfilelocation:
./orarun.log
SettingKernelParameters...
net.core.rmem_default=262144
net.core.wmem_max=1048576
uid=500(oracle)gid=500(oinstall)groups=500(oinstall),501(dba)context=root:
system_r:
unco
nfined_t:
SystemLow-SystemHigh
10、
11、
12、
13、
[root@oracleoraInventory]#./orainstRoot.sh
Changingpermissionsof/u01/oraInventory.
Addingread,writepermissionsforgroup.
Removingread,write,executepermissionsforworld.
Changinggroupnameof/u01/oraInventorytooinstall.
Theexecutionofthescriptiscomplete.
[root@oracleoracle]#./root.sh
RunningOracle11groot.shscript...
Thefollowingenvironmentvariablesaresetas:
ORACLE_OWNER=oracle
ORACLE_HOME=/u01/app/oracle
Enterthefullpathnameofthelocalbindirectory:
[/usr/local/bin]:
Copyingdbhometo/usr/local/bin...
Copyingoraenvto/usr/local/bin...
Copyingcoraenvto/usr/local/bin...
Creating/etc/oratabfile...
Entrieswillbeaddedtothe/etc/oratabfileasneededby
DatabaseConfigurationAssistantwhenadatabaseiscreated
Finishedrunninggenericpartofroot.shscript.
Nowproduct-specificrootactionswillbeperformed.
Finishedproduct-specificrootactions.
14、
配置监听
2017年11月9日
14:
39
[oracle@oracle/]$netca
OracleNetServicesConfiguration:
[oracle@oracle/]$lsnrctlstatus
LSNRCTLforLinux:
Version11.2.0.1.0-Productionon26-JUN-201715:
01:
06
Copyright(c)1991,2009,Oracle.Allrightsreserved.
Connectingto(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle)(PORT=1521)))
STATUSoftheLISTENER
------------------------
AliasLISTENER
VersionTNSLSNRforLinux:
Version11.2.0.1.0-Production
StartDate26-JUN-201715:
00:
15
Uptime0days0hr.0min.51sec
TraceLeveloff
SecurityON:
LocalOSAuthentication
SNMPOFF
ListenerParameterFile/u01/app/oracle/network/admin/listener.ora
ListenerLogFile/u01/app/diag/tnslsnr/oracle/listener/alert/log.xml
ListeningEndpointsSummary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1521)))
Thelistenersupportsnoservices
Thecommandcompletedsuccessfully
创建数据库
05
[oracle@oracle/]$dbca
2018年1月10日
16:
46
1、创建表空间test,用户test,数据文件test01.dbf,建表school,插入3条数据
1)、创建临时表空间
SQL>
createtemporarytablespaceuser_temp
2tempfile'
/u01/orcldata/user_temp.dbf'
3size1024m
4autoextendon
5next1024mmaxsize10240m
6extentmanagementlocal;
Tablespacecreated.
2)、创建数据表空间
createtablespaceuser_data
2logging
3datafile'
/u01/orcldata/user_data.dbf'
4size1024m
5autoextendon
6next50mmaxsize10240m
7extentmanagementlocal;
3)、创建用户并指定表空间
createuserusernameidentifiedbypassword
2defaulttablespaceuser_data
3temporarytablespaceuser_temp;
Usercreated.
4)、给用户授权权限
grantconnect,resource,dbatousername;
Grantsucceeded.
2018年1月18日
36
SQL实验:
1、创建表
CREATETABLEproductinfo(
ProductIdvarchar2(10),
ProductNamevarchar2(20),
productPricenumber(8,2),
Quantitynumber(10),
Categoryvarchar2(10),
Desperationvarchar2(1000),
Originvarchar2(10)
);
2、使用ALTER添加一列备注remark信息
ALTERTABLEproductinfo
ADDremarkvarchar2(200);
3、创建categoryinfo表,设置主键约束(categoryid)
CREATETABLEcategoryinfo(
CategoryIdvarchar2(10),
CategoryNamevarchar2(30),
PRIMARYKEY(categoryId)
4、修改productinfo主键约束
ALTERTABLEproductinfo
ADDCONSTRAINTSpk_productinfo
PRIMARYKEY(productID);
5、修改productinfo外键约束
ADDCONSTRAINTSfk_productinfo
FOREIGNKEY(category)
REFERENCEScategoryinfo(categoryId)
ONDELETECASCADE;
6、创建Age列的检查约束
CREATETABLEcustominfo(
CumstomIdvarchar2(10),
Namevarchar2(10),
Agenumber
(2),
Gendervarchar2
(2),
Telvarchar2(11),
Addressvarchar2(100),
CONSTRAINTCHK_AGECHECK(Age>
=18andAge<
=50));
ALTERTABLEcustominfo
ADDCONSTRAINTCHK_GENDERCHECK(Gender='
男'
orGender='
女'
7、添加唯一约束
CREATETABLEorderinfo(
OrderIdvarchar2(10),
CustomIdvarchar2(10),
OrderDatevarchar2(10),
OrderQuantityvarchar2(10),
SendDatevarchar2(10),
CONSTRAINTUNQ_ORDERIDUNIQUE(OrderId)
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- ORACLE 11G单机实例 11 单机 实例