江苏龙网

  1. 主页 > 生活百科 > >

Centos7.6上静默安装oracle11.2.0.4.0( 二 )

Oracle

14.配置监听export DISPLAY=127.0.0.1:1.0netca -silent -responsefile /u01/soft/database/response/netca.rsp在/u01/app/oracle/product/11.2.0/db_1/network/admin目录下创建tnsnames.ora文件CRMDB =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = cbov10-tidb57-206)(PORT = 1521))(CONNECT_DATA =https://www.isolves.com/it/sjk/Oracle/2020-09-22/(SERVER = DEDICATED)(SERVICE_NAME = crmdb)))如果监听一直出不来，可以使用alter system register手工注册
15.dbca静默建库[GENERAL]RESPONSEFILE_VERSION = "11.2.0"OPERATION_TYPE = "createDatabase"[CREATEDATABASE]GDBNAME = "crmdb"SID="crmdb"TEMPLATENAME = "General_Purpose.dbc"CHARACTERSET = "ZHS16GBK"TOTALMEMORY = "512"SYSPASSword = "oracle"SYSTEMPASSWORD = "oracle"/u01/app/oracle/product/11.2.0/db_1/assistants/dbca/templates/General_Purpose.dbc
在上述文件中，可以修改数据库文件，redo，归档模式，Controlfile存放位置和大小
dbca -silent -initParams log_archive_dest_1='location=/oracle/archivelog' -responseFile /u01/soft/database/response/db_create.rsp
设置timestamp时间显示格式
alter system set nls_date_format='yyyy-mm-dd hh24:mi:ss' scope=spfile;
/u03/app/oracle/product/11.2.0/db_1/assistants/dbca/templates/General_Purpose.dbc文件修改
<?xml version = '1.0'?><DatabaseTemplate name="General_Purpose" description="" version="11.1.0.0.0"><CommonAttributes><option name="OMS" value=https://www.isolves.com/it/sjk/Oracle/2020-09-22/"false"/>16.安全配置解除密码180天有效期限制，这个一步非常重要
alter profile default limit password_life_time unlimited;


推荐阅读


上一篇：健脾祛湿代茶饮配方,赤小豆薏仁祛湿茶配方

下一篇：喝茶什么茶能减肥吗,什么茶减肥