NAV: SLTechnology News&Howtos > Database >

• 

  Deployment of Installation Oracle11gR2 RAC--- basic environment

  Chapter 1 basic environment deployment 1.1, environment operating system: SuSE Linux Enterprise Server 11SP3 database: Oracle 11gR2 (112040) Node 1 hostname: jason1ip address: 10.

  2022-06-01 16:41:00 Views: 261
• 

  EBS OM sales order interface related

  OM interface related table: 1. OE_HEADERS_IFACE_ALL this table is a multi-organization table used to insert sales order headers into the open interface. This table stores the order header information from other subsystems that need to import the OM module. The fields / conditions that must be entered when the table is imported: ORD

  2022-06-01 16:41:00 Views: 303
• 

  SQL injection

  Prevent SQL injection SQL injection: pass parameters maliciously to deceive the server to execute malicious SQL. Select * from students where id=2 or 2 / 2; / / obtain full table data by making the where condition true.

  2022-06-01 16:41:00 Views: 261
• 

  SQL Server 2012 memory

  SQLServer 2012 memory translation from: https://mssqlwiki.com/tag/sql-server-2012-memory-architecture/SQL Server 2012 and before

  2022-06-01 16:40:56 Views: 241
• 

  Oracle 10G RAC deletes an existing node

  If you now have three nodes C1, c2, and c3 in the RAC cluster: if you want to uninstall the c3 node. 1. Delete the c3 instance and run dbca on C1 or c2, and then select Oracle Real Application Clusters datab

  2022-06-01 16:40:56 Views: 209
• 

  MySQL Design Specification (continued)

  1.1 Database field design specifications give priority to the smallest data types that meet storage needs: unsigned integers are used to store non-negative data; N represents the number of characters in varchar (N), not the number of bytes (Oracle is the number of bytes, for example, 2 bytes under Chinese GBK

  2022-06-01 16:40:56 Views: 208
• 

  SQL structured query language-- DQL language

  Memory idea: SQL's DQL language select query command. From queries which columns from which table where queries under what conditions select, whether order by sorts based on a field, and how many rows limit # outputs. 1. Single table query 1. Commonly used check

  2022-06-01 16:40:53 Views: 234
• 

  Oracle determines which object permissions are granted

  There are several views related to object permissions. TAB represents table permissions and COL represents column permissions: USER_TAB_PRIVS_MADEUSER_TAB_PRIVS_RECDALL_TAB_PRIVS_MADEALL_TAB_PR

  2022-06-01 16:40:52 Views: 287
• 

  [MongoDB Learning Notes 20] Index of MongoDB

  The index concept and function of MongoDB's index and relational database are the same: (1) A search without an index can be called a full table scan, that is, the server must find the entire table before it can query the entire result; (2) search after the index is established, query in the index, search in the index entry

  2022-06-01 16:40:52 Views: 263
• 

  OGG maintenance optimization script (23)-OGG status monitoring system-interface introduction

  Originally, I just wanted to make a simple interface to show the operation of the goldengate collected by the previous information collection class script. Later, feeling good, I slowly added something to the specific interface as follows: configuration information and status, error log information, replicat write error log record.

  2022-06-01 16:40:34 Views: 209
• 

  Powershell backup code and database to local and offsite

  Enable powershell execution permission Set-ExecutionPolicy RemoteSigned# purpose: for backing up wiki code and data # time: 2017-2-15 hours localizations backup dirt = "C:

  2022-06-01 16:40:33 Views: 256
• 

  Oracle11G online redefinition

  Create tablespace tbs1 datafile'/ opt/oracle/oradata/haier/tbs1.dbf' size 500m autoextend on maxsize

  2022-06-01 16:40:33 Views: 268
• 

  Mysql 5.6Multiinstance mysqld_multi stop failed to shut down the database

  It shows that according to the needs of the business and from the point of view of rational use of hardware resources, there are many instances in the preparation of the production database, and a small problem is encountered in the process of testing. Record it. 2.vi / etc/ my.cnf[mysqld _ multi] mysqld=/

  2022-06-01 16:40:00 Views: 221
• 

  Installation of HBASE version 0.98, one step: compile HADOOP version 2.2.0 x64

  1. Install JDK to download JDK 7u55 version, both JDK and JRE are required. Tools.jar is included in JDK. This jar package must be installed on / java. 2. Download Hadoop 2.2.0 source code wget http:/

  2022-06-01 16:40:00 Views: 208
• 

  Oracle11g dg configuration (picture and text version)

  A little lazy, we forgive the position of the pictures will not be added one by one, the work is relatively busy, just copy and paste my document for everyone. Chapter III main Library configuration 3.1 create a directory and modify the name / / create the required folder mkdir / u01/app/oracle/an in the main library

  2022-06-01 16:40:00 Views: 207
• 

  ZKEACMS could not run the problem summary

  Preface if you don't know ZKEACMS, you might as well know it first. ASP.NET MVC open source site building system ZKEACMS is recommended and put together from this website. Official address: http://www.zkea.net/zkeacms download address

  2022-06-01 16:39:39 Views: 204
• 

  Centos6.8 install zabbix2.4

  Because the official website is very slow, it is very annoying to often read the official documents, so record the steps for me to install and configure zabbix on the official website. # installation environment centos6.8192.168.2.110 basic server installation # disable firewall service ip

  2022-06-01 16:39:38 Views: 212
• 

  Oracle logminer exploration

  LogMiner component check: first we need to make sure that the database already has the necessary packages. If not, we need to run two packages: @? / rdbms/admin/dbmslm.sql script to install the DBMS_LOGMNR package, which is used by the package user to analyze the day

  2022-06-01 16:39:38 Views: 243
• 

  The principle and basic Application of Redis

  CAP theorem: C:Consistency consistency, data backup nodes in distributed systems need to maintain data consistency in real time; A:Availability availability, the failure of nodes in the cluster does not affect the whole cluster to provide services; P:Part

  2022-06-01 16:39:26 Views: 267
• 

  Oracle sqlplus common commands

  1. Sys users and system users Oracle installation will automatically generate sys users and system users (1), sys users are superusers, with the highest privileges, sysdba role, create database permissions, this user

  2022-06-01 16:39:25 Views: 213