1. After AIX is restarted, the Oracle Database Listener cannot be started. 2. For example: gt; lsnrctlstatusConnectingto (DESCRIPTION (ADDRESS (PROTOCOLTCP )(
1. After AIX is restarted, the Oracle Database Listener cannot be started. 2. For example: gt; lsnrctl statusConnecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP )(
1. After AIX is restarted, the Oracle Database Listener cannot be started.
2. For example:
> Lsnrctl status
Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = ip) (PORT = 1521 )))
TNS-12541: TNS: no listener
TNS-12560: TNSrotocol adapter error
TNS-00511: No listener
IBM/aix risc System/6000 Error: 79: Connection refused
> Lsnrctl start
LSNRCTL for IBM/aix risc System/6000: Version10.2.0.1.0-Production on 02-AUG-
09:26:12 2010
Copyright (c) 1991,200 5, Oracle. All rights reserved.
Starting/usr/oracle/oms/102_64/bin/tnslsnr: please wait...
TNSLSNR for IBM/AIX assume System/6000: Version10.2.0.1.0-Production
System parameter file is/usr/oracle/oms/102_64/network/admin/listener. ora
Log messages written to/usr/oracle/oms/102_64/network/log/listener. log
Listening on: (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = ip) (PORT = 1521)
))
Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = ip) (PORT = 1521)
))
3. The database cannot be started.
$ Sqlplus "/as sysdba"
SQL * Plus: Release10.2.0.1.0-Production on Mon Aug 2 09:26:24 2010
Copyright (c) 1982,200 5, Oracle. All rights reserved.
SQL> select * from v $ instance;
Select * from v $ instance
*
ERROR at line 1:
A ORA-01034: ORACLE not available
SQL>
SQL>
SQL>
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: cocould not open parameter file '/usr/oracle/oms/102_64/dbs/initTEST. ora
Cause: the above reason is mainly because the/etc/hosts file was changed. After the database is restarted, the hostname of the AIX system is inconsistent with that in/etc/hosts, resolve the above problem by keeping the system's hostname consistent with the name in/etc/hosts. The listener. ora listener of Oracle has a great relationship with/ect/hosts of AIX.