从为知笔记同步过来太乱了,大家可以使用下面的链接打开
centos 7以下版本安装oracle 19c 问题较多,centos 以上版本没有任何问题。记录如下。
hosts文件,否则图形界面无法启动
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.67.25 p0gqgdb901
1
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
2
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
3
4
192.168.67.25 p0gqgdb901
fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 kernel.panic_on_oops = 1 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 net.ipv4.conf.all.rp_filter = 2 net.ipv4.conf.default.rp_filter = 2 fs.aio-max-nr = 1048576 net.ipv4.ip_local_port_range = 9000 65500
oracle soft nofile 1024 oracle hard nofile 65536 oracle soft nproc 16384 oracle hard nproc 16384 oracle soft stack 10240 oracle hard stack 32768 oracle hard memlock 134217728 oracle soft memlock 134217728
yum install -y bc yum install -y binutils yum install -y compat-libcap1 yum install -y compat-libstdc++-33 #yum install -y dtrace-modules #yum install -y dtrace-modules-headers #yum install -y dtrace-modules-provider-headers yum install -y dtrace-utils yum install -y elfutils-libelf yum install -y elfutils-libelf-devel yum install -y fontconfig-devel yum install -y glibc yum install -y glibc-devel yum install -y ksh yum install -y libaio yum install -y libaio-devel yum install -y libdtrace-ctf-devel yum install -y libXrender yum install -y libXrender-devel yum install -y libX11 yum install -y libXau yum install -y libXi yum install -y libXtst yum install -y libgcc yum install -y librdmacm-devel yum install -y libstdc++ yum install -y libstdc++-devel yum install -y libxcb yum install -y make yum install -y net-tools # Clusterware yum install -y nfs-utils # ACFS yum install -y python # ACFS yum install -y python-configshell # ACFS yum install -y python-rtslib # ACFS yum install -y python-six # ACFS yum install -y targetcli # ACFS yum install -y smartmontools yum install -y sysstat # Added by me. yum install -y unixODBC
groupadd oinstall groupadd dba groupadd oper useradd -g oinstall -G dba,oper oracle
passwd oracle # Oracle123!
Set secure Linux to permissive by editing the "/etc/selinux/config" file, making sure the SELINUX flag is set as follows.
SELINUX=permissive
mkdir -p /u01/app/oracle/product/19.3.0/dbhome_1 chown -R oracle:oinstall /u01 chmod -R 775 /u01
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19.3.0/dbhome_1
export ORACLE_PATH=$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin
export ORACLE_SID=orcl
export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin:$ORACLE_HOME/bin
export ORACLE_TERM=xterm
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export CLASSPATH=$ORACLE_HOME/JRE
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
1
export ORACLE_BASE=/u01/app/oracle
2
export ORACLE_HOME=$ORACLE_BASE/product/19.3.0/dbhome_1
3
export ORACLE_PATH=$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin
4
export ORACLE_SID=orcl
5
export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin:$ORACLE_HOME/bin
6
export ORACLE_TERM=xterm
7
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
8
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
9
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
10
export CLASSPATH=$ORACLE_HOME/JRE
11
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
12
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
13
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
cd $ORACLE_HOME
unzip -oq ~/LINUX.X64_193000_db_home.zip
1
cd $ORACLE_HOME
2
unzip -oq ~/LINUX.X64_193000_db_home.zip
Centos 6.10 问题:
[oracle@p0gqgdb901 dbhome_1]$ strings /lib64/libc.so.6 |grep GLIBC_
GLIBC_2.2.5
GLIBC_2.2.6
GLIBC_2.3
GLIBC_2.3.2
GLIBC_2.3.3
GLIBC_2.3.4
GLIBC_2.4
GLIBC_2.5
GLIBC_2.6
GLIBC_2.7
GLIBC_2.8
GLIBC_2.9
GLIBC_2.10
GLIBC_2.11
GLIBC_2.12
GLIBC_PRIVATE
1
[oracle@p0gqgdb901 dbhome_1]$ strings /lib64/libc.so.6 |grep GLIBC_
2
GLIBC_2.2.5
3
GLIBC_2.2.6
4
GLIBC_2.3
5
GLIBC_2.3.2
6
GLIBC_2.3.3
7
GLIBC_2.3.4
8
GLIBC_2.4
9
GLIBC_2.5
10
GLIBC_2.6
11
GLIBC_2.7
12
GLIBC_2.8
13
GLIBC_2.9
14
GLIBC_2.10
15
GLIBC_2.11
16
GLIBC_2.12
17
GLIBC_PRIVATE
一、安装glibc-2.14
1
2
3
4
5
6
7
8
9
10
|
[root@jrgc130 ~] # wget http://ftp.gnu.org/gnu/glibc/glibc-2.14.tar.gz [root@jrgc130 ~] # mv glibc-2.14.tar.gz /opt/software [root@jrgc130 ~] # cd /opt/software [root@jrgc130 software] # tar xf glibc-2.14.tar.gz [root@jrgc130 software] # cd glibc-2.14 [root@jrgc130 glibc-2.14] # mkdir build [root@jrgc130 glibc-2.14] # cd build [root@jrgc130 build] # ../configure --prefix=/usr/local/glibc-2.14 [root@jrgc130 build] # make -j4 [root@jrgc130 build] # make install |
二、拷贝链接库
1
2
|
[root@jrgc130 build] # cd /usr/local/glibc-2.14/lib [root@jrgc130 lib] # cp libc-2.14.so /lib64/ |
三、创建链接
1
2
|
[root@jrgc130 lib] # cd /lib64 |
1
|
[root@example lib64] # /sbin/sln libc-2.14.so /lib64/libc.so.6 |
[root@jrgc130 lib64]
# strings /lib64/libc.so.6 |grep GLIBC
GLIBC_2.2.5
GLIBC_2.2.6
GLIBC_2.3
GLIBC_2.3.2
GLIBC_2.3.3
GLIBC_2.3.4
GLIBC_2.4
GLIBC_2.5
GLIBC_2.6
GLIBC_2.7
GLIBC_2.8
GLIBC_2.9
GLIBC_2.10
GLIBC_2.11
GLIBC_2.12
GLIBC_2.13
GLIBC_2.14
GLIBC_PRIVATE
2.
解决:把主机名写入hosts文件
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.67.25 p0gqgdb901
1
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
2
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
3
4
192.168.67.25 p0gqgdb901
解决:
参考:Oracle 18c on RHEL 6.10 fail with "[FATAL] [INS-30060] Check for group existence failed." (文档 ID 2464358.1)
加参数:./runInstaller -ignoreInternalDriverError 继续启动图形界面
建库
dbca 的时候加入参数-J-Doracle.assistants.dbca.validate.ConfigurationParams=false跳过检查
dbca -J-Doracle.assistants.dbca.validate.ConfigurationParams=false
1
dbca -J-Doracle.assistants.dbca.validate.ConfigurationParams=false
依然报错,修改成高级安装,不使用模板方式建库,使用自定义方式建库。。。。。
<wiz_tmp_tag id="wiz-table-range-border" contenteditable="false" style="display: none;">