SID and database name are concepts you could think belonging on a server's host. I'll attempt to add some clarification, specially the part about SID and instance name. Trying to run multiple listeners and creating a 1-to-1 relationship between listeners and db instances is like the phone company trying to maintain a separate switchboard for each telephone on the network. The listener is just a connection broker - a switchboard, if you will. Listener : The Listener is a named process which runs on the Oracle Server, awaiting requests from Clients to connect to the InstanceĪnd please point out that a single listener, with the default name of LISTENER, using the single default port of 1521, is quite capable of - was designed to - support multiple database instances of multiple versions running from multiple ORACLE_HOMEs. Service name =SERVICE NAMES specifies one or more names for the database service to which this instance connects. Instance Name = it is same as Oracle SID. Mariappan ArjunanSid= SID(system identifier) is a unique name for an Oracle database instance.ĭB Name(database name) = Name of the database (database can be shared between multiple instances ) Please tell me the difference between SID, Database Name, Instance Name, Service Name and listener. 1.7K Training / Learning / Certification.165.3K Java EE (Java Enterprise Edition).7.8K Oracle Database Express Edition (XE).
0 Comments
Leave a Reply. |