今天在aix7.1系统上启动数据库,出现以下错误:
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=103.160.176.61)(PORT=1521))'
解决方案:
1、查看监听配置文件是否正确:
cat $ORACLE_HOME/network/admin/listener.ora
2、查看本机IP地址:
ifconfig -a
3、查看计算机名称:
hostname
4、修改/etc/hosts文件信息
vi /etc/hosts
103.160.176.61 kfap1
5、重新启动数据库
SQL> startup
ORACLE instance started.
Total System Global Area 6263357440 bytes
Fixed Size 2257984 bytes
Variable Size 1644170176 bytes
Database Buffers 4596957184 bytes
Redo Buffers 19972096 bytes
Database mounted.
Database opened.
SQL>