[RAT] how wrc clients connect to the replay database after remap connection
Hi,
I'm testing an upgrade from Oracle 11gR2 RAC 4 instances database to Oracle 19.20 RAC 5 instances database.
I've already capture the workload on the source database and processed it on the target database that is a restore of the source database at the SCN when the capture started. I've already inizialized the replay and run the connection remapping with:
select q'[exec DBMS_WORKLOAD_REPLAY.REMAP_CONNECTION(connection_id => ]'
|| conn_id
|| q'[, replay_connection => ']'
|| substr(regexp_substr(capture_conn, '(SERVICE_NAME=)(.*)', 1, 1, null, 2),1,instr(regexp_substr(capture_conn, '(SERVICE_NAME=)(.*)', 1, 1, null, 2),'.')-1)
|| q'[');]' from DBA_WORKLOAD_CONNECTION_MAP;