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

梦里梦外; 2022-05-18 07:39 436阅读 0赞

**Linux带图形界面安装oracle**

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

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

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服务和监听器开机自启,[参考博客][Link 3]

**卸载Oracle数据库 ：[参考博客][Link 4]**

**Oracle在linux下静默安装 详细安装步骤 [参考博客][Link 5]**

安装过程中遇到问题

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

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

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

解决办法：增加swap空间，[参考博客][Link 6]

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，这两个参数需要根据自己机器配置

[Link 1]: https://docs.oracle.com/database/121/index.htm
[Link 2]: https://blog.csdn.net/holmofy/article/details/77622284
[Link 3]: https://www.cnblogs.com/Anonymous-1/p/4996326.html
[Link 4]: https://blog.csdn.net/u010257584/article/details/50911347
[Link 5]: https://blog.51cto.com/12790274/2062955
[Link 6]: https://yq.aliyun.com/articles/69078