Database Administrator

The following describes database objects such as tables, views, synonyms, and sequences. 1. Table. Create, delete, and modify tables in Oracle in the same way as other databases. However, the database types of oracle databases are different from

On the weekend, I installed Oracle R12 on Windows XP with virtual machine Linux. Because the system was copied, there were no problems except when I checked the NIC address, two abnormal restarts occur during installation. The cause is unknown. I

First, build a database in Ubuntu, such as temp. Mysql-h localhost-u root-p temp You will be prompted to enter the password. 2. import data: The syntax is mysqldump-opt database name The example is mysqldump-hlocalhost-uroot-p123456 zf

MySQL (Versions later than 4.1) servers use character sets in six key locations: client, connection, database, results, server, and system. MySQL has two character set concepts: character set itself and character set verification rules. Character

Main Environment:JBOSS 5.1.0 Orace 10G Gatein3.1.0-GA Refer to the original article in the movie in official user manual and briefly translate and annotate it:2.1. Database Configuration2.1.1. OverviewDependencies in 3.1 has two different database

Use the user_indexes and user_ind_columns system tables to view existing indexes. For existing indexes in the system, we can use the following two system views (user_indexes and user_ind_columns) to view the specific content, for example, which

CREATE [UNDO] TABLESPACE tablespace_name [DATAFILE datefile_spec1 [, datefile_spec2] ...... [{Mininum extent integer [k | m] | BLOCKSIZE integer [k] | Logging clause | FORCE LOGGING | DEFAULT {data_segment_compression} storage_clause | [Online |

A ORA-00119 and ORA-00132 error was received when the recent system was started, which is actually related to LISTENER, the usual solution is to dump spfile to pfile and then start from pfile And generate a new spfile. However, this operation method

Modify the validity period of the backup file (the database must be started with spfile) SQL> alter system set control_file_record_keep_time = 30 scope = both; System altered. Start Archiving first SQL> startup mount Oracle instance started. Total

I. Description See an ASM upgrade document on the official website, as shown below: How To Upgrade ASM from 10.2 to 11.1 (RAC) Unable To Open Database After ASM Upgrade From Release 11.1 To Release 11.2 For database upgrades under RAC,

Oracle RAC also has HA (High Availiablity) and LB (LoadBalance), and its High availability is based onFailover (Failover)It means that the failure of any node in the cluster will not affect the user's use, and the user connected to the faulty node

The NoSQL product to be evaluated in this article is Redis. It can be understood as a Key-Value data structure operation. The data is stored in the memory and regularly refreshed to the disk, high read/write efficiency has attracted much attention.

The CR blocks created:  Oracle metric is the number of CURRENT blocks cloned to create CR (consistent read) blocks. The most common reason for cloning is that the buffer is held in an incompatible mode.   Read consistency is used when competing

Decided to install Oracle for fun. This time, RedHat Enterprise Linux 4 + Oracle 11g R2 is used. Some problems have been encountered during the installation process. We will summarize the issues for future use.Before the installation, install Linux

1. Environment VariablesJava code Export Oracle_HOME =/home/app/oracle/product/10.2.0/Db_1 Export ORACLE_BASE =/home/app/oracle Export ORACLE_SID = ifm30 Export ORACLE_HOME =/home/app/oracle/product/10.2.0/db_1export ORACLE_BASE

It took me a week to install rac, and I had a lot of detours. I hope to help people who encounter similar problems in the future. First of all, I would like to thank Lei Yu for following his steps. You can install it according to his subsidy, and he

A sample program that uses JDBC to process transaction Import java. SQL .*; Public class TestJDBC {Public static void main (String [] args ){Connection conn = null;Statement stmt = null;Try {Class. forName ("Oracle. jdbc. driver. OracleDriver

I. preparations:Go to www.oracle.comto download linux_x86_11gr1_database.zip (x86 represents the architecture of the computer and is usually x86 ).2. Create necessary users, groups, and directories# Mkdir-p/u01/Oracle# Groupadd dba# Groupadd

Errors in the replication process: Using the following key columns for target table CHQING. DH_OPS_TESTOILLOG: PK_TEST_LOG. 10:40:37 WARNING OGG-01004 Aborted grouped transaction on 'chqing. MLOG_ADM_DAILY_LOG_ORG_DTL ', Database error 100

The following is an article about SQL Injection found on the Internet. Recently, the project involved the prevention of SQL injection. However, because PYTHON and MYSQL are used, some of the ready-made methods provided in JAVA code cannot be used,