java.sql.SQLException: Io exception: Invalid number format for port number

[Former Member]

Hi,

I am having problems while installing Solution Manager 4.0 SR2 on HP-UX 11.23 Itanium 2. The installation stops while Java Load. The DB is up and running.I can connect to it through SQL.The details of the jload.log file are as under:

05.07.07 14:57:03 com.sap.inst.jload.Jload main

SEVERE: couldn't connect to DB

05.07.07 14:57:03 com.sap.inst.jload.Jload logStackTrace

SEVERE: java.sql.SQLException: Io exception: Invalid number format for port number

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)

at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)

at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)

at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.java:215)

at com.sap.sql.connect.OpenSQLDataSourceImpl.createConnection(OpenSQLDataSourceImpl.java:522)

at com.sap.sql.connect.OpenSQLDataSourceImpl.getConnection(OpenSQLDataSourceImpl.java:276)

at com.sap.inst.jload.db.DBConnection.connectViaSecureStore(DBConnection.java:105)

at com.sap.inst.jload.db.DBConnection.connect(DBConnection.java:149)

at com.sap.inst.jload.Jload.main(Jload.java:580)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)

I have checked the tnsnames.ora file and the entries are good and the PORT is set to 1521.

[Former Member]

Hi Siddarth

I'm getting same problem (invalid port). Could you pls pass me the solution of this problem?

Regards

Amar

[Former Member]

Hi Amar,

I just restarted the installation and it worked. You could also try changing the port no to 1521 (oracle default) while installing. The SAP inst defaults the port no to 1527.