Database Administrator

I CONTROL [initandlisten] ** WARNING:/sys/kernel/mm/transparent_hugepage/enabled is 'alway'., transparenthugepage The following message is prompted when mongodb is started. Server has startup warnings: 2015-06-18T17:20:17.944+0800 I CONTROL

RMAN prelude, rman backupSQL> select * from v $ version where rownum = 1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-ProductionSQL>!

Linux Force uninstall mysql, linux Force mysqlIn the case that MySQL cannot be installed in Linux already exists, we can force uninstall it before installing it. steps:1. Find the installed myslq version:# Rpm-q mysqlThe installed mysql package name,

Ubuntu Server 14.04 installation + Secure Web Server (linux + apache + mysql + php) Construction Process (update), ubuntu14.04 After CentOS and Ubuntu, we found that Ubuntu is much simpler ~~ I don't know what the performance is like. Taking

Oracle Policy For NBU, policynbuTheory: NBU use a automatic script to connect RMAN and backup database Steps:First, make a automatic script.Second, build a oracle policy First:Make a automatic script. NBU has provide some scripts on it's client

Removing Netbackup Server Software From Unix, removingnetbackupTo remove NetBackup from UNIX servers1 Log on as the root user on the server. 2 Perform a catalog backup. 3 If the NetBackup Administration Console is open, you must close it now. 4 Save

Install phpredis in redis and phpredis in redis Wget http://download.redis.io/releases/redis-3.0.2.tar.gz Tar xzf redis-3.0.2.tar.gz Cd redis-3.0.2 Make Cd src Mkdir/usr/redis Cp redis-server/usr/redis Cp redis-benchmark/usr/redis Cp

The CACHE features of the KEEP pool and the CACHE features of the KEEP pool The use of the KEEP pool is very simple. If the value of DB_KEEP_CACHE_SIZE is greater than 0, you can set the BUFFER_POOL parameter of other objects to KEEP. Alter table t

For troubleshooting of "Connected to an idle instance" in sqlplus, sqlplusinstance Troubleshooting of "Connected to an idle instance" in sqlplus: This issue is explained in the following article:How to Check the Environment Variables for an Oracle

Java. SQL. SQLException: The IN or OUT parameters are lost IN the index: x, and the outlook index is lost. When using JDBC, the following error occurs: java. SQL. SQLException: The IN or OUT parameters are lost IN the index: x As shown in the

Use JDBC to connect to the MySQL database-Typical Case Analysis (9)-financial account DAO design and implementation, jdbcmysql Reprinted Please note:Http://blog.csdn.net/uniquewonderq Problem: 1. Add a financial account: 2. Modify the information

Redis data type: string type, redisstring Web programmer blog: http://blog.csdn.net/thinkercode String type-Features String is the simplest type. You can think of it as the same type as Memcached. A key corresponds to a value, and the

[Mysql5.6] after the master and slave ip addresses are changed, the synchronization is re-established. mysql5.6ip In this case:Master/Slave System centos6.5 mysql5.6 Because the IP address of the IDC has changed, the original active data cannot

The method for creating a sequence in Mysql. Create table emp_seq (seq VARCHAR (8); insert into emp_seq VALUES ('0'); UPDATE emp_seq SET seq = LAST_INSERT_ID (seq + 1); SELECT LAST_INSERT_ID (); This is exactly the same as the sequence of

Use MySQL in Linux -- forget the root password and modify the default MySQL encoding, mysqlroot Overview: This blog will not explain or explain MySQL syntax any more. If you want to know or be familiar with MySQL, Please study it on your own Baidu

Summary of oracle ebs architecture and management basics (12.1.3), ebs12.1.3 Document directory Blog of Sunan Sheng 1. Overall architecture 2 1.1 directory structure 2 1.2 layer-3 logical architecture 3 2. Basic management 5 2.1 start

Execl data import SQL Server, execl data import SQL You can import execl table data to the database to specify columns or *Note:This statement can only be executed in the local database. If the remote server is connected, the statement should be

Oracle hierarchical query learning summary, oracle levelHierarchical query document directory: 1.1 Summary 21.2 node terminology 21.3 use the connect by and start with clauses 31.4 hierarchical query instance 31.5 query from bottom up 41.6 Delete

Redis translation memory optimization and redis Translation Memory OptimizationSpecial encoding of small aggregate data types Special encoding small set data type Since Redis 2.2 bytes data types are optimized to use less space up to a certain size.

Oracle instance Performance Analysis and Optimization-AWR learning summary, oracleawrSummary Sunan Health Blog's article ORACLE performance optimization includes instance performance optimization and SQL statement performance optimization. They