Database Administrator

Create a file named Oracle [root@stark init.d]# pwd  /etc/init.d  [root@stark init.d]# touch oracle  Add the following content to oracle: #!/bin/bash  # chkconfig: 35 95 1 

Take utf8 as an example. Assume that you have installed MySQL in Ubuntu (SEE) and the installation is successful. 1. Stop mysql Sudo/etc/init. d/mysql. server stop 2. modify my. cnf Sudo gedit/etc/my. cnf Find the corresponding part and add the

I. Check hardware requirements Memory Requirements (at least 1 GB) # grep MemTotal/proc/meminfoSwap zone requirements # grep SwapTotal/proc/meminfo/Tmp directory (at least MB space) # df-m/tmpIi. system software requirements View the operating

Sometimes, the EBS reports insufficient connections. Therefore, we try to improve processes and sessions. After EBS is installed, the default value of the init parameter processes is 200, and the default value of sessions is 400. here I increase the

Redo log files Record Database Change Data. Generally, the failure of redo log files will not cause database data loss, but will affect database recovery. Redo logs can be divided into two statuses: Current online redo logs and non-current online

Today, when you import a table from a remote user to a local through a data link, you encounter a ORA-39149: unable to link the authorized user to an unauthorized user C: \ Users \ admin> expdp admin/admin network_link = ADMIN_TO_DB1 directory =

Oracle 11g provides new row and column conversion operations: Convert (row to column) and unconvert column to row. This document describes the unregister function. The existing table src_table is as follows: Product_Id (product ID)

One of my systems is to deploy redis on various machines, so as to achieve horizontal scaling, the problem is that it is very inconvenient for statistics. To configure multiple master nodes and one slave node, I added Slaveof 1.1.1.1 6379Slaveof

1. When a table is created, double quotation marks are added. The case sensitivity of the table name will be retained and written to the database, Note: Double quotation marks are not written into the database, and Oracle converts them to uppercase

Requirements for Oracle 11.31 database installation on HP-UX IA64 10.2 systems: I. Swap memory requirements If RAM is 1024 MB to 2048 MbThen 1.5 times RAMElseif RAM & gt; 2048 MB andThen match RAMElse RAM> 8192 MBThen. 75 times RAM Ii. JDK

I. Problem Description Database Error. Read alertlog, which repeats the following content: Wed Jul 25 17:47:18 2012 Errors in file/oracle/admin/etldb/udump/etldb_ora_15674.trc: ORA-07445: exception encountered: core dump [kghssgdmp () + 273] [SIGFPE]

First article on Restoration Based on SCN 1. Check the SCN number before deleting the data: SQL> col name format a45 SQL & gt; set line 300 SQL> select name, checkpoint_change # from v $ datafile_header;   NAME CHECKPOINT_CHANGE # -------------------

Creating a database through the command line can help you better understand the database creation process. Today, I tried to manually create the Oracle11gR2 database. It seems that the 10G manual database creation process is still different, for

1. Install cmake first.# Tar zxf cmake-2.8.3.tar.gz# Cd cmake-2.8.3/#./Bootstrap & gmake install 2. Install mysql# Groupadd mysql# Useradd-g mysql-s/sbin/nologin# Mkdir-p/data/mysql # Chown-R mysql. mysql/data/mysql # Chmod 755/data/mysql # Tar zxf

One day, the Oracle production database server went down abnormally. the following error was reported when the server was restarted to enable the database: SQL> startupORACLE instance started.Total System Global Area 1.6911E + 10 bytesFixed Size 2113

I remember that Oracle I installed more than a year ago has never been used. When I was preparing for use, I encountered various problems. I had to find a solution on the Internet to solve them one by one. I 'd like to note it in case I forget it: I.

Oracle spatial function exampleDisplay the area of the computing Oracle spatial Space ObjectSelect mdsys. sdo_geom.sdo_area (shape, 0.005) from jbnt_xzq; // Calculate the area of the geometric object based on the coordinates of the Surface object/200

1. Install the dependency package. 1. yum install cmake 2. yum install gcc-c ++ 3. yum install ncurses-devel Ii. decompress the source code package 1. tar-zxvf mysql-5.5.8.tar.gz Go to the extracted file ....... Iii. Compilation + Installation 1.

RMAN list Command1. list the corresponding event RMAN> list incarnation; 2. List backups2.1 Overview of available backup RMAN> list backup summary;B Indicates backupF indicates FULLA Indicates archive log0 1 indicates incremental backupS indicates

I have been studying MongoDB for a while, read some books, and read a lot of information on the Internet. In fact, I copied and copied many of them, but they have not been verified by myself. I can post them to my blog, and then let me know what to