Database Administrator

Unable to connect database ORA-01034 & ORA-27101 with connection string The operating system is linux as5 and the database is 10 Gb. After the machine is restarted, @ connecct_string cannot be used to connect to the database. You can only use the

Solutions to OUI-25031 during Oracle 10g RAC setup The OS version is Enterprise Linux Server release 5.4.DB version: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64biWhen you install the clusterware component during RAC configuration,

Use awk to parse dump files Dump files are often encountered at work. Sometimes a dump is obtained, but more information is not provided, which may cause problems during import. If a user's default tablespace is user, but the table's tablespace in

Oracle online extended partitions and oracle online extended partitions In the Partition Table operation, when a partition already has the largest partition, how can we expand the partition again? The simple method is to delete the maximum partition

Analysis on the storage format of Oracle nested tables and oracle nesting Oracle nested tables are rarely used. The following describes how to store them. For example, a user corresponds to a department. SQL> select * from v $ version;BANNER---------

Oracle GoldenGate Install For Linux, oraclegoldengateDownLoad: Http://edelivery.oracle.com Prepare (Source And Target DB): Add Environment Variblevi/home/oracle /. bash_profileexport LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/lib:/opt/ogg Configure

One mysql optimization experience and one mysql optimization experience One day, O & M suddenly said that the channel page interface of the wireless terminal had a large amount of traffic, and the memcache cache could not handle it. As a result, the

Mysql update modifies multiple data entries and mysql updatesGenerally, the following SQL statement is used to update the field value:Copy codeThe Code is as follows:UPDATE mytable SET myfield = 'value' WHERE other_field = 'other _ value ';However,

MySql Chinese garbled problem (3), mysql Chinese garbled Problem The MySql client is on the dos interface, but the default character set encoding method on the dos interface is: GBK (1) MySql character conversion Principle (2). view all the

MongoDB beginner (1): configuration environment, mongodb beginner I. mongoDB Installation 1. First download the installation package http://www.mongodb.org/on the official MongoDB website /. Download the SDK based on your operating system. 2. Create

Chapter 1 Securing Your Server and Network (8): Stop unused services, chaptersecuringSource: Workshop Without the consent of the author, no one shall be published in the form of "original" or used for commercial purposes. I am not responsible for

Detailed use of RECORD, VARRAY, and TABLE in ORACLE, oraclevarrayLimit limit 1 Description 1.1 RECORD Define the record data type. It is similar to the STRUCTURE in C language. PL/SQL provides a holistic approach to combine several related,

MySql performs the JDBC join (Add/delete/modify/query) operation, and mysqljdbc Video address: http://www.tudou.com/programs/view/4GIENz1qdp0/ Create BaseDao Package cn. wingfly. dao; import java. SQL. connection; import java. SQL. driverManager;

The SQL Server user can only access the specified view. The SQL Server View Use crm-- Create a role for the current databaseExec sp_addrole 'rapp'-- Assign view permission grant select on veiw TO [role] -- Specify the View listGrant select on v_city

[Translated from mos] SYS_OP_ C2C full table scan (fts)/full index scan, sys_op_c2cfts SYS_OP_ C2C full table scan (fts)/full index Scan Reference Original:SYS_OP_ C2C Causing Full Table/Index Scans (Doc ID 732666.1) Applicable:Oracle

[Translated from mos] Main Note, mos mainnote Main Note-Supplemental Logging and TRANDATA of ogg Original article:Main Note-Supplemental Logging and TRANDATA for OGG (Doc ID 1537838.1) ApplicableOracle GoldenGate-Version 9.5 _ EA and

Oracle Optimization-double-edged sword and oracle optimization double-edged sword Oracle optimization is a double-edged sword. Pay special attention to the use of this sword:OLTP or OLAP Optimization 1: Index During DML operations, indexes must be

Let you know software development in advance (34): Database Maintenance Part 1 Database SQL language Database Maintenance   For some large software products, once commercialized, a lot of user information will be stored, which is the database used

Original blog link address: Database open error ORA-01555: snapshot too old During his honeymoon in Dongguan today, a student said that the test library he managed had a problem and could not be opened. Let's first look at the problem:

SQL Server database design specifications (1) 1. Introduction Database Design refers to constructing the optimal database mode for a given application environment, establishing a database and other application systems, so as to effectively store