NAV: SLTechnology News&Howtos > Database >

• 

  File searcher-- detailed explanation of find command

  1. File search: in the linux system, because of the large number of files, it is often necessary to find a file among many files. If it takes a long time, it is difficult to remember where the files are stored. However, you are not more worried about this, because developers provide us with powerful file search tools.

  2022-06-01 16:51:31 Views: 220
• 

  [Oracle Database] Oracle RAC (6): node management

  [root@wallet03 ~] # yum install-y iscsi-initiator-utils [root@wallet03 ~] # vim / etc/iscsi/iscsid.conf

  2022-06-01 16:51:07 Views: 244
• 

  What kind of mysql can be accessed directly locally after setting a password, and you don't need to enter a password to log in to the database?

  Select * from mysql.user where user=''; query should be made for an empty user in the database. If so, delete him and restart the mysql service.

  2022-06-01 16:51:07 Views: 247
• 

  Missing package errors when developing hbase programs with eclipse

  Configure hbase in eclipse on win, then write a simple operation to create a table, and use the build.xml of ant to run the error message: [sshexec] Connecting to 192.168.60.111:

  2022-06-01 16:51:06 Views: 278
• 

  Ora-600 [kcblasm_1] bug processing (1)

  There is an ora-600 [kcblasm_1] bug in the ORACLE10205 database, and you need to install the p12419392_10205_Linux-x86-64.zip patch as follows. 1. Conduct environmental testing to ensure that the

  2022-06-01 16:50:36 Views: 218
• 

  Basic use of Postgresql

  Under Windows, the service checks the home page to check whether the service is running or not to find the postgresql service is running. Command line management to open cmd command line connection database command to access PostgreSQL database: psql-h IP address-p

  2022-06-01 16:50:36 Views: 245
• 

  Some questions about mongodb upgrade

  Our mongodb database is a simple one-master-one-slave architecture. At present, it is version 2.4. I want to upgrade to 3.2. the way introduced on the Internet is basically the kind of step-by-step upgrade. I have an upgrade idea, that is, to start a slave database with 3.2, and when the synchronization is completed, directly change the 3.2 from.

  2022-06-01 16:50:36 Views: 272
• 

  .bash _ profile

  / home/oracle hides the file .bash _ profile# .bash _ profile# Get the aliases and functionsif [- f ~ / .bashrc]; then

  2022-06-01 16:50:35 Views: 239
• 

  1. Basic knowledge of LDAP

  1. Concept: directory service is a professional distributed database optimized for query, browsing, and searching. It organizes data in a tree structure, just like a file directory in a Linux/Unix system. Unlike relational databases, catalog databases have excellent read performance, but poor write performance, and

  2022-06-01 16:50:19 Views: 299
• 

  Naming rules for MS SQL development

  The following naming rules for SQL development are summarized and sorted out during my own development, and will be continuously improved and modified in the future development process. I also hope that netizens can give us some advice and criticism. Program: SQL statement keywords are all uppercase, naming rules recommend using Pascal Case or every

  2022-06-01 16:50:16 Views: 224
• 

  Installation and deployment of mongodb replica set replica set (3)

  1. To put it simply, replica set is a master-slave cluster with automatic failure recovery. The most obvious difference between master-slave cluster and replica set is that there is no fixed master node in the replica set, and the whole cluster will elect a master node. Node type standard: constant

  2022-06-01 16:50:16 Views: 285
• 

  ORACLE system tables and views

  1. The system parameters of the system table ORACLE database are stored in the database and can be queried by the user SYSYTEM through SQLPLUS. Several important tables or views are as follows: v$controlfile: control file information; v$datafile

  2022-06-01 16:50:16 Views: 237
• 

  Centos6.5 install Mysql-5.6.41

  1. Download mysqlmysql official website address: https://dev.mysql.com/downloads/mysql/5.6.html#downloads I choose the version is: MySQL Community S

  2022-06-01 16:50:16 Views: 238
• 

  A complete set of Mysqldump parameters

  -- all-databases,-An exports all databases. Mysqldump-uroot-p-- all-databases--all-tablespaces,-Y exports all tablespaces. Mysqldu

  2022-06-01 16:50:15 Views: 230
• 

  Oracle 11g default user name (sys, system) difference

  1 sys/change_on_install SYSDBA default username, password username / password login identity (role) indicates that sys/change_on_install SYSDBA and SYSOPER cannot log in to Oracle as NORMAL

  2022-06-01 16:50:15 Views: 284
• 

  Revisit by oracle scn

  Redo block address select dbms_flashback.get of SCN (system change number) system change number RBA (redo block address) onlin redo log

  2022-06-01 16:50:15 Views: 266
• 

  Add listening and create instances for Oracle

  Add a new monitor 1. Execute the netca command, select "Listener configuration", and click Next2. Select "Add" and click Next3. Enter the listener name and click Next4. Select TCP protocol and click Nex

  2022-06-01 16:49:45 Views: 214
• 

  CentOS 6.4. install MariaDB 10.3

  This article describes how to install MariaDB 10.31 on CentOS 6. 4 using yum. Create the mysql group groupadd mysql2. Create a mysql user and add to the mysql group useradd-g mysq

  2022-06-01 16:49:42 Views: 240
• 

  MySQL migrates data to MongoDB and synchronizes

  Due to the company's business requirements to use mongodb, the tests are as follows: third-party data replication engine-- Tungsten-Replicator main features: 1 support high-version MySQL to low-version replication, 5.1-> 5.02 support cross-database system

  2022-06-01 16:49:41 Views: 299
• 

  Triggers, indexes, transactions in the database

  one。 A trigger is a special stored procedure that implements complex data integrity and automatically triggers execution when a update, insert, or delete statement is executed against a table or view to prevent incorrect, unauthorized, or inconsistent parameters on the data. / * create trigger * / cr

  2022-06-01 16:49:11 Views: 293