ORA-12505, TNS:listener does not currently know of SID given in connect desc
时间: 2023-11-01 17:31:22 浏览: 31
This error message typically occurs when a user is attempting to connect to an Oracle database using an incorrect or invalid Service Identifier (SID) value. The SID is a unique identifier for a particular Oracle database instance and is used to connect to that instance.
To resolve this error, the user should verify that they are using the correct SID value when attempting to connect to the database. The SID value can typically be found in the tnsnames.ora file or can be obtained from the database administrator.
If the user is using the correct SID value and is still experiencing this error, they may need to check the Oracle listener configuration to ensure that the listener is properly configured to recognize the specified SID. The listener.ora file should be checked to verify that the SID is correctly specified and that the listener is running and listening for incoming connections.