17,086
社区成员
发帖
与我相关
我的任务
分享修改oracle端口引发的血案
今天为了测试一下如何更改oracle的默认服务端口，将 /home/oracle/product/10g2/db_1/network/admin/下的listener.ora与tnsnames.ora中的1521变成了1525，再重启动了数据库，结果就血案了，在网络中就再也连接不上数据库了，把1525变回1521也不行，杯具了。报12514
...全文
请发表友善的回复…
发表回复
minitoy 2011-04-13
- 打赏
- 举报
minitoy 2011-04-13
- 打赏
- 举报
C:\Documents and Settings\Administrator>sqlplus / as sysdba
SQL*Plus: Release 10.1.0.2.0 - Production on 星期三 4月 13 11:49:09 2011
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> Alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = lenovo-
950e1927)(PORT = 1525))';
System altered.
SQL> alter system register;
System altered.
新开cmd窗口
C:\>sqlplus huawei/huawei@//192.168.1.35:1525/orcl
SQL*Plus: Release 10.1.0.2.0 - Production on 星期三 4月 13 11:52:53 2011
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
SQL*Plus: Release 10.1.0.2.0 - Production on 星期三 4月 13 11:49:09 2011
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> Alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = lenovo-
950e1927)(PORT = 1525))';
System altered.
SQL> alter system register;
System altered.
新开cmd窗口
C:\>sqlplus huawei/huawei@//192.168.1.35:1525/orcl
SQL*Plus: Release 10.1.0.2.0 - Production on 星期三 4月 13 11:52:53 2011
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
minitoy 2011-04-13
- 打赏
- 举报
执行下
Alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = hostname or ip)(PORT = 1525))';
alter system register;
具体分析见
http://hi.baidu.com/timework/blog/item/a25518125c043bdcf7039e8e.html
Alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = hostname or ip)(PORT = 1525))';
alter system register;
具体分析见
http://hi.baidu.com/timework/blog/item/a25518125c043bdcf7039e8e.html
toadzw 2011-04-13
- 打赏
- 举报
将listener.ora中的端口号改回1521之后重启监听就可以
lsnrctl stop
lsnrctl start
----------
这样做不行，我自己也是这样做的，结果挂了
lsnrctl stop
lsnrctl start
----------
这样做不行，我自己也是这样做的，结果挂了
47522341 2011-04-12
- 打赏
- 举报
将listener.ora中的端口号改回1521之后重启监听就可以
lsnrctl stop
lsnrctl start
----------
lsnrctl stop
lsnrctl start
----------
huangdh12 2011-04-12
- 打赏
- 举报
重建tns和监听吧。
Mark_MaoHUA 2011-04-12
- 打赏
- 举报
改端口最好使用Oracle自带的工具软件
秋雨飘落 2011-04-12
- 打赏
- 举报
很简单，重新创建监听呗，，创建监听的时候，端口号随意你设置，
