您好,登錄后才能下訂單哦!
這幾天在生產環境安裝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進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。