자세한 답변 정말로 감사드리고요.. 한가지만 더 질문 드릴께요.
제가 자바에서 접속을 할때
String url = "jdbc:oracle:thin:@localhost:1521:orcl"; //oracle 로 하면 안되요.
Connection con = DriverManager.getConnection(url,"scott","tiger");
이렇게 해야만 접속이 되거든요. 근데 저의 listener.ora 하고 tnsname.ora 의
SID 명을 oracle 로 했거든요. 근데 위의 @localhost:1521:orcl";에서
oracle 로 하면 안되는데.. 상관이 없는건가요.
설치 할때 global database name 을 oracle 로 했는데..
감사합니다.
:: :: 저의 listener.ora 입니다.
:: :: # D:\ORACLE8I\ORA81\NETWORK\ADMIN\LISTENER.ORA Configuration File:d:\Oracle8i\Ora81\network\admin\listener.ora
:: :: # Generated by Oracle Net8 Assistant
:: ::
:: :: LISTENER =
:: :: (DESCRIPTION_LIST =
:: :: (DESCRIPTION =
:: :: (ADDRESS_LIST =
:: :: (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
:: :: )
:: :: )
:: :: )
:: ::
:: :: SID_LIST_LISTENER =
:: :: (SID_LIST =
:: :: (SID_DESC =
:: :: (SID_NAME = oracle)
:: :: (ORACLE_HOME = d:\Oracle8i\Ora81)
:: :: (PROGRAM = extproc)
:: :: )
:: :: )
:: ::
:: :: tnsname.ora 입니다.
:: :: # D:\ORACLE8I\ORA81\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:d:\Oracle8i\Ora81\network\admin\tnsnames.ora
:: :: # Generated by Oracle Net8 Assistant
:: ::
:: :: WANNAEGO.DONGBU.THRUNET.COM =
:: :: (DESCRIPTION =
:: :: (ADDRESS_LIST =
:: :: (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
:: :: )
:: :: (CONNECT_DATA =
:: :: (SID = oracle)
:: :: (PRESENTATION = RO)
:: :: )
:: :: )
:: ::
|