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