<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hello All<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I m shifting my RT to oracle 10g and everytime I tried to
connect I got following error<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[Wed Jul 22 19:39:41 2009] [notice] FastCGI: process manager
initialized (pid 3599)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[Wed Jul 22 19:39:41 2009] [notice] Apache/2.0.53 (Unix)
mod_fastcgi/2.4.2 configured -- resuming normal operations<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[Wed Jul 22 19:39:41 2009] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" started (pid 3601)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>DBI connect('host=hostname;sid=oracle;port=1522','rtracker',...)
failed: ORA-12505: TNS:listener does not currently know of SID given in connect
descriptor (DBD ERROR: OCIServerAttach) at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 107<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Connect Failed ORA-12505: TNS:listener does not currently
know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> at /opt/rt3/lib/RT.pm line 205<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>in sub dsnin sub dsn[Wed Jul 22 19:39:42 2009] [warn]
FastCGI: server "/opt/rt3/bin/mason_handler.fcgi" (pid 3601)
terminated by calling exit with status '255'<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[Wed Jul 22 19:39:42 2009] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" started (pid 3607)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>DBI connect('host=hostname;sid=oracle;port=1522','rtracker',...)
failed: ORA-12505: TNS:listener does not currently know of SID given in connect
descriptor (DBD ERROR: OCIServerAttach) at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 107<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Connect Failed ORA-12505: TNS:listener does not currently
know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> at /opt/rt3/lib/RT.pm line 205<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>in sub dsnin sub dsn[Wed Jul 22 19:39:42 2009] [warn]
FastCGI: server "/opt/rt3/bin/mason_handler.fcgi" (pid 3607)
terminated by calling exit with status '255'<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[Wed Jul 22 19:39:43 2009] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" started (pid 3609)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>DBI connect('host=hostname;sid=oracle;port=1522','rtracker',...)
failed: ORA-12505: TNS:listener does not currently know of SID given in connect
descriptor (DBD ERROR: OCIServerAttach) at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 107<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Connect Failed ORA-12505: TNS:listener does not currently
know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> at /opt/rt3/lib/RT.pm line 205<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>in sub dsnin sub dsn[Wed Jul 22 19:39:44 2009] [warn]
FastCGI: server "/opt/rt3/bin/mason_handler.fcgi" (pid 3609)
terminated by calling exit with status '255'<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[Wed Jul 22 19:39:44 2009] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" started (pid 3611)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>DBI connect('host=hostname;sid=oracle;port=1522','rtracker',...)
failed: ORA-12505: TNS:listener does not currently know of SID given in connect
descriptor (DBD ERROR: OCIServerAttach) at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 107<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Connect Failed ORA-12505: TNS:listener does not currently
know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> at /opt/rt3/lib/RT.pm line 205<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>in sub dsnin sub dsn[Wed Jul 22 19:39:45 2009] [warn]
FastCGI: server "/opt/rt3/bin/mason_handler.fcgi" (pid 3611)
terminated by calling exit with status '255'<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[Wed Jul 22 19:39:45 2009] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" has failed to remain running for 30
seconds given 3 attempts, its restart interval has been backed off to 600
seconds<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[Wed Jul 22 19:39:45 2009] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" has failed to remain running for 30
seconds given 3 attempts, its restart interval has been backed off to 600
seconds<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[Wed Jul 22 19:39:45 2009] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" has failed to remain running for 30
seconds given 3 attempts, its restart interval has been backed off to 600
seconds<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[Wed Jul 22 19:39:45 2009] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" has failed to remain running for 30
seconds given 3 attempts, its restart interval has been backed off to 600
seconds<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[Wed Jul 22 19:39:45 2009] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" has failed to remain running for 30
seconds given 3 attempts, its restart interval has been backed off to 600
seconds<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[Wed Jul 22 19:39:45 2009] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" has failed to remain running for 30
seconds given 3 attempts, its restart interval has been backed off to 600 seconds<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[Wed Jul 22 19:39:45 2009] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" has failed to remain running for 30
seconds given 3 attempts, its restart interval has been backed off to 600
seconds<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[Wed Jul 22 19:39:45 2009] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" has failed to remain running for 30
seconds given 3 attempts, its restart interval has been backed off to 600
seconds<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[Wed Jul 22 19:39:45 2009] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" has failed to remain running for 30
seconds given 3 attempts, its restart interval has been backed off to 600
seconds<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[Wed Jul 22 19:39:45 2009] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" has failed to remain running for 30
seconds given 3 attempts, its restart interval has been backed off to 600
seconds<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[Wed Jul 22 19:39:46 2009] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" has failed to remain running for 30
seconds given 3 attempts, its restart interval has been backed off to 600
seconds<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[Wed Jul 22 19:39:46 2009] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" has failed to remain running for 30
seconds given 3 attempts, its restart interval has been backed off to 600
seconds<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[Wed Jul 22 19:39:46 2009] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" has failed to remain running for 30
seconds given 3 attempts, its restart interval has been backed off to 600
seconds<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[Wed Jul 22 19:39:46 2009] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" has failed to remain running for 30
seconds given 3 attempts, its restart interval has been backed off to 600
seconds<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[Wed Jul 22 19:39:46 2009] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" has failed to remain running for 30
seconds given 3 attempts, its restart interval has been backed off to 600
seconds<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[Wed Jul 22 19:39:46 2009] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" has failed to remain running for 30
seconds given 3 attempts, its restart interval has been backed off to 600
seconds<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[Wed Jul 22 19:39:46 2009] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" has failed to remain running for 30
seconds given 3 attempts, its restart interval has been backed off to 600
seconds<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[Wed Jul 22 19:39:46 2009] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" has failed to remain running for 30
seconds given 3 attempts, its restart interval has been backed off to 600
seconds<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[Wed Jul 22 19:39:46 2009] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" has failed to remain running for 30
seconds given 3 attempts, its restart interval has been backed off to 600
seconds<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[Wed Jul 22 19:39:46 2009] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" has failed to remain running for 30
seconds given 3 attempts, its restart interval has been backed off to 600
seconds<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Actully when I looked at the problem with oracle connection.
I find it is picking up wrong SID for connecting oracle 10g. We have given SID
as ‘rtbetadb’ in oracle and also in RT_Siteconfig but some how it
is picking up <b><span style='font-weight:bold'>SID = “oracle”. </span></b>I
don’t know from where it is picking that thing. Anyone has any ideas<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Thanks In Advance<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Varun Vyas<o:p></o:p></span></font></p>
</div>
</body>
</html>