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)
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
Updated•9 years ago
|
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.
Description
•