Database Administrator

On the Internet, if sysv-rc-conf is used for configuration, or if S is changed to start with K, because 10.04 connects the MySql startup to/lib/init/upstart-job, and the latter calls/etc/init/mysql. the definition of boot in the conf file is a new

This article describes how to install and configure Oracle SOA Suite in Linux. The version of SOA Suite is 11.1.1.3.0, which is the latest version. Just like setting up an environment in the past two days, simply record the building process and

Connection con = this. creatCon (); // get the ConnectionPreparedStatement pstm = null; // command String SQL = "insert into student (student_id, name, sex, age) values (?,?,?,?) "; // Set the SQL statement to be executedPstm = con. prepareStatement

Keywords: Hongqi Asianux3 + Oracle 10g R2 for Linux x86-64 1. Receive a consulting phone number in the morning: Oracle cannot be started in Linux. We will try to solve the problem at the site in the afternoon. 2. After arriving at the site, learn

Installing Oracle on the Linux platform requires a lot of preparation. For example, create a user, modify the environment variables, and set oracle parameters. Now it is compiled into a shell script to facilitate installation.1. Create an

Oracle10g. A table similar to BIN $ nJ5JuP9cQmqPaArFei384g ==$ 0 will appear after you select and delete it in pl/SQL. 1. view the recycle bin Select * from user_recyclebin; 2. Clear the recycle bin Purge recyclebin; 3. Clear a table in the recycle

1. Build the installation environment 1. Create an informix user group and user Log in as root, and then: Groupadd-g 3000 informix Useradd-u 3000-g 3000-d/home/informix-m informix 2. Modify Environment Variables # Su-informix # Cd # Ls- # Vi.

A major system fault occurred On Weibo a few days ago, and many technical friends are concerned about it. The reason is not as high as James Hamilton's On design and Deploying Internet-Scale Service (1) in summary, James's first experience "Design

Environment: OS: rhel 6.3 _ 64bit DB: Oracle 10gR2 Level switching process: Master Database SQL> select protection_mode, protection_level from v $ database; PROTECTION_MODE PROTECTION_LEVEL----------------------------------------MAXIMUM

This article and its attachments are published in the PostgreSQL Protocol A friend once asked how to clear the cache. Without this function, it is very inconvenient to test. I have made a patch. For more information, see the attachment. Provide

Ddl operations are actually converted into a series of dml statements for execution. Follow up ddl operations to view the content automatically executed by the Oracle back-end data dictionary: Scott @ ORCL> conn/as sysdba; Connected. Sys @ ORCL>

Oracle materialized view testMaterialized View is a special physical table. The Materialized view is relative to a common view. A common view is a virtual table, which has many application limitations. Any query of the view, Oracle, is actually

Overview: MySQL 6.4 installed through yum in CentOS 5.1 is old, so I want to install the later version 5.6.14 through the source code.Body: 1: uninstall the old version Run the following command to check whether MySQL Server is installed. rpm -qa |

In the past, most of the company's projects were on version 5.5, and there was just a project (free trading platform) with a small amount of data. A single server ran stably online and rarely took over, in order to unify the version, I plan to

When using Oracle SQL * PLUS, SPOOL is really easy to use. How can we implement it in MySQL? The following is an experiment description. In MySQL, the tee parameter can be used in three methods: First, add the tee parameter to the my. cnf parameter

Take a look at the official description of slave_exec_mod. Command-Line Format --slave-exec-mode=mode Option-File Format slave_exec_mode System Variable Name slave_exec_mode Variable Scope Global

Flash back technology is usually used to quickly and easily recover logical errors such as misoperations in the database. The flash back method can be divided into database flash back, table flash back, and transaction flash back, based on the

Fault symptom:Go to the slave server and run:Mysql> show slave status \ G.......Relay_Log_File: localhost-relay-bin.000535Relay_Log_Pos: 21795072Relay_Master_Log_File: localhost-bin.000094Slave_IO_Running: YesSlave_ SQL _Running:

1. OUI-10182 The valid tive user ID does not match the owner of the file .......... Solution: Use the root account to create the oraInst. loc file under/etc and write the following content: Inventory_loc =/u01/app/oraInventory (directory of

Oracle 11gR2 service descriptionSome background processes Background Process Description Oracle High Availability Service (OHAS) OHAS is the first Grid Infrastructure component opened after the server is started. It is