公司把端口给封了,想要连接oracle数据库除了1521端口后还有其他什么端口? 如题!!!!在线等!!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 如果是你要设置服务器端口,顺着1521设就行了,但如果你是要访问ORACLE服务器,并且服务端口已经设定,你也就只能使用该端口了! 自己爱用什么端口就用什么端口,前提是不与别的程序争用手动更改oracle1521端口的办法,比如改成1523:第一步,找到listener.ora文件,把相关配置节里的1521改成1523,比如:LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1523)) ) ) )第二步,找到tnsnames.ora文件, 把相关的port从1521改成1523,比如:ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1523)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) 完了要重启下监听,在服务里重启,或是cmd下: lsnrctl stop/start 重新配置 listener,调整侦听端口 oracle SQL跟踪,如何跟踪某个用户发出的所有SQL? 求助,关于alert.log 别人建立的试图,我查询不到数据 一个关于sequence的问题,求高手帮忙 高分提问. 列的转换问题 oracle9i的问题,火急!!!! ORACLE解析WHERE子句的顺序问题 简单问题 what is meaning??? Oracle数据库表存储数据的问题 Oracle不同版本数据库导入导出的问题??
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1523))
)
)
)第二步,找到tnsnames.ora文件, 把相关的port从1521改成1523,比如:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1523))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
在服务里重启,
或是cmd下: lsnrctl stop/start