Get the App
SLTechnology News&Howtos  ›  Database  › 

ORA-12154 TNScould not resolve the connect identifier specified

Shulou Source: shulou.com Published: 2022-06-01 10:31:12 11月01日 Update

Today, I logged in to PL/SQL to connect to ORACLE 11G R2 with the following error: ORA-12154 TNScould not resolve the connect identifier specified.

My solution is: 1. Open "my computer"-- "Properties"-- "Advanced system Settings"-- "Environment variable"-- "system variable"-- PATH-- "Edit"-delete the variable value of "C:\ app\ linxi\ product\ 11.2.0\ dbhome_1\ BIN".

two。 Open PL/SQL, enter the user name, password, database name and role, and find that the login is successful!

Tags: Variables system login advanced success method password properties data database environment user user name computer role value input Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Microsoft Docker MySQL macOS Shulou Information