[RADIATOR] Connecting to Oracle DB on non default port
Hartmaier Alexander
alexander.hartmaier at t-systems.at
Tue Jan 7 05:59:20 CST 2014
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
More information about the radiator
mailing list