历史
版本 | 时间 | 代号 |
---|---|---|
4.3 | 2013-06 | Kepler |
4.4 | 2014-06 | Luna |
4.5 | 2015-06 | Mars |
4.6 | 2016-06 | Neon |
4.7 | 2017-06 | Oxygen |
4.8 | 2018-06 | Photon |
4.12 | 2019-06 | |
4.16 | 2020-06 | |
4.20 | 2021-06 |
32位
64位
安装依赖
1 | yum -y install binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel expat gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers libaio libaio-devel libgcc libstdc++ libstdc++-devel make pdksh sysstat unixODBC unixODBC-devel |
检查依赖
1 | rpm -q binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel expat gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers libaio libaio-devel libgcc libstdc++ libstdc++-devel make pdksh sysstat unixODBC unixODBC-devel | grep "not installed" |
安装 compat-libstdc++-33
1 | wget http://mirror.centos.org/centos/6.7/os/i386/Packages/compat-libstdc++-33-3.2.3-69.el6.i686.rpm |
安装 pdksh
1 | wget http://vault.centos.org/5.11/os/x86_64/CentOS/pdksh-5.2.14-37.el5_8.1.x86_64.rpm |
1 | fs.aio-max-nr=1048576 |
配置hosts
1 | vi /etc/hosts |
创建用户
1 | groupadd oinstall |
配置环境变量
1 | su oracle |
1 | su - oracle |
1 | ps -ef | grep ora | awk '{print $2}' | xargs kill -9 |
客户端
1 | SIMPLIFIED CHINESE_CHINA.ZHS16GBK |
服务端
1 | select userenv('language') from dual; |
Checking swap space: 0 MB available, 1535 MB required. Failed
1 | swapon -s |
centos 安装oracle 报Checking swap space: 0 MB available, 150 MB required. Failed
ORA-00845: MEMORY_TARGET not supported on this system
https://blog.csdn.net/sunny05296/article/details/56495599
https://stackoverflow.com/questions/33366282/oracle-startup-not-possible-ora-00845-memory-target-not-supported-on-this-sys
1 | mount -t tmpfs shmfs -o size=2G /dev/shm |
PLSQL Developer 13 注册码
product code: 4vkjwhfeh3ufnqnmpr9brvcuyujrx3n3le
serial Number:226959
password: xs374ca
Editor -> AutoReplace
1 | sf = select * from |
User Interface -> PL/SQL Beautifier
Items on one line
Syntax Case to Lowercase
Oracle -> Logon History
Oracle -> Connection
避免误操作Session Mode改为Dual或Single,Multiple Connections取消勾选Allow multiple connections
Tools -> Recall Statement
set Maximum size to 1000
Encoding
自动识别确保导出查询结果至剪切板时不会乱码
变量绑定
使用&id
占位符
Special Copy
Right Click -> Special Copy -> Java
AfterConnect.sql & Login.sql
1 | alter session set NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS.FF'; |