Database Administrator

Not long ago, the machines used for the company were really slow. I was so angry that I had formatted Windows and installed the Ubuntu operating system. However, a problem occurs in the Java program: 1. Default Character Set settings for MySQL:

SQLDBA> SELECT * from v $ LOGFILE;GROUP # STATUS MEMBER-----------------------------------------------1 STALE/Oracle/7.3.4/dbs/log1P734. dbf2/oracle/7.3.4/dbs/log2P734. dbf3/oracle/7.3.4/dbs/log3P734. dbf Solution summary: 1. Do not forcibly close

MySQL is installed with the source in Ubuntu 9.04. By default, mysql shell is used to log on to create a database, create a table, and insert Chinese data. The select statement is used to identify Chinese, but garbled characters are displayed when

According to foreign media reports, Trip Chowdhry, an analyst at Global Equities Research, said, oracle may need to strip or sell Sun's MySQL open source database business to obtain approval from the EU Anti-Monopoly Regulatory Authority for Sun's

1: the maturity of software products. Different product quality and market strategies have created different user groups. 2. Advanced Technology Oracle Application System 11i is an application software that is fully based on the INTERNET

Today, I sorted out the installation process of Oracle 10g on Ubuntu 9.04, encountered several problems during the installation process, and finally finished it after a long time. I will explain it during the installation process. First, you need to

I have a lot of Oracle databases that use SUSE linux as the basic platform. When installing oracle, former colleagues directly use the loose package (oraRun *. rpm ). The lazy package is naturally quite lazy, saving a lot of effort when installing

Table T1 contains million data records, with ID = 2 containing 10 records. The case when index can be used when ID = 2 is queried. You can create an index as follows: Create index I _1 ON T1 (CASE WHEN ID> 1 THEN ID ELSE NULL END ); Or similar to

Oracle 12C R1 RAC installThis article includes the CRS installation of the Oracle 12C R1 RAC real application Cluster The DATABASE will be installed later, and the entire process of NETCA and DBCA for 12cR1 RAC Recommended reading: Installing Oracle

Note:There are many ways to create a consumer uard. This article describes one of these methods, which is applicable to 10g/11g.This article uses the RMAN target master database and local auxiliary database to create an Oracle 11g backup uard

Dblink is used to perform regular synchronization from Oracle to oracle. A synchronization just made on the card center is used as an example. Recommended reading: Use Oracle DBLink for table Synchronization Use Oracle DBLink Oracle accesses

When viewing the SQL Execution Plan, we will find that there are many table connection methods. This article introduces the table connection methods to better understand the execution plan and understand the SQL Execution principles. I. Connection

There are three common ways to install MySQL: Rpm package format Common binary format Source code compilation 1. rpm package format (1) provided by the operating system publisher (2) officially provided by MySQL (version updates fix more common

Because the project needs to test the environment, the original database is Oracle 10.2.0.4 64-bit, and the environment needs to be migrated to a 32-bit machine. There are many articles on the Internet that upgrade 32-bit to 64-bit, in fact, the

Today, when the view backs up two large tables in expdp mode to a mounted nfs disk, it encounters a ORA-27054: NFS file system where the file is created or resides is not mounted with correct options. I checked it online and found three solutions:

1. Open PL/SQL Developer. The logon window is displayed. The Username, password, and Database are set when Oracle is installed. The default Username is sys, the default Database is ORCL, And the Connect as option is SYSDBA. 2. After successful

There is such a sentence in the project's stored procedure Select jtpd, jgmc into parm_mrjtpd, parm_mrjgmc From BL_KHXX where jtpd = parm_jtpd; An error is reported every time you debug the stored procedure. ORA-01403: No data found ORA-06512:

Today, a friend has such a situation, in the use of pl/SQL to connect to the database prompts ORA-12537: TNS: Connection closed. View the process (simulated process for confidentiality ): View process: 1) view the client tnsname. ora file

For example, I have a user class that contains a label attribute. This label is an array and the elements in the array are embedded documents. The format is as follows: {"_ Id": "195861 ","Tags ":[{& Quot; tagId & quot;: NumberLong (766 ),"OptDate":

Oracle provides powerful audit functions to audit operations on a variety of databases at the user level, system level, standard audit, fine-grained audit, and other methods. However, many small and medium databases need to record user login and