Enterprise Manager

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Unable to open/connect to Oracle 12c Enterprise Manager Express

cbailissJun 16 2015 — edited Jun 16 2015

I have a just installed a new single instance installation of Oracle 12c (12.1.0.2.0 on Windows x64) with ASM. The database itself is working OK (can be accessed locally and remotely via port 1521), however I am unable to open Enterprise Manager Express. (I have tried different browsers).

"lsnrctl status", "lsnrctl services" output and listener.ora contents are given below.

The listener is up and seems to be configured for Ent. Mgr. Express, plus I can telnet into the relevant ports (tcp:8080 and tcps:5500), however when connecting via a web browser, no data is returned (verified using Fiddler).

Because ASM is being used, there could be two listeners, however all services are actually exposed via the Grid listener, there is no listener configured against the database home.

Any advice would be appreciated as I am not sure where to look next.

Thanks,

Chris

"lsnrctl status" output is as follows:

LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 15-JUN-2015 23:07:45

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cba***.cbailiss.com)(PORT=1521)))

STATUS of the LISTENER

Alias LISTENER

Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production

Start Date 15-JUN-2015 23:02:00

Uptime 0 days 0 hr. 5 min. 47 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File C:\app\grid\cbailiss\product\12.1.0\grid\network\admin\listener.ora

Listener Log File C:\app\grid\cbailiss\diag\tnslsnr\cbaz***\listener\alert\log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cbaz***.cbailiss.com)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.5)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=cbaz***.cbailiss.com)(PORT=5500))(Security=(my_wallet_directory=C:\APP\ORACLE\admin\orcl\xdb_wallet))(Presentation=HTTP)(Session=RAW))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cbaz***.cbailiss.com)(PORT=8080))(Presentation=HTTP)(Session=RAW))

Services Summary...

Service "+ASM" has 1 instance(s).

Instance "+asm", status READY, has 1 handler(s) for this service...

Service "orcl" has 1 instance(s).

Instance "orcl", status READY, has 1 handler(s) for this service...

Service "orclXDB" has 1 instance(s).

Instance "orcl", status READY, has 1 handler(s) for this service...

The command completed successfully

listener.ora contents:

listener.ora Network Configuration File: C:\app\grid\cbailiss\product\12.1.0\grid\network\admin\listener.ora

Generated by Oracle configuration tools.

VALID_NODE_CHECKING_REGISTRATION_LISTENER = SUBNET

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = cbaz***.cbailiss.com)(PORT = 1521))

)

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

"lsnrctl services" output:

LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 16-JUN-2015 00:15:04

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cbaz****.cbailiss.com)(PORT=1521)))

Services Summary...

Service "+ASM" has 1 instance(s).

Instance "+asm", status READY, has 1 handler(s) for this service...

Handler(s):

"DEDICATED" established:0 refused:0 state:ready

LOCAL SERVER

Service "orcl" has 1 instance(s).

Instance "orcl", status READY, has 1 handler(s) for this service...

Handler(s):

"DEDICATED" established:0 refused:0 state:ready

LOCAL SERVER

Service "orclXDB" has 1 instance(s).

Instance "orcl", status READY, has 1 handler(s) for this service...

Handler(s):

"D000" established:1 refused:0 current:0 max:1022 state:ready

DISPATCHER <machine: CBAZ****, pid: 1804>

(ADDRESS=(PROTOCOL=tcp)(HOST=cbaz****.cbailiss.com)(PORT=51202))

The command completed successfully

Andreas Weiden

like this ?

WITH DATA AS (SELECT TO_DATE('10/01/2008 03:00:00', 'DD/MM/YYYY HH:MI:SS') DATEVAL, 0 INDICATOR FROM DUAL
              UNION ALL
              SELECT TO_DATE('10/01/2008 06:00:00', 'DD/MM/YYYY HH:MI:SS') DATEVAL, 1 INDICATOR FROM DUAL
              UNION ALL
              SELECT TO_DATE('10/01/2008 07:00:00', 'DD/MM/YYYY HH:MI:SS') DATEVAL, 0 INDICATOR FROM DUAL
              UNION ALL
              SELECT TO_DATE('10/01/2008 08:00:00', 'DD/MM/YYYY HH:MI:SS') DATEVAL, 1 INDICATOR FROM DUAL
              UNION ALL
              SELECT TO_DATE('11/01/2008 03:00:00', 'DD/MM/YYYY HH:MI:SS') DATEVAL, 1 INDICATOR FROM DUAL
              UNION ALL
              SELECT TO_DATE('11/01/2008 06:00:00', 'DD/MM/YYYY HH:MI:SS') DATEVAL, 1 INDICATOR FROM DUAL
              UNION ALL
              SELECT TO_DATE('11/01/2008 07:00:00', 'DD/MM/YYYY HH:MI:SS') DATEVAL, 0 INDICATOR FROM DUAL
              UNION ALL
              SELECT TO_DATE('11/01/2008 08:00:00', 'DD/MM/YYYY HH:MI:SS') DATEVAL, 1 INDICATOR FROM DUAL
             )
SELECT TO_CHAR(DATEVAL, 'DD.MM.YYYY HH:MI:SS') DATEVAL, INDICATOR_SUM, CASE WHEN INDICATOR_SUM=0 THEN NULL ELSE ROW_NUMBER() OVER (PARTITION BY TRUNC(DATEVAL), INDICATOR_SUM ORDER BY DATEVAL) END RNK
  FROM (
SELECT DATEVAL, 
       DECODE(SUM(1-INDICATOR) OVER (PARTITION BY TRUNC(DATEVAL) ORDER BY DATEVAL), 0, 0, 1) INDICATOR_SUM, 
       INDICATOR
  FROM DATA
);
DATEVAL             INDICATOR_SUM        RNK
------------------- ------------- ----------
10.01.2008 03:00:00             1          1
10.01.2008 06:00:00             1          2
10.01.2008 07:00:00             1          3
10.01.2008 08:00:00             1          4
11.01.2008 03:00:00             0
11.01.2008 06:00:00             0
11.01.2008 07:00:00             1          1
11.01.2008 08:00:00             1          2

Frank Kulash

Hi,

Interesting problem!

The analytic funtion ROW_NUMBER can assign the numbers. The trick is keeping certain rows from being considered in the numbering.
The analytic COUNT (or SUM) function can tell how many rows with indicator=0 have occured so far within each partition. (I assume you want to partition by day, that is, every distinct calendar day will have its own rankings, starting with 1.)
Once we have that COUNT (which I called cnt_prev_0, below), we can use that to make a separate numbering for the rows with cnt_prev_0, and then map all of them to NULL:

WITH	p0	AS
(
	SELECT	dt
	,	COUNT (CASE WHEN indicator = 0 THEN 1 END) OVER
			(	PARTITION BY	TRUNC (dt)
				ORDER BY	dt
			) AS cnt_prev_0
	FROM	table_x
)
,	rn	AS
(
	SELECT	dt
	,	cnt_prev_0
	,	ROW_NUMBER () OVER
			(	PARTITION BY	TRUNC (dt)
				,		SIGN (cnt_prev_0)
				ORDER BY	dt
			) AS row_num
	FROM	p0
)
SELECT	dt
,	CASE
		WHEN	cnt_prev_0	!= 0
		THEN	row_num
	END	rnk
FROM	rn
;

You'll notice I didn't use date or rank as column names. They are reserved words in Orcle, and it's a lot of trouble to have columns with the same names as reserved words.

667579

I hate this query - I'm sure someone will pop with a simpler way as soon as I post this - but it does work:

with t as (
select to_date('10/01/2008 03:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') date_ind, 0 ind from dual UNION ALL
select to_date('10/01/2008 06:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') date_ind, 1 ind from dual UNION ALL
select to_date('10/01/2008 07:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') date_ind, 0 ind from dual UNION ALL
select to_date('10/01/2008 08:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') date_ind, 1 ind from dual UNION ALL
select to_date('11/01/2008 03:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') date_ind, 1 ind from dual UNION ALL
select to_date('11/01/2008 06:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') date_ind, 1 ind from dual UNION ALL
select to_date('11/01/2008 07:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') date_ind, 0 ind from dual UNION ALL
select to_date('11/01/2008 08:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') date_ind, 1 ind from dual)
select to_char(date_ind, 'MM/DD/YYYY HH:MI:SS AM') date_ind,
       ind,
       decode(ranking, NULL, NULL, new_rank) ranking
from (
select date_ind,
       ranking,
       ind,
       row_number() over (partition by to_char(date_ind, 'YYYYMMDD'), decode(ranking, NULL, 0, 1) order by date_ind) new_rank
from (
select date_ind,
       ind,
       case
         when rn > sum_ind then rn
         else NULL
       end ranking
from (
select date_ind, 
       ind,
       row_number() over (partition by to_char(date_ind, 'YYYYMMDD') order by date_ind) rn,
       sum(ind) over (partition by to_char(date_ind, 'YYYYMMDD') order by date_ind) sum_ind
from t)))
order by date_ind;

DATE_IND               IND                    RANKING                                  
---------------------- ---------------------- ---------------------------------------- 
10/01/2008 03:00:00 AM 0                      1                                        
10/01/2008 06:00:00 AM 1                      2                                        
10/01/2008 07:00:00 AM 0                      3                                        
10/01/2008 08:00:00 AM 1                      4                                        
11/01/2008 03:00:00 AM 1                                                               
11/01/2008 06:00:00 AM 1                                                               
11/01/2008 07:00:00 AM 0                      1                                        
11/01/2008 08:00:00 AM 1                      2                                        

8 rows selected

user517674

Thank you all - Andreas, Frank and TK. I am going with the Andreas solution

Aketi Jyuuzou

My similer solution ;-)

WITH DATA AS (
SELECT TO_DATE('10/01/2008 03:00:00', 'DD/MM/YYYY HH:MI:SS') DATEVAL, 0 INDICATOR FROM DUAL
UNION ALL
SELECT TO_DATE('10/01/2008 06:00:00', 'DD/MM/YYYY HH:MI:SS') DATEVAL, 1 INDICATOR FROM DUAL
UNION ALL
SELECT TO_DATE('10/01/2008 07:00:00', 'DD/MM/YYYY HH:MI:SS') DATEVAL, 0 INDICATOR FROM DUAL
UNION ALL
SELECT TO_DATE('10/01/2008 08:00:00', 'DD/MM/YYYY HH:MI:SS') DATEVAL, 1 INDICATOR FROM DUAL
UNION ALL
SELECT TO_DATE('11/01/2008 03:00:00', 'DD/MM/YYYY HH:MI:SS') DATEVAL, 1 INDICATOR FROM DUAL
UNION ALL
SELECT TO_DATE('11/01/2008 06:00:00', 'DD/MM/YYYY HH:MI:SS') DATEVAL, 1 INDICATOR FROM DUAL
UNION ALL
SELECT TO_DATE('11/01/2008 07:00:00', 'DD/MM/YYYY HH:MI:SS') DATEVAL, 0 INDICATOR FROM DUAL
UNION ALL
SELECT TO_DATE('11/01/2008 08:00:00', 'DD/MM/YYYY HH:MI:SS') DATEVAL, 1 INDICATOR FROM DUAL)
select to_char(DATEVAL, 'YYYY/MM/DD HH24') as DATEVAL,INDICATOR,
nvl2(PID,row_number() over(partition by PID order by DATEVAL),null) as rn
from (select DATEVAL,INDICATOR,
      min(decode(INDICATOR,0,DATEVAL)) over(partition by trunc(DATEVAL) order by DATEVAL) as PID
        from DATA)
order by DATEVAL,rn;

DATEVAL        INDICATOR    RN
-------------  ---------  ----
2008/01/10 03          0     1
2008/01/10 06          1     2
2008/01/10 07          0     3
2008/01/10 08          1     4
2008/01/11 03          1  null
2008/01/11 06          1  null
2008/01/11 07          0     1
2008/01/11 08          1     2

1 - 5

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 14 2015

Added on Jun 16 2015

2 comments

1,370 views

Enterprise Manager

Unable to open/connect to Oracle 12c Enterprise Manager Express

Comments

Post Details