Rename the Oracle Instance name

[Endmost]

Hi All,
Any suggestions if we want to change the default Oracle Instance name from sid@hostname to servicename@hostname? I have tried to modify the "Oracle DB On Unix" pattern and replaced $sid with another variable in step "sets the display label". The discovery log can show the correct name in the Creating CI section, but the actual cmdb_ci_db_ora_instance CI just won't change the name. Any idea?

Endmost

[SiD2]

Hi @Endmost,

Check if you have any BR that override this but usually it should update the CI.

Please mark Helpful / Accept Solution so that it helps others with similar questions.

[Endmost]

Hi SiD,

No, I couldn't find any BR that overwrites the oracle instance name. What I found is, if I delete the instance before I re-run the discovery for its hosting server then the instance name would get renamed.

Endmost

[SiD2]

Hi @Endmost,

This is strange... Check if there were any custom reconciliation rules that were setup for Discovery source to exclude updating some fields and if name is among them.

If that is also not the case, someone needs to look in directly so you can raise a Case with ServiceNow Support.

Please mark Helpful / Accept Solution so that it helps others with similar questions.

[Endmost]

Hi SiD,

There is an OOB reconciliation rule, Oracle Instance rule by ServiceWatch. After disabling it and re-run discoveries, the oracle instances changed their name to the desired.

Endmost