Database Administrator

To install Oracle 11g in Ubuntu 10.04, follow these steps:1. Install JDK. For the installation method, see setting up a sun java Development Environment under Ubuntu 10.04.To solve Chinese garbled characters, create the "fallback" directory in the

Multiple Oracle databases physically stored in the network can be logically considered as a single large database. Users can access the data in the remote database through the network, the collaborative processing between servers is completely

1. Modify the/etc/my. cnf FileDefault-character-set = utf8[Mysqld]Datadir =/var/lib/mysqlSocket =/var/lib/mysql. sockUser = mysql# Default to using old password format for compatibility with mysql 3.x# Clients (those using the mysqlclient10

An error occurred while installing the Oracle database: INFO:/usr/lib/: No such file or directory It indicates that the dynamic link library is missing. This dynamic link library is composed of libstdc ++ The dynamic link library provided in

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

Sys_context 1. terminal: The identifier of the terminal corresponding to the current session customer 2. language: language 3. db_name: Current Database Name 4. nls_date_format: Date Format corresponding to the current session customer 5.

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

At work, we need to insert and read and write Chinese data to MySQL. This problem was tricky at first. After a period of investigation, the problem was solved smoothly. The solution is as follows: 1. Set the character set of the MySQL server. The

MySQL installed in the rpm package in Linux does not install the/etc/my. cnf file, As to why MySQL can be started and used normally without this file, there are two points, The first statement is that my. cnf is only a parameter file during MySQL

The strace in Linux can help us track program system calls. LGWR is an important process in Oracle and is responsible for writing redo logs into online redo logs. Let's try to use strace to peat LGWR behavior. First, find the LGWR process Number:

During Oracle development, various forms of report presentation are often encountered. Some reports cannot be directly written using SQL statements, and must be implemented in concert with SQL, however, the report query speed is slow and is not

Oracle SQL optimization Consultant -- AuthorizationGrant administer any SQL tuning set to scott;Grant advisor to scott;Grant create any SQL profile to scott;Grant alter any SQL profile to scott;Grant drop any SQL profile to scott; -- Create a

The following error is reported on the master database after Standby is restarted. PING [ARC0]: Heartbeat failed to connect to standby 'standby'. Error is 16047. Find other people's solutions on the Internet and solve the problem successfully. The

User Managed Backup & Recovery Diagnostic Collection Note: Log on to SQL * PLUS with SYSDBA permission for executionThe instance must be mounted or OPEN mode.Generate the result file: recovery_diagnostics.out (default location is/tmp) ---------------

When I updated a view, I encountered this error: ORA-01779: could not modify the column corresponding to the non-key save table 01779,000 00, "cannot modify a column which maps to a non key-preserved table"// * Cause: An attempt was made to insert

Authorize scott to enable the execution plan. The script is as follows:[Oracle @ rac1 admin] $ sqlplus/as sysdbaSQL * Plus: Release 10.2.0.5.0-Production on Sat Oct 12 02:02:28 2013Copyright (c) 1982,201 0, Oracle. All Rights

Create error table: Create sequence seq_error_log_id;Create table error_log (id number, unit_name varchar2 (30 ),Err_code varchar2 (100 ),Err_desc varchar2 (4000 ),Err_date date ); Automatically expand the partition package: Create or replace

Mysql binlog3 formats: row, mixed, and statement. Parsing Mysqlbinlog -- base64-output = DECODE-ROWS-v mysql-bin.000144 | more   -- Base64-output = DECODE-ROWS: displays the SQL changes brought about by row mode. -V: displays SQL statements in

Lock table read lock If a thread acquires a read lock on a table, the thread and all other threads can only read data from the table and cannot perform any write operations. Lock tables user read; // read the locked table Unlock tables; //

11.1 view fra location SQL> show parameters db_recovery_file_dest NAME TYPE VALUE ----------------------------------------------------------------------------- Db_recovery_file_dest string Db_recovery_file_dest_size big integer 0 Select * from v $