大势趋007

每个人都是🏆
随笔 - 79, 文章 - 1, 评论 - 3, 阅读 - 8812
  新随笔  :: 管理

oem执行os命令

Posted on   大势趋007  阅读(4)  评论(1编辑  收藏  举报
复制代码
[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 ~

 

复制代码

 

相关博文:
阅读排行:
· TypeScript + Deepseek 打造卜卦网站:技术与玄学的结合
· 阿里巴巴 QwQ-32B真的超越了 DeepSeek R-1吗?
· 如何调用 DeepSeek 的自然语言处理 API 接口并集成到在线客服系统
· 【译】Visual Studio 中新的强大生产力特性
· 2025年我用 Compose 写了一个 Todo App
点击右上角即可分享
微信分享提示