利用PLSQL Developer查看并导出Oracle表数据,本篇经验将和大家介绍如何利用PLSQLDeveloer查看并导出Oracle表数据,希望对大家的工作和学习有所帮助!......
2023-03-17 322 oracle
oracle 10.2.0.4 安装之前必须通过安装10.2.0.1升级安装
安装思路:
1: 安装rhel 5时需要做的设置
2: 编辑/etc/hosts文件
3: 设置内核参数
4: 安装oracle所需安装的rpm包
5: 创建用户
6: 编辑oracle环境
7: 安装oracle 10.2.0.1 软件
8: 安装oracle 10.2.0.4 软件
9: dbca建库
10:创建监听
注意:oracle 10.2.0.1安装必须在rhel 3或者rhel 4,如果需要在rhel 5上安装,安装时需要加“./runInstaller -ignoresysprereqs”,oracle 10.2.0.4可以再rhel 4 或者rhel5上安装
安装rhel 5时需要做的设置
1:swap 最小2G
2:secure Linux disabled(/etc/selinux/config文件SELINUX=disabled)
3:选择的安装包:
GNOME Desktop Environment
Editors
Graphical Internet
Text-based Internet
Development Libraries
Development Tools
Legacy Software Development
Server Configuration Tools
Administration Tools
Base
Legacy Software Support
System Tools
X Window System
编辑/etc/hosts文件
添加(ip 主机名):
192.168.56.125 oracle10g
设置内核参数
1:编辑/etc/sysctl.conf
添加:
#kernel.shmall = 2097152
#kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
#fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144
编辑完之后需要执行命令:/sbin/sysctl -p
2:编辑/etc/security/limits.conf
添加:
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536
3:编辑/etc/pam.d/login
添加
session required pam_limits.so
4:编辑/etc/selinux/config
将SELINUX设置为disabled:SELINUX=disabled
安装oracle所需安装的rpm包
rpm -Uvh setarch-2*
rpm -Uvh make-3*
rpm -Uvh glibc-2*
rpm -Uvh libaio-0*
rpm -Uvh compat-libstdc -33-3*
rpm -Uvh compat-gcc-34-3*
rpm -Uvh compat-gcc-34-c -3*
rpm -Uvh gcc-4*
rpm -Uvh libXp-1*
rpm -Uvh openmotif-2*
rpm -Uvh compat-db-4*
如何安装rpm包,请参考我的经验:oracle rac 11g on rhel 6:[1]准备
创建用户
groupadd oinstall
groupadd dba
useradd -m -g oinstall -G dba -u oracle
[root@oracle10g ~]# id oracle
uid=500(oracle) gid=500(oinstall) groups=500(oinstall),501(dba)
编辑oracle环境
[oracle@node1 ~]$ vi .bash_profile
export ORACLE_SID=orcl
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
安装oracle 10.2.0.1 软件
上传软件并解压
[oracle@oracle10g 10.2.0.1]$ gunzip 10201_database_linux_x86_64.cpio.gz
如果解压过程中报错请参考我的经验:invalid compressed data--format violated
[oracle@oracle10g 10.2.0.1]$ cpio -idv 10201_database_linux_x86_64.cpio
[oracle@oracle10g database]$ ./runInstaller
Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Failed
Exiting Oracle Universal Installer, log for this session can be found at /u01/app/oraInventory/logs/installActions2014-10-26_07-03-07PM.log
[oracle@oracle10g database]$ ./runInstaller -ignoresysprereqs
Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Failed
>>> Ignoring required pre-requisite failures. Continuing...
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-10-26_07-18-30PM. Please wait ...[oracle@oracle10g database]$ Oracle Universal Installer, Version 10.2.0.1.0 Production
Copyright (C) 1999, 2005, Oracle. All rights reserved.
安装oracle 10.2.0.4 软件
安装完oracle 10.2.0.1之后,先不要建库,直接安装安装oracle 10.2.0.4 软件
[oracle@oracle10g Disk1]$ ./runInstaller
Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version: must be redhat-3, SuSE-9, SuSE-10, redhat-4, redhat-5, UnitedLinux-1.0, asianux-1, asianux-2 or asianux-3
Passed
All installer requirements met.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-10-26_08-05-15PM. Please wait ...[oracle@oracle10g Disk1]$ Oracle Universal Installer, Version 10.2.0.4.0 Production
Copyright (C) 1999, 2008, Oracle. All rights reserved.
dbca 建库
[oracle@oracle10g Disk1]$ dbca
创建监听
[oracle@oracle10g Disk1]$ netca
然后一直点击 next ,最后点击finish 即可
查看数据库版本
[oracle@oracle10g ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Oct 28 01:48:51 2014
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL>
以上方法由办公区教程网编辑摘抄自百度经验可供大家参考!
标签: oracle
相关文章
利用PLSQL Developer查看并导出Oracle表数据,本篇经验将和大家介绍如何利用PLSQLDeveloer查看并导出Oracle表数据,希望对大家的工作和学习有所帮助!......
2023-03-17 322 oracle
编程之oracle 11g安装解说,Oracle11g是甲骨文公司在2007年年7月12日推出的最新数据库软件,Oracle11g有400多项功能,经过了1500万个小时的测试,开发工作量达到了3.6......
2023-03-17 455 oracle