To vypadá na chybu mezi listenerem a databází. Určitě máte SID m24? SID
nemusí být totožný se SERVICE_NAME. Thin driver se vůbec nebaví s
tnsnames.ora na lokálním klientu.
Cituji z dokumentace, ale to jste asi zkoumal:
12505, 00000, "TNS:listener does not currently know of SID given 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 SID for an instance (usually a database instance) 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 instances are currently known by the listener by executing:
// lsnrctl services <listener name>
// - Check that the SID parameter in the connect descriptor specifies
// an instance known by the listener.
// - Check for an event in the listener.log file.
Dejte vědět co jste vypátral a jak se to vyřešilo.
Malec David napsal(a):
...
Ked skusam pripojenie cez TOAD, vsetko ide OK.
*Moje TNSNames : *
M24.ALIAS=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = testServer)(PORT = 1526))
)
(CONNECT_DATA =
(SERVICE_NAME = m24)
)
)
*Problem je pri pripojeni z aplikacie :*
pouzivam thin driver - ojdbc14.jar , driverName =
"oracle.jdbc.driver.OracleDriver" url =
“jdbc:oracle:thin:userName/[EMAIL PROTECTED]:1526:m24”
chyba je nasledovna, akoby nevedel rozpoznat SID:
/16.10.2006 15:07:24 16.10.2006 15:07:24
org.hibernate.util.JDBCExceptionReporter logExceptions/
/SEVERE: Listener refused the connection with the following error:/
/ORA-12505, TNS:listener does not currently know of SID given in
connect descriptor/
/The Connection descriptor used by the client was:/
/testServer:1526:m24/
Vyvijame pod Java 5.
Ak mate s tym niekto skusenost, poradte prosim.
Dakujem a pekny den
David...
--
Pavel Vedral
----------------------------------------------------------
Nez mi poslete prilohu .doc, .xls nebo .ppt, prectete si,
prosim, WWW stranku uvedenou na poslednim radku signatury:
http://www.gnu.org/philosophy/no-word-attachments.cs.html
