Logon to Oracle’s sqlplus:

Sqlplus >connect ABC/********** (userid/password)
create table al_machine_info_backup as select * from al_machine_info;
Delete from AL_MACHINE_INFO where MACHINE_NAME='<old_hostname>’;
Delete from AL_MACHINE_INFO where MACHINE_NAME='<old_hostname>.dns_name.com>';
Select machine_name,port from AL_MACHINE_INFO;


For user schema DEF:

Sqlplus >connect DEF/********** (userid/password)
create table al_machine_info_backup as select * from al_machine_info;
Delete from AL_MACHINE_INFO where MACHINE_NAME='<old_hostname>’;
Delete from AL_MACHINE_INFO where MACHINE_NAME='<old_hostname>.dns_name.com>';
Select machine_name,port from AL_MACHINE_INFO;


For system schema user DS_<SID>_cntrl_repo:

Sqlplus >connect DS_<SID>_cntrl_repo /********** (userid/password)
create table al_machine_info_backup as select * from al_machine_info;
Delete from AL_MACHINE_INFO where MACHINE_NAME='<old_hostname>’;
Delete from AL_MACHINE_INFO where MACHINE_NAME='<old_hostname>.dns_name.com>';
Select machine_name,port from AL_MACHINE_INFO;

Similarly, do the same for the system schema users DS_<SID>_datam_repo, DS_<SID>_prof_repo, DS_<SID>_STAGING.


For system schema user <SID>_REPO:

Sqlplus >connect <SID>_REPO/********** (userid/password)
create table al_machine_info_backup as select * from al_machine_info;
Delete from AL_MACHINE_INFO where MACHINE_NAME='<old_hostname>’;
Delete from AL_MACHINE_INFO where MACHINE_NAME='<old_hostname>.dns_name.com>';
Select machine_name,port from AL_MACHINE_INFO;

Similarly, do the same for the system schema users DS_<SID>_cntrl_repo, DS_<SID>_datam_repo, DS_<SID>_prof_repo, DS_<SID>_STAGING.