Database Administrator

On the weekend, I installed Oracle R12 on Windows XP with virtual machine Linux. Because the system was copied, there were no problems except when I checked the NIC address, two abnormal restarts occur during installation. The cause is unknown. I

MySQL cluster based on two servers. MySQL can continue to run when any server encounters a problem or goes down.Note: In theory, you can create a MySQL cluster based on only two servers. However, in this architecture, once a server goes down, the

I. Description Oracle recommends that you use the Database Resource Manager rather than this SQL statement to establish resource limits. the Database Resource Manager offers a more flexible means of management and tracking resource use. for more

Use the user_indexes and user_ind_columns system tables to view existing indexes. For existing indexes in the system, we can use the following two system views (user_indexes and user_ind_columns) to view the specific content, for example, which

CREATE [UNDO] TABLESPACE tablespace_name [DATAFILE datefile_spec1 [, datefile_spec2] ...... [{Mininum extent integer [k | m] | BLOCKSIZE integer [k] | Logging clause | FORCE LOGGING | DEFAULT {data_segment_compression} storage_clause | [Online |

Original works can be reprinted. During reprinting, you must mark the original source, author information, and this statement in hyperlink form. Otherwise, legal liability will be held.Http://winos.blog.51cto.com/937089/582997 I. Prepare the

The NoSQL product to be evaluated in this article is Redis. It can be understood as a Key-Value data structure operation. The data is stored in the memory and regularly refreshed to the disk, high read/write efficiency has attracted much attention.

Decided to install Oracle for fun. This time, RedHat Enterprise Linux 4 + Oracle 11g R2 is used. Some problems have been encountered during the installation process. We will summarize the issues for future use.Before the installation, install Linux

In Oracle11g, you can easily locate the current trace file, that is, access the view v $ diag_info.Store @ TEST> select * from v $ version; BANNER--------------------------------------------------------------------------------Oracle Database 11g

I. preparations:Go to www.oracle.comto download linux_x86_11gr1_database.zip (x86 represents the architecture of the computer and is usually x86 ).2. Create necessary users, groups, and directories# Mkdir-p/u01/Oracle# Groupadd dba# Groupadd

Preface Recently, I have been learningMySQLThe database architecture-related content searches the Internet for a large number of related materials and articles, and reads them in a rough manner. It is found that architecture-related things are

Close Database As with database startup, there are several options available to close the database. In whatever circumstances, readers need to figure out these close options The syntax for shutting down a database is SHUTDOWN [NORMAL | TRANSACTIONAL

#! /Bin/sh# The scripts is for RHEL5U1# Author is kevin# Date 2011-06-06 For I in libXp-1.0.0-8 openmotif-2.3.0-0.3.el5 compat-db-4.2.52-5.1 compat-gcc-34-3.4.6-4 compat-libf2c-34-3.4.6-4 compat-gcc-34-g77-3.4.6-4 compat-gcc-34-c ++-3.4.6-4

Oracle error message ORA-28001: the password has expired, According to the survey, the new features of Oracle 11G are caused. The default password expiration limit for Oracle 11G users is 180 days. If the user password is not modified for more than

A jsp code segment connecting to mysql on the internet, giving the database backup file, but only frm, Each mysql table has three files ,*. frm describes the table structure ,*. MYD Stores Table data records ,*. MYI is the index of the table,

1. When Oracle UCM is started, the console reports an error.The following exception occurs when you view logs: ------ #### Java. SQL. SQLException: ORA-28001: the password has expired ------ Java. SQL. SQLException: ORA-28001: the password

GoldenGate suspected BUG: info all cannot view extract Symptom:Info all cannot view extract ext2, but info ext2 can display the status.GGSCI (UNID1) 20> add extract ext2, SOURCEISTABLEERROR: EXTRACT EXT2 already exists.GGSCI (UNID1) 21> info

When 64-bit Oracle 10g is installed on Oracle Linux Server Release 5.7, the following problems are encountered: Error in invoking target 'install' of makefile'/u01/app/oracle/product/dbhome_1/ctx/lib/ins_ctx.mk '. See

1. An error is reported when Oracle is started. SQL> startup Error: ORA-03113: end-of-file on communication channel View the alert. log File and find ORA-03113: end-of-file on communication channelCannot reclaim 45680128 bytes disk space from 2147483

I. Reminder: The following operations will delete the database. Please back up the database files on your own in advance. 2. Three files are required. The file names and content of the three files are as follows: File 1: Mysql_Drop_DataBase.txt.