PL.SQL.Developer客户端怎么远程连接oracle服务器,我是在我没有装oracle的情况下,不管(服务器/客户端)都没有装,就只装了个PL.SQL.Developer客户端工具,请问我可以远程连接别人的oracle服务器吗?能连怎么连?
再问下怎么给数据库主键列加序列,并在插入(insert)的时候可以不用写主键字段,它会默认增加?
再问下怎么给数据库主键列加序列,并在插入(insert)的时候可以不用写主键字段,它会默认增加?
需要安装Oracle 客户段,并且在$ORACLE_HOME\NETWORK\AMDIN\TNSNAME.ORA文件中添加相关信息,
ICD_SFCC_PD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.85.8.22)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)红色部分要该成你的相应信息
在重启监听C:>lsnrctl restart
在连接时选中远程的SID就可以了.
Oracle 的自增长需要通过sequence(序列来实现)具体使用参考blog:ORACLE SEQUENCE 介绍http://blog.csdn.net/tianlesoftware/archive/2009/10/29/4745039.aspx
STUDY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 20090922-0938)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = study.Oracle.com)
)
)TELEK =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.118.48.76)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = telek)
)
)INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 20090922-0938)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)KLAMM0 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 20090922-0938)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = KLAMM0)
)
)
颜色为红色的,就是远程连接的配置