网站建设具体方案,阿里云wordpress插件,h5网站建设价格,2019网页游戏排行榜安装 下载 从 Oracle官方下载地址 需要的版本#xff0c;本次安装是在Linux上使用yum安装#xff0c;因此下载的是RPM。另外#xff0c;需要说明的是#xff0c;Oracle加了锁的下载需要登录用户才能安装#xff0c;而用户是可以免费注册的#xff0c;这里不做过多说明。 …安装 下载 从 Oracle官方下载地址 需要的版本本次安装是在Linux上使用yum安装因此下载的是RPM。另外需要说明的是Oracle加了锁的下载需要登录用户才能安装而用户是可以免费注册的这里不做过多说明。 安装
# 创建oracle用户组
[rootQingYun oracle19]# groupadd oracle
# 创建oracle用户
[rootQingYun oracle19]# useradd -g oracle -G oracle oracle
# rpm安装oracle
[rootQingYun oracle19]# rpm -ivh oracle-database-ee-19c-1.0-1.x86_64.rpm使用上述rpm不出意外的话应该会报错如下
[rootQingYun oracle19]# rpm -ivh oracle-database-ee-19c-1.0-1.x86_64.rpm
warning: oracle-database-ee-19c-1.0-1.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
error: Failed dependencies:oracle-database-preinstall-19c is needed by oracle-database-ee-19c-1.0-1.x86_64意思是oracle-database-ee-19c-1.0-1.x86_64.rpm依赖的oracle-database-preinstall-19c没有安装。 解决这个错误需要从 Oracle官网yum源 下载rpm依赖包oracle-database-preinstall-19c安装即可。
[rootQingYun oracle19]# rpm -ivh oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
warning: oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
error: Failed dependencies:bind-utils is needed by oracle-database-preinstall-19c-1.0-1.el7.x86_64compat-libcap1 is needed by oracle-database-preinstall-19c-1.0-1.el7.x86_64compat-libstdc-33 is needed by oracle-database-preinstall-19c-1.0-1.el7.x86_64ksh is needed by oracle-database-preinstall-19c-1.0-1.el7.x86_64libaio-devel is needed by oracle-database-preinstall-19c-1.0-1.el7.x86_64nfs-utils is needed by oracle-database-preinstall-19c-1.0-1.el7.x86_64psmisc is needed by oracle-database-preinstall-19c-1.0-1.el7.x86_64smartmontools is needed by oracle-database-preinstall-19c-1.0-1.el7.x86_64xorg-x11-utils is needed by oracle-database-preinstall-19c-1.0-1.el7.x86_64xorg-x11-xauth is needed by oracle-database-preinstall-19c-1.0-1.el7.x86_64可以看到安装oracle-database-preinstall-19c时也有很多依赖的包依次进行安装即可。 这里也罗列了我之前下载安装的一些列依赖rpm有点多耐心安装即可
[rootQingYun oracle19]# ls
bind-libs-9.9.4-74.el7_6.2.x86_64.rpm
bind-license-9.9.4-74.el7_6.2.noarch.rpm
bind-utils-9.9.4-74.el7_6.2.x86_64.rpm
compat-libcap1-1.10-7.el7.x86_64.rpm
compat-libstdc-33-3.2.3-72.el7.x86_64.rpm
GeoIP-1.5.0-14.el7.x86_64.rpm
geoipupdate-2.5.0-1.el7.x86_64.rpm
glibc-2.17-322.0.1.el7_9.x86_64.rpm
glibc-common-2.17-322.0.1.el7_9.x86_64.rpm
ksh-20120801-144.0.1.el7_9.x86_64.rpm
libaio-devel-0.3.109-13.el7.x86_64.rpm
libdmx-1.1.3-3.el7.x86_64.rpm
libXmu-1.1.2-2.el7.x86_64.rpm
libXt-1.1.5-3.el7.x86_64.rpm
libXtst-1.2.3-1.el7.x86_64.rpm
libXv-1.0.11-1.el7.x86_64.rpm
libXxf86dga-1.1.4-2.1.el7.x86_64.rpm
libXxf86misc-1.0.3-7.1.el7.x86_64.rpm
mailx-12.5-19.el7.x86_64.rpm
nfs-utils-1.3.0-0.68.0.1.el7.x86_64.rpm
oracle-database-ee-19c-1.0-1.x86_64.rpm
oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
psmisc-22.20-17.el7.x86_64.rpm
quota-4.01-19.el7.x86_64.rpm
rpcbind-0.2.0-49.el7.x86_64.rpm
smartmontools-7.0-2.el7.x86_64.rpm
xorg-x11-utils-7.5-23.el7.x86_64.rpm
xorg-x11-xauth-1.0.9-1.el7.x86_64.rpm踩坑
1. su oracle 报错 2.乱码
安装好之后使用sqlplus登录之后可以看到SQL界面的显示都是???这个实际上是中文显示乱码 解决这个问题直接修改数据库字符集为英文
SQL conn /as sysdba;
SQL shutdown immediate;
SQL startup mount;
SQL alter system enable restricted session;
SQL alter system set job_queue_processes0;
SQL alter system set aq_tm_processes0;
SQL alter database open;
# 设置成中文
SQL alter database character set internal_use ZHS16GBK;
# 设置成英文
SQL alter database character set internal_use AL32UTF8;
SQL alter system set nls_language AMERICAN scope spfile;
SQL alter system set nls_territory AMERICA scope spfile;
SQL shutdown immediate;
SQL startup;
