Vygooglil som nasledovne z jedneho fora, kde mal ten isty problem: I actually just found out that they're running a Oracle RAC environment so my JDBC url needs to look like this for it to work.
url=jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=myhost1.edu)(PORT=1 521)) (ADDRESS=(PROTOCOL=TCP)(HOST=myhost2.edu)(PORT= 1521))(CONNECT_DATA=(SERVICE_NAME=h8sontst))) Ked som predefinoval moju URL na tento format, tak to funguje, nicmene este to preskumam, momentalne som mimo prace, dam vediet ako to dopadlo. Dakujem vsetkym D. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pavel Vedral Sent: Monday, October 16, 2006 4:47 PM To: Java Subject: Re: Oracle 8.1.7 driver pre Java 5 To vypadá na chybu mezi listenerem a databází. Urcite máte SID m24? SID nemusí být totozný se SERVICE_NAME. Thin driver se vubec 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 vedet co jste vypátral a jak se to vyresilo. 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
