Database Administrator

Oracle 10g quick manual database creation procedure Step record of Oracle 10g quick manual database creation: 0. Modify Environment Variables [Oracle @ ocm1 ~] $ Vi. bash_profile Add the following content:Export ORACLE_SID = PRODExport ORACLE_BASE =/

Why didn't Oracle RAC Opatch go to Rac database home during auto? First explain the environment:Operating System: AIX 7.1Oracle version: Oracle Rac 11.2.0.3I used the 11.2.0.3.9 patch set before and it was not officially used for Rac installation,

Redis Master/Slave + KeepAlived for High Availability Redis is a popular non-relational database that supports a wide range of data types, multi-thread high concurrency support, redis runs in memory with faster read/write. Because redis is doing so

MySQL configuration file The latest MySQL product actually exceeded the version carried by Red Hat Enterprise Linux. However, stability and open source code are very important factors, so it makes sense to use an earlier MySQL version on the

Oracle DBAs for IT ninja turtles are commonly used to query enumeration of vomiting blood, oracledba -1. query all objects in the systemSelect owner, object_name, object_type, created, last_ddl_time, timestamp, statusFrom dba_objectsWhere owner =

MongoDB database installation details (2). mongodb details How to change mongodb in java Java-based mongodb insert, read, modify, and delete operationsThis article describes how to operate MongoDB in Java and how to perform routine

Step 1 of kettle's User Defined Java Class, kettledefinedZookeeper Step 1 of User Defined Java Class)   The "user-defined java class" step in kettle, also known as the UDJC step, is available in version 4.0 and has powerful functions and is

Oracle creates tablespaces, creates users, and grants and views permissions. oracle Permissions Create temporary tablespace Create temporary tablespace test_temp TEMPFILE 'C: \ oracle \ product \ 10.1.0 \ oradata \ orcl \ test_temp01.dbf' SIZE 32

Data Center reconstruction-view and Data Center reconstruction Views, stored procedures, triggers, and so on have long been heard, but they have never been really touched. They have been in a future State and cannot be escaped. What happened to Data

ORA-00942: Table or view does not have a low-level error example, ora-00942 example ORA-00942: a low-level error does not exist in a table or view   Run the query statement and report a ORA-00942 Error   After checking, the user who does not

Why don't you shrink the database file (foreign translation) and the database translation? Preface: I have read a lot of articles about SQL server shrinking data files over the past few days. I am going to write an article about shrinking logs, but

How does Mysql set the field to automatically obtain the current time? Application scenarios:   1. In a data table, to record when each piece of data was created, the data database automatically records the creation time without the need for the

1 Overview 1.1 proposal of questions Currently, many applications store data in the database and read and process data from the database. In business processing, applications are often divided into two types: Data consumer applications ("Producers"

2015 China Database Conference Mongodb sharing, 2015 mongodbThis article was shared by MongoDB Greater China technical consultant. When the "old man" came up, he asked what Mongo meant. He guessed the prize and claimed that he was the best MongoDB

In Oracle tablespaces and data files, Temp tablespaces and files are special. In addition to the temporary segment (Temp segment) corresponding to the temp tablespace, it is automatically managed by Oracle. The sparse file feature is also an

Big environment MySQL5.6 source code Installation Practice step by step teach you CentOS6.5 _ 64bit under the compilation and installation of MySQL-5.6.23 @ guoyJoe, centos6.5mysql5.6 L reprint please indicate the source:

Blue growth note-chasing DBA (14): unforgettable "Cloud" end, initial hadoop deployment, dbahadoop Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the

Database Programming -- Use of translate, -- translate1. translate syntaxTranslate (string, from_str, to_str)2. explanation: replace each character in the string from_str from left to right with each character corresponding to the string to_str, if

Atitit. troubleshooting ------ sometimes com. microsoft. sqlserver. jdbc. SQLServerException: Connection reset by peer: soc, connectionreset Atitit. troubleshooting ------ sometimes com. microsoft. sqlserver. jdbc. SQLServerException: Connection

1. Sybase Database Introduction  1. Version In 1984, Mark B. Hiffman and Robert Epstern created Sybase and launched Sybase database products in 1987. SYBASE has three major versions: one is the version running under the UNIX operating system, the