run dbpatch_55.sql catch IO exception

[pjh1029]

Hi,
When I run the SQL: @dbpatch_55.sql after I run . ./gc3env.cmd
I find exception: java.sql.SQLException: Io Exception: The Network Adapter could not establish the connection. Please give me some advice. Thank you very much.
The following update_content.log is
--------------------------------------------------
update_content_otmdb_252007_1546.log
ECHO is off.
ECHO is off.
Parameters:
Properties directory: D:\otm55\glog\config
Connection ID for GLOGOWNER: dbaglogowner
Connection ID for REPORTOWNER: dbareportowner
Version: V55P
ECHO is off.
csv_update_glogowner.cmd
ECHO is off.
Parameters:
Properties directory: D:\otm55\glog\config
Connection ID for GLOGOWNER: dbaglogowner
Version: V55P
ECHO is off.
ECHO is off.
V55P_PARTITION_KEY_FORMULA
Caught exception: java.sql.SQLException: Io Exception: The Network Adapter could not establish the connection
ECHO is off.
V55P_BN_CONTEXT
Caught exception: java.sql.SQLException: Io Exception: The Network Adapter could not establish the connection
ECHO is off.
V55P_BN_TYPE
Caught exception: java.sql.SQLException: Io Exception: The Network Adapter could not establish the connection
.......

regards
Catherine

[chrisplough]

Re: run dbpatch_55.sql catch IO exception

Catherine,

This error indicates that the Java code that the OTM script runs is not able to make a connection with the database server. This code is used to update the OTM DB content from CSV files.

This error could be caused by:

• Incorrect DB parameters entered during the OTM installation, including hostname, port and/or SID. These are located in D:\otm55\glog\config\glog.properties
• The Oracle DB is not running
• A firewall is between the OTM App and DB server, which is blocking the traffic

--Chris