VMware Cloud Community
chstb22
Contributor
Contributor

VCDB Oracle 10.2.0.4 Vcenter vsphere 4.1 - Storage Management Service => Service initialization failed

Issue resolved

Issue : Vcenter Service Status : Alerte : Storage

Management Service => Service initialization failed

Log sms.log : at com.vmware.vim.sms.ServiceImpl$ServiceInitializer.run(Unknown Source)

Caused by: java.sql.SQLException: [Gestionnaire de pilotes ODBC] Longueur de cha?ne ou de m?moire tampon non valide

at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)

at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)

at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3907)

Resolution : modify tnsnames.ora, convert Port an Host from lowercase to uppercase.

(ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(Host="Vcdb ip adress")(Port = 1521))

Becomes

(ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(HOST = Vcdb ip adress)(PORT = 1521))

0 Kudos
0 Replies