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" <konference@java.cz>
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...
>
--
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
__________ Informace od NOD32 1.1804 (20061015) __________
Tato zprava byla proverena antivirovym systemem NOD32.
http://www.nod32.cz
