VMware Cloud Community
Michelle_Laveri
Virtuoso
Virtuoso
Jump to solution

error setting up vCloud director TNS:listener does not currently know of service requested in connect

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

Enter the database port :

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... Smiley Sad






Regards

Mike Laverick

RTFM Education

http://www.rtfm-ed.co.uk

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

Regards
Michelle Laverick
@m_laverick
http://www.michellelaverick.com
0 Kudos
1 Solution

Accepted Solutions
WillL
Enthusiast
Enthusiast
Jump to solution

Thank you Mike, glad I was able to help.

View solution in original post

0 Kudos
10 Replies
WillL
Enthusiast
Enthusiast
Jump to solution

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.

Michelle_Laveri
Virtuoso
Virtuoso
Jump to solution

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

http://www.rtfm-ed.co.uk

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

Regards
Michelle Laverick
@m_laverick
http://www.michellelaverick.com
0 Kudos
Michelle_Laveri
Virtuoso
Virtuoso
Jump to solution

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

http://www.rtfm-ed.co.uk

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

Regards
Michelle Laverick
@m_laverick
http://www.michellelaverick.com
0 Kudos
WillL
Enthusiast
Enthusiast
Jump to solution

Thank you Mike, glad I was able to help.

0 Kudos
Michelle_Laveri
Virtuoso
Virtuoso
Jump to solution

Your welcome... Mentioned you on my recent blog post - http://www.rtfm-ed.co.uk/2010/09/22/3122/






Regards

Mike Laverick

RTFM Education

http://www.rtfm-ed.co.uk

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

Regards
Michelle Laverick
@m_laverick
http://www.michellelaverick.com
0 Kudos
WillL
Enthusiast
Enthusiast
Jump to solution

Great, this is fun Smiley Happy

0 Kudos
depping
Leadership
Leadership
Jump to solution

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

0 Kudos
WillL
Enthusiast
Enthusiast
Jump to solution

We encountered an Oracle bug in 10g in our vCD environment, Oracle's fix is to upgrade to 11g. Smiley Wink

0 Kudos
Michelle_Laveri
Virtuoso
Virtuoso
Jump to solution

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

http://www.rtfm-ed.co.uk

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

Regards
Michelle Laverick
@m_laverick
http://www.michellelaverick.com
0 Kudos
WillL
Enthusiast
Enthusiast
Jump to solution

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.

0 Kudos