Database Administrator

I wrote something in my blog on Ubuntu for the first time. I haven't updated it for a long time. Come here today. The first thing we need to consider when installing Oracle-xe-client is whether the swap partition is large enough,This system does not

Innodb_buffer_pool_size of innodb can only be up to 2 GB on 32 machines. In this way, the increase in memory is insufficient to speed up. I heard that the 64-bit environment can use more than 2 GB of memory, so I began to

MySQL is installed with the source in Ubuntu 9.04. By default, mysql shell is used to log on to create a database, create a table, and insert Chinese data. The select statement is used to identify Chinese, but garbled characters are displayed when

This is the first time I have installed MySQL on Ubuntu Linux 9.04. I have not installed MySQL before. So I have made some configurations by referring to some network articles. The following is the entire installation process. I. Installation and

I. Check whether the Oracle database is in archive mode:1. select name, log_mode from v $ database;NAME LOG_MODE------------------------------------------QUERY NOARCHIVELOG2. Use the archive log list CommandDatabase log mode No Archive ModeAutomatic

EnvironmentCentOS6.4 _ 64Network Configuration192.168.10.167 OS-14192.168.10.166 OS-13192.168.10.151 OS-1192.168.10.152 OS-2192.168.10.153 OS-3192.168.10.154 OS-4192.168.10.155 OS-5192.168.10.156 OS-6Architecture and resource allocation192.168.10.151

The single-host multi-instance MySQL solution is to run multiple MySQL database instances on one physical server. Advantages of Single-host and multi-instance MySQL:1. save costs and reduce the number of servers, IP addresses, and cabinets. The

Oracle 12C R1 RAC installThis article includes the CRS installation of the Oracle 12C R1 RAC real application Cluster The DATABASE will be installed later, and the entire process of NETCA and DBCA for 12cR1 RAC Recommended reading: Installing Oracle

Oracle Database cloning is also called Oracle Database Replication. It can be achieved through user management or RMAN. In addition, Oracle recommends using RMAN because it is easy to use and hides its complicated logic. You can just run a duplicate

These two names are very common in alert log. Apart from Oracle, they are inevitably prone to a variety of problems and some are well solved, but some are heartbroken. Example: ORA-00600 The description given by OERR is as follows: // * Cause:

Symptom: After the CRS is restarted on both nodes, this instance cannot start with the CRS. After CRS is started, crs_start-all can be used to set up the resources not started, and no error is reported. Analysis: Find the cause in crsd. log and

Mysql Cluster Overview The most significant advantage of MySql Cluster is high availability, high real-time performance, high redundancy, and high scalability. It allows you to deploy the Cluster of the "in memory" database in a non-shared system.

ORA-00257 archiving log error Solution In the actual project encountered a ORA-00257 error (insufficient space error), by looking for information, the vast majority of said this is due to archiving too many logs, occupying all the hard disk space

MySQL master-slave replication is widely used in small ZTE enterprises. There are three key points for configuring MySQL master-slave replication. 1. server-id. The master server-id is smaller than the slave server-id2. Create an account that can be

Complete MySQL installation and master-slave dual-machine configuration Example HOST: 192.168.0.1 example slave: 192.168.0.2 ################### Complete mysql installation ################## # Groupadd mysqlUseradd-g

Today, a friend has such a situation, in the use of pl/SQL to connect to the database prompts ORA-12537: TNS: Connection closed. View the process (simulated process for confidentiality ): View process: 1) view the client tnsname. ora file

Oracle 10g provides four regular expression functions: regexp function: REGEXP_LIKE, REGEXP_REPLACE, REGEXP_INSTR, REGEXP_SUBSTR. REGEXP_LIKE: (matched) checks whether a string matches a regular expression.(Srcstr, pattern [,

Environment: OS: rhel63_64bit DB: Oracle10gR2 Master/Slave switchover sequence: first from the master database to the slave database, then from the slave database to the master databaseSwitchover:Lossless conversion is usually triggered manually or

During the daily system check, I checked the database tablespace usage through the Oracle Enterprise Manager Console, and found that the system tablespace usage is 100%, and the temporary tablespace corresponding to each user is the system

8.3.2Dropping Tablespaces and Deleting Datafiles8.3.2 Delete Tablespaces and data files When you delete one or moredatafiles or drop one or more tablespaces in the primary database, you also need to delete the corresponding datafiles to the standby