CREATE USER zabbix_mon IDENTIFIED BY <PASSWORD>; #创建一个用户/密码都为zabbix_mon的用户 -- Grant access to the zabbix_mon user. #这里有个细节，官网给的视图授权语句里V后边是没有下划线_的执行报错，需要手动修改一下，以下为修改过的语句 GRANT CONNECT, CREATE SESSION TO zabbix_mon; GRANT SELECT ON DBA_TABLESPACE_USAGE_METRICS TO zabbix_mon; GRANT SELECT ON DBA_TABLESPACES TO zabbix_mon; GRANT SELECT ON DBA_USERS TO zabbix_mon; GRANT SELECT ON SYS.DBA_DATA_FILES TO zabbix_mon; GRANT SELECT ON V_$ACTIVE_SESSION_HISTORY TO zabbix_mon; GRANT SELECT ON V_$ARCHIVE_DEST TO zabbix_mon; GRANT SELECT ON V_$ASM_DISKGROUP TO zabbix_mon; GRANT SELECT ON V_$DATABASE TO zabbix_mon; GRANT SELECT ON V_$DATAFILE TO zabbix_mon; GRANT SELECT ON V_$INSTANCE TO zabbix_mon; GRANT SELECT ON V_$LOG TO zabbix_mon; GRANT SELECT ON V_$OSSTAT TO zabbix_mon; GRANT SELECT ON V_$PGASTAT TO zabbix_mon; GRANT SELECT ON V_$PROCESS TO zabbix_mon; GRANT SELECT ON V_$RECOVERY_FILE_DEST TO zabbix_mon; GRANT SELECT ON V_$RESTORE_POINT TO zabbix_mon; GRANT SELECT ON V_$SESSION TO zabbix_mon; GRANT SELECT ON V_$SGASTAT TO zabbix_mon; GRANT SELECT ON V_$SYSMETRIC TO zabbix_mon; GRANT SELECT ON V_$SYSTEM_PARAMETER TO zabbix_mon;
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 16-NOV-2021 10:42:43
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=db132)(PORT=1521)))
STATUS of the LISTENER
Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 16-NOV-2021 09:34:04 Uptime 0 days 1 hr. 8 min. 40 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/19.3.0/db_1/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/db132/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db132)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=db132)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/admin/orcl/xdb_wallet))(Presentation=HTTP)(Session=RAW)) Services Summary... Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... Service "d083de58225c7d4fe0530100007f0ce6" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... Service "orcl" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... Service "orclXDB" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... Service "orclpdb" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... The command completed successfully
