无法登录到 Oracle Enterprise Manager Express

Cannot login to Oracle Enterprise Manager Express

提问by jkc

I have downloaded Oracle Developer Days Database 12c virtualbox image. I can boot it and access the desktop. When I try to log in to Enterprise Manager (EM) Express using the URL http://127.0.0.1:8888/emI am asked to install Adobe Flash. I install it and get to the login screen.

我已经下载了 Oracle Developer Days Database 12c virtualbox 镜像。我可以启动它并访问桌面。当我尝试使用 URL http://127.0.0.1:8888/em登录 Enterprise Manager (EM) Express时，系统要求我安装 Adob​​e Flash。我安装它并进入登录屏幕。

If I try to login as SYSTEM I get the following error:

如果我尝试以 SYSTEM 身份登录，则会出现以下错误：

But when I try to log in as user SYS I get a strange error: Security token does not match. You must login again..

但是当我尝试以 SYS 用户身份登录时，出现一个奇怪的错误：安全令牌不匹配。你必须重新登录..

To me it looks like the credentials for SYS are OK, but there is something wrong with the user in the database. Is this correct and if so how can I fix it? Or is EM Express just not setup on the image?

对我来说，SYS 的凭据看起来没问题，但是数据库中的用户有问题。这是正确的，如果是，我该如何解决？或者 EM Express 只是没有在图像上设置？

回答by jkc

This document from Oracles Metalink solves it (https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=185690872522025&id=1968763.1&_afrWindowMode=0&_adf.ctrl-state=16vhefh1mo_9). The solution contains 3 steps.

Oracles Metalink 的这份文档解决了这个问题（https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=185690872522025&id=1968763.1&_afrWindowMode=0&_adf.ctrl-state=16vhefh1mo_9）。该解决方案包含 3 个步骤。

1. Make sure that XDB_WALLET is recreated succesfully.
2. Make sure XDB is installed succesfully and the appropriate roles, EM_EXPRESS_BASIC/ALL is applied.
3. Use IE 11.0.9600.16476 with compatibility view.

1. 确保成功重新创建 XDB_WALLET。
2. 确保 XDB 已成功安装并应用了适当的角色 EM_EXPRESS_BASIC/ALL。
3. 使用具有兼容性视图的 IE 11.0.9600.16476。

Mark Stewards answer covers step 2.

Mark Stewards 的回答涵盖了第 2 步。

Actually the first 2 step are not necessary. It looks like they have already been applied to the image. All you have to do is use a different browser. Opera, Chrome and IE all works but Firefox doesn't.

其实前两步不是必须的。看起来它们已经应用于图像。您所要做的就是使用不同的浏览器。Opera、Chrome 和 IE 都可以运行，但 Firefox 不行。

But why Oracle installs a browser that doesn't work with EM Express and why Adobe Flash is not installed when it's required is very strange.

但是为什么甲骨文安装了一个不能和EM Express一起使用的浏览器，为什么在需要的时候没有安装Adobe Flash就很奇怪了。

But thanks for the answer it works for me now from a remote browser but not from the image installed browser.

但是感谢您的回答，它现在从远程浏览器而不是从图像安装的浏览器对我有用。

回答by Mark Stewart

Set up a personal user ID, grant DBA to it, and try granting EM_EXPRESS_ALL role to your user ID.

设置个人用户 ID，将 DBA 授予它，然后尝试将 EM_EXPRESS_ALL 角色授予您的用户 ID。

回答by plumsky

Following solution worked for me:

以下解决方案对我有用：

After making sure that a desired account has EM_EXPRESS_ALLgranted I just accessed Enterprise Managerusing New Private Window in Firefox.

在确保已EM_EXPRESS_ALL授予所需帐户后，我刚刚Enterprise Manager使用 Firefox 中的新私人窗口访问。

回答by James Jithin

I faced this because of the cookie data stored by Adobe Flash. Browsing on Private mode or Incognito did not help. Here are the steps to remove the stored data and start using EM on Chrome:

由于 Adob​​e Flash 存储的 cookie 数据，我遇到了这个问题。浏览私人模式或隐身模式没有帮助。以下是删除存储数据并开始在 Chrome 上使用 EM 的步骤：

1. Go to Settings>Advanced>Content Settings>Cookies
2. Coose See all cookies and site data
3. In the cookies search box, key in the hostname used to access EM. I run EM on my localhost and hence filtered by localhost: You can see Flash data being listed
4. Click on the item to expand and delete the item related to EM:

1. 前往Settings> Advanced> Content Settings>Cookies
2. 库斯 See all cookies and site data
3. 在 cookie 搜索框中，键入用于访问 EM 的主机名。我在我的本地主机上运行 EM，因此被本地主机过滤： 你可以看到列出的 Flash 数据
4. 点击item展开删除EM相关的item：

回答by techxmex

Same error still exists in 2019 on EM with Chrome Version 76.0.3809.87. Solution is to add EM URL to the "Allow" section in the Cookies section.

同样的错误在 2019 年的 EM 上仍然存在，Chrome 版本为 76.0.3809.87。解决方案是将 EM URL 添加到 Cookies 部分的“允许”部分。

回答by JaccoC

In Microsoft Edge, no problem accessing Oracle 12c EM In Microsoft IE 11, no problem accessing Oracle 12c EM In Firefox : Security Token does not match

在 Microsoft Edge 中，访问 Oracle 12c EM 没有问题 在 Microsoft IE 11 中，访问 Oracle 12c EM 没有问题 在 Firefox 中：安全令牌不匹配

Found a solution for Firefox on Is there a way to make Firefox ignore invalid ssl-certificates?

在 Firefox 上找到了解决方案有没有办法让 Firefox 忽略无效的 ssl 证书？

Go to Tools > Options > Advanced "Tab"(?) > Encryption Tab

转到工具 > 选项 > 高级“选项卡”(?) > 加密选项卡

Click the "Validation" button, and uncheck the checkbox for checking validity

单击“验证”按钮，取消选中检查有效性的复选框

Be advised though that this is pretty unsecure as it leaves you wide open to accept any invalid certificate. I'd only do this if using the browser on an Intranet where the validity of the cert isn't a concern to you, or you aren't concerned in general.

不过请注意，这是非常不安全的，因为它让您敞开心扉接受任何无效的证书。如果在您不关心证书有效性的内联网上使用浏览器，或者您一般不关心，我只会这样做。