Share My Idea from life

Sign in Subscribe

maintenance

How to update the BIOS version of a Dell Server using EFI file

Steps: Please download the Bios XXX.EFI file for your server from the Dell support site. 1. Copy the file to a USB device. Note: If you are doing this locally, copy the file to a USB FAT 32 device format on the root of the drive. Alternatively, create an

為什麼我的Windows Update無法更新錯誤代碼:80072EE2

請參考 Windows Update 錯誤 80072ee2 或是以系統管理員身分執行命令提示字元，然後執行下列三行指令 net stop wuauserv reg delete HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate net start wuauserv 然後再試試看

CentOS / RHEL 7 : How to setup yum repository using locally mounted DVD

https://www.thegeekdiary.com/centos-rhel-7-how-to-setup-yum-repository-using-locally-mounted-dvd/ yum is the primary tool for getting, installing, deleting, querying, and managing Red Hat Enterprise Linux RPM software packages from official Red Hat software repositories, as well as other third-party repositories. The post below describes step by step procedure to use a locally mounted RHEL

Oracle Database 12c - How to Add / Multiplex Control Files

Oracle Database 12c – How to Add / Multiplex Control Files PURPOSE: – protect your Database in case of a disk failure – reduce the risk of control file loss due to corruption or accidental removal – as a DBA, it’s your responsibility to multiplex and backup control files to protect your organization in

刪除 ORACLE ARCHIVE LOG

下面指令，都請至該台DB SERVER cmd模式下執行 1.查看archive相關設定值 c:\>sqlplus / as sysdba SQL> SHOW PARAMETER ARCH NAME TYPE VALUE —————————- ——– ——————- ………(篇幅關係上面還有，只取下面) log_archive_dest_state_9 string enable log_archive_duplex_dest string log_archive_format string ARC%S_%R.%T log_archive_local_first boolean TRUE

rman delete Oracle archive log

rman target sys/corl Recovery Manager: Release 12.2.0.1.0 – Production on Mon May 14 16:31:37 2018 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. connected to target database: ORCL001 (DBID=3872964947) RMAN> show archivelog deletion policy; using target database control

ORA-65096: invalid common user or role name

Oracle Database 12c 因為有 multitenant container database (CDB) 及 pluggable databases (PDBs) 的功能，所以在建立帳號時，就必需要指定。不然會有錯誤訊息：ORA-65096: invalid common user or role name [oracle@oradb12clinux ~]$ echo $ORACLE_SID orcl [oracle@oradb12clinux ~]$ sqlplus / as sysdba SQL> show con_name CON_NAME —————————— CDB$ROOT SQL> create user abcd identified by