Closed Bug 1204686 Opened 9 years ago Closed 9 years ago

Unable to connect to Oracle Database using SERVICE_NAME

Categories

(Bugzilla :: Installation & Upgrading, defect)

defect
Not set
normal

Tracking

()

RESOLVED DUPLICATE of bug 620552

People

(Reporter: sid.siddula, Unassigned)

Details

User Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:40.0) Gecko/20100101 Firefox/40.0
Build ID: 20150826023504

Steps to reproduce:

New Install.
Unable to connect to Oracle Database using SERVICE_NAME (Since we are running Oracle 11G RAC), we are supposed to connect using SERVICE_NAME. 

Getting exception:
Can't connect to the database.
Error: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)
  Is your database installed and up and running?
  Do you have the correct username and password selected in localconfig?

checksetup.pl

$ ./checksetup.pl
* This is Bugzilla 5.0 on perl 5.22.0
* Running on Linux 2.6.32-279.el6.x86_64 #1 SMP Thu Jun 21 15:00:18 EDT 2012

Checking perl modules...
Checking for               CGI.pm (v3.51)     ok: found v4.21
Checking for           Digest-SHA (any)       ok: found v5.95
Checking for             TimeDate (v2.23)     ok: found v2.24
Checking for             DateTime (v0.75)     ok: found v1.20
Checking for    DateTime-TimeZone (v1.64)     ok: found v1.93
Checking for                  DBI (v1.614)    ok: found v1.634
Checking for     Template-Toolkit (v2.24)     ok: found v2.26
Checking for         Email-Sender (v1.300011) ok: found v1.300020
Checking for           Email-MIME (v1.904)    ok: found v1.936
Checking for                  URI (v1.55)     ok: found v1.69
Checking for       List-MoreUtils (v0.32)     ok: found v0.413
Checking for    Math-Random-ISAAC (v1.0.1)    ok: found v1.004
Checking for           File-Slurp (v9999.13)  ok: found v9999.19
Checking for              JSON-XS (v2.01)     ok: found v3.01

Checking available perl DBD modules...
Checking for           DBD-SQLite (v1.29)     ok: found v1.48
Checking for            DBD-mysql (v4.001)    ok: found v4.032
Checking for           DBD-Oracle (v1.19)     ok: found v1.74
Checking for               DBD-Pg (v2.7.0)    not found

The following Perl modules are optional:
Checking for                   GD (v1.20)     not found
Checking for                Chart (v2.4.1)    not found
Checking for          Template-GD (any)       not found
Checking for           GDTextUtil (any)       not found
Checking for              GDGraph (any)       not found
Checking for           MIME-tools (v5.406)    ok: found v5.506
Checking for          libwww-perl (any)       ok: found v6.13
Checking for             XML-Twig (any)       not found
Checking for          PatchReader (v0.9.6)    ok: found v0.9.6
Checking for            perl-ldap (any)       ok: found v0.65
Checking for          Authen-SASL (any)       ok: found v2.16
Checking for         Net-SMTP-SSL (v1.01)     not found
Checking for           RadiusPerl (any)       ok: found v0.24
Checking for            SOAP-Lite (v0.712)    ok: found v1.19
Checking for          XMLRPC-Lite (v0.712)    ok: found v0.717
Checking for             JSON-RPC (any)       ok: found v1.06
Checking for           Test-Taint (v1.06)     ok: found v1.06
Checking for          HTML-Parser (v3.67)     ok: found v3.71
Checking for        HTML-Scrubber (any)       ok: found v0.14
Checking for               Encode (v2.21)     ok: found v2.72
Checking for        Encode-Detect (any)       ok: found v1.01
Checking for          Email-Reply (any)       ok: found v1.203
Checking for HTML-FormatText-WithLinks (v0.13)     ok: found v0.15
Checking for          TheSchwartz (v1.07)     ok: found v1.12
Checking for       Daemon-Generic (any)       ok: found v0.84
Checking for             mod_perl (v1.999022) not found
Checking for     Apache-SizeLimit (v0.96)     not found
Checking for        File-MimeInfo (any)       ok: found v0.27
Checking for           IO-stringy (any)       ok: found v2.111
Checking for      Cache-Memcached (any)       ok: found v1.30
Checking for  File-Copy-Recursive (any)       ok: found v0.38
WARNING: We could not check the configuration of Apache. This sometimes
happens when you are not running checksetup.pl as root. To see the
problem we ran into, run: /usr/sbin/apachectl -t -D DUMP_MODULES

***********************************************************************
* OPTIONAL MODULES                                                    *
***********************************************************************
* Certain Perl modules are not required by Bugzilla, but by           *
* installing the latest version you gain access to additional         *
* features.                                                           *
*                                                                     *
* The optional modules you do not have installed are listed below,    *
* with the name of the feature they enable. Below that table are the  *
* commands to install each module.                                    *
***********************************************************************
*      MODULE NAME * ENABLES FEATURE(S)                               *
***********************************************************************
*               GD * Graphical Reports, New Charts, Old Charts        *
*            Chart * New Charts, Old Charts                           *
*      Template-GD * Graphical Reports                                *
*       GDTextUtil * Graphical Reports                                *
*          GDGraph * Graphical Reports                                *
*         XML-Twig * Move Bugs Between Installations, Automatic Update Notifications *
*     Net-SMTP-SSL * SSL Support for SMTP                             *
*         mod_perl * mod_perl                                         *
* Apache-SizeLimit * mod_perl                                         *
***********************************************************************
COMMANDS TO INSTALL OPTIONAL MODULES:

             GD: /u01/bugzilla/perl/bin/perl install-module.pl GD
          Chart: /u01/bugzilla/perl/bin/perl install-module.pl Chart::Lines
    Template-GD: /u01/bugzilla/perl/bin/perl install-module.pl Template::Plugin::GD::Image
     GDTextUtil: /u01/bugzilla/perl/bin/perl install-module.pl GD::Text
        GDGraph: /u01/bugzilla/perl/bin/perl install-module.pl GD::Graph
       XML-Twig: /u01/bugzilla/perl/bin/perl install-module.pl XML::Twig
   Net-SMTP-SSL: /u01/bugzilla/perl/bin/perl install-module.pl Net::SMTP::SSL
       mod_perl: /u01/bugzilla/perl/bin/perl install-module.pl mod_perl2
Apache-SizeLimit: /u01/bugzilla/perl/bin/perl install-module.pl Apache2::SizeLimit


To attempt an automatic install of every required and optional module
with one command, do:

  /u01/bugzilla/perl/bin/perl install-module.pl --all

Reading ./localconfig...

OPTIONAL NOTE: If you want to be able to use the 'difference between two
patches' feature of Bugzilla (which requires the PatchReader Perl module
as well), you should install patchutils from:

    http://cyberelk.net/tim/software/patchutils/

Checking for           DBD-Oracle (v1.19)     ok: found v1.74


Can't connect to the database.
Error: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)
  Is your database installed and up and running?
  Do you have the correct username and password selected in localconfig?


localconfig:
$webservergroup = 'dba';
$db_driver = 'Oracle';
$db_host = 'servername.companyname.com';
$db_name = 'bugs';
$db_user = 'bugs';
$db_pass = 'bugs1';
$db_port = 1521;

tnsnames.ora:
bugzilla =
    (DESCRIPTION =
     (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = servername.compnayname.com)(PORT = 1521))
    )
      (CONNECT_DATA = (SERVICE_NAME = bugs))
  )



Actual results:

Can't connect to the database.
Error: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)
  Is your database installed and up and running?
  Do you have the correct username and password selected in localconfig?


Expected results:

expecting an OK
Severity: normal → critical
Priority: -- → P1
Severity: critical → normal
Status: UNCONFIRMED → RESOLVED
Closed: 9 years ago
Priority: P1 → --
Resolution: --- → DUPLICATE
You need to log in before you can comment on or make changes to this bug.