First check service name of database in Oracle.
SQL> show parameter service_names;
By default the SERVICE_NAMES parameter is a concatenation of the DB_NAME and DB_DOMAIN parameters. if host computer is not in domain the service name will be like this :
For example IP address of computer is 192.168.8.100 and database name is orcl then service name will be orcl.168.8.100.
However, you can change it to whatever you'd like For example:
ALTER SYSTEM SET SERVICE_NAMES='orcl_11g.host-name.xyz.com';
Using SERVICE_NAMES is a good way to isolate applications for tracing and metrics measurement.
SQL> show parameter service_names;
By default the SERVICE_NAMES parameter is a concatenation of the DB_NAME and DB_DOMAIN parameters. if host computer is not in domain the service name will be like this :
For example IP address of computer is 192.168.8.100 and database name is orcl then service name will be orcl.168.8.100.
However, you can change it to whatever you'd like For example:
ALTER SYSTEM SET SERVICE_NAMES='orcl_11g.host-name.xyz.com';
Using SERVICE_NAMES is a good way to isolate applications for tracing and metrics measurement.
Thank you so much.
ReplyDelete