Database Administrator

Detailed steps and precautions for building a single instance DG for two Oracle 11g nodes RAC Environment Introduction: OS: [root @ java3 ~] # Uname- Linux java3 2.6.18-308. el5 #1 SMP Tue Feb 21 20:06:06 EST 2012 x86_64 x86_64 x86_64

Oracle deletes log files The syntax for deleting a log file is as follows:Alter database drop logfile member logfile_name;Note the following when deleting a log file:1. The log file group of the log file cannot be in the current status. You need to

MySQL 5.0 and mysql 5.0 1. Select next: 2. Select Custom. Among them, "Typical (default)", "Complete (Complete)", and "Custom (Custom )": 3. Click "component components (developer part)" and select "This feature, and all subfeatures, will be

Oracle uses the using Keyword, oracleusing keywordOracle using KeywordThe SQL/92 standard can use the using keyword to simplify the connection query, but only when the query meets the following two conditionsSimplify with the using keyword.1. the

Mysql 1366 error: incorrect data insertion due to Character Set conflict. Solution: mysql1366 I. error message: errorCode: 1366 Caused by: java. SQL. SQLException: Incorrect string value: '\ xE7 \ xAE...' for column 'description' at row 1 Ii. Cause

Common MySQL database operationsServer operation (cmd) Check whether the mysqld.exe process exists in the progress table) Disable the server (ensure that mysql is a windows Service): net stop mysql56Check whether the process mysqld.exe

Path to mathematics-SPSS memo (1), path to mathematics-spss memo 1. import data. Create a script to open the seismic data. Open an excel file Get data/TYPE = XLSX /FILE = 'H: \ mybook \ 4.5_month.xlsx' /SHEET = name '4. 5_month' /CELLRANGE =

[Minute-second function for getting system time in Oracle], oracle minute-second function 1. Get the year of the current system time Select to_char (sysdate, 'yyyy') from dual; -- year 2. Obtain the month of the current system time.Select to_char

Study database notes 5. Database notes I Where subquery The inner query result acts as the outer query condition. 1. query the latest product Step a) select max (goods_id) from goods; this is a dynamic statement, and how to add it will be

Basic database architecture and log functions, database architecture logs1. Why mysql? MySQL features a plug-in storage engine to facilitate read/write splitting It is open-source and free2. How database software runs in the Early Stage: data is

Poor memory: 92-spring3 Learning (13)-small differences between spring and hibernate database access, 92-spring3-spring In the Spring data source, autoCommint is set to true by default. That is to say, by default, the statements executed through

9 Key Points for optimizing Redis memory9 Key Points for optimizing Redis memory  1. Pay attention to the special encoding settings for small aggregate data types in redis. conf:   Hash-max-zipmap-entries 64 (hash-max-ziplist-entries for Redis >=2.6)

Database Upgrade Code learning and Database Upgrade Code Business scenarios and requirements:After the product is launched at each banking outlet [in cooperation with the Company] in China, you must upgrade your business to meet new functional

SQL Server database image (2) complete image script configuration in the domain environment, SQL Server Image SQL Server database image (1) image script configuration without witness on a single server SQL Server database image (2) complete image

Solution: mysql_connect () is not supported. Check whether the mysql module is correctly loaded. Fault description: linux discuz installation error prompt: mysql_connect () does not support checking whether the mysql module is correctly loaded.

OCCI processes different CHAR string variables, occichar Problem background: An old application, originally written In proc, is a 9i Database. Now, the application needs to use OCCI instead, with a query logic: select... where upper (state) = upper (

Let your eclipse implementation write JAVA code, HTML, CSS, JAVASCRIPT code prompts, eclipsejavascript 1. Open eclipse → Windows → Preferences → Java → Editor → Content Assist Modify Auto Activation triggers for java to: zjava click apply 　　 　　 2

Automatically back up the mysql database and send it to the e-mail method, mysqlemail A blog, the most important thing for a website is a database, so it is necessary to back up data frequently.WordPressThere is a plug-in for regular data backup,

Set the default tablespace in oracle.In oracle, the user's default permanent tablespace is system, and the default temporary tablespace is temp. If all users use the default temporary tablespace, the system and temp tablespaces will undoubtedly be

Mysqli pre-compilation mechanism for batch data processing, mysqli compilation Mechanism The mysqli enhancement also includes the addition of the Transaction Processing Mechanism and pre-compilation mechanism. In fact, both of them are for the sake