Hi all,
I’m fighting some issues with the database upgrade utility (on a new install) it’s not playing nice with Oracle Instant client.
In depth: I have a new host with 5.0 install, and I’m pointing it to a 3.8.7 database to upgrade it, thus running the upgrade script.
[root@310cdac4fe32 rt5]# echo $ORACLE_HOME
/usr/lib/oracle/19.8/client64/
[root@310cdac4fe32 rt5]# echo $TNS_ADMIN
/usr/lib/oracle/19.8/client64/lib/network/admin/
tnsnames.ora is configured with the SID entry.
Database params are configured in RT_SiteConfig.pm
I cannot get past:
DBI connect('sid=SOMETHING;host=myhost.mydomain;port=1521','RT',...) failed: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)
Now, running the following test script is working successfully:
#!/bin/perl
use strict;
use DBI;
my $machine = 'someserver.example.com';
my $port = 1521;
my $sid = 'BLAH.eample.com';
my $user = 'rt';
my $pass = 'somepass';
my $dbh = DBI->connect("dbi:Oracle://$machine:$port/$sid", $user, $pass) ||
die "Failed to connect: $DBI::errstr\n";
However, as mentioned the RT db utility ./sbin/rt-setup-database
is giving me the SID error.
Is it looking in a particular place for the tnsnames.ora???
Any help would be really appreciated!
Cheers,
Aaron.