这几天在生产环境安装12 c dg很不顺利,参照以前6。X装12 c dg,参数什么的一样,可一直提示ora - 01017, listener.ora tnsnames.ora/设置没啥问题。
如下为后续在自己备库测试环境搭建参数:
SID_LIST_LISTENER=
,(SID_LIST=
,,(SID_DESC=
,,,(GLOBAL_DBNAME=racdg)
,,,(ORACLE_HOME=/u01/app/12.2.0/网格)
,,,(SID_NAME=racdg)
,,)
,,(SID_DESC=
,,,(GLOBAL_DBNAME=racdg)
,,,(ORACLE_HOME=/u01/app/12.2.0/网格)
,,,(SID_NAME=rac)
,,)
,,(SID_DESC=
,,,(GLOBAL_DBNAME=rac)
,,,(ORACLE_HOME=/u01/app/12.2.0/网格)
,,,(SID_NAME=rac)
,,)
,)
* .audit_file_dest=& # 39;/u01/app/oracle/admin/rac/adump& # 39;
* .audit_trail=& # 39; db # 39;
* .db_recovery_file_dest=& # 39; +数据# 39;
* .db_recovery_file_dest_size=1024
* .db_unique_name=& # 39; racdg& # 39;
* .db_name=& # 39; rac # 39;
* .control_files=& # 39; +数据/racdg/CONTROLFILE control01.ctl& # 39;, & # 39; +数据/racdg/CONTROLFILE control02.ctl& # 39;
* .diagnostic_dest=& # 39;/oracle/app/oracle # 39;
* .dispatchers=& # 39;(协议(TCP)(服务=racXDB) & # 39;
* .fal_server=& # 39; rac # 39;
家庭:dw_helper.instance_mode=& # 39;只读# 39;
* .job_queue_processes=0
# * .local_listener=& # 39; -oraagent-dummy & # 39;
* .log_archive_config=& # 39; DG_CONFIG=(racdg rac) & # 39;
* .log_archive_dest_1=& # 39;位置=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME=racdg& # 39;
* .log_archive_dest_2=& # 39;服务=rac LGWR异步VALID_FOR=(ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME=rac # 39;
# * .log_archive_dest_state_1=& # 39;使# 39;
# * .log_archive_dest_state_2=& # 39;使# 39;
* .log_archive_format=& # 39; % t_ % s_ % r.dbf&识别# 39;
* .open_cursors=300
* .processes=1000
* .remote_login_passwordfile=& # 39;独家# 39;
* .standby_file_management=& # 39;汽车# 39;
* .undo_tablespace=& # 39; UNDOTBS1& # 39;
* .service_names=& # 39; racdg& # 39;
* .log_file_name_convert=& # 39; +数据/rac/& # 39; & # 39; +数据/racdg/ONLINELOG & # 39;, & # 39; +数据/rac/ONLINELOG& # 39; & # 39; +数据/racdg/ONLINELOG& # 39;
* .db_file_name_convert=& # 39; +数据/rac/& # 39; & # 39; +数据/racdg/功能/& # 39;,& # 39;+/功能/数据/rac & # 39;, & # 39; +数据/racdg/丢失# 39;