We upgraded our Oracle database from v81600 to v92060. As part of the upgrade we also changed the listener port from the default 1521. The reporting for this database is done via the Web server that was able to connect to the v8 database using the v8 ODBC. We loaded the Oracle client v9 on the Web server and now it does not matter whether we use the v8 ODBC or the v9 ODBC, but we continue to get the ORA-12154 errors. The tnsnames.ora file on the Web server and the Unix database server both reflect the correct port number. We can make the connection from everywhere except the Web server. Please note that SQLplus on the Web server works fine. Any suggestions?
The ORA-12154 error is telling you that the TNS entry you specified cannot be found. If the wrong port was being used, you would be getting a different error. So you need to make sure that your TNSNAMES.ORA and SQLNET.ORA configuration files are set up correctly on the Web server. These files should be in the $ORACLE_HOME/network/admin directory. Additionally, if you use a DEFAULT_DOMAIN in your SQLNET.ORA, then all TNS entries in TNSNAMES.ORA must have this domain in the name. You also might want to ensure that your TNS_ADMIN environment variable is pointing to the Oracle 9i $ORACLE_HOME/network/admin directory or any other directory that contains your config files.