[oracle@prdb19 ~]$ emcli create_named_credential -cred_name="hostv1" -auth_target_type="host" -cred_type="HostCreds" -attributes="HostUserName:oracle;HostPassword:oracle" Credential HOSTV1 created. [oracle@prdb19 ~]$ [oracle@prdb19 ~]$ emcli set_preferred_credential -set_name=HostCredsNormal -target_name=prdb19 -target_type=host -credential_name=hostv1 -credential_owner="sysman" Successfully set preferred credentials for target prdb19:host. [oracle@prdb19 ~]$ emcli execute_hostcmd -cmd="ls -l;" -credential_set_name="HostCredsNormal" -targets="prdb19:host;" ******************************************************************************* * Target: prdb19:host * Execution Status: Succeeded ******************************************************************************* total 152 -rw-r-----. 1 oracle oinstall 22 Jul 18 20:56 ag_current_status.msg -rw-r-----. 1 oracle oinstall 243 Jul 18 20:29 agntstmp.txt -rw-r-----. 1 oracle oinstall 242 Jul 15 15:09 agntstmp.txt.bak drwxr-----. 2 oracle oinstall 6 Apr 20 13:02 attachmentDB drwxr-----. 4 oracle oinstall 35 Apr 20 12:57 backupUpload -rw-r-----. 1 oracle oinstall 0 Jul 18 20:29 blackouts.lck -rw-r-----. 1 oracle oinstall 52 Apr 20 12:57 blackouts.xml drwxr-----. 2 oracle oinstall 252 Jul 18 20:41 collection drwxr-----. 2 oracle oinstall 6 Apr 20 12:57 collection_upgrade drwxr-----. 2 oracle oinstall 6 Apr 20 13:01 dumps -rw-r-----. 1 oracle oinstall 3444 Apr 20 17:46 emagent_storage.config drwxr-----. 2 oracle oinstall 6 Apr 20 13:01 longOpDiag drwxr-----. 2 oracle oinstall 6 Apr 20 13:02 metricCache drwxr-----. 2 oracle oinstall 6 Apr 20 13:02 metricExtLib drwxr-----. 2 oracle oinstall 6 Apr 20 13:02 remote drwxr-----. 15 oracle oinstall 4096 Apr 20 16:42 state -rw-r-----. 1 oracle oinstall 63416 Jul 18 20:29 targets.xml -rw-r-----. 1 oracle oinstall 63416 Jul 15 15:09 targets.xml.bak drwxr-----. 2 oracle oinstall 6 Jul 18 20:31 temp drwxr-----. 4 oracle oinstall 35 Apr 20 12:57 upload ******************************************************************************* * Execution Summary * Targets Succeeded: 1 * prdb19:host * Targets Failed: 0 ******************************************************************************* [oracle@prdb19 ~]$ [oracle@prdb19 ~]$ emcli execute_hostcmd -cmd="sh /home/oracle/001.sh;" -credential_set_name="HostCredsNormal" -targets="prdb19:host;" ******************************************************************************* * Target: prdb19:host * Execution Status: Succeeded ******************************************************************************* SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jul 18 21:01:12 2024 Version 19.23.0.0.0 Copyright (c) 1982, 2023, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.23.0.0.0 SQL> NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ allow_group_access_to_sga boolean FALSE lock_sga boolean FALSE pre_page_sga boolean TRUE sga_max_size big integer 8000M sga_min_size big integer 0 sga_target big integer 8000M unified_audit_sga_queue_size integer 1048576 SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.23.0.0.0 ******************************************************************************* * Execution Summary * Targets Succeeded: 1 * prdb19:host * Targets Failed: 0 ******************************************************************************* [oracle@prdb19 ~]$ [oracle@prdb19 ~]$ emcli execute_hostcmd -input_file="FILE:/home/oracle/001.sh" -credential_set_name="HostCredsNormal" -targets="prdb19:host;" -osscript="FILE" -cmd="/bin/sh -s" ******************************************************************************* * Target: prdb19:host * Execution Status: Succeeded ******************************************************************************* SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jul 18 21:03:40 2024 Version 19.23.0.0.0 Copyright (c) 1982, 2023, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.23.0.0.0 SQL> NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ allow_group_access_to_sga boolean FALSE lock_sga boolean FALSE pre_page_sga boolean TRUE sga_max_size big integer 8000M sga_min_size big integer 0 sga_target big integer 8000M unified_audit_sga_queue_size integer 1048576 SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.23.0.0.0 ******************************************************************************* * Execution Summary * Targets Succeeded: 1 * prdb19:host * Targets Failed: 0 ******************************************************************************* [oracle@prdb19 ~]$
[oracle@ssm01 ~]$ emcli dg_switchover -primary_target_name="testdbstd" -primary_target_type="oracle_database" -standby_target_name="testdb_ssc01.oracle.com.cn" -standby_target_type="oracle_database"
Parsing command line arguments...
Procedure activity DataGuardSwitchover_20240725120808525 for Switchover to testdb_ssc01.oracle.com.cn successfully submitted.
[oracle@ssm01 ~]$
[oracle@ssm01 ~]$ emcli get_jobs -targets="testdbstd:oracle_database"
Name Type Job ID Execution ID Scheduled Completed TZ Offset Status Status ID Owner Target Type Target Name
AUTO_METADATA_DISCOVERY_21 DataScanner 1E0ACFF317947057E06361F2B60A6C09 1E0ACFF317967057E06361F2B60A6C09 2024-07-25 11:31:05 2024-07-25 11:31:07 GMT+08:00 Succeeded 5 SYSMAN oracle_database testdbstd
DBDISCOVERDBSERVICEENTITIES07-25-2024 11:50:38 dbDiscoverDBServiceEntities 1E0B26D99D996900E06361F2B60AB385 1E0B26D99D9B6900E06361F2B60AB385 2024-07-25 11:50:38 2024-07-25 11:50:40 GMT+08:00 Succeeded 5 SYSMAN oracle_database testdbstd
UPDATE_DG_PROPERTIES_2024-07-25 11:31:02.02 dbRecomputeEMDGInfo 1DE6FB8B95135D84E06361F2B60AB629 1DE6FB8B95155D84E06361F2B60AB629 2024-07-25 11:31:02 2024-07-25 11:31:19 GMT+08:00 Failed 4 SYSMAN oracle_database testdbstd
UPDATE_DG_PROPERTIES_2024-07-25 11:46:46.46 dbRecomputeEMDGInfo 1DE6FB8B957A5D84E06361F2B60AB629 1DE6FB8B957C5D84E06361F2B60AB629 2024-07-25 11:46:46 2024-07-25 11:48:11 GMT+08:00 Succeeded 5 SYSMAN oracle_database testdbstd
UPDATE_DG_PROPERTIES_2024-07-25 12:09:38.38 dbRecomputeEMDGInfo 1DE6FBA111B45E4DE06361F2B60AEF6E 1DE6FBA111B65E4DE06361F2B60AEF6E 2024-07-25 12:09:38 2024-07-25 12:09:58 GMT+08:00 Succeeded 5 SYSMAN oracle_database testdbstd
UPDATE_DG_PROPERTIES_2024-07-25 12:18:32.32 dbRecomputeEMDGInfo 1DE6FB88FA1F5D61E06361F2B60A15E8 1DE6FB88FA215D61E06361F2B60A15E8 2024-07-25 12:18:32 none GMT+08:00 Running 2 SYSMAN oracle_database testdbstd
[oracle@ssc01 ~
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· TypeScript + Deepseek 打造卜卦网站:技术与玄学的结合
· 阿里巴巴 QwQ-32B真的超越了 DeepSeek R-1吗?
· 如何调用 DeepSeek 的自然语言处理 API 接口并集成到在线客服系统
· 【译】Visual Studio 中新的强大生产力特性
· 2025年我用 Compose 写了一个 Todo App