oracle instance_name vs. service_name
From: JĊns MÁrtin SchlÁttĊr <KmoEfrUewEbx_at_spammotel.com>
Date: Wed, 19 Nov 2008 04:24:04 -0800 (PST)
Message-ID: <f1c343c5-6f84-450e-ac7d-e21eb0170315@i24g2000prf.googlegroups.com>
Date: Wed, 19 Nov 2008 04:24:04 -0800 (PST)
Message-ID: <f1c343c5-6f84-450e-ac7d-e21eb0170315@i24g2000prf.googlegroups.com>
If I use sqlplus to connect to a database, I do it like that:
sqlplus user1/secret1_at_ora1.mydomain.com:1583/db.prd1
where db.prd1 is the service_name.
If I do the connect through JDBC, the connection url is:
jdbc:oracle:thin:@ora1.mydomain.com:1583:db1
SQLPLUS uses the service name, whereas JDBC uses the instance_name (resp. sid).
How does this work? Is the oracle protocol so that either instance name or service name can be used?
Martin Received on Wed Nov 19 2008 - 06:24:04 CST