(首先说明:本次时使用的redhat7操作系统Oracle12c数据库)
一般情况下按照步骤一步一步的来是没用问题,但是我从网上查了很多文章花了半个小时才解决oem登陆不上去的问题。网络上有些博主的文章给得步骤不完善,在此我发一篇比较完善的步骤请指教!
一、很多情况下是因为防火墙没有关闭完全,在Linux操作系统中有两个防火墙(SElinux和firewalld)要么开放防火墙的特定端口要么使用命令关闭防火墙:
systemctl stop firewalld
setenforce 0
二、Linux系统自带的firefox浏览器可能需要安装一个插件才能正常使用oem
插件的位置在(免费下载):https://download.csdn.net/download/qq_61920297/87741481https://download.csdn.net/download/qq_61920297/87741481
步骤如下:
进入root用户后:输入下面命令(#号后面是注释)
这里是你把插件上传到了哪个位置然后再执行如下命令:
解压
tar -zxvf install_flash_player_11_linux.x86_64.tar.gz
复制插件到火狐浏览器插件文件夹
cp libflashplayer.so /usr/lib64/mozilla/plugins
定位到插件目录
cd /usr/lib64/mozilla/plugins
更改插件权限
chmod 755 libflashplayer.so
三、Oracle12c数据库的企业管理器本身就有不用再做其他的步骤
首先数据库能够打(open状态)开显示如下界面:
SQL> startup
ORACLE instance started.
Total System Global Area 763363328 bytes
Fixed Size 8625368 bytes
Variable Size 603980584 bytes
Database Buffers 142606336 bytes
Redo Buffers 8151040 bytes
Database mounted.
Database opened.
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL>
打开监听如下所示:
SQL> !lsnrctl start
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 29-APR-2023 05:53:22
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Starting /u01/app/oracle/product/12.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 12.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/12.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/jtxy/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jtxy)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=jtxy)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 29-APR-2023 05:53:24
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/jtxy/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jtxy)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
SQL>
SQL> show parameter dispatchers #所有对Database Express的访问都通过共享服务器机制实现,这需要有DISPATCHER,它是默认运行的
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dispatchers string (PROTOCOL=TCP) (SERVICE=orclXDB)
开放端口:(必须保证该端口每本占用)
使用命令查看:
查看端口是否被占用 netstat -anp |grep 3306
开放端口
SQL> exec DBMS_XDB_CONFIG.setHTTPPort(5500);
SQL> exec DBMS_XDB_CONFIG.setHTTPSPort(5502);
查看监听:(如果没有显示出来或者之后的步骤出错就重新启动Oracle数据库服务器和监听)
SQL> !lsnrctl status |grep 55
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=jtxy)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/admin/orcl/xdb_wallet))(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jtxy)(PORT=5502))(Presentation=HTTP)(Session=RAW))
四、接下来即可通过5502端口访问:http://192.168.1.20:5502/em (或者使用:https://192.168.1.20:5502/em). 以下是登录页面示范: