ORA-12505, Tns:listener does not currently know of SID given in Connect Desc.
This situation is generally because the instance name of the database is not given, only the service name of the database is given
What is a DB instance name? The database instance name is the identity used to contact the operating system, meaning the database instance name is used for interaction between the database and the operating system. The instance name is also written to the parameter file, which is instance_name, and the instance name is also written to the registry in the Winnt platform. The database name and instance name can be the same or different. In general, database names and instance names are a one-to-many relationship, but if you are in an Oracle Parallel server architecture (that is, Oracle real-time application clusters), the database name and instance name are a one-to-numerous relationship.
This situation is generally because the instance name of the database is not given, only the service name of the database is given
Select instance_name from V$instance;
How to solve it?
Orasession has a Datatypemap attribute
Here you can fill in the service name
In fact, the program can not be changed, only used in front of the service name plus sn= on it.
This is the only difference from the instance name.
ORA-12505, Tns:listener does not currently know of SID given in Connect Desc.