Question & Answer
Question
Network Adapter cannot establish the connection error when running updatedb script *|* -7E8BB2385AC5BF9285257042007C0161- *|*
Answer
Technote (troubleshooting)
Problem(Abstract)
You get the following error when running the updatedb script for an Oracle database during the installation of a WebSphere Commerce fix pack or during WebSphere Commerce migration.
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java(Compiled Code))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
Cause
This error occurs when running the updatedb script on an Oracle database that is not using the default port (1521).
Resolving the problem
The updatedb script does not provide an option for using a port number other than the default (1521). The default port number is hardcoded inside the script.
To use a different port number:
1. Open the updatedb script in a text editor:
- Windows: WC_installdir\bin\updatedb.bat
- UNIX: WC_installdir/bin/updatedb.sh
2. Locate the following string:
?-jdbcurl jdbc:oracle:thin:@%dbhost%:1521:%database%
3. Replace the default port number (1521) with the port number used by your Oracle database.
4. Save the file and re-execute the script.
Was this topic helpful?
Document Information
Modified date:
12 October 2021
UID
ibm10767275