Database Administrator

During program debugging, one way is to start from the first line, which is very hard (for example, the program source files are too many or compiled or encrypted ). The other method is to check from the back. The last write is the DB, so we start

Install MySQL in Ubuntu: Download the version you need from the MySQL official website. Generally, you can download the latest version directly. Address: http://www.MySQL.com/downloads/ You can download all the packages under the community server

After upgrading Ubuntu to 10.04, the following error occurs when connecting to mysql:Can't connect to local MySQL server through socket '/var/run/mysqld. sock' After reading this, mysql is not started. RunSudo start mysqlUnable to start, no

In Linux, openSUSE 10.0 is used. It is intended to install MySQL and PHP and Apache servers. Follow the prompts on the network to install Mysql first. But after a long time, it just doesn't work. Today, we finally made a breakthrough. After finding

Before the article, the archive mode is enabled and the archive log format is set to the front for easy reading and clarification. Each part will be described in detail later. SQL> archive log list // view the current archive ModeDatabase log mode

1. Install JDKHttp://java.sun.com(1) The downloaded binfile can be directly executed.# Chmod 755 jdk-1.6.0_23-linux-i586.rpm.bin #./Jdk-1.6.0_23-linux-i586.rpm.bin After this step is complete, a file for the jdk-1.6.0_23-linux-i586.rpm is

SQL> conn/as sysdba ERROR: ORA-28056: Writing audit records to Windows Event Log failed OSD-1627319533: Message 1627319533 not found; product = RDBMS; facility = SOSD O/S-Error: (OS 1502 )?????????????????? ORA-28056: Writing audit records to

Software to be installed in advance: svn, apache2.2.x, and mysql5.1 Objective: To implement apache mysql Authentication through the mod_auth_mysql Module Download Software: mod_auth_mysql,: http://www.heuer.org/mod_auth_mysql/ There is a compiled

1. Two mysql servers are compiled and installed: A: 192.168.1.6 (mysql user name: root; Password: gaso123; copy the support-files/my-huge.cnf file under the installation source file directory to/etc/my. cnf) B: 192.168.1.8 (mysql user name: root;

Environment: Oracle 11gr2 + dataguard 128 GB memory +-core cpu + high-performance storage server Uname- Linux dbhost 2.6.18-238. el5 #1 SMP Sun Dec 19 14:22:44 EST 2010 x86_64 x86_64 x86_64 GNU/Linux Symptoms: During rman backup, the system memory

Youmust regularly gather statistics on database objects as thesedatabase objects are modified over time. To determine whether agiven database object needs new database statistics, OracleDatabase provides a table monitoring facility. This limit

Oracle Introduction Oracle is the first word for English translation of oracle (Oracle bone inscriptions) Unearthed from Yin. Oracle is the world's largest supplier of information management software and services. It was founded in 1977 and is

ORA-16249 master database down, logical standby direct change master database SQL> alter database activate logical standby database finish apply;Alter database activate logical standby database finish apply*ERROR at line 1:ORA-16249: Terminal apply

Trigger There are two common types: Row Trigger and Statement Trigger) There are also: Instead of Trigger and Event trigger. Example 1-Row Trigger: Create or replace trigger client afterinsert on tt1 for each

Windows 7 flagship edition 64-bit VMware 7 Oracle Linux Release 5 E-Business R12.1.1 Linux x8   In the linux graphic interface, add the dba group and the oracle and applmgr users. These two users are automatically selected during EBS

Cause: User user1 updates the table. User user2 reads data in the table before user1 is submitted, and reads data in large batches (for example, it takes 3 minutes) in the past three minutes, user1 committed the transaction. After the transaction is

The current status is dg1 as the master database, and the slave database is dg2.First check the status of the Master/Slave database:Dg1 SQL> select name, database_role, OPEN_MODE, SWITCHOVER_STATUS from v $ database;DATABASE_ROLE OPEN_MODE

To back up the data, you need to export the complete data of 11 GB users on the server. The client on the machine is Oracle10g. Run the command: exp ***/*** @ *** file = ***. dmp full = y After the command is executed, the system prompts: EXP-00008

Today, we used the stress test provided by hbase to stress down our hbase cluster. Cluster configuration: master 8 CPU * 32G + 3 8 CPU * 16G Parameter configuration. The zookeeper and hdfs configurations are modified. Test method: Hbase org.

The following error is reported when you execute the create Control File Script: SQL> @/orac/controlfile. SQL SP2-0042: unknown command "DATAFILE"-rest of line ignored. SP2-0734: unknown command beginning "'/orac/ora..."-rest of line ignored. SP2-073