"One" understanding of the Oracle_sid--------------------------------------------------------------------------------The SID in Oracle acts like a "switch variable"---directs Oracle to start the instance correctly by reading the appropriate
The understanding of "one" to Oracle_sid
--------------------------------------------------------------------------------The role of SIDS in Oracle is similar to that of a "switch variable"---directs Oracle to read and load the appropriate parameter
The "preface" is explained in the blog post:This article will introduce the concept of server_name and instance name SID in Oracle by personal tone, and under the current time point "May 22, 2017 ", the level of technology is limited, there may be a
The JDBC Connection database uses the difference between SID and Service_Name most recently using JDBC to connect to the Oracle times error:ORA-12505, Tns:listener does not currently know of SID given in Connect descriptor the Connection descriptor
Problem Description:ORA-12505, Tns:listener does not currently know of SID given in Connect descriptor the Connection descriptor used by the C Lient was:10.12.162.84:1521:xxxxThe Oracle data is configured in the Tnsnames.ora: Service_Name =xxxx. The
The JDBC Connection database uses the difference between SID and Service_NameBlog Category:
Oracle
Recently using JDBC to connect to Oracle times error:ORA-12505, Tns:listener does not currently know of SID given in Connect descriptor
Recently using JDBC to connect to Oracle times error:ORA-12505, Tns:listener does not currently know of SID given in Connect descriptor the Connection descriptor used by the C Lient was:10.12.162.84:1521:xxxxLogging in to Oracle Data discovery is
http://java-xp.iteye.com/blog/1639607——————————————————————————————————————————————————————Recently using JDBC to connect to Oracle times error:ORA-12505, Tns:listener does not currently know of SID given in Connect descriptor the Connection
Show parameter service_names
select instance_name from v$instance;
Db_name is a real physical name. SERVICE_NAME carries the domain name, because if the two databases do not have the same domain, they can have the same name. The SID is the
In init. ora contains db_name, instance_name, and service_name. in the operating system, you must configure oracle_sid in listener. ora contains SID_NAME, GLOBAL_DBNAME, in tnsname. there are so many SERVICE_NAME and SID in ora that you are confused.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.