访问em失败，解决方法 - 重庆思庄Oracle、Redhat认证学习论坛

[PZHIE9P~M3A]F8L)VK2D~L.png (37.79 KB, 下载次数: 131)

2022-8-20 20:45 上传

解决办法：
1、ping ip是否正常

ZPUI9CRB7FT6I8DQSA[N5MW.png (31.91 KB, 下载次数: 142)

2022-8-20 20:48 上传

2、查看服务端监听
[grid@sztech bin]$ lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 19-AUG-2022 13:51:15

Copyright (c) 1991, 2021, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sztech)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                   LISTENER
Version                TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date             19-AUG-2022 12:11:40
Uptime                   0 days 1 hr. 39 min. 35 sec
Trace Level             off
Security                ON: Local OS Authentication
SNMP                   OFF
Listener Parameter File /u01/app/19.14/grid/network/admin/listener.ora
Listener Log File       /u01/app/grid/diag/tnslsnr/sztech/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sztech)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=sztech)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/admin/orclcdb/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "+ASM_DAT" has 1 instance(s).
  Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA" has 1 instance(s).
  Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s).
  Instance "orclcdb", status READY, has 1 handler(s) for this service...
Service "e69255bb8c70336ae0537a85a8c0eb42" has 1 instance(s).
  Instance "orclcdb", status READY, has 1 handler(s) for this service...
Service "orclcdb" has 1 instance(s).
  Instance "orclcdb", status READY, has 1 handler(s) for this service...
Service "orclcdbXDB" has 1 instance(s).
  Instance "orclcdb", status READY, has 1 handler(s) for this service...
Service "orclpdb" has 1 instance(s).
  Instance "orclcdb", status READY, has 1 handler(s) for this service...
The command completed successfully
[grid@sztech bin]$

看一下/u01/app/oracle/admin/orclcdb/xdb_wallet
[grid@sztech xdb_wallet]$ ll
total 8
-rw------- 1 oracle asmadmin 3880 Aug 19 12:51 cwallet.sso
-rw------- 1 oracle asmadmin 3835 Aug 19 12:51 ewallet.p12

发现Oracle组里面没有任何权限
[oracle@sztech ~]$ cd /u01/app/oracle/admin/orclcdb/xdb_wallet
[oracle@sztech xdb_wallet]$ ls -lt /u01/app/oracle/admin/orclcdb/xdb_wallet -d
drwxr-x--- 2 oracle asmadmin 44 Aug 19 12:51 /u01/app/oracle/admin/orclcdb/xdb_wallet
[oracle@sztech xdb_wallet]$ ll
total 8
-rw------- 1 oracle asmadmin 3880 Aug 19 12:51 cwallet.sso
-rw------- 1 oracle asmadmin 3835 Aug 19 12:51 ewallet.p12
[oracle@sztech xdb_wallet]$ chmod g+r *
[oracle@sztech xdb_wallet]$ ll
total 8
-rw-r----- 1 oracle asmadmin 3880 Aug 19 12:51 cwallet.sso
-rw-r----- 1 oracle asmadmin 3835 Aug 19 12:51 ewallet.p12

再次访问成功

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)