일단 URL을 인식하지 못한다는 뜻입니다.

문법은 정확한것 같네요.

tnsping을 이용하여 먼저 Check해보심이 좋을듯 싶네요.

다음과 같이 입력을 해보세요.

tnsping 210.106.228.11

그리고 TNS-12541: TNS:no listener이런 Message가 나오면 listener가 안떠있는 상태입니다.

Check방법은 lnsrctl status입니다.

Start시키는 방법은 lsnrctl start하시면 됩니다.

>>김용준 님께서 쓰시길<<

:: 아래 myTestDB01.java를 실행하면 이런 오류 메시지가 생깁니다.

::

:: Krona Error : java.sql.SQLException: 부적합한 Oracle URL이 지정되었습니다: OracleDriver.connect

::

:: -------------------------------------------------------------------------------

:: //myTestDB01.java 파일입니다.

:: import java.io.*;

:: import java.sql.*;

::

:: public class myTestDB01{

:: public static void main(String[] args){

:: String url = "jdbc:oracle:thin@210.106.228.11:1521:ORCL";

:: String query = "Select * from Bonus";

::

:: Connection myCon = null;

::

:: Statement stmt = null;

::

:: try{

:: Class.forName("oracle.jdbc.driver.OracleDriver");

:: }catch(ClassNotFoundException e){

:: System.err.println(e.getMessage());

:: }

::

:: try {

:: myCon = DriverManager.getConnection(url,"scott","tiger");

::

:: stmt = myCon.createStatement();

::

:: ResultSet rs = stmt.executeQuery(query);

::

:: while(rs.next()){

:: String col1 = rs.getString(1);

:: String col2 = rs.getString(2);

:: int col3 = rs.getInt(3);

:: int col4 = rs.getInt(4);

::

:: System.out.println(" " + col1 + ":" + col2 + ":" + col3 + " : " + col4 );

:: System.out.println("gkgkgkgk");

:: }

::

:: rs.close();

:: stmt.close();

:: myCon.close();

:: } catch(Exception e) { System.out.println("Krona Error : " + e);}

:: }

:: }

:: -------------------------------------------------------------------------------------

::

:: //autoexec.bat

:: SET BLASTER=A220 I7 D3 H7 P330 T6

:: SET SBPCI=C:\SBPCI

:: loadhigh C:\WINDOWS\COMMAND\nlsfunc.exe C:\WINDOWS\country.sys

:: SET PATH=C:\HNC\;C:\ORACLE\ORA81\BIN;"C:\PROGRAM;FILES\ORACLE\JRE\1.1.7\BIN";C:\PROGRA~1\ULTRAE~

:: 1;C:\JDK1.3\BIN

:: SET CLASSPATH=.;C:\jdk1.3\lib\tools.jar;C:\jdk1.3\classes;c:\jdk1.3\jre\lib\classes12.zip

:: SET JAVA_HOME=C:\jdk1.3

:: SET TOMCAT_HOME=C:\Apache Group\jakarta-tomcat

::

:: //tnsnames.ora

:: # C:\ORACLE\ORA81\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:c:\Oracle\Ora81\NETWORK\ADMIN\tn

:: snames.ora

:: # Generated by Oracle Net8 Assistant

::

:: ORAKRONA =

:: (DESCRIPTION =

:: (ADDRESS_LIST =

:: (ADDRESS = (PROTOCOL = TCP)(HOST = 210.106.228.11)(PORT = 1521))

:: )

:: (CONNECT_DATA =

:: (SERVICE_NAME = ORCL)

:: )

:: )

::

:: //listener.ora

:: # C:\ORACLE\ORA81\NETWORK\ADMIN\LISTENER.ORA Configuration File:c:\Oracle\Ora81\network\admin\li

:: stener.ora

:: # Generated by Oracle Net8 Assistant

::

:: LISTENER =

:: (DESCRIPTION_LIST =

:: (DESCRIPTION =

:: (ADDRESS_LIST =

:: (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

:: )

:: (ADDRESS_LIST =

:: (ADDRESS = (PROTOCOL = TCP)(HOST = www)(PORT = 1521))

:: )

:: )

:: )

::

:: SID_LIST_LISTENER =

:: (SID_LIST =

:: (SID_DESC =

:: (SID_NAME = PLSExtProc)

:: (ORACLE_HOME = c:\Oracle\Ora81)

:: (PROGRAM = extproc)

:: )

:: )