oracle修改hostname

环境：centos6,oracle 11g

之前的监听，默认localhost

1、停止数据库以及监听

##停止监听

su - oracle

lsnrctl stop

##停止数据库

sqlplus / as sysdba

shutdown immediate

2、修改hostname

sysctl kernel.hostname=yforcl1

vi /etc/sysconfig/network

NETWORKING=yes

HOSTNAME=yforcl1

vi /etc/hosts

增加127.0.0.1 yforcl1

3、修改listener.ora文件

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = yforcl1)(PORT = 1521))
    )
  )

4、修改tnsnames.ora文件

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = yforcl1)(PORT = 1521))
 
 
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = yforcl1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )

5、启动监听

lsnrctl start

此时报错The listener supports no services，需要数据库实例注册到listener

登录数据库：

$​​​​​​sqlplus / as sysdba  

startup

SQL>show parameter service_names  显示服务名

SQL>alter system register 强制注册服务

6、再次查看监听