Search This Blog

Showing posts with label Oracle RAC. Show all posts
Showing posts with label Oracle RAC. Show all posts

Startup of HTTP LISTENER failure (00716)

ORACLE RAC 11g R2, OS: AIX 7.1

$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.
https://dba03.flora.in:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ...................................................................................... failed.
------------------------------------------------------------------
Logs are generated in directory /d01/app/oracle/product/11.2.0/dbhome/dba03_ORCL/sysman/log

check em agent log
--------------------------
$ tail emagent.log
2019-05-27 12:00:06,896 Thread-1 Starting Agent 10.2.0.4.5 from /d01/app/oracle/product/11.2.0/dbhome (00701)
2019-05-27 12:00:06,900 Thread-1 : Startup of HTTP LISTENER failure (00716)

Modify the property of EMD
------------------------------------
$ vi emd.properties
#EMD_URL=https://dba03.flora.in:3938/emd/main
EMD_URL=https://dba03.flora.in:3939/emd/main << change

Now start the dbconsole
---------------------------------
$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.
https://dba03.flora.in:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ...... started.
------------------------------------------------------------------
Logs are generated in directory /d01/app/oracle/product/11.2.0/dbhome/dba03_ORCL/sysman/log

$ emctl upload agent
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
EMD upload completed successfully

$ emctl status agent
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version     : 10.2.0.4.5
OMS Version       : 10.2.0.4.5
Protocol Version  : 10.2.0.4.5
Agent Home        : /d01/app/oracle/product/11.2.0/dbhome/dba03_ORCL
Agent binaries    : /d01/app/oracle/product/11.2.0/dbhome
Agent Process ID  : 17564134
Parent Process ID : 9961922
Agent URL         : https://dba03.flora.in:3939/emd/main
Repository URL    : https://dba03.flora.in:1158/em/upload/
Started at        : 2019-05-27 12:49:19
Started by user   : oracle
Last Reload       : 2019-05-27 13:09:57
Last successful upload                       : 2019-05-27 13:10:55
Total Megabytes of XML files uploaded so far :     2.74
Number of XML files pending upload           :        2
Size of XML files pending upload(MB)         :     0.00
Available disk space on upload filesystem    :    48.36%
Data channel upload directory                : /d01/app/oracle/product/11.2.0/dbhome/dba03_ORCL/sysman/recv
Last successful heartbeat to OMS             : 2019-05-27 13:10:45
---------------------------------------------------------------
Agent is Running and Ready

ORA-03113: end-of-file on communication channel

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Nov 6 12:27:17 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup pfile='/home/oracle/pfile/initORADB.ora';
ORACLE instance started.

Total System Global Area 1.6034E+10 bytes
Fixed Size                  2262200 bytes
Variable Size            1.1241E+10 bytes
Database Buffers         4764729344 bytes
Redo Buffers               26484736 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 16974138
Session ID: 195 Serial number: 3

SQL> shutdown immediate
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Nov 6 12:32:04 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area 1.6034E+10 bytes
Fixed Size                  2262200 bytes
Variable Size            1.1241E+10 bytes
Database Buffers         4764729344 bytes
Redo Buffers               26484736 bytes
SQL> alter database mount;

Database altered.


SQL> alter database clear unarchived logfile group 2;

Database altered.

SQL> alter database clear unarchived logfile group 3;

Database altered.

SQL> alter database clear unarchived logfile group 1;

Database altered.

SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.

SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1.6034E+10 bytes
Fixed Size                  2262200 bytes
Variable Size            1.1241E+10 bytes
Database Buffers         4764729344 bytes
Redo Buffers               26484736 bytes
Database mounted.
Database opened.

Note: To set the log archive destination :

SQL> startup nomount;

SQL> alter system set log_archive_start=TRUE SCOPE=SPFILE;

System altered.

SQL> alter system set log_archive_dest_1=’LOCATION=+FRA/oradb/archivelog’ SCOPE=SPFILE;

System altered.

Launch your Online Business with a $5.99 .COM!