Database Administrator

ORA-39126 ORA-00904 ORA-06512 Solution Process Expdp test/123456 dumpfile = B. dmp directory = DUMP_DLSPThe following error occurs when using data mercury. According to the parameters I used, no advanced parameters are used, which are the most

1. Install Firebird in the new IDE of Ubuntu 2. Install Firebird Management Tool FlameRobin in Add/delete 3. change the password of firebird: sudo passwd firebird 4. change the password of the database administrator SYSDBA in firebird: sudo

Sun Microsystems (NASDAQ: JAVA) released a new Sun system product for MySQL ), this is a set of solutions specifically designed to quickly change the economic effect of Web services, allowing enterprise customers to deploy basic MySQL-based Web

After the Oracle 10g Database is installed, the web page is installed by default to manage the Oracle access path, including: Em: http: // localhost: 1158/em Isql * plus: http: // localhost: 5560/isqlplus and http: // localhost:

For RAC databases with NAT or firewall, ORA-12545 connection Errors often occur when load balance is enabled on the server, because after the server forwards client connection requests to other nodes, the client uses the returned IP address to send

Slave slave test the importance of OLR in oracle 11g cluster Called an Oracle Local Registry (OLR): each node in a cluster has a local registry for node-specific resources Test 1: Simulate the loss of an olr exception: First, set the olr

During database operations, some data formats are irrelevant, that is, when it is non-relational, we will use non-relational databases, MongoDB is a distributed non-relational database written by C ++. Its Applications are mature, stable, and API

Overview I wrote about the Server login name, server role, database user, database role relationship, and theoretical knowledge in a previous blog. You can refer to this blog: Login Name, server role, user Name and database role. This blog focuses

Understanding about ora-01000: a point beyond the maximum number of opened cursorsORA-01000: maximum open cursors exceededERROR at line 1:ORA-01000: maximum open cursors exceeded Problem Analysis:1. When the cursor is open, an error occurs and no

How to operate SQLite databases using Python and VC6.0 During this time, due to work needs, I simply learned how to operate the SQLite database. In order to easily write the collected data into the SQLite database, I used Python. However, since C is

NoSQL (non-relational database)In short, a relational model refers to a two-dimensional table model, and a relational database is a data organization composed of two-dimensional tables and their relationships. The most common interpretation of NoSQL

Because both of them are used, informatica is easy to manage in the future, especially for data correction. when data is supplemented in the later stage, the data stream is clear at a glance.SQL is efficient, but it is inconvenient to maintain it

IntroductionThe data warehouse architecture is a branch of the IT architecture. As the core role of data in enterprises increases, the data warehouse architecture becomes increasingly important. The data warehouse architecture seems complicated

1. Preface As a saying goes, "You must know what it is, but you must know what it is ". But I don't know why. Why. This series of articles will show you how to do it and why it will also be involved. However, due to the limited level, the principle

1. Defining the TCP/IP connection of the MySQL Cluster is the default transmission protocol used by the MySQL Cluster to establish connections. Normally, no connection is required. You can use [tcp default] or [TCP] for definition. 1.

Background:The physical memory of the master and slave machines is doubled. After the memory is expanded, You need to modify the memory parameters related to the database, including the database and operating system. After doubling the memory size

Oracle installation is a complex process. In Linux, AIX, and other operating system versions, the preparation process and time often exceed the installer and the database creation process. In addition, once a configuration item is incorrect,

I. Principles of MySQL master-slave Replication 1. mysql replication process: each time a write operation is executed, it will save a copy to its own database. At the same time, this write operation will also be stored in a binary log file, and save

Linux has become popular among various operating systems. Therefore, more and more mainstream database vendors are porting their products to Linux operating systems, such as Sybase, Oracle, and IBM. In addition, more and more free software are

Before Oracle9i Database, if the default tablespace is not specified during user creation, it will be the SYSTEM tablespace by default. If you do not explicitly specify a tablespace when creating a segment, this segment will be created in