Nejsem odbornik pres Oracle ale s timhle jsem se uz setkal. Pokud je
listener zkonfigurovan, ze pouziva SID
tak url je ve tvaru :
jdbc:oracle:thin:@ip_addres:port:sid
jestlize je pouzito service name tak je url ve tvaru:
jdbc:oracle:thin:@ip_addres:port/service_name
rozdil je v dvojtecce nebo lomitku za portem listeneru.
Jaroslav Hurdes
Artur Linhart - Java Communication wrote:
Jen doplnim, co vas mozna uz napadlo - zkuste to rozbehnout s OCI driverem
kde muzete TNSNames.ora vyuzivat, a uvidite, jestli budou problemy podobne
nebo jestli to pujde - pokud vam to funguje z TOADu tak by mel oci driver
fungovat urcite a pak bude nejspise problem v tech pojmenovanich, jak se
pise v predchozi odpovedi...
Take by mne zajimalo, jak se to vyresilo, s pouzitim thin driveru nemame az
zas tolik zkusenosti...
Ahoj, Archie.
----- Original Message -----
From: "Pavel Vedral" <[EMAIL PROTECTED]>
To: "Java" <[email protected]>
Sent: Monday, October 16, 2006 4:46 PM
Subject: Re: Oracle 8.1.7 driver pre Java 5
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...
