紧急求救!!!!ORACLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = jw)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcle.jw)
)
)用emc可以连接,但PL/sql 不能连接怎么会事啊???
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = jw)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcle.jw)
)
)用emc可以连接,但PL/sql 不能连接怎么会事啊???
ORACLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = jw)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcle)
)
)
又装了准备连接一个数据库的ORACLE 11
分2部
1、在环境变量里吧10的 放在前面
2、10里面的tnsnames.ora 拷贝到11里面覆盖
一般是这样测试的:
ORACLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = jw)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcle.jw)
)
) 先tnsping ORACLE,看是否能联通
pl/sql 里是test/test@ORACLE(这边是你上面配的)