[RADIATOR] Connecting to Oracle DB on non default port

[Hartmaier Alexander]

On 2014-01-06 21:26, rohan.henry @cwjamaica.com wrote:

Thanks Alexander.

I am able to connect to the remote server via the Linux prompt using:

sqlplus user/passwd at server_IP/SID

But can't seem to get it right in Radiator.

Rohan


On Fri, Jan 3, 2014 at 5:24 AM, Hartmaier Alexander <alexander.hartmaier at t-systems.at<mailto:alexander.hartmaier at t-systems.at>> wrote:
On 2014-01-03 00:14, rohan.henry @cwjamaica.com<http://cwjamaica.com> wrote:
Hello,

How is a non default port specified when connecting to a remote Oracle server? Thanks.

DBSource   dbi:oracle:server
DBUsername
DBAuth

Rohan
The Oracle InstantClient configuration is in tnsnames.ora, there you specify things like hostnames, ports and other settings. In Radiator you only use the name you gave the connection in tnsnames.ora.


The DBD::Oracle docs show you the possible ways to connect: https://metacpan.org/pod/DBD::Oracle#connect

Normally you'd specify the database name you've defined in tnsnames.ora:

DBSource dbi:Oracle:DBNAME

Note that Perl is case sensitive, you have to specify Oracle uppercase else DBI looks for a DBD::oracle module.


*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
T-Systems Austria GesmbH Rennweg 97-99, 1030 Wien
Handelsgericht Wien, FN 79340b
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
Notice: This e-mail contains information that is confidential and may be privileged.
If you are not the intended recipient, please notify the sender and then
delete this e-mail immediately.
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.open.com.au/pipermail/radiator/attachments/20140107/32d99db6/attachment.html