database
总算赶在0点前发了出来，就不配图了。 在北京时间今天的18:10，MySQL更新了最新的GA版本8.0.11。 尴尬的是，那时候我正在将MySQL从5.7.21升级到5.7.22（在今天15:15放出）。 所以更新至5.7.22后，又马不停蹄的开了台测试机，测试了8.0.11。 便开始掉坑之旅，在摔得鼻青脸肿后，边查文档边爬出来。。。 让我一一道来，首先是my.cnf的。 Symbolic links现在默认就是禁用了，无需再去标记禁用了，如果你标记的话，会有个提醒： ‘Disabling symbolic links using –skip-symbolic-links (or equivalent) is the default. Consider not using this option as it’
database
MySQL 5.7.9 GA版本已经出来，目前VPS已更新完成，虽说不像修正版本号更新一样，直接把数据库目录移过去就好那么容易，但也不难。 这次更新了子版本号，过程顺利，没坑，启动有告警。（我是从MySQL 5.6.27更新而来） 说说第一个： [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. secure-file-priv这个参数主要是限制LOAD_FILE和LOAD DATA和SELECT … ，INTO OUTFILE报表到指定的目录。 一般来说很少用，默认值有empty、dirname、NULL，正确的意思就是：
database
Database error: SQLSTATE[HY000] [2002] No such file or directory Hello to all ; Somebody could help me how to fix this .. ?? My server was running ok I dont know what exactly happened Try to open “system/data/autoconfig.php” in a text editor and change the MySQL configured hostname from
database
Playing with Oracle 12c Multitenant Users and Roles Posted on November 10, 2013 I’ve realized these days that the great list of articles by Oracle Alchemist does not contain any articles describing a little more in depth common roles and Users. I’ve found these ones by Pete Finnigan
Oracle
Oracle Database 12c Release 1 (12.1) Installation on Oracle Linux 7 (OL7.2) Note from Oracle Database 12c R1 Installation Guide: * Starting with Oracle Database 12c Release 1 (12.1.0.2), Oracle Linux 7 and Red Hat Enterprise Linux 7 are supported on Linux x86-64 systems. Supported Oracle
database
Oracle 12c: Create a Container Database (CDB) manually with CREATE DATABASE script Note: Oracle strongly recommends using the Database Configuration Assistant (DBCA) instead of the CREATE DATABASE SQL statement to create a CDB, because using DBCA is a more automated approach, and your CDB is ready to use when DBCA
configuration
如果您要配置用於 Tivoli Identity Manager 組織架構的 Oracle，必須完成多個後置安裝作業。 1. 驗證 $ORACLE_HOME /dbs/init.ora 檔中存在下行： * Oracle 8i: compatible=8.1.0 * Oracle 9i: compatible=9.2.0.0 2. 建立資料庫來使用 Tivoli Identity Manager。 下面是一個可用來建立資料庫的 SQL Script 範例。您應配合網站的需求，來變更 Script 中的值。 -- Create database CREATE DATABASE sample CONTROLFILE REUSE LOGFILE
database
下面指令，都請至該台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
database
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
database
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
database
https://docs.oracle.com/cd/B28359_01/server.111/b28310/diag001.htm#ADMIN11258 The V$DIAG_INFO view lists all important ADR locations for the current Oracle Database instance. SELECT * FROM V$DIAG_INFO; INST_ID NAME VALUE ------- --------------------- ------------------------------------------------------------- 1 Diag Enabled TRUE 1 ADR Base /u01/oracle
Monitor
This title introduce how to configure as title description. 1. grafana_5.0.4_amd64.deb which install at Ubuntu xenial server which IP 172.22.4.101 default login account admin, password admin 2. At ubuntu server , run apt-get install influxdb 3. We plan to monitor IOMC server that