Wrong SID Picked By RT

Hello All

I m shifting my RT to oracle 10g and everytime I tried to connect I got
following error

[Wed Jul 22 19:39:41 2009] [notice] FastCGI: process manager initialized
(pid 3599)

[Wed Jul 22 19:39:41 2009] [notice] Apache/2.0.53 (Unix) mod_fastcgi/2.4.2
configured – resuming normal operations

[Wed Jul 22 19:39:41 2009] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" started (pid 3601)

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

Connect Failed ORA-12505: TNS:listener does not currently know of SID given
in connect descriptor (DBD ERROR: OCIServerAttach)

at /opt/rt3/lib/RT.pm line 205

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’

[Wed Jul 22 19:39:42 2009] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" started (pid 3607)

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

Connect Failed ORA-12505: TNS:listener does not currently know of SID given
in connect descriptor (DBD ERROR: OCIServerAttach)

at /opt/rt3/lib/RT.pm line 205

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’

[Wed Jul 22 19:39:43 2009] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" started (pid 3609)

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

Connect Failed ORA-12505: TNS:listener does not currently know of SID given
in connect descriptor (DBD ERROR: OCIServerAttach)

at /opt/rt3/lib/RT.pm line 205

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’

[Wed Jul 22 19:39:44 2009] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" started (pid 3611)

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

Connect Failed ORA-12505: TNS:listener does not currently know of SID given
in connect descriptor (DBD ERROR: OCIServerAttach)

at /opt/rt3/lib/RT.pm line 205

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’

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

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
SID = “oracle”. I don’t know from where it is picking that thing. Anyone
has any ideas

Thanks In Advance

Varun Vyas