Oracle Database new installation connection string problem cutover newly installed database, Client Login no problem, apache/cgi-bin program problems, sqlnet. the log is as follows: Fatal NI connect error 12170. version information: www.2cto.com 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 www.2cto.com TNS-00505: Operation timed out nt secondary err code: 110 nt OS err code: 0 Client address: <unknown>
Cause: the tns resolution string is specified. 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. Execute the environment variable in apache and restart apache. 2. Reply tnsnames. ora to $ ORACLE_HOME/network/admin.