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!