Shulou(Shulou.com)06/01 Report--

The installation of 12c dg in the production environment is not smooth these days. With reference to the previous 6.x installation of 12c dg, the parameters are the same, but you can always prompt that there is no problem with the ORA-01017,listener.ora/tnsnames.ora/ setting.

The following parameters are built in the test environment of your own library:

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 parameter

* .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'

I will not block the parameter "local_listener='-oraagent-dummy-'", and will always prompt ORA-01017: invalid username/password.

After I have shielded this parameter, I restart the database again, and the problem is solved. I wonder, isn't this parameter controlled by dynamic registration? And in the past, I didn't block this parameter in other versions. I don't know if any other friends have similar questions, please answer them.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.