maintenance

configuration

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

By ipstor

database

刪除 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

By ipstor

database

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

By ipstor