NAV: SLTechnology News&Howtos > Database >

• 

  RAC creates oracle whitelist

  Due to business needs, we need to use whitelist to limit the address of users logging in to the database, and decided to use the database whitelist function! Generally, you only need to add the following to the sqlnet.ora to launch the whitelist of instance database: TCP.VALIDNODE_CHECKING=

  2022-06-01 07:56:00 Views: 299
• 

  Dashboard installation and Optimization of puppet

  The dashboard of puppet can see the detailed running status of puppet more intuitively. It's also an important part of puppet, so let's start installing and optimizing it! Pptserver_wangsu_bj_192.168.3.68

  2022-06-01 07:55:57 Views: 225
• 

  Database knowledge supplement

  2016.12.27. Tuesday-modify table alter-- add field ADDALTER TABLE table name ADD field name various modifiers AFTER field name; ALTER TABLE library ADD boo

  2022-06-01 07:55:57 Views: 249
• 

  Quickly install MySQL database command set in binary mode

  Mirror source: http://mirrors.sohu.com/1. Quick installation of MySQL database commands in binary mode 1. Install mysqlcd / usr/local/srcwget http://mirrors.soh

  2022-06-01 07:55:56 Views: 293
• 

  Three Oracle RMAN backup encryption strategies

  CONFIGURE ENCRYPTION FOR DATABASE OFF; # defaultCONFIGURE ENCRYPTION ALGORITHM 'AES128'; # defaultRM

  2022-06-01 07:55:55 Views: 270
• 

  Under openstack

  Continue to the previous part of computing service: installation configuration control node: yum install openstack-nova-api openstack-nova-conductor\ openstack-nova-console ope

  2022-06-01 07:55:55 Views: 300
• 

  PostgreSQL state transition

  Typedef enum DBState {DB_STARTUP = 0, DB_SHUTDOWNED, DB_SHUTDOWNED_IN_RECOVERY

  2022-06-01 07:55:55 Views: 271
• 

  Mongodb backup

  1. Cold backup and recovery-create a copy of the data file (if you stop the MongoDB server), that is, directly copy www.2cto.com MongoDB stores all data in the data directory. The default is / data/db/ (Wind)

  2022-06-01 07:55:54 Views: 264
• 

  Organize information about MySQL and MariaDB (installation and deployment, database operations, S

  About MySQL and MariaDB (installation and deployment, database operations, SQL statements) Friday, August 9, 2019, 15: 101, MySQL: (practical environment: CentOS6.5 installation MySQL5.6) reference original address: https:

  2022-06-01 07:55:54 Views: 295
• 

  Cancel SQL statements in other sessions

  The following statements can be used after 12C: ALTER SYSTEM CANCEL SQL 'SID, SERIAL;ALTER SYSTEM CANCEL SQL' SID, SERIAL, SQL_ID'; AL

  2022-06-01 07:55:54 Views: 293
• 

  Linux source code installation mysql

  Source code installation mysqltar zxf mysql-boost-5.7.11.tar.gzrpm-ivh cmake-2.8.12.2-4.el6.x86_64.rpmyum install cmake-

  2022-06-01 07:55:54 Views: 301
• 

  Redis's Sentinel (sentinel) (concept)

  Redis's sentinel redis's sentinel system is used to manage multiple redis server instances (instance). Sentinels are suitable for non-clustered redis environments, such as redis master-slave environments. In the redis set

  2022-06-01 07:55:53 Views: 273
• 

  SQL-- Seven items for learning simple sentences

  / * * 1.Create table guestbook**/--if object_id ('guestbook') is null--CREATE TABLE guestbook (id int PR

  2022-06-01 07:55:53 Views: 235
• 

  SQL 2000 backup task schedule is not executed

  Solution: in the windows Control Panel-- > Administrative tools-- > Services-- > SQLSERVERAGENT-- > start, and set to start automatically. Reference: http://jingyan.baidu.com/article/6525:

  2022-06-01 07:55:53 Views: 207
• 

  JBPM (II)-- install and configure JBPM

  1. Prerequisites for JBPM4.4 installation download the package 4.4.The address is as follows: http://sourceforge.net/projects/jbpm/ working directory: before you start using JBPM, you also need to prepare the following environment: jd

  2022-06-01 07:55:27 Views: 274
• 

  Oracle Common commands 2

  First, the number of connections: check the current number of connections select count () from vconnections process; view the maximum number of connections set (default is 150C): select value from v$parameter wher

  2022-06-01 07:55:23 Views: 289
• 

  PLSQL cannot connect to 64-bit Oracle solution

  There is an error when Plsql is opened, and there is no connection target selection in the login interface. Reason: PLSQL itself doesn't seem to support 64-bit Oracle. Solution: download the 32-bit Oracle client from the Oracle official website at http://www.

  2022-06-01 07:55:23 Views: 252
• 

  Database syntax

  Modify the table name: 1. Alter table table name rename to new name; 2. Rename table table name to new name; modify table name, but also across databases. Example: alter table aa rename to

  2022-06-01 07:55:23 Views: 255
• 

  Basic operation of MYSQL database

  Insert data when creating an empty database and data table, the first thing you need to consider is how to add data to the data table, which can be done using insert statements. Use the insert statement to insert a new row into an existing data table, that is, to insert a new row of records. In MySQ

  2022-06-01 07:55:06 Views: 276
• 

  11204 ASM online storage migration.

  2.1 stop database shutdown immediate2.2 scanning disk echo 1 > / sys/class/fc_host/host3/issue_lipecho 1 > / sys/class/fc_

  2022-06-01 07:55:06 Views: 296