unable to login to em express login with user scott

Bitra Hemanth

Hello everyone,

     I am able to login with user SYSTEM in EM Express Login page ( https://localhost:5500/em/login  ) but i am not able to login with scott and hr user in EM Express Login

can anyone give me solution to login with scott and hr login in EM Express login

AndrewSayer

Do SCOTT and HR have the right to connect to EM Express?

When I google "oracle em express login" I find http://www.oracle.com/technetwork/database/manageability/emx-intro-1965965.html  as the top hit.  It says

"

Do I need any database privileges to use EM Express?

In order to use EM Express, a database user needs to have been granted the EM_EXPRESS_BASIC or EM_EXPRESS_ALL role.  The DBA role includes both the EM_EXPRESS_BASIC and the EM_EXPRESS_ALL roles.

EM_EXPRESS_BASIC grants a user read-only privileges, so that the user can view pages but not perform any actions.  EM_EXPRESS_ALL grants a user all privileges required to perform any action in EM Express."

Hmmm?

John Thorton

Bitra Hemanth wrote:Hello everyone, I am able to login with user SYSTEM in EM Express Login page ( https://localhost:5500/em/login ) but i am not able to login with scott and hr user in EM Express Login can anyone give me solution to login with scott and hr login in EM Express login

We don't know what you are doing wrong since you decided to NOT show us exactly what you do & how Oracle responds.

It appears that you are not qualified to use Oracle & should stick with MS Access which is much more user friendly.

EdStevens

Bitra Hemanth wrote:Hello everyone, I am able to login with user SYSTEM in EM Express Login page ( https://localhost:5500/em/login ) but i am not able to login with scott and hr user in EM Express Login can anyone give me solution to login with scott and hr login in EM Express login

"i am not able to login" is totally devoid of any actionable information.  Oracle is very good about emitting very specific error messages, each with its own code.  If you had shared those messages, more help might be available. 

EVERY TIME you post to a forum (any forum) about an error, you should post the entire error message(s) as well as the command that produced them.  This is fundamental to asking for help with a technical problem.  When you take your car to the mechanic, don't you tell him everything you did and what resulted?  Surely you don't just drop it off and say "it doesn't work."

Now, that said, I'm going to bet that when you actually show an error message it will clearly state that either (1) you provided the wrong password, or (2) the account for SCOTT is locked.

AndrewSayer

Do SCOTT and HR have the right to connect to EM Express?

When I google "oracle em express login" I find http://www.oracle.com/technetwork/database/manageability/emx-intro-1965965.html  as the top hit.  It says

"

Do I need any database privileges to use EM Express?

In order to use EM Express, a database user needs to have been granted the EM_EXPRESS_BASIC or EM_EXPRESS_ALL role.  The DBA role includes both the EM_EXPRESS_BASIC and the EM_EXPRESS_ALL roles.

EM_EXPRESS_BASIC grants a user read-only privileges, so that the user can view pages but not perform any actions.  EM_EXPRESS_ALL grants a user all privileges required to perform any action in EM Express."

Hmmm?

Bitra Hemanth

First I am able to login username SYSTEM as shown in the image below

But i am not able to connect with user scott

I can login with user scott through linux terminal

Vlad Visan-Oracle

I guess you connect to a PDB over there and I don't think that EM Express will connect to the PDB but to the CDB.

So user scott may not exist in the root container, check with :

select a.username,b.name as container from cdb_users a join v$containers b on (a.con_id=b.con_id) where a.username in ('SYSTEM','SCOTT');

John Thorton

does user SCOTT have "EM EXPRESS CONNECT" privilege?

Bitra Hemanth

Don't no about it

AndrewSayer

Bitra Hemanth wrote:Don't no about it

I've already provided you a handy link which explains about it.

Bitra Hemanth

Hello everyone,

In EM Express i had observed that there is scott and hr users are not listed in the users screen

as shown below  in the image

Bitra Hemanth

Hello everyone,

Now i got solution to connect with pdborcl of em express

https://blogs.oracle.com/db/entry/troubleshooting_why_em_express_is

Steps i followed is

alter session set container = pdborcl;

and check with these commands

select dbms_xdb_config.gethttpport from dual;

Output :

GETHTTPPORT

-----------

      0

select dbms_xdb_config.gethttpsport() from dual;

Output ;

DBMS_XDB_CONFIG.GETHTTPSPORT()

------------------------------

                 0

By executing two commands i observed http and https port are zero

then i execute below commands to configure port

SQL> exec DBMS_XDB_CONFIG.SETHTTPPORT(8181);

PL/SQL procedure successfully completed.

SQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5511);

PL/SQL procedure successfully completed.

after this i used below commands to verify it is configured correctly

SELECT 'https://'||SYS_CONTEXT('USERENV','SERVER_HOST')||':'||dbms_xdb_config.gethttpsport()||'/em/' from dual;

'HTTPS://'||SYS_CONTEXT('USERENV','SERVER_HOST')||':'||DBMS_XDB_CONFIG.GETHTTPSP

--------------------------------------------------------------------------------

https://localhost:5511/em/

SELECT 'http://'||SYS_CONTEXT('USERENV','SERVER_HOST')||':'||dbms_xdb_config.gethttpport()||'/em/' from dual;

'HTTP://'||SYS_CONTEXT('USERENV','SERVER_HOST')||':'||DBMS_XDB_CONFIG.GETHTTPPOR

--------------------------------------------------------------------------------

http://localhost:8181/em/

Then later i connect to sys as sysdba in pdborcl container

and i have EM EXPRESS BASIC, EM EXPRESS ALL and EM EXPRESS CONNECT previllage to user "SCOTT"

Now i am able to connect em express  with user scott

This i am able login you can close this problem thanq