Αποτελέσματα Αναζήτησης
4 Σεπ 2008 · SID = unique name of the INSTANCE (eg the oracle process running on the machine). Oracle considers the "Database" to be the files. Service Name = alias to an INSTANCE (or many instances).
26 Δεκ 2023 · SIDs and service names are both used to identify a database instance, but they serve different purposes. SIDs are used for internal purposes within the Oracle database, while service names are used for external purposes, such as connecting to the database from an application.
31 Μαΐ 2001 · The service_name may or may not be the ORACLE_SID. It is setup via the init.ora file with the "service_names" parameter. You can check this parameter by: select name, value from v$parameters where name like 'service%' /
The SERVICE_NAME can be any valid service presented by the listener. You can check the available services by issuing the lsnrctl status or lsnrctl service commands on the database server. Typically there is at least one service matching the ORACLE_SID of the instance, but you can create more.
17 Φεβ 2009 · 1) What is the difference between SID entry and SERVICE_NAME in the tnsnames.ora. 2) When I put SID the connection is successful, when I put SERVICE_NAME it says tns could not resolve service name. So This works. MYDB.world =. (DESCRIPTION =. (ADDRESS_LIST =.
SID parameter, which identifies the system identifier (SID) of the Oracle database. The SID is sales. SERVICE_NAME parameter, which identifies the service. The destination service name is a database service named sales.us.example.com.
20 Σεπ 2004 · sid+oracle_home+hostname = a database instance. use this and you get connected to specific instance service=collection of equivalent instances. used most often in a clustering environment but has applicability in single instance database configurations as well.
