Set the environment variable TNS_ADMINoracleproductapp5networkadminsamples to read the new tnsnames. ora location. You can use the client to connect to the oracle program.
Set the environment variable TNS_ADMIN =/oracle/product/app5/network/admin/samples to read the location of the new tnsnames. ora, and use the client to connect to the oracle program.
The new database is installed after cutover, and the client login is normal. The apache/cgi-bin program is faulty. The sqlnet. log is as follows:
Fatal NI connect error 12170.
Version information:
TNS for Linux: Version 10.2.0.4.0-Production
TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.4.0-Production
Time: 2012 10:53:02
Tracing not turned on.
Tns error struct:
Ns main err code: 12535
TNS-12535: TNS: operation timed out
Ns secondary err code: 12560
Nt main err code: 505
TNS-00505: Operation timed out.
Nt secondary err code: 110
Nt OS err code: 0
Client address:
Cause:
The tns resolution string specifies the problem.
Set the environment variable TNS_ADMIN =/Oracle/product/app5/network/admin/samples to read the location of the new tnsnames. ora, and use the client to connect to the oracle program to run normally.
However, the cgi-bin program cannot be executed normally because of the environment variable transmission relationship of http.
Two solutions:
1. Run the environment variable in apache and restart apache.
2. Reply tnsnames. ora to $ ORACLE_HOME/network/admin.