Database Administrator

I believe many users have met Oracle's data files. You can check them here. In this process, use sqlplus to log on with sys and perform the following steps: 1. offline the data file:Alter database datafile 'd: \ Oracle \ PRODUCT \ 10.2.0 \ DBFILES

MySQL is installed in two parts: client and server. After the MySQL server and client are installed, the database tables and the table structures in the database are imported and exported, some SQL commands used now: > MySQL-u busiusr-p enters the

1. Start MySQL synchronization:Add the following two lines to the/etc/rc. d/rc. local file:Echo "Starting MySQL Server"/Etc/rc. d/init. d/mysql. server start 2. Disable MySQL synchronization:Insert the following two lines at the beginning of the

From Oracle9i, oracle Installation includes XDB by default. After the database, the http service of Oracle XDB automatically occupies port 8080, which makes it a lot of trouble to use java web development or JBoss or Tomcat. Here we will introduce

Because the supervisor requires a script on the central management server to automatically check the running status of all mysql servers of the company at the specified time every day, and then send it to the specified mailbox. All mysql server

1. Compile the previous conditions to check whether the following software has been installed. Some of them may not be necessary, but we recommend that you install them all.Apt-get install autoconf automake autotools-dev cpp curl gawk gcclftp

In Linux, MySQL5.1 installed with packages does not support GBK encoding. It only supports UTF8 encoding. Specific performance: When you open a database encoded with GBK, the following message is displayed: ERROR 1273 (HY000): Unknown collation

The Kohana version I use is 2.3.1. Although the socket interface is left in the database configuration, this socket is still not used after configuration. You have to modify the Framework Code as follows (in bold ): System/libraries/drivers/Database/

As part of the performance comparison between MySQL 5.5 and 5.6, I have studied the differences between the default parameters of the next two versions. To understand the differences, I used the following SQL statements to query MySQL 5.5 and 5.6

MySQL replication is established to achieve data redundancy based on business needs. MySQL 5.6.10 provides a more convenient GTID-based replication function. MySQL can automatically identify the last synchronization point through GTID, which greatly

I have not fully studied Oracle sqldev, but it is not convenient to use it in a few places. I found that I can modify the shortcut key to correct it. 1. Code intelligent completion prompt All the shoes that have used eclipse are used to using

For Chinese, database encoding has always been a big problem, but in Linux mysql we can initially set all the encoding to UTF-8, the operation is as follows: 1. Modify the/etc/mysql/my. cnf file, sudo gedit/etc/mysql/my. cnfAdd

If you forget about SYSDBA, you can modify the password of SYSDBA. The premise is to find the installation path of Oracle. PWDsid is available in the \ oracle \ product \ 11.2.0 \ dbhome_1 \ database directory. ora file. This is the file that

Backup recovery is an important technology in Oracle. Of course, it is recommended that you do not need this technology, just as you do not need to go to the hospital. When you open the database, oracle compares the control file with the data file

Project Background: The original database server runs on the HP DL388G7 server with 32 GB memory. Due to business growth, the memory is tight, and server hardware faults occur from time to time. As a single instance and single server, spof is

I. Initialization1. Create an initialization file[Oracle @ sigleNode dbs] $ more initdw. ora | grep-v '#' | grep-v '^ $'> initprod. oraEdit the initialization file and set parameters. Add the following settings based on the original parameter

Full table scan is a common method for accessing database tables in Oracle. As soon as you see the full table scan in the SQL statement execution plan, you have to consider repairing it. The existence of full table scan does have room for

I. Runtime Environment Note: The SWAP installed on Oracle11 must be above 2.57G. Therefore, when installing CentOS, make sure that the swap is larger than 2.57G. System Environment: centos 5.6 32-bit (graphical installation)Hard Disk Partition:/Boot

Procedure and function programming in PL/SQLProcedure: Stored procedure eg: create or replace procedure p -- here is the difference with plsql iscursor cisselect * from emp2 for update; -- v_temp c % rowtype; begin for v_temp in cloopif (v_temp.sal

Today, I encountered a problem when I used RMAN for backup, and then I suddenly realized it. I used the client RMAN for backup. The client was windows and the server was installed with Oracle linux. I want to output the RMAN backup information to a