I'm trying to get my head around configuring Oracle Net services on my home laptop and have a few questions.
This I get...
SID is the system identifier i.e. the actual instance.
Database name, is the database files actually on the disk.
SID != Instance Name (only found this out a couple of days ago)
Instance Name & Net Service Name are simply Net concepts. (again something new to me)
CONNECT USER/PASSWD@MYDB
Net Service name "PDBORCL" (not the Service name) is what you use when you want to connect to a database, i.e. the first PDBORCL in the TNSNAMES entry below.
PDBORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdborcl)
)
)
Where I'm having difficulty is the concept of Instance name which is not the same as the Oracle SID, and Service name. In the TNSNAMES entry above SERVICE_NAME can be replaced by SID.
So is SID = Service Name always, where is it defined?
Where does the net concept Instance Name fit in, in all of this?