Change service name in oracle SID

Before you can change the SERVICE_NAME in your TNSNAMES.ORA file you have to make sure that the SERVICE_NAMES parameter on the database is configured appropriately. You can display the current value as follows:
SQL> show parameter service_names
By default the SERVICE_NAMES parameter is a concatenation of the DB_NAME and DB_DOMAIN parameters. However, you can change it to whatever you'd like and it can take multiple values. For example:
ALTER SYSTEM SET SERVICE_NAMES='application_a.your.domain','application_b.your.domain' SCOPE=BOTH;
Using SERVICE_NAMES is a good way to isolate applications for tracing and metrics measurement.

Popular posts from this blog

Shrink you container size up to 95%.

alma linux: dnf Module yaml error: Unexpected key in data