Database Administrator

PuTTY + Xming for Oracle image Installation When we use PuTTY software to connect to a Linux server, ssh or telnet is used by default. Since PuTTY does not have the X window Function, the Oracle graphical installation interface cannot be

Oracle 10 Gb read-only table N methods Sometimes to improve data security, we need to set one or more tables to read-only, that is, no DML (Insert, Update, Delete) operations can be performed on them. It is very easy to implement read-only tables in

A Simple Analysis of ORA-01113 Problems When starting a database, various problems may always occur in the open stage, such as daunting errors. ORA-01113: file 1 needs media recovery I have noticed that this problem may occur in many scenarios, and

Oracle 11g partition maintenance (4) -- Exchanging Partitions Swap Partition You can convert a partition (or sub-partition) into a non-partition table by exchanging data segments, or convert a non-partition table into a partition (or sub-partition)

Node reads files in the form of data blocks In Node, the default value of Transfer-Encoding in the http response header is chunked. Transfer-Encoding: chunked Node's inherent asynchronous mechanism allows the response to be generated gradually. This

Node. js log management package Nodejs log management toolkit: log4js and winston 1. Use of log4js 1) Add dependencies to package. json "Log4js ":"~ 0.6.21" 2) Write A log4js configuration file log4js_conf.json {"Appenders ":[{"Type":

How to increase the Oracle tablespace Increase the Oracle tablespace size: one is to add data files to the tablespace/the other is to increase the size of the original data file in the tablespace 1. Add data files to the tablespace: Alter

Recovery database encountered a ORA-0600 fault Errors in file/u01/admin/UIDB/udump/uidb_ora_59394.trc:ORA-00600: internal error code, arguments: [krbrrd_bz2_ksfqrd_noblks], [/u01/test/tests], [576000], [], [], [], [], [], [], []Full restore complete

Install Oracle11g + PL/SQL and win8oracle11g in Win8 (64) Recently, Oracle11g is required and PL/SQL is used for management. Software and Hardware Description OS: Win8 64-bit operating system, memory: 8 GB. Oracle_11g_R2 64-bit version PL/SQL

Does tnsping prove that the Oracle database is available ?, TnspingoracleListener is a server-based network service of Oracle. It is mainly used to listen for connection requests from clients to database servers. Oracle officially defines it as: A

Detailed description of innobackupex Backup Recovery and innobackupex Backup Recovery I don't want to talk about anything that is useless. Let's look at the actual operation .. Let's just say, innobackupex reads locks for non-innodb tables during

Oracle display the usage of the object space show_space, oracleshow_space Tom wrote a script to view the object space usage of the Oracle database.The following shows how to use it: -Tool source code CREATE OR REPLACE PROCEDURE show_space(p_segname

Redis data type string, redis Data TypeRedis data type string redis string The redis string is not a C-language native string, but a self-built simple dynamic string (SDS), which is similar to a C-language native string, use '\ 0' as the end. In

Learning notes for five types of Redis objects and five learning notes for redis When using Redis, we directly access String, List, Hash, and Set objects ), sortedSet. Basic commands include String (get set) List (lpush rpush lpop rpop lrange) Hash (

Oracle Data Accesses other Oracle databases. Create a database link in the local oracle databaseDrop database link mydblink;Create database link mydblink connect to zszq identified by "zszq" using '192. 168.0.175: 192/orcl '; SQL> DROP DATABASE LINK

Configure master-slave replication for redis, and configure master-slave for redisConfigure master-slave replication for redis master-slave Replication ./Redis-server command. If no parameter is appended, it starts the redis service according to the

ORACLE-015: ora-25153 temporary tablespace is empty, ora01652 cannot pass through 128, oracle-015ora01652 I wrote a complex select statement, and suddenly oracle reported: ora-25153 temporary tablespace is empty, this error, so I checked online,

WAS _ cluster deployment application encountered ADMA0085E and adma00000w errors, adma0085eadma00000w Original works, from "Deep Blue blog" blog, deep blue blog: http://blog.csdn.net/huangyanlong/article/details/47143431 Recently, a was package

Ubuntu mysql cannot be started for simple troubleshooting. tumysql My website has not been on for a long time. I want to open it and find that it cannot be opened, so I found a series of reasons. After a simple investigation, my vps service was

Java jdbc simple encapsulation and java jdbc simple Encapsulation After learning jdbc for a while, I felt like I could try to write a simple encapsulation, so I wrote a little bit about some of the reference materials. After all, I didn't learn it