请大侠们 指教!指教! 谢谢啦 ~~
解决方案 »
- 有关ORACLE数据库导入DMP文件
- 一条有难度的sql
- oracle以前的数据怎么导入到现在的oracle中
- 请问谁知道utl_all_ind_comps视图(表)STATUS列含义
- oracle内存占用不断增长问题
- 有点难度的排序
- 数据库建表,加字段注意什么问题?大家近来聊聊..........
- 提问:在Linux9下,Oracle9.2.0.1已经装好,应用中用dbca建立一个数据库,完成时,程序被挂起....
- 关于大记录量的数据库设计的问题(急)
- 有关datalink建立的问题。怎么查不能建datalink的原因呢。
- 大家帮我看看这个sql怎么写
- 如何从旧系统向新系统迁移数据(表结构变化很大)
启动SQLPLUS,连接
String driver="oracle.jdbc.OracleDriver";
String url="jdbc:oracle:thin:@localhost:1521:orcl";
String name="shopping";
String pwd="shopping";
public Connection openget()throws Exception{
Class.forName(driver);
return DriverManager.getConnection(url,name,pwd);
}public static void main(String[] args) {
// TODO Auto-generated method stub
shoppingDao dao=new shoppingDao();
try {
dao.openget();
System.out.println("AAAAAAAAAAAA");
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}输出:AAAAAAAAAAAA插上的时候:
java.sql.SQLException: 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:
localhost:1521:orcl
listener
# listener.ora Network Configuration File: D:\app\Administrator\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST=localhost)(PORT = 1521))
)
)tnsnames
# tnsnames.ora Network Configuration File: D:\app\Administrator\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)--把这个去掉试试
(SERVICE_NAME = orcl)
)
)
去掉之后还是不行啊
这个好像是原因:插上网线之后ip变成了自动获取了啊,
肯定不再与配置监听器里面的127.0.0.1匹配了啊,
于是你的连接没有监听器的,
所以用不了,
拔网线后你本机的ip又变回了127.0.0.1所以又行了啊 对于这问题 高手们请帮帮小弟 拜托拜托!!
# listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
tnsnames.ora内容下
# tnsnames.ora Network Configuration File:
D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)