After a 64-bit Oracle 10g Database is installed on the 64-bit win2003 operating system, you can connect to the database using PLSQL over the network, but the server cannot connect to the database.
Solve the problem as follows:
1. Install the 32-bit Oracle client (about MB) and select the Administrator mode.
And use the net manager of this version to configure the server connection string. Do not use the server version for configuration, because the former is 32-bit, and the latter is 64-bit.
One of their home directories is under D: \ oracle \ product \ 10.2.0 \ client_1, and the other is under D: \ oracle \ product \ 10.2.0 \ db_1.
Both directories contain the network \ admin \ tnsnames. ora file. The 32-bit software must use the file in the 32-bit client directory.
2. Install PLSQL to the specified directory (for example, D: \ PLSQL). Do not select the default directory (D: \ Program Files (x86 ))
Because the 32-bit software installed on the 64-bit server is installed on D: \ Program Files (x86) by default, because the Oracle Net service has a bug when parsing the connection, the parentheses included in the path cannot be parsed.