sqlDeveloper连接oracle

1.解决oracle11g的ORA-12505问题

启动oraclehome92TNSlistener服务，启动oracleserviceXXXX,XXXX就是你的database SID.

<span style="color:#ff0000;">(SID_DESC =  
      (GLOBAL_DBNAME = orcl)  
      (ORACLE_HOME =  D:\Oracle\product\11.2.0\dbhome_1)  
      (SID_NAME = orcl)  
    )  
</span>

http://zhidao.baidu.com/link?url=swIi3kK6BGGL7Fo_eXXdqOa3-CCt90sS8z35TpA1qAXWmJACwHMtfRSJTTVln952zTOfgjGsdlN6TnCLOCRLna

 

http://blog.sina.com.cn/s/blog_8e6f1b330101a0cf.html

2.The Network Adapter could not establish the connection问题

hostname处的ip写错了。我要连接的不是localhost。

http://www.cnblogs.com/adolfmc/archive/2012/10/07/2713711.html

——————————————————————————————————————————

3.在plsql developer中如何给表设一个自增主键?

http://blog.csdn.net/xiao2shiqi/article/details/7359405