Tuesday, July 16, 2013

How to configure the HTTPS Port for EM Database Express 12c

Configuring the HTTPS Port for EM Database Express 12c

If you used dbca to configure your database and enabled to configure also the EM Express you can find the EM Express URL provided by DBCA in the latest GUI screen.
If you forget the URL you can use the following SQL statement to find the port for EM Express:
[oracle@vsi08devpom ~]$ sqlplus / as sysdba

SQL*Plus: Release Production on Tue Jul 16 13:31:31 2013

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

Connected to:
Oracle Database 12c Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select dbms_xdb_config.gethttpsport() from dual;

In your web browser enter the EM Express URL in this format to go to the login page: https://hostname:portnumber/em/
When EM Express prompts you for your username and password, log in as a user with DBA privilege (such as SYSTEM or SYS). 

If you want to change the default HTTPS Port for EM Express, that is 5500, you can proceed following these steps (as seen on Oracle documentation):

1. Configure and start the Oracle Net Listener (the listener). You can use lsnrctl to start, stop, and view the status of the listener

2. If the listener is running on a nonstandard port (for example, not 1521), then the init.ora file for the database you want to manage using EM Express must contain a local_listener entry so that the HTTPS port can register with the correct listener. The local_listener entry references a TNSNAMES entry that points to the correct listener. For example:
where inst1 is a TNSNAMES entry defined in tnsnames.ora that points to the listener. For example:
inst1= (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host_name)(PORT=1234))
In this example, 1234 is the nonstandard port on which the listener has been configured to listen.

3. Enable the TCP dispatcher by adding the following entry to the init.ora file for the database you want to manage using EM Express:
In my case, because the database SID is CDB001 I have:
SQL> show parameter dispatchers

NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
dispatchers                 string     (PROTOCOL=TCP) (SERVICE=CDB001
max_dispatchers              integer

4. Restart the database so that the changes made in the init.ora file take effect.

5. Use the PL/SQL procedure DBMS_XDB_CONFIG.SETHTTPSPORT to set the HTTPS port for EM Express. This will update the HTTPS port in the xdbconfig.xml file in the Oracle XML DB Repository. You must connect as SYS / AS SYSDBA to run the procedure. In my case I'm going to change the default port 5500 to 5555:

PL/SQL procedure successfully completed.

6. To access EM Express, enter a URL in the following format in a Web browser: https://hostname:portnumber/em/

Have a look at the following picture:

When prompted for your username and password, log in as a user with DBA privilege (such as SYSTEM).
Simply executes the same procedure to set again the default port number to 5500.

That's all.


Sunil Nair said...


Please can you let me know how to upgrade EM Database Express 12c to Enterprise Manager Cloud control 12c R3.

Thanks & regards

eMarcelCom said...

Hi Mate!
did you try to disable SSL in DB Express and connect via http?


oakleyses said...

oakley sunglasses, prada handbags, oakley sunglasses, longchamp handbags, longchamp handbags, louboutin shoes, louis vuitton handbags, coach factory outlet, tiffany and co, coach purses, louis vuitton outlet, polo ralph lauren outlet, air max, prada outlet, longchamp outlet, oakley sunglasses cheap, ray ban sunglasses, louboutin outlet, michael kors outlet, michael kors outlet, tiffany and co, burberry outlet, christian louboutin shoes, coach outlet store online, jordan shoes, polo ralph lauren outlet, louboutin, kate spade handbags, michael kors outlet, coach outlet, air max, gucci outlet, michael kors outlet, ray ban sunglasses, chanel handbags, michael kors outlet, tory burch outlet, nike free, kate spade outlet, louis vuitton outlet, burberry outlet, louis vuitton outlet stores, louis vuitton, nike shoes, michael kors outlet

oakleyses said...

air max, hollister, true religion outlet, nike blazer, louboutin, ray ban sunglasses, polo ralph lauren, michael kors, true religion jeans, sac guess, sac longchamp, hogan outlet, ralph lauren, vans pas cher, sac louis vuitton, air max pas cher, nike free pas cher, nike free, air max, mulberry, nike roshe run, sac burberry, hollister, vanessa bruno, louis vuitton, lululemon, michael kors pas cher, oakley pas cher, air jordan, ray ban pas cher, new balance pas cher, polo lacoste, converse pas cher, north face, sac louis vuitton, michael kors, sac hermes, nike tn, timberland, louis vuitton uk, longchamp, true religion jeans, nike air max, air force, north face

oakleyses said...

abercrombie and fitch, instyler, ghd, bottega veneta, ugg boots, jimmy choo outlet, soccer shoes, ugg pas cher, herve leger, beats by dre, birkin bag, abercrombie and fitch, north face jackets, soccer jerseys, mont blanc, rolex watches, lululemon outlet, celine handbags, nike roshe run, nike trainers, giuseppe zanotti, hollister, wedding dresses, nike huarache, mcm handbags, vans shoes, chi flat iron, babyliss pro, north face outlet, nike roshe, ugg australia, ugg, marc jacobs, barbour, nfl jerseys, p90x, new balance shoes, asics running shoes, ferragamo shoes, mac cosmetics, insanity workout, uggs outlet, reebok outlet, longchamp, valentino shoes

oakleyses said...

converse, air max, gucci, canada goose, juicy couture outlet, canada goose, wedding dresses, moncler, ralph lauren, lancel, montre homme, moncler, louboutin, oakley, karen millen, vans, coach outlet store online, air max, canada goose jackets, ugg, hollister clothing store, louis vuitton, baseball bats, hollister, rolex watches, juicy couture outlet, iphone 6 cases, canada goose uk, canada goose outlet, ugg, moncler, moncler outlet, timberland boots, hollister, supra shoes, moncler, canada goose, converse shoes, toms shoes, moncler, moncler, canada goose, ugg boots, ray ban, parajumpers, canada goose

Nike Free said...

In 2004, Mark saw Rooney in Branson, Mo., where Chris had booked Mickey and Jan for a gig. Mark says he found Chris "already positioning himself" to get access to Rooney's money, having persuaded Mickey and Jan to move out of their "big and beautiful" home in Sherman Oaks and into a "really michael kors sale crappy rental home" in Westlake Village. Moreover, recalls Mark, "He was on the phone shopping for new Porsches. The guy said he needed to check Chris' credit and paperwork and he goes, 'You've got to check my f—ing credit? I'm a f—ing millionaire! What are you talking about?' And michael kors outlet online sale I'm like, 'Wait a minute, what's going on here?' "
Demi Lovato has a lot to celebrate this week — she debuted the music video for "Confident," released her fifth studio album of the same name, which Billboard described as a "surprisingly compelling listen," and now she's landed a michael kors outlets modeling contract.The "Cool for the Summer" singer has been signed with Wilhelmina Models, the agency announced on Friday. Lovato is in good company at Wilhelmina, joining Nick Jonas, Sydney Sierota, Ellar Coltrane and Empire's Trai Byers as part of the agency's impressive roster."We are so thrilled to represent such 2015 michael kors outlet a sophisticated, confident and talented woman, as Demi," said Alex Vaickus, CEO of Wilhelmina Models, in a release. "She has proved that she is an accomplished singer and actress, and we look forward to seeing her success within the modeling realm."
Anna Wintour is a busy lady, and her michael kors stores time is money — $25,000 to be exact. That's what it will cost for a meet-and-greet with the legendary Vogue editor in chief at the Conde Nast HQ at 1 World Trade Center in New York City. But don't worry, the money is all for a good cause. The michael kors outlet online meet-and-greet as well as host of goodies from the closet (including Vera Wang and Michael Kors swag) is part of a Charity Buzz auction raising money for the United States Tennis Foundation. Bidding closes on Sept. 14, so make your move quick.
When Gigi Hadid isn't working the runways michael kors uk and shutting down Internet trolls, she apparently directs music videos in her spare time (because starring in one just won't cut it). Yes, the 20-year-old face of Guess co-directed boyfriend Joe Jonas' new music video, "Cake by the Ocean," a dance-rock track by Jonas' new band, DNCE.Just as the michael kors outlet online store 49.00 outlet song suggests,

oakleyses said...

jordan shoes, christian louboutin, uggs outlet, michael kors outlet online, uggs on sale, louis vuitton outlet, louis vuitton outlet, louis vuitton, ray ban sunglasses, replica watches, christian louboutin uk, chanel handbags, michael kors outlet online, uggs outlet, longchamp outlet, nike air max, michael kors outlet, burberry handbags, tiffany and co, polo outlet, nike free, nike air max, ugg boots, oakley sunglasses, ray ban sunglasses, michael kors outlet online, oakley sunglasses, christian louboutin outlet, longchamp outlet, prada handbags, gucci handbags, prada outlet, oakley sunglasses wholesale, michael kors outlet, oakley sunglasses, kate spade outlet, christian louboutin shoes, louis vuitton outlet, tory burch outlet, ugg boots, michael kors outlet online, burberry outlet, cheap oakley sunglasses, louis vuitton, ray ban sunglasses, nike outlet, longchamp outlet

oakleyses said...

sac vanessa bruno, new balance, vans pas cher, ray ban uk, nike blazer pas cher, true religion outlet, michael kors outlet, true religion outlet, replica handbags, polo lacoste, oakley pas cher, coach purses, hollister uk, abercrombie and fitch uk, nike free uk, north face uk, louboutin pas cher, polo ralph lauren, hollister pas cher, nike air max uk, michael kors pas cher, nike air max, true religion jeans, timberland pas cher, nike air max uk, coach outlet, air max, michael kors, jordan pas cher, sac hermes, north face, lululemon canada, coach outlet store online, nike roshe, sac longchamp pas cher, nike air force, mulberry uk, hogan outlet, ralph lauren uk, longchamp pas cher, michael kors, converse pas cher, burberry pas cher, nike roshe run uk, true religion outlet, kate spade, nike free run, nike tn, ray ban pas cher, guess pas cher

oakleyses said...

asics running shoes, babyliss, soccer jerseys, hermes belt, reebok outlet, ipad cases, oakley, iphone cases, soccer shoes, iphone 5s cases, nfl jerseys, north face outlet, abercrombie and fitch, ghd hair, vans outlet, iphone 6 cases, hollister, nike roshe run, wedding dresses, mac cosmetics, lululemon, new balance shoes, jimmy choo outlet, instyler, giuseppe zanotti outlet, p90x workout, s6 case, chi flat iron, iphone 6s cases, longchamp uk, baseball bats, mcm handbags, iphone 6 plus cases, bottega veneta, ferragamo shoes, timberland boots, mont blanc pens, insanity workout, nike air max, nike trainers uk, herve leger, nike huaraches, celine handbags, north face outlet, beats by dre, iphone 6s plus cases, valentino shoes, ralph lauren, hollister clothing, louboutin

oakleyses said...

moncler uk, louis vuitton, thomas sabo, wedding dresses, barbour, moncler, gucci, montre pas cher, supra shoes, hollister, barbour uk, nike air max, karen millen uk, pandora uk, moncler, canada goose uk, coach outlet, ugg, juicy couture outlet, swarovski, canada goose, louis vuitton, moncler outlet, louis vuitton, hollister, ugg,ugg australia,ugg italia, canada goose outlet, replica watches, pandora jewelry, ugg,uggs,uggs canada, moncler, canada goose outlet, ugg pas cher, louis vuitton, juicy couture outlet, swarovski crystal, louis vuitton, canada goose, pandora charms, canada goose outlet, links of london, marc jacobs, lancel, converse, converse outlet, toms shoes, doudoune moncler, moncler, pandora jewelry, canada goose jackets, vans, canada goose