Sqlplus logon fails to locate the program Input Point longjmp in the dynamic link library error message, sqlpluslongjmp
Problem description: When we log on to Oracle sqlplus as follows, the program cannot be located. The longjmp input point is in the dynamic link library D: \ app \ porry \ product \ 11.2.0 \ dbhome_1 \ bin \ oracore11.dll error message.
Alternatively, a ora-12514 error prompt appears while logging on with the Oracle PL/SQL Developer client, but the TNS configuration is not incorrect, the error is as follows:
Solution: this problem occurs because Oracle Developer Suit is installed after Oracle is installed. In this way, the database values in the environment variables are pushed to the backend. As shown in:
Specific Practices:
You only need to put the database-related variable value at the beginning in the path environment variable, as shown in:
After setting and saving the environment variables, we use PL/SQL Developer to log on and check whether the logon is successful. If the interface appears, the problem is solved successfully.
Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.