1、 Directory structure
D:\install\PLSQL |-- instantclient_11_2 |-- tnsnames.ora |-- PLSQL Developer |-- readme.txt
2、 Environment variables
you must configure environment variables, otherwise the database fields will be added with random comments
NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK TNS_ADMIN = D:\install\PLSQL\instantclient_11_2
3、 PL/SQL developer environment settings
1. Location Tools -> Preferences -> Connections 2. Settings Oracle home directory name = D:\install\PLSQL\instantclient_11_2 OCI library = D:\install\PLSQL\instantclient_11_2\oci.dll
The tnsnames.ora file needs to be created manually and set up accordingly, refer to the online tutorial.
Problem: you need to modify the tnsnames.ora file to configure the database connection, but you can’t find the path of the file. Many online searches say that it’s in the app directory of disk D, but you still can’t find it.
Solution: open PL/SQL and find help – & gt; Support information
after opening, you will see the PL/SQL version information and other configuration information. If you pull down, there will be a “TNS file”, which is the tnsnames.ora file path of the PL/SQL you installed. After modification, you need to restart PL/SQL
- SQL Developer error: Unable to find a Java Virtual Machine solution
- MYSQL 5.7 Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it..
- Mybatis Error: The server time zone value ‘����1532a0’ is unrecognized
- [Solved] Running in 64 bit mode with the 32 bit Oracle client installed
- Solve ERROR 1231 (42000): Variable’time_zone’ can’t
- How to Fix MySQL ERROR 1130 (HY000): Host ‘XXXX’ is not allowed to connect to this MySQL server
- [Solved] SQLSTATE[HY000]  Connection refused to report an error when PHP connects to mysql in the docker container
- [How to Fix] Database can’t open file (errno:24)
- How to Solved Error: 18456, Severity: 14, State: 38.
- [Solved] docker mysql SQLSTATE[HY000]  Connection refused
- MySQL Error: Error writing file ‘/tmp/MY4WYVlC‘ (Errcode: 28 – No space left on device)
- [Solved] Daily further: database error: unknown column ‘model’ in ‘field list‘
- Idea connect mysql error Server returns invalid timezone. Go to’Advanced’ tab and set’serverTimezone’ property
- How to Solve mysql [Err] 1067-Invalid default value for
- [Solved] MYSQL 5.7 gruop by eRROR: this is incompatible with sql_mode=only_full_group_by
- Runtime error occurred: 1843 (ORA-01843: invalid month)
- Mysql Flashback Warning: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe
- [Solved] Caused by: java.sql.SQLException: Access denied for user ‘root‘@‘hadoop102‘ (using password: YES)
- C# System.Data.SQLite.SQLiteException:“SQL logic error or missing database no such table: XX”
- (Fixed) workbench MySQL Error Code: 2013. Lost connection to MySQL server during query