ORACLE服务器更改主机名后,对数据库的影响.doc

ORACLE服务器更改主机名后,对数据库的影响 Linux下主机名的修改对oracle监听及EM的影响及恢复 一． 修改主机名及恢复监听 修改主机名分为动态和静态，动态是指不需要重启就能更改，但是重启无法保存，静态的意思需要修改配置文件，重启会被保存 1. 动态修改对监听的影响 查看当前的hostname [root@localhost ~]# hostname localhost.localdomain [root@localhost ~]# hostname oracle [root@localhost ~]# su – 查看network的hostname [root@oracle ~]# vi /etc/sysconfig/network NETWORKING=yes NETWORKING_IPV6=no HOSTNAME=localhost.localdomain 查看hosts [root@oracle ~]# vi /etc/hosts # Do not remove the following line, or various programs # that require network functionality will fail. localhost.localdomain localhost ::1 localhost6.localdomain6 localhost6 先去启动一下监听看一下有什么变化 [root@oracle ~]# su - oracle [oracle@oracle ~]$ [oracle@oracle~]$cd/u01/app/oracle/product/10.2.0/dbhome_1/network/admin/ [oracle@oracle admin]$ pwd /u01/app/oracle/product/10.2.0/dbhome_1/network/admin [oracle@oracle admin]$ ls listener.ora samples shrept.lst sqlnet.ora tnsnames.ora [oracle@oracle admin]$ vi listener.ora # listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/dbhome_1/network/admin/listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/app/oracle/product/10.2.0/dbhome_1) (PROGRAM = extproc) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521)) ) ) ~ listener.ora 20L, 525C [oracle@oracle ~]$ lsnrctl start LSNRCTL for Linux: Version .0 - Production on 26-FEB-2011 01:23:16 Copyright (c) 1991, 2005, Oracle. All rights reserved. Starting