VMware Cloud Community
amerenciano
Contributor
Contributor

vCD appliance unable to connect to database

We have just upgraded our vmware vcloud environment: vCloud Director 1.5.1, vCenter 5.1, vShield 5.1 and ESXi 5.1 hosts

The issue happened after restarting the vClould Director Appliance when web UI stopped working. 

I went through the vCD log files and found the following error in cloud-container-debug.log:

2013-03-21 11:56:18,920 | ERROR    | Start Level Event Dispatcher | JDBCExceptionReporter          | The Network Adapter could not establish the connection |

2013-03-21 11:56:19,078 | INFO     | Start Level Event Dispatcher | StartupUtils                   | Successfully bound network port: 80 on host address: 172.16.1.152 |

2013-03-21 11:56:19,079 | INFO     | Start Level Event Dispatcher | StartupUtils                   | Successfully bound network port: 443 on host address: 172.16.1.152 |

VMware vCloud Director 5.1.0.810718, Central European Time, 172.16.1.152 (172.16.1.152)

2013-03-21 11:56:20,244 | DEBUG    | Bound HTTP Request Log Files | JettyStarter                   | Found log file: 2013_03_14.request.log (Size = 2,113,827 bytes} |

2013-03-21 11:56:20,244 | DEBUG    | Bound HTTP Request Log Files | JettyStarter                   | Found log file: 2013_03_17.request.log (Size = 0 bytes} |

2013-03-21 11:56:20,244 | DEBUG    | Bound HTTP Request Log Files | JettyStarter                   | Found log file: 2013_03_20.request.log (Size = 4,943,406 bytes} |

2013-03-21 11:56:20,244 | DEBUG    | Bound HTTP Request Log Files | JettyStarter                   | Found log file: 2013_03_18.request.log (Size = 0 bytes} |

2013-03-21 11:56:20,244 | DEBUG    | Bound HTTP Request Log Files | JettyStarter                   | Found log file: 2013_03_16.request.log (Size = 0 bytes} |

2013-03-21 11:56:20,244 | DEBUG    | Bound HTTP Request Log Files | JettyStarter                   | Found log file: 2013_03_15.request.log (Size = 0 bytes} |

2013-03-21 11:56:20,244 | DEBUG    | Bound HTTP Request Log Files | JettyStarter                   | Found log file: 2013_03_19.request.log (Size = 0 bytes} |

2013-03-21 11:56:20,245 | DEBUG    | Bound HTTP Request Log Files | JettyStarter                   | Request log processing complete. Total log file size: 7,057,233 bytes; Deleted 0 request log files |

2013-03-21 11:56:20,285 | DEBUG    | Start Level Event Dispatcher | ConnectionPool                 | Creating interceptor instance of class:class com.vmware.vcloud.common.jdbcpool.interceptor.ConnectionState |

2013-03-21 11:56:20,286 | DEBUG    | Start Level Event Dispatcher | PooledConnection               | Unable to connect to database. |

java.sql.SQLException: The Network Adapter could not establish the connection

It seems that vCD is not able to connect to the embedded Oracle database, but I am able to connect to this same db using sqlplus.

-bash-3.2$ sqlplus "/ as sysdba"

SQL*Plus: Release 11.2.0.2.0 Production on Thu Mar 21 13:04:55 2013

Copyright (coffee) 1982, 2011, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

Also NICs on the vCD VM are up and have the correct IP settings.

I made some reboots but the problem is still present

Please let me know if anyone has faced this issue.

Thanks in advance

Tags (2)
Reply
0 Kudos
1 Reply
IamTHEvilONE
Immortal
Immortal

the vCloud Application connects to the Oracle DB as the user vcloud.

So if you login as sysdba, you'd have to connect as vcloud.  however, you don't have the password since it's random and encrypted.

What you might be able to do as sysdba is see if vcloud account is locked or if the password expired.

As a side note/reminder, the appliance is only for Proof of concept and not production purposes.  there is no migration method to go from the Appliance to a full instance either, so just be aware of that.

Reply
0 Kudos