ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > Oracle > ORACLE安装好后修改LINUX机器名

ORACLE安装好后修改LINUX机器名

原创 Oracle 作者：warren20 时间：2015-03-08 00:39:34 0 删除 编辑
    由于LINUX上的ORACLE软件和数据已经安装好了，现在要更改机器名，即将原机器名LINUX10 更改为LINUX15，特地将相关的步骤记录下来。

查看服务器版本信息
  1. [oracle@LINUX15 ~]$ lsb_release -a
  2. LSB Version:    :base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch
  3. Distributor ID:    OracleServer
  4. Description:    Oracle Linux Server release 6.5
  5. Release:    6.5
  6. Codename:    n/a

修改hosts文件

  1. -- 将hosts 文件中本地IP 对应的 LINUX10 更改成 LINUX15
  2. [oracle@LINUX10 ~]$ vi /etc/hosts

  4. [oracle@LINUX15 ~]$ more /etc/hosts
    127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
    ::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
    192.168.56.15 LINUX15

修改network

    1. -- 将network 文件中本地IP 对应的 LINUX10 更改成 LINUX15
  2. [root@LINUX10 ~]# vi /etc/sysconfig/network

  4. [oracle@LINUX15 ~]$ more /etc/sysconfig/network
  5. NETWORKING=yes
  6. HOSTNAME=LINUX15

查看监听配置文件及本地服务名文件

如果监听配置文件中是用的主机名，就需要将原主机名更改成新的主机名，如果是配置的IP地址，就不需要调整

  1. [oracle@LINUX15 j2ee]$ cd /u01/app/oracle/product/11.2.3/oracle/network/admin
  2. [oracle@LINUX15 admin]$ ls
  3. listener.ora samples shrept.lst
  4. [oracle@LINUX15 admin]$ more listener.ora
  5. # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.3/oracle/network/admin/listener.ora
  6. # Generated by Oracle configuration tools.

  8. SID_LIST_LISTENER =
  9.   (SID_LIST =
  10.     (SID_DESC =
  11.       (GLOBAL_DBNAME = orcl)
  12.       (ORACLE_HOME = /u01/app/oracle/product/11.2.3/oracle)
  13.       (SID_NAME = orcl)
  14.     )
  15.   )

  17. LISTENER =
  18.   (DESCRIPTION =
  19.     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.×××.×××)(PORT = 1521))
  20.   )

  22. ADR_BASE_LISTENER = /u01/app/oracle
上面监听文件中是配置的IP地址，所以不需要调整，直接启动监听即可

  1. [oracle@LINUX15 ~]$ lsnrctl start

  3. LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 07-MAR-2015 22:32:48

  5. Copyright (c) 1991, 2011, Oracle. All rights reserved.

  7. Starting /u01/app/oracle/product/11.2.3/oracle/bin/tnslsnr: please wait...

  9. TNSLSNR for Linux: Version 11.2.0.3.0 - Production
  10. System parameter file is /u01/app/oracle/product/11.2.3/oracle/network/admin/listener.ora
  11. Log messages written to /u01/app/oracle/diag/tnslsnr/LINUX15/listener/alert/log.xml
  12. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.15)(PORT=1521)))

  14. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.15)(PORT=1521)))
  15. STATUS of the LISTENER
  16. ------------------------
  17. Alias LISTENER
  18. Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
  19. Start Date 07-MAR-2015 22:32:49
  20. Uptime 0 days 0 hr. 0 min. 0 sec
  21. Trace Level off
  22. Security ON: Local OS Authentication
  23. SNMP OFF
  24. Listener Parameter File /u01/app/oracle/product/11.2.3/oracle/network/admin/listener.ora
  25. Listener Log File /u01/app/oracle/diag/tnslsnr/LINUX15/listener/alert/log.xml
  26. Listening Endpoints Summary...
  27.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.15)(PORT=1521)))
  28. Services Summary...
  29. Service "orcl" has 1 instance(s).
  30.   Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
  31. The command completed successfully
由于我没有配置本地服务名，所以没有tnsnames.ora 文件，如果有该文件，也需要进行调整（将原主机名更改成新的主机名，如果是配置的IP地址，就不需要调整）

启动数据库

  1. [oracle@LINUX15 ~]$ sqlplus / as sysdba

  3. SQL*Plus: Release 11.2.0.3.0 Production on Sat Mar 7 22:32:59 2015

  5. Copyright (c) 1982, 2011, Oracle. All rights reserved.

  7. Connected to an idle instance.

  9. SQL> startup
  10. ORACLE instance started.

  12. Total System Global Area 939495424 bytes
  13. Fixed Size         2233960 bytes
  14. Variable Size         629148056 bytes
  15. Database Buffers     301989888 bytes
  16. Redo Buffers         6123520 bytes
  17. Database mounted.
  18. Database opened.

数据库可以正常启动

启动EM报错处理

  1. [oracle@LINUX15 ~]$ emctl status dbconsole
  2. OC4J Configuration issue. /u01/app/oracle/product/11.2.3/oracle/oc4j/j2ee/OC4J_DBConsole_LINUX15_orcl not found.
提示文件找不到，此时要更改两个文件夹的名称
  1. [oracle@LINUX15 ~]$ cd $ORACLE_HOME
  2. [oracle@LINUX15 oracle]$ ll
  3. total 312
  4. ......
  5. ......
  6. drwxr-xr-x. 4 oracle oinstall 12288 Feb 15 22:57 lib
  7. drwxr-----. 3 oracle oinstall 4096 Mar 7 17:04 LINUX10_orcl
  8. drwxr-xr-x. 5 oracle oinstall 4096 Mar 7 22:32 log
  9. ......
  10. ......
将文件夹 LINUX10_orcl（机器名+数据库名） 重命名为 LINUX15_orcl
  1. [oracle@LINUX15 oracle]$ mv LINUX10_orcl LINUX15_orcl
重命名文件夹 OC4J_DBConsole_LINUX10_orcl 为 OC4J_DBConsole_LINUX15_orcl
  1. [oracle@LINUX15 j2ee]$ pwd
  2. /u01/app/oracle/product/11.2.3/oracle/oc4j/j2ee
  3. [oracle@LINUX15 j2ee]$ ll
  4. total 32
  5. -rw-r--r--. 1 oracle oinstall 1000 Feb 15 22:55 deploy_db_wf.ini
  6. drwxr-xr-x. 14 oracle oinstall 4096 Feb 15 22:53 home
  7. drwxr-xr-x. 3 oracle oinstall 4096 Feb 15 22:52 oc4j_applications
  8. drwxr-x---. 6 oracle oinstall 4096 Feb 15 22:52 OC4J_DBConsole
  9. drwxr-x---. 10 oracle oinstall 4096 Feb 16 00:01 OC4J_DBConsole_LINUX10_orcl
  10. drwxr-xr-x. 5 oracle oinstall 4096 Feb 15 22:52 OC4J_Workflow_Component_Container
  11. drwxr-xr-x. 5 oracle oinstall 4096 Feb 15 22:52 OC4J_Workflow_Management_Container
  12. drwxr-xr-x. 2 oracle oinstall 4096 Feb 15 22:53 utilities
  13. [oracle@LINUX15 j2ee]$
  14. [oracle@LINUX15 j2ee]$ mv OC4J_DBConsole_LINUX10_orcl OC4J_DBConsole_LINUX15_orcl

再次启动EM还是报错处理

  1. [oracle@LINUX15 j2ee]$ emctl start dbconsole
  2. Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
  3. Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.
  4. https://LINUX10:1158/em/console/aboutApplication
  5. Starting Oracle Enterprise Manager 11g Database Control ....................................... failed.
  6. ------------------------------------------------------------------
  7. Logs are generated in directory /u01/app/oracle/product/11.2.3/oracle/LINUX15_orcl/sysman/log
查看 /u01/app/oracle/product/11.2.3/oracle/LINUX15_orcl/sysman/log 下面的跟踪日志文件
  1. [oracle@LINUX15 j2ee]$ cd /u01/app/oracle/product/11.2.3/oracle/LINUX15_orcl/sysman/log

  3. [oracle@LINUX15 log]$ tail -10 emdctl.trc
  4. 2015-03-07 23:26:43,128 Thread-3461998336 ERROR http: nmehl_connect_internal: failed to get host info. Could not resolve name
    2015-03-07 23:26:55,169 Thread-686225152 ERROR http: nmehl_connect_internal: failed to get host info. Could not resolve name
    2015-03-07 23:27:01,293 Thread-2620741376 ERROR http: nmehl_connect_internal: failed to get host info. Could not resolve name
    2015-03-07 23:27:01,398 Thread-2324297472 ERROR http: nmehl_connect_internal: failed to get host info. Could not resolve name
    2015-03-07 23:27:01,398 Thread-2324297472 ERROR main: nmectla_agentctl: Error connecting to https://LINUX10:3938/emd/main. Returning status code 1
    2015-03-07 23:27:07,423 Thread-1574823680 ERROR http: nmehl_connect_internal: failed to get host info. Could not resolve name
    2015-03-07 23:27:19,460 Thread-316806912 ERROR http: nmehl_connect_internal: failed to get host info. Could not resolve name
    2015-03-07 23:27:31,495 Thread-1615763200 ERROR http: nmehl_connect_internal: failed to get host info. Could not resolve name
    2015-03-07 23:27:31,559 Thread-3334194944 ERROR http: nmehl_connect_internal: failed to get host info. Could not resolve name
    2015-03-07 23:27:31,559 Thread-3334194944 ERROR main: nmectla_agentctl: Error connecting to https://LINUX10:3938/emd/main. Returning status code 1
看到em还是默认是以前的机器名，看来要重新配置em了
重新配置EM

重新配置EM可以参考网址 http://blog.itpub.net/30150152/viewspace-1452052/

首先，删除EM资料库
  1. [oracle@LINUX15 log]$ emca -repos drop

  3. STARTED EMCA at Mar 7, 2015 11:40:53 PM
  4. EM Configuration Assistant, Version 11.2.0.3.0 Production
  5. Copyright (c) 2003, 2011, Oracle. All rights reserved.

  7. Enter the following information:
  8. Database SID: orcl
  9. Listener port number: 1521
  10. Password for SYS user:
  11. Password for SYSMAN user:

  13. ----------------------------------------------------------------------
  14. WARNING : While repository is dropped the database will be put in quiesce mode.
  15. ----------------------------------------------------------------------
  16. Do you wish to continue? [yes(Y)/no(N)]: Y
  17. Mar 7, 2015 11:41:32 PM oracle.sysman.emcp.EMConfig perform
  18. INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2015_03_07_23_40_52.log.
  19. Mar 7, 2015 11:41:34 PM oracle.sysman.emcp.EMReposConfig invoke
  20. INFO: Dropping the EM repository (this may take a while) ...
  21. Mar 7, 2015 11:46:50 PM oracle.sysman.emcp.EMReposConfig invoke
  22. INFO: Repository successfully dropped
  23. Enterprise Manager configuration completed successfully
  24. FINISHED EMCA at Mar 7, 2015 11:46:50 PM
资料库删除成功。

其次，创建EM资料库
  1. [oracle@LINUX15 log]$ emca -repos create

  3. STARTED EMCA at Mar 8, 2015 12:24:13 AM
  4. EM Configuration Assistant, Version 11.2.0.3.0 Production
  5. Copyright (c) 2003, 2011, Oracle. All rights reserved.

  7. Enter the following information:
  8. Database SID: orcl
  9. Listener port number: 1521
  10. Password for SYS user:
  11. Password for SYSMAN user:

  13. Do you wish to continue? [yes(Y)/no(N)]: Y
  14. Mar 8, 2015 12:24:40 AM oracle.sysman.emcp.EMConfig perform
  15. INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2015_03_08_00_24_11.log.
  16. Mar 8, 2015 12:24:41 AM oracle.sysman.emcp.EMReposConfig createRepository
  17. INFO: Creating the EM repository (this may take a while) ...
  18. Mar 8, 2015 12:41:29 AM oracle.sysman.emcp.EMReposConfig invoke
  19. INFO: Repository successfully created
  20. Enterprise Manager configuration completed successfully
  21. FINISHED EMCA at Mar 8, 2015 12:41:29 AM
最后配置database control
  1. [oracle@LINUX15 ~]$ emca -config dbcontrol db
  3. STARTED EMCA at Mar 8, 2015 8:30:50 PM
  4. EM Configuration Assistant, Version 11.2.0.3.0 Production
  5. Copyright (c) 2003, 2011, Oracle. All rights reserved.
  7. Enter the following information:
  8. Database SID: orcl
  9. Database Control is already configured for the database orcl
  10. You have chosen to configure Database Control for managing the database orcl
  11. This will remove the existing configuration and the default settings and perform a fresh configuration
  12. Do you wish to continue? [yes(Y)/no(N)]: Y
  13. Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.3/oracle ]:
  14. Password for SYS user: le
  15. Password for DBSNMP user: l
  16. Password for SYSMAN user: a
  17. Email address for notifications (optional):
  18. Outgoing Mail (SMTP) server for notifications (optional):
  19. -----------------------------------------------------------------
  21. You have specified the following settings
  23. Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.3/oracle
  25. Local hostname ................ LINUX15
  26. Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.3/oracle
  27. Listener port number ................ 1521
  28. Database SID ................ orcl
  29. Email address for notifications ...............
  30. Outgoing Mail (SMTP) server for notifications ...............
  32. -----------------------------------------------------------------
  33. Do you wish to continue? [yes(Y)/no(N)]: y
  34. Mar 8, 2015 8:32:09 PM oracle.sysman.emcp.EMConfig perform
  35. INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2015_03_08_20_30_49.log.
  36. Mar 8, 2015 8:32:10 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
  37. INFO: Stopping Database Control (this may take a while) ...
  38. Mar 8, 2015 8:32:24 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
  39. INFO: Uploading configuration data to EM repository (this may take a while) ...
  40. Mar 8, 2015 8:33:51 PM oracle.sysman.emcp.EMReposConfig invoke
  41. INFO: Uploaded configuration data successfully
  42. Mar 8, 2015 8:33:56 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
  43. INFO: Securing Database Control (this may take a while) ...
  44. Mar 8, 2015 8:35:04 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
  45. INFO: Database Control secured successfully.
  46. Mar 8, 2015 8:35:04 PM oracle.sysman.emcp.util.DBControlUtil startOMS
  47. INFO: Starting Database Control (this may take a while) ...
  48. Mar 8, 2015 8:36:17 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
  49. INFO: Database Control started successfully
  50. Mar 8, 2015 8:36:17 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
  51. INFO: >>>>>>>>>>> The Database Control URL is https://LINUX15:1158/em <<<<<<<<<<<
  52. Mar 8, 2015 8:36:20 PM oracle.sysman.emcp.EMDBPostConfig invoke
  53. WARNING:
  54. ************************ WARNING ************************
  56. Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted. The encryption key has been placed in the file: /u01/app/oracle/product/11.2.3/oracle/LINUX15_orcl/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will become unusable if this file is lost.
  58. ***********************************************************
  59. Enterprise Manager configuration completed successfully
  60. FINISHED EMCA at Mar 8, 2015 8:36:20 PM
查看EM是否启动
  1. [oracle@LINUX15 ~]$ emctl status dbconsole
  2. Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
  3. Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.
  4. https://LINUX15:1158/em/console/aboutApplication
  5. Oracle Enterprise Manager 11g is running.
  6. ------------------------------------------------------------------
  7. Logs are generated in directory /u01/app/oracle/product/11.2.3/oracle/LINUX15_orcl/sysman/log
现在EM也已经配置好了，可以通过页面访问了。

来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30150152/viewspace-1452077/ ，如需转载，请注明出处，否则将追究法律责任。

0
0
上一篇： ORACLE重建EM
下一篇： dbms_stats.gather_table_stats与analyze table
请登录后发表评论 登录
全部评论
warren20

注册时间：2015-03-03

  • 博文量
    56
  • 访问量
    376704

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593