oracle账号是什么在linux上安装完oracle数据库后,如何修改ORACLE_HOSTNAME

预备:先关闭ORACLE数据库及监听,具体方法见:https://blog.csdn.net/zxnlmj/article/details/23096877

1、修改HOSTS文件,添加JTWF到本机IP地址的映射:

[root@JTWF home]# gedit /etc/hosts

最后一行为添加的:

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4::1         localhost localhost.localdomain localhost6 localhost6.localdomain616.54.136.81 Joracle账号TWF

2、修改/etc/sysconfig/network添加如下:

[root@JTWF home]# gedit /etc/sysconfig/networkNETWORKING=yesHOSTNAME=JTWF

3、修改listener.ora

su oraclegedit /home/oracle/product/11.2/db_1/network/admin/listener.ora

修改HOST由HOST=localhost改为HOST=JTWF(随意):

# listener.ora Network Configuration File: /home/oracle/product/11.2/db_1/network/admin/listener.ora# Generated by Oracle configuration tools.LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = TCP)(HOST = JTWF)(PORT = 1521))    )  )ADR_BASE_LISTENER = /home/oracle

4、tnsnames.ora文件不修改也可,我没修改 

gedit /home/oracle/product/11.2/db_1/network/admin/tnsnames.ora 
# tnsnames.ora Network Configuration File: /home/oracle/product/11.2/db_1/network/admin/tnsnames.ora# Generated by Oracle configuration tools.ORCL =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = orcl)    )  )
此条目发表在oracle metalink账号分类目录,贴了标签。将固定链接加入收藏夹。