TS Installation using Oracle Service Name instead of SID

Hi,

TS 7.3.1
RHEL
Oracle 11g

During the TS installation where it prompts to enter the DB information for common services, how do I enter the Oracle 11g "Service Name" instead of SID? I have tried using Custom and enter the db connection string then, I am getting "Missing Field Entry:null" error message.

Anyone used Oracle Service Name instead of SID for TeamSite?

Any help is appreciated.

Thank you
John

Find more posts tagged with

Comments

Rick Poulin

The recommended practice is to use SIDs because that's what Iwov understands by default. If you must use service names, make sure to use the Oracle thin driver and use a manual JDBC connection string that looks a bit different. Not sure if the installer will allow you to specify what you need, so you might need to use a 'dummy' database for the install and then search+replace all the jdbc mappings everywhere later and recreate the schmas (hence why you'd be better off with SIDs).

Standard jdbc connection string:
jdbc Smiley Surprised

racle:thin:@myserver Smiley Tongue

ort:sid

Service Name connection string:
jdbc Smiley Surprised

racle:thin:@//myserver Smiley Tongue

ort/ABCD

Adam Stoller

The recommended practice is to use SIDs because that's what Iwov understands by default. If you must use service names, make sure to use the Oracle thin driver and use a manual JDBC connection string that looks a bit different. Not sure if the installer will allow you to specify what you need, so you might need to use a 'dummy' database for the install and then search+replace all the jdbc mappings everywhere later and recreate the schmas (hence why you'd be better off with SIDs).

Standard jdbc connection string:
jdbcracle:thin:@myserverort:sid

Service Name connection string:
jdbcracle:thin:@//myserverort/ABCD

For those who prefer less confusing code - I've disabled the smilies :-)

jasonmcneil

Just to elaborate a bit more on this (as I'm facing a similar issue with 731). I tried using the Oracle RAC option while installing, and after providing all of the field values for the connection I was receiving the same error message as above saying that the field values were null.

Upon closer inspection, they weren't the fields presented on the Oracle RAC input screen (which are the same fields as on the Custom JDBC screen), but the fields presented in all the other database options (e.g. Database Server name, port, database name, etc.) which aren't collected on either of these screens.

I tried using the Oracle Database type which does accept these fields that the installer is trying to validate and "hooray" it works...

So basically the installer is trying to validate fields which is isn't asking for, yay. I had to enter the connection details as a standard Oracle database, and I'll hopefully be able to re-configure afterwards.

jasonmcneil

To follow up, I contacted support and this is a known bug with a patch to the installer's iwpkg file. I applied the patch and it seems to be working happily now