您好,登录后才能下订单哦!
这几天在生产环境安装12c dg很不顺利,参照以前6.X装12c dg,参数什么的一样,可一直提示ORA-01017,listener.ora/tnsnames.ora/设置没啥问题。
如下为后续在自己备库测试环境搭建参数:
listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = racdg)
(ORACLE_HOME = /u01/app/12.2.0/grid)
(SID_NAME = racdg)
)
(SID_DESC =
(GLOBAL_DBNAME = racdg)
(ORACLE_HOME = /u01/app/12.2.0/grid)
(SID_NAME = rac)
)
(SID_DESC =
(GLOBAL_DBNAME = rac)
(ORACLE_HOME = /u01/app/12.2.0/grid)
(SID_NAME = rac)
)
)
tnsnames.ora
RAC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.168)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rac)
(UR=A)
)
)
RACdg =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.188)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = racdg)
(UR=A)
)
)
initracdg.ora 参数
*.audit_file_dest='/u01/app/oracle/admin/rac/adump'
*.audit_trail='db'
*.db_recovery_file_dest='+DATA'
*.db_recovery_file_dest_size=1024m
*.db_unique_name='racdg'
*.db_name='rac'
*.control_files='+DATA/racdg/CONTROLFILE/control01.ctl','+DATA/racdg/CONTROLFILE/control02.ctl'
*.diagnostic_dest='/oracle/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=racXDB)'
*.fal_server='rac'
family:dw_helper.instance_mode='read-only'
*.job_queue_processes=0
#*.local_listener='-oraagent-dummy-'
*.log_archive_config='DG_CONFIG=(racdg,rac)'
*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=racdg'
*.log_archive_dest_2='SERVICE=rac LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=rac'
#*.log_archive_dest_state_1='ENABLE'
#*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.processes=1000
*.remote_login_passwordfile='exclusive'
*.standby_file_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.service_names='racdg'
*.log_file_name_convert='+DATA/rac/','+DATA/racdg/ONLINELOG/','+DATA/rac/ONLINELOG','+DATA/racdg/ONLINELOG'
*.db_file_name_convert='+DATA/rac/','+DATA/racdg/DATAFILE/','+DATA/rac/DATAFILE/','+DATA/racdg/DATAFILE'
*.local_listener='-oraagent-dummy-' 这个参数我不屏蔽,一直会提示 ORA-01017: invalid username/password
我屏蔽了这个参数后,再次重启数据库,问题解决。 实在有些纳闷,这个参数不是管控动态注册的吗?而且以前其他版本这个参数我都没有去屏蔽都没问题。不知道有没有其他朋友碰到类似问题,还请解答下。
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。