NAV: SLTechnology News&Howtos > Database >

• 

  Powershell Management Series (40) PowerShell query

  -provide Microsoft product implementation and outsourcing, such as AD\ Exchange\ Lync\ Sharepoint\ CRM\ SC\ O365, QQ:185426445. Telephone 18666943750 demand: according to the requirements of the group AD domain and subordinates 3

  2022-06-01 12:14:22 Views: 212
• 

  Detailed explanation of parameter file configuration of oracle dataguard main and standby library

  Main library parameter details: keep all DB_NAME in the same Data Guard the same DB_NAME=ora11g # specify a unique name for a database. Once specified, this parameter will not be changed unless the DBA actively changes it in Oracle

  2022-06-01 12:14:22 Views: 224
• 

  Mariadb multi-source master-slave replication error skipped. Md

  Mysql's master-slave error skip is different from mariadb's multi-source master-slave replication error skip operation. Please note: STOP SLAVE 'slave_account';SET @ @ default_master_connection

  2022-06-01 12:14:22 Views: 288
• 

  Zabbix cleans up old data

  Zabbix cleans up old data #! / bin/bashUser=userPasswd=passwdDate= `date-d $(date-d "- 30 day" +% Y%m%d) +% s` # 30 days before fetching

  2022-06-01 12:14:19 Views: 246
• 

  Lower_case_table_names of the MySQL parameter

  Lower_case_table_names parameter MySQL library table case. Default is 00. Database table is sensitive and case sensitive. The specified case saves the file 1. The library table is insensitive and not case sensitive. The file system is saved in lowercase 2 using create

  2022-06-01 12:14:19 Views: 220
• 

  Query of MYSQL connected tables and usage of aliases

  MYSQL connected table query is a query between two tables or more tables, which queries all data by means of foreign keys, resulting in field duplication in the query process. In order to distinguish this situation, database design aliases, some tables are very long, can also use aliases. 1. Query INNER J with tables.

  2022-06-01 12:14:18 Views: 293
• 

  Database backup Sunday full + Daily incremental backup script

  I believe that many small partners who do operation and maintenance will use the mysql database. Here is a script to share with you. #! / bin/bashSCRIPT_DIR=$ (dirname $0) BACKUP_DIR= "/ data1/mysqlbac

  2022-06-01 12:14:18 Views: 204
• 

  Centos6.6 system installs seafile service

  1. Log in to the server 2. Install the dependent package yum install-y gcc zlib zlib-devel openssl openssl-develmysql mysql-server mysql-dev

  2022-06-01 12:14:13 Views: 233
• 

  ORA-65086: cannot open/close the pluggable database

  SQL > show pdbsCON_ID CON_NAME OPEN MODE RESTRICTED

  2022-06-01 12:14:13 Views: 261
• 

  Construction of oracle 11g dg environment under linux

  Item 192.168.12.22 (master) 192.168.12.23 (slave) oracle sidorclorcldb_unique_nameuniquepdguniquesdgtnsnameTns_pdgTn

  2022-06-01 12:14:13 Views: 213
• 

  12c connect to pdb through service

  $lsnrctl serviceLSNRCTL for Linux: Version 12.1.0.2.0-Production on 06-MAR-2018 06:52:45Copyright

  2022-06-01 12:14:13 Views: 295
• 

  Overview of database backup

  Overview of database backup: storing the existing data in the database as a copy of the data can solve the data disaster recovery; improve the high availability and disaster recovery of the system, and restore the data at the minimum cost when the data crashes; causes of data loss: program errors, human errors, disk errors, days

  2022-06-01 12:14:13 Views: 235
• 

  How to delete a user connection for oracle

  1) check the connection status of select username,sid,serial# from users. (2) find

  2022-06-01 12:14:12 Views: 293
• 

  ORA-27102: out of memory Linux-X86_64

  First, more and more X86 servers are used in the current production environment, and non-core systems basically do not use minicomputers. The client server expands the memory and wants to modify the SGA size, but prompts to report a memory overflow. The original physical memory is 8 gigabytes and the capacity is expanded to 32 gigabytes. Both SGA and PGA need to be adjusted.

  2022-06-01 12:14:07 Views: 240
• 

  Selenium-- links the MySQL database and writes data to the database

  Today, I will tell you how to write the desired data to the specified database when doing automated testing. The database is ready and the table is set up. I have built a database called test here. There are many tables under this library. The structure of this table will be used later according to the actual items.

  2022-06-01 12:14:07 Views: 229
• 

  Oracle2oracle installed by OGG

  Both servers need to create an ogg operating system user (this step is optional or can be installed by an ORACLE user). Useradd-u 1003-g oinstall-G dba oggpasswd oggsu-ogg

  2022-06-01 12:14:06 Views: 227
• 

  Migration of sybase Devices under aix

  Under aix, migrating all sybase libraries from one storage to another, or from one vg to another vg, or moving all sybase libraries to a new location can be achieved by copying the relevant lv under aix. Due to the hardware of the company's ibm minicomputer, it is simple

  2022-06-01 12:14:06 Views: 220
• 

  Mongodb runs processes in the background in linux

  # method 1: (recommended) #-the fork option will tell mongod to run / path/to/MongoDB_Dir/bin/mongod-- logpath / path/to/file.log-- in the background.

  2022-06-01 12:14:06 Views: 202
• 

  An example of dealing with the Fault of Oracle Lock Table

  Once the developer does the delete table operating system directly on the database server, which runs during the rush hour, resulting in unresponsive execution for a long time, and then shuts down the SQLPLUS client, runs the delete statement again, and causes the database to run slowly. Ask about the operation process. Got it.

  2022-06-01 12:14:06 Views: 256
• 

  MySQL source code compilation and installation

  1. Install cmake-2.8.10.2.tar.gz to enable root users to enter shell#tar-zxvf cmake-2.8.10.2.tar.gz#cd cmake-2.8.10.2#./configur

  2022-06-01 12:14:05 Views: 250