ORA-12514: TNS:listener does not currently know of service reques

[leorbarbosa 0]

Bom dia,

 

instalei o Oracle 11g XE em minha estação local somente para testes com Php. Via console está tudo certinho, conexão, schema, usuários e senha.

 

Só que quando tento conectar via aplicação surge o erro:

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor in ... on line 22

 

Esse é o tnsnames do server

CURRICULO =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = CURRICULO)
   )
 )

 

Esse é o tnsnames da pasta client

CURRICULO =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = CURRICULO)
   )
 )

 

Esse é listener do server

LISTENER =
 (DESCRIPTION_LIST =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
     (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
   )
 )

DEFAULT_SERVICE_LISTENER = (CURRICULO)

 

O que pode estar errado?

[Motta 645]

Do manual

 

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Cause: The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a service name for a service (usually a database service) that either has not yet dynamically registered with the listener or has not been statically configured for the listener. This may be a temporary condition such as after the listener has started, but before the database instance has registered with the listener.

Action:

- Wait a moment and try to connect a second time.

 

- Check which services are currently known by the listener by executing: lsnrctl services <listener name>

 

- Check that the SERVICE_NAME parameter in the connect descriptor of the net service name used specifies a service known by the listener.

 

- If an easy connect naming connect identifier was used, check that the service name specified is a service known by the listener.

 

- Check for an event in the listener.log file.

[sawicontroladoria 0]

Você apelidou o service de CURRICULO MESMO!!!

O default é XE.

Ficaria:

CURRICULO =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = XE)

)

)

 

No mais já tive problemas com Listener ao alterar o nome da máquina. Nesse caso tem que olhar o arquivo Listener como que está e ajustar o nome.

 

 

Atenciosamente

Felipe Filho

Skype: felipe.calixto

Site: sawicontroladoria.tk

Blog: sawiblog.sytes.net