Linux下Oracle图形界面安装、静默安装和卸载总结

Linux带图形界面安装oracle

linux下安装oracle还是比较麻烦，官方在线文档

1.详细安装步骤，有步骤解释和截图 参考博客 

2.安装完后配置listener.ora和tnsnames.ora两个文件，把主机名修改成本机ip才能远程连接数据库

listener.ora参考配置

# listener.ora Network Configuration File: /u01/app/oracle/product/12.2.0.1/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.35)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

SID_LIST_LISTENER =
(SID_LIST =
 (SID_DESC =
 (GLOBAL_DBNAME = cdb1) #cdb db_name 实际连接数据库时使用的名称
 (SID_NAME = cdb1) #安装时候配置的sid名称
 )
 (SID_DESC =
 (GLOBAL_DBNAME = cdb1pdb) #pdb db_name 实际连接数据库时使用的名称
 (SID_NAME = cdb1) #安装时候配置的sid名称
 )
)
USE_SID_AS_SERVICE_LISTENER=ON  #打开可以使用sid方式连接pdb数据库

 tnsnames.ora参考配置

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.2.0.1/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_CDB1 =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.35)(PORT = 1521))


CDB1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.35)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = cdb1)
    )
  )

CDB1PDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.35)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = cdb1pdb)
    )
  )

 

3.打开监听和启动数据库基本命令

打开监听器，关闭监听器，查看监听状态   

lsnrctl start | stop | status

启动数据库

sqlplus /nolog

SQL>conn / as sysdba

SQL>startup

关闭数据库并回退事务

SQL>shutdown immediate

4.配置Oracle服务和监听器开机自启,参考博客

卸载Oracle数据库 ：参考博客

Oracle在linux下静默安装 详细安装步骤 参考博客

安装过程中遇到问题

1.静默安装这篇博客这个地方博主可能注释错了，参数oinstall没有错，这个不是写主机名，而是oracle用户的用户组

UNIX_GROUP_NAME=oinstall                                              //35行主机名称（hostname查询）

2.把oracle安装到虚拟机，检测到内存不够，我的虚拟机只有4g内存，只好增加swap空间磁盘当内存用了

解决办法：增加swap空间，参考博客

3.静默配置新库 dbca.rsp 

automaticMemoryManagement=true          //594    当物理内存总量大于4GB时，不允许使用自动内存管理选项，需要填false

4.静默配置新库 dbca.rsp 

ORA-00821: Specified value of sga_target 600M is too small, needs to be at least 1072M
在initParams上加参数：sga_target=4096MB,sga_max_size=10720MB，这两个参数需要根据自己机器配置