I thought I would start my own thread on this...
I trashed my original oracle installation - and started again. But have the same problem...
I installed oracle just accepting all the defaults. So things like the oracle instance name is orcl and so on...
I've also followed to the letter the instructions in the installation guide and here - http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=102576... which are much the same.
Here's what I'm inputting to the vCloud Director configuration setup:
Enter the host (or IP address) for the database: orcl10g.corp.com
Using default value "1521" for port.
Enter the database service name :
Using default value "orcl" for database service name.
Enter the database username: vclouduser
Enter the database password:
Connecting to the database: jdbc:oracle:thin:@orcl10g.corp.com:1521/orcl
And this is what my log file reports...
VMware Cloud Director 1.0.0.285979 Greenwich Mean Time
2010-09-21 21:08:53,891 | DEBUG | main | ConfigAgent | VCLOUD_HOME is /opt/vmware/cloud-director |
2010-09-21 21:08:53,893 | DEBUG | main | ConfigAgent | SQL files will be read from /opt/vmware/cloud-director/db |
2010-09-21 21:08:53,893 | DEBUG | main | ConfigAgent | Using default properties file. |
2010-09-21 21:08:53,893 | DEBUG | main | ConfigAgent | Properties file is /opt/vmware/cloud-director/etc/global.properties |
2010-09-21 21:08:53,893 | INFO | main | ConfigAgent | Reading responses from file: /opt/vmware/cloud-director/etc/responses.properties |
2010-09-21 21:08:53,894 | INFO | main | ConfigAgent | Reading configuration from file: /opt/vmware/cloud-director/etc/global.properties |
2010-09-21 21:08:53,895 | INFO | main | ConfigAgent | System Version=2 |
2010-09-21 21:08:54,880 | DEBUG | main | EncryptionManager | EncryptionManager configured with system key. |
2010-09-21 21:08:54,882 | DEBUG | main | EncryptionManager | EncryptionManager has been loaded successfully. |
2010-09-21 21:10:25,203 | DEBUG | main | PooledConnection | Unable to connect to database. |
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412)
at oracle.jdbc.driver.PhysicalConnection.(Oracle.java:41)
at com.vmware.vcloud.configure.Db.getInstance(Db.java:167)
at com.vmware.vcloud.configure.ConfigAgent.getDb(ConfigAgent.java:1771)
at com.vmware.vcloud.configure.ConfigAgent.configureDatabaseCredentials(ConfigAgent.java:1723)
at com.vmware.vcloud.configure.ConfigAgent.configureDatabase(ConfigAgent.java:1663)
at com.vmware.vcloud.configure.ConfigAgent.start(ConfigAgent.java:425)
at com.vmware.vcloud.configure.ConfigAgent.main(ConfigAgent.java:320)
Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:385)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)
... 20 more
2010-09-21 21:10:25,205 | DEBUG | main | ConnectionPool | Unable to create a new JDBC connection. |
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
I would be really grateful if someone could help me on this. I've been trying to install the product for 3-days and not getting very far...
Regards
Mike Laverick
RTFM Education
Author of the SRM Book:http://www.rtfm-ed.co.uk/2010/03/22/new-administrating-vmware-site-recovery-manager-4-0/
Free PDF or at-cost Hard Copy
Thank you Mike, glad I was able to help.
You may want to double check tnsnames.ora and listener.ora on Oracle side, make sure SERVICE_NAME is orcl which is usually a FQDN like orcl.corp.com; and make sure TCP protocol is in listener.ora, it's there by default.
I managed to resolve the problem about 2hrs ago.
Sods law: As soon as you raise a formum post and contact all your buddies for friends - you stop being stupid, and solve your own issue.
Here was my problem - I was specifiying the wrong name for the DB instance.
The configuration tool defaults to "orcl", but my instance name was orcl.corp.com...
Once I typed in orcl.corp.com instead of orcl then it worked...
That forms part of your advice to check... so thanks for that...
Regards
Mike Laverick
RTFM Education
Author of the SRM Book:http://www.rtfm-ed.co.uk/2010/03/22/new-administrating-vmware-site-recovery-manager-4-0/
Free PDF or at-cost Hard Copy
Thanks for you help on this...
I thought your other post was an addition to this one...
Please leave another comment - and I will mark this as answered and award you points!
Regards
Mike Laverick
RTFM Education
Author of the SRM Book:http://www.rtfm-ed.co.uk/2010/03/22/new-administrating-vmware-site-recovery-manager-4-0/
Free PDF or at-cost Hard Copy
Thank you Mike, glad I was able to help.
Your welcome... Mentioned you on my recent blog post - http://www.rtfm-ed.co.uk/2010/09/22/3122/
Regards
Mike Laverick
RTFM Education
Author of the SRM Book:http://www.rtfm-ed.co.uk/2010/03/22/new-administrating-vmware-site-recovery-manager-4-0/
Free PDF or at-cost Hard Copy
Great, this is fun
this is one of the reasons I started using 10g in my home lab.... it always works 🙂
Duncan
VMware Communities User Moderator | VCDX
-
Now available: <a href="http://www.amazon.com/gp/product/1439263450?ie=UTF8&tag=yellowbricks-20&linkCode=as2&camp=1789&creative=9325&creativeASIN=1439263450">Paper - vSphere 4.0 Quick Start Guide (via amazon.com)</a> | <a href="http://www.lulu.com/product/download/vsphere-40-quick-start-guide/6169778">PDF (via lulu.com)</a>
Blogging: http://www.yellow-bricks.com | Twitter: http://www.twitter.com/DuncanYB
We encountered an Oracle bug in 10g in our vCD environment, Oracle's fix is to upgrade to 11g.
What's the nature of the bug...
I'm on Oracle 11g. Just went for the latest version. As slip on the keyboard I called my host orcl10g.corp.com...
Regards
Mike Laverick
RTFM Education
Author of the SRM Book:http://www.rtfm-ed.co.uk/2010/03/22/new-administrating-vmware-site-recovery-manager-4-0/
Free PDF or at-cost Hard Copy
see my post at http://communities.vmware.com/thread/283892?tstart=15, there was a workaround in 10g but it would turn off some optimizer, so the fix was upgrade to 11g r2.