Deployment to Oracle 10g

OD Version 6.1.0

I'm trying to connect to a oracle 10g DB to deploy some info and i'm using this string in DD:

database name="oracle10g" "s0141241.xxxxx.com:1521 Smiley Frustrated

YSTA" user="xxxxx" password="xxxxxx" vendor="oracle" delete-tracker = "yes"

and i'm getting this error:

DBD: Connecting to the database...
DBD: Try connecting using jdbc Smiley Surprised

racle:thin:@s0141241.****.gov:1521 Smiley Frustrated

YSTA...
DBD: SQL failure
DBD: ERROR:ERROR: Could not connect to [jdbc Smiley Surprised

racle:thin:@s0141241.xxxx.gov:com Smiley Frustrated

YSTA]
DBD:
DBD: *******************************************************
DBD: SQLException occured in JdbcCheckup:MakeConnection()
DBD: Exception Message: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
DBD: Vendor Error Code: 17002
DBD: SQL state: null
DBD: *******************************************************

any ideas? I've never used a Oracle connection before, it's always been SQL server in the past.

Find more posts tagged with

Comments

rshekhawat

I would first check your JDBC connection from oralce client or Toad using same credential
also set TNSORA file as follow
Add the (SERVER=DEDICATED) property to the TNS connect string
stored in the tnsnames.ora file on the client.

RajatChopra

Is this a clustered 10g or a single node 10g. From previous experiences, you cannot use 'DEDICATED' with 10g cause of inherent virtualization on the 10g servers for clustering.

-Rajat

Drep.rptdesign

tejul

Your connection string should be something like this:

//servername Smiley Tongue

ORT/service_name

Hope this help