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

[metadojo]

forgive im a newbie....

but when i run.,..

/opt/vmware/cloud-director/bin/configure

i get the following...

Connecting to the database: jdbc:oracle:thin:@10.1.104.80:1521/orcl

unable to connect.

then i check inside

invcloud-container-info.log

and i see....

ORA-12514, TNS:listener does not currently know of service requested in connect

2010-09-06 23:53:45,418 | ERROR | main | ConfigAgent | Could not 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

now when i search the web for oracle:thin vcloud

i get examples like so

jdbc:oracle:thin:@vcloud-http.vCloudDirector.com:1521\/vcloud1

looks difference than my connection attempt.

can anyone help me get past this last hurdle.

ive set up the database correctly.

my redhat/vcloud is inside a VM in VMworkstation firewalls off

my oracle DB is inside windows 7

[f10]

On the Windows 7 VM where Oracle is installed check if the following services are started and automatic

OracleDBConsoleorcl

OracleMTSRecoveryService

PracleOraDb11_home1TNSListner

On the Windows 7 VM are you able to connect to the DB using IE

If you found this or other information useful, please consider awarding points for "Correct" or "Helpful".

f10

VCP3,VCP4,HP UX CSA

[metadojo]

ahhh MTS was off.. hmm ill try again later thanks.

[metadojo]

ahhh MTS was off.. hmm ill try again later thanks.

[drenz]

I am having a similar problem, with my vCD installation.

The vCD cell and oracle db are both installed on RHEL.

I am able to access the database using sqldeveloper from another machine, but I get this same error when doing the config for vCD.

Has anyone had this issue with Oracle on Linux?

Thanks in advance!

[Michelle_Laveri]

I've got the same problem.

I've been following the instructions from both the install guide and here - http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=102576...

I am able to connect to the console from the Oracle server (running on Windows) - and ping the oracle server. From the vCD server...

The services all look to have correctly started...

So I'm stumped. It's taken me 2-days to get here. Started out with Oracle Express on Linux. Then Oracle Enteprise on Linux. Then thew in the towel and decided to install Oracle on Windows - I've made more progress doing that. Who'd have thought I would spend two days trying to resolve DB and installation issues... I'm loathed to say, but wish this thing ran on MS SQL, I would know where to begin...

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

[drenz]

I just figured out my issue.

The unique name that I gave the new oracle db was "vcloud10.vcd"

However, the SSID is just vcloud10.

On a hunch I typed in the full unique name "vcloud10.vcd" and it worked!

Hopefully this helps someone out.

[Michelle_Laveri]

I just figured out my issue.

The unique name that I gave the new oracle db was "vcloud10.vcd"

However, the SSID is just vcloud10.

On a hunch I typed in the full unique name "vcloud10.vcd" and it worked!

Hopefully this helps someone out.

Can ask where did you type the full unique name?

Was it to the - Enter the database service name :

How did your SSID become vcloud10?

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

[WillL]

In Oracle, SERVICE_NAME is usually FQDN, SID is its hostname portion for backward compatibility. For example:

SERVICE_NAME = vCDDB.example.com

SID = vCDDB

vCD Cell configuration tool asks for SERVICE_NAME instead of SID, you should be able to find SERVICE_NAME in $ORACLE_HOME/network/admin/tnsnames.ora

Hope this helps,

William