centost7下安装oracle11g 总结踩坑

1.参考文章

【总结】CentoS下Oracle静默安装流程_正在启动oracle universal installer..._仲冬二三的博客-CSDN博客

https://blog.csdn.net/Liqiong_0412/article/details/126153857?

unset DISPLAY

可以跳过图形化检查  这边也卡了很久

[oracle@wangmengyuan database]$ ./runInstaller -silent -responseFile /u01/app/oracle/database/response/db_install.rsp -ignorePrereq

这边要注意环境变量   否则进行不下去

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

#hx modify
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH

#oracle变量：
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=orcl
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
export NLS_LANG=american_america.zhs16gbk
 

#hx modify 这部分一开始注释的有点问题  卡了好久这个地方
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH

配置监听地址

find / -name netca
find: ‘/usr/libexec/initscripts/legacy-actions/auditd’: 权限不够
/u01/app/oracle/product/11.2.0/db_1/inventory/Templates/assistants/netca
/u01/app/oracle/product/11.2.0/db_1/assistants/netca
/u01/app/oracle/product/11.2.0/db_1/bin/netca

#这一部分原来就会有
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.181.132)(PORT = 1521)) #将HOST修改为当前ip地址
    )
  )

#这一部分手动添加
SID_LIST_LISTENER=
             (SID_LIST =
                (SID_DESC =
                  (GLOBAL_DBNAME =  orcl)
                  (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
                  (SID_NAME = orcl)
                 )
               )

ADR_BASE_LISTENER = /u01/app/oracle
 

17.创建数据库  也卡了很久 模板配置的方式没搞定

参考了其他办法

dbca -silent -createDatabase -responseFile NO_VALUE -templateName General_Purpose.dbc -gdbname orcl -sid orcl \
-datafileDestination '/u01/app/oracle/oradata' \
-systemPassword qq88415xx2 \
-sysPassword qq88415xx2