Oracle启动出现了ORA-00119，ORA-00130

• 修改/etc/sysconfig/network
• 修改/etc/hosts
• 修改/data/app/oracle/admin/Approval/pfile/init.ora.47201731833
• 修改/data/app/oracle/product/11.2.0/network/admin/listener.ora
• 修改/data/app/oracle/product/11.2.0/network/admin/tnsnames.ora
• 重启Linux系统
• 启动数据库

---

修改/etc/sysconfig/network

//  修改了这一项目必要要重新启动系统vi /etc/sysconfig/network加入  HOSTNAME = oracleDb

修改/etc/hosts

// 具体ip 地址根据你自己的电脑定192.168.206.131 oracleDb 

修改/data/app/oracle/admin/Approval/pfile/init.ora.47201731833

LOCAL_LISTENER="(ADDRESS = (PROTOCOL = TCP)(HOST = oracleDb)(PORT = 1521))"

修改/data/app/oracle/product/11.2.0/network/admin/listener.ora

LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = TCP)(HOST = oracleDb)(PORT = 1521))    )  )ADR_BASE_LISTENER = /data/app/oracle

修改/data/app/oracle/product/11.2.0/network/admin/tnsnames.ora

APPROVAL =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = oracleDb)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = Approval)    )  )

重启Linux系统

reboot

启动数据库

// 以sysdba方式登录数据库sqlplus / as sysdba// 启动数据库startup

最后成功的结果是：