Database - RAC/Scalability (MOSC)

MOSC Banner

[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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center