Linux上oracle更换ip后需要做的工作

oracle 11g，ip改变时需要netca重新配置监听：
[oracle@imagehost ~]$ netca

Oracle Net Services 配置:
停止 Oracle Net 监听程序:
正在运行监听程序控制:
/u01/app/oracle/product/11g/db_1/bin/lsnrctl stop LISTENER
监听程序控制完成。
监听程序已成功停止。
正在配置监听程序:LISTENER
监听程序配置完成。
Oracle Net 监听程序启动:
正在运行监听程序控制:
/u01/app/oracle/product/11g/db_1/bin/lsnrctl start LISTENER
监听程序控制完成。
监听程序已成功启动。
成功完成 Oracle Net Services 配置。退出代码是0
然后重启实例：
[oracle@imagehost db_1]$ sqlplus /nolog

sql*Plus: Release 11.2.0.1.0 Production on Mon Nov 24 16:39:02 2014

Copyright (c) 1982, 2009, Oracle. All rights reserved.
sql> conn /as sysdba
Connected to an idle instance.
sql> startup
ORACLE instance started.

Total System Global Area 492707840 bytes
Fixed Size 2214656 bytes
Variable Size 377488640 bytes
Database Buffers 104857600 bytes
Redo Buffers 8146944 bytes
Database mounted.
Database opened.
sql> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@imagehost db_1]$ lsnrctl status

LSNRCTL for linux: Version 11.2.0.1.0 – Production on 24-NOV-2014 16:42:02

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=imagehost)(PORT=1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 – Production
Start Date 24-NOV-2014 16:34:30
Uptime 0 days 0 hr. 7 min. 31 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11g/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/imagehost/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=imagehost)(PORT=1521)))
Services Summary…
Service “orcl” has 1 instance(s).
Instance “orcl”, status READY, has 1 handler(s) for this service…
Service “orclXDB” has 1 instance(s).
Instance “orcl”, status READY, has 1 handler(s) for this service…
The command completed successfully
[oracle@imagehost db_1]$

重启dbconsole：
[oracle@imagehost db_1]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
https://imagehost:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is not running.
——————————————————————
Logs are generated in directory /u01/app/oracle/product/11g/db_1/imagehost_orcl/sysman/log
[oracle@imagehost db_1]$ emctl
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
Oracle Enterprise Manager 10g Database Control commands:
emctl start | stop dbconsole
emctl status | secure | setpasswd dbconsole
emctl config dbconsole -heap_size -max_perm_size
emctl status agent
emctl status agent -secure [-omsurl :/em/*>;]
emctl getversion
emctl reload | upload | clearstate | getversion agent
emctl reload agent dynamicproperties [:]….
emctl config agent
emctl config agent updateTZ
emctl config agent getTZ
emctl resetTZ agent
emctl config agent credentials [[:]]
emctl gensudoprops
emctl clearsudoprops
Blackout Usage :
emctl start blackout [-nodeLevel] [[:]]…. [-d ]
emctl stop blackout
emctl status blackout [[:]]….

The following are valid options for blackouts
defaults to local node target if not specified.
If -nodeLevel is specified after ,the blackout will be applied to all targets and any target list that follows will be ignored.
Duration is specified in [days] hh:mm

emctl getemhome
emctl ilint
Em Key Commands Usage :
emctl config emkey -emkeyfile [-force] [-sysman_pwd ]
emctl config emkey -emkey [-emkeyfile ] [-force] [-sysman_pwd ]
emctl config emkey -repos [-emkeyfile ] [-force] [-sysman_pwd ]
emctl config emkey -remove_from_repos [-sysman_pwd ]
emctl config emkey -copy_to_repos [-sysman_pwd ]
emctl status emkey [-sysman_pwd ]

Secure DBConsole Usage :
emctl secure dbconsole -sysman_pwd [-passwd_file ]
[-host ] [-sid ] [-reset] [-secure_port ]
[-root_dc ] [-root_country ] [-root_state ] [-root_loc ]
[-root_org ] [-root_unit ] [-root_email ]
[-wallet ] [-wallet_pwd ] [-trust_certs_loc ]
emctl secure status dbconsole
Register Targettype Usage :
emctl register oms targettype [-o

] OR
emctl register oms targettype [-o

]

[oracle@imagehost db_1]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
https://imagehost:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ………. started.
——————————————————————
Logs are generated in directory /u01/app/oracle/product/11g/db_1/imagehost_orcl/sysman/log
[oracle@imagehost db_1]$

访问：https://本机ip:1158/em,登录dbconsole。

声明: 除非转自他站（如有侵权，请联系处理）外，本文采用 BY-NC-SA 协议进行授权 | 智乐兔
转载请注明：转自《Linux上oracle更换ip后需要做的工作》
本文地址：https://www.zhiletu.com/archives-286.html
关注公众号：