Menu de navegação

[mpunganParticipante]

Pessoal, alguém já se deparou com esse tipo de erro.

[Thu Apr 26 18:04:24 2012] [error] [client 10.40.40.78] PHP Notice: Undefined index: query in /apache/htdocs/controle/bootstrap.php on line 24
[Thu Apr 26 18:04:24 2012] [error] [client 10.40.40.78] PHP Fatal error: Uncaught exception ‘PDOException’ with message ‘SQLSTATE[HY000]: pdo_oci_handle_factory: ORA-12514: TNS:listener does not currently know of service requested in connect descriptorn (/opt/oracle/PDO_OCI-1.0/oci_driver.c:463)’ in /apache/htdocs/comum/Zend/Zend/Db/Adapter/Pdo/Abstract.php:129nStack trace:n#0 /apache/htdocs/comum/Zend/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->__construct(‘oci:dbname=(DES…’, ‘SITE_JMJ’, ‘si_laguna01’, Array)n#1 /apache/htdocs/comum/Zend/Zend/Db/Adapter/Pdo/Abstract.php(386): Zend_Db_Adapter_Pdo_Abstract->_connect()n#2 /apache/htdocs/comum/Zend/Zend/Db/Adapter/Pdo/Oci.php(182): Zend_Db_Adapter_Pdo_Abstract->getServerVersion()n#3 /apache/htdocs/comum/Zend/Zend/Db/Table/Abstract.php(834): Zend_Db_Adapter_Pdo_Oci->describeTable(‘site_configurac…’, ‘SITE_JMJ’)n#4 /apache/htdocs/controle/classes/tabelas/Tabela.php(71): Zend_Db_Table_Abstract->_setupMetadata()n#5 /apache/htdocs/controle/classes/tabelas/Tabela.php(50): Tabela->_setupMetadata()n#6 /apache/htdocs/modulos/tabelas/SiteC in /apache/htdocs/comum/Zend/Zend/Db/Adapter/Pdo/Abstract.php on line 144
[Thu Apr 26 18:07:44 2012] [error] [client 10.40.40.78] PHP Warning: phpinfo(): It is not safe to rely on the system’s timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected ‘America/Sao_Paulo’ for ‘BRT/-3.0/no DST’ instead in /apache/htdocs/phpinfo.php on line 2
[Thu Apr 26 18:09:23 2012] [error] [client 10.40.40.78] PHP Notice: Undefined index: query in /apache/htdocs/controle/bootstrap.php on line 24
[Thu Apr 26 18:09:23 2012] [error] [client 10.40.40.78] PHP Fatal error: Uncaught exception ‘PDOException’ with message ‘SQLSTATE[HY000]: pdo_oci_handle_factory: ORA-12514: TNS:listener does not currently know of service requested in connect descriptorn (/opt/oracle/PDO_OCI-1.0/oci_driver.c:463)’ in /apache/htdocs/comum/Zend/Zend/Db/Adapter/Pdo/Abstract.php:129nStack trace:n#0 /apache/htdocs/comum/Zend/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->__construct(‘oci:dbname=(DES…’, ‘SITE_JMJ’, ‘si_laguna01’, Array)n#1 /apache/htdocs/comum/Zend/Zend/Db/Adapter/Pdo/Abstract.php(386): Zend_Db_Adapter_Pdo_Abstract->_connect()n#2 /apache/htdocs/comum/Zend/Zend/Db/Adapter/Pdo/Oci.php(182): Zend_Db_Adapter_Pdo_Abstract->getServerVersion()n#3 /apache/htdocs/comum/Zend/Zend/Db/Table/Abstract.php(834): Zend_Db_Adapter_Pdo_Oci->describeTable(‘site_configurac…’, ‘SITE_JMJ’)n#4 /apache/htdocs/controle/classes/tabelas/Tabela.php(71): Zend_Db_Table_Abstract->_setupMetadata()n#5 /apache/htdocs/controle/classes/tabelas/Tabela.php(50): Tabela->_setupMetadata()n#6 /apache/htdocs/modulos/tabelas/SiteC in /apache/htdocs/comum/Zend/Zend/Db/Adapter/Pdo/Abstract.php on line 144
[Thu Apr 26 18:28:27 2012] [error] [client 10.40.40.78] PHP Warning: phpinfo(): It is not safe to rely on the system’s timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected ‘America/Sao_Paulo’ for ‘BRT/-3.0/no DST’ instead in /apache/htdocs/phpinfo.php on line 2
[Thu Apr 26 18:28:49 2012] [error] [client 10.40.40.78] PHP Notice: Undefined index: query in /apache/htdocs/controle/bootstrap.php on line 24
[Thu Apr 26 18:28:49 2012] [error] [client 10.40.40.78] PHP Fatal error: Uncaught exception ‘PDOException’ with message ‘SQLSTATE[HY000]: pdo_oci_handle_factory: ORA-12514: TNS:listener does not currently know of service requested in connect descriptorn (/opt/oracle/PDO_OCI-1.0/oci_driver.c:463)’ in /apache/htdocs/comum/Zend/Zend/Db/Adapter/Pdo/Abstract.php:129nStack trace:n#0 /apache/htdocs/comum/Zend/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->__construct(‘oci:dbname=(DES…’, ‘SITE_JMJ’, ‘si_laguna01’, Array)n#1 /apache/htdocs/comum/Zend/Zend/Db/Adapter/Pdo/Abstract.php(386): Zend_Db_Adapter_Pdo_Abstract->_connect()n#2 /apache/htdocs/comum/Zend/Zend/Db/Adapter/Pdo/Oci.php(182): Zend_Db_Adapter_Pdo_Abstract->getServerVersion()n#3 /apache/htdocs/comum/Zend/Zend/Db/Table/Abstract.php(834): Zend_Db_Adapter_Pdo_Oci->describeTable(‘site_configurac…’, ‘SITE_JMJ’)n#4 /apache/htdocs/controle/classes/tabelas/Tabela.php(71): Zend_Db_Table_Abstract->_setupMetadata()n#5 /apache/htdocs/controle/classes/tabelas/Tabela.php(50): Tabela->_setupMetadata()n#6 /apache/htdocs/modulos/tabelas/SiteC in /apache/htdocs/comum/Zend/Zend/Db/Adapter/Pdo/Abstract.php on line 144
[Thu Apr 26 18:29:17 2012] [error] [client 10.40.40.78] PHP Warning: phpinfo(): It is not safe to rely on the system’s timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected ‘America/Sao_Paulo’ for ‘BRT/-3.0/no DST’ instead in /apache/htdocs/phpinfo.php on line 2

Configuração do serviço na maquina cliente:

SRVCO_GERAL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = macae-vip.prod.br)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = torres-vip.prod.br)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = buzios-vip.prod.br)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SRVCO_GERAL)
)
)

[Douglas Paiva de SousaParticipante]

O valor informado para o parâmetro SERVICE_NAME não está correto, pelo visto você está tentando conectar-se a um banco de dados RAC. Se o nome do serviço está correto talvez esteja faltando concatenar a ele o nome do domínio.

PS: Dá próxima vez por favor coloque somente o erro e não todo o seu log, pois fica mais fácil de ler.

Att,

[Autor]

Posts