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.