Ver Mensaje Individual
  #1 (permalink)  
Antiguo 12/05/2009, 03:05
taraitaitai
 
Fecha de Ingreso: mayo-2009
Mensajes: 5
Antigüedad: 14 años, 11 meses
Puntos: 0
Conectar Java Oracle 10g

Tengo un problema al realizar la conexion. Acontinuacion os describo todo lo q hago:



el ERROR obtenido es el siguiete:

java.sql.SQLException: Listener refused the connection with the following error:
Error con la conexi¢n a la base de datos:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
//127.0.0.1:1521/XE

at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:261)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnecti on.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>(Physi calConnection.java:414)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnect ion.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnectio n(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriv er.java:801)

///////////////////////////////////////////////////////////


mi fichero tnsnames.ora es este tal cual:

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Equipo)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)


y el LISTENER.ORA


SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = Equipo)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (XE)