Today, a colleague encountered a problem when installing our system to a customer.

Background: colleagues installed as follows:

       The server is a small machine, a virtual machine made on the small machine. WIN2003 operating system is installed with 64 bits.

       Database: oracle11g.

       PLSQL7.5

On a 64-bit machine, the following error is reported when PLSQL is accessed:

Initialization error
SQL*Net not properly installed

OracleHomeKey:
OracleHomeDir:

I searched on the Internet and found that it is a 64-bit machine, and a 32-bit Oracl client needs to be installed for PLSQL to access it correctly.

After installing the Oracl client, this problem was solved.

Then came another problem: when logging in with PLSQL, an error ORA-12154: TNS: Unable to process the service name was reported . I changed the listener.ora and tnsname.ora under D:\Oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN, but it still doesn’t work. After various attempts, the error persisted.

I have no choice but to install an Oracl client and PLSQL7.5 on another LAN machine. When installing PLSQL7.5, the default path is c:\program files (x86)\PLSQLDeveloper, but an error will be reported, roughly Saying that NET might have a problem, I changed the path to D:\tool\PLSQLDeveloper. After configuring tnsname.ora of an Oracl client, run PLSQL again, and it is normal and connected.

Go back, check the PLSQL on the server, the installation path is the default path c:\program files (x86)\PLSQLDeveloper, uninstall and reinstall. The installation path has been changed. After finishing, run PLSQL again, it is normal. Haha

Read More:

• [Solved] lightdb oracle_fdw Error: ERROR: error connecting to Oracle: OCIEnvCreate failed to create environment handle
• Error while trying to run project:unable to start debugging.the debugger is not properly installed. run setup to install or repa
• Oracle VM VirtualBox open replication virtual machine Error
• How to Fix TNS 12560 Error
• [Solved] RK3568-ANDROID11-BOARD_HAVE_DONGLE ERROR (3G/4G)
• [Solved] Toad Set Error: The following files specified on the Executables tab could not be found:TNS Ping
• Solve the problem that the native machine cannot use ant script checkout project
• MacOS Mojave uses SMB LAN share as backup disk of timemachine time machine. Disk does not support time machine backups. (error 45)
• ORA-24338 statement handle not executed [How to Solve]
• [Solved] Oracle 18C RAC Install Error: Error in invoking target ‘irman ioracle idrdactl idrdalsnr idrdaproc‘ of makefile
• [Solved] IDEA Start Project Error: Abnormal build process termination:Could not create the Java Virtual Machine.
• Error using tensorflow GPU: could not create cudnn handle: cudnn_STATUS_NOT_INITIALIZED
• [Solved] Navicat Connect Error: Oracle library is not loaded.
• [Solved] Phone Debug Program Error: The application could not be installed: INSTALL_FAILED_TEST_ONLY
• CUDA error: CUBLAS_STATUS_NOT_INITIALIZED when calling `cublasCreate(handle)`
• [Solved] Xcode13.1 Upgrade Error: CocoaPods installed but not working Failed to build gem native extension
• The problem of using GB2312 encoding in .NET Core to report errors
• The application could not be installed: INSTALL_FAILED_USER_RESTRICTED
• [Solved] ora 01033 linux,ORA-01033: ORACLE initialization or shutdown in progres