ORA-12505:
    TNS:listener does not currently know of SID 
    given in connect descriptor.

##</code><code>##

use v5.12;
use strict;
use warnings;
use diagnostics;

use DBI;

my $dbh;

# This code produces an ORA-12505 error
$dbh = DBI->connect(
    "DBI:Oracle:sid=JUPITER;host=jupitercluster",
    "user",
    "pass",
);
    
# Alternatively, this code, 
# reproducting the content of tnsnames.ora, works !
$dbh = DBI->connect(
    "DBI:Oracle:",
    "user/pass@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = jupitercluster)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = jupiter)))",
);

__END__

# Content of the entry in tnsnames.ora
JUPITER =
(DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = jupitercluster)(PORT = 1521))
  (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME=jupiter)
  )
)