Database Administrator

After Mysql is installed in RedHat Linux, the default encoding is as follows: (Run the following command to view the encoding method) # Mysql-u root-p Enter password: Mysql> show variables like "character % "; Encoding display: + --------------------

Auto start/stop Oracle Database Under AIX 1: Modify/etc/oratab and change "N" to "Y" to enable auto start. $ Vi/etc/oratab# This file is used by ORACLE utilities. It is created by root. sh# And updated by the Database Configuration Assistant when

I have always wanted to take a good look at Oracle, but now the item is about oracle Security. So, take a moment to sort it out. Although it is impossible to fully understand oracle, but it is better to do it than not. I. ORACLE instances　　1. ORACLE

Because of the differences in Linux versions: the locations and names of automatically started shell scripts are also different. in linux versions such as RedHat and red flag, the startup scripts are placed in/etc/rc. in the d directory, the name is

The CentOS Oracle Installation process has been widely used but is constantly being updated. Here we will introduce how to install and install CentOS oracle to help you install and install CentOS oracle Process Systems. Here we will introduce how to

1. When to consider performance issues. Performance considerations should run through all stages of System Construction: system design, database design, code development, and system O & M. 1. system design phase: System Architecture: Layer 2, Layer 3

In many cases, when we were Oracle DBAs, we were notified by our administrators that they were using very slowly and databases very slowly, when we go to the database, we do a few examples of Select and find the same problem, sometimes we will not

Test an Android program that reads an sqlite database mydb. After I perform the following operations, the getWritableDatabase method of SQLiteOpenHelper has an exception.1. backed up this database in adb shell: mv mydb mydb_bak2. Restore the

Today, a friend asked me how to delete archive logs in Oracle10g and answered the following question: Archiving logs in Oracle cannot be directly deleted by operating system (OS) commands, because some information of archiving logs is recorded in

Sometimes, you can view the attribute statements of objects such as tables, storage, and triggers in the following two ways: 1. query the all_source table 2. Use the DBMS_METADATA Package. 1. Use the all_source table First, let's check which types

Definition: Stored Procedure is a set of SQL statements for specific functions. It is compiled and Stored in the database. You can run a stored procedure by specifying its name and providing parameters (if the stored procedure has parameters.

I. Preface: After the database server is set up, the first thing we need to do is not to consider which MySQL-initiated programs should be run on the server that supports the database, but when the database is damaged, how to safely restore to the

1. Go to the listener and check the corresponding log_file and log_status [Oracle @ bys3 log] $ lsnrctl.LSNRCTL for Linux: Version 11.2.0.4.0-Production on 06-DEC-2013 10:27:11Copyright (c) 1991,201 3, Oracle. All rights reserved.Welcome to LSNRCTL,

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) ---------------

MySQL master-slave synchronization setup Master database: IP: 192.168.18.204 Edit/etc/my. cnf file to open log-bin Vim/etc/my. cnf Log-bin =/application/mysql/data/mysql. bin Server-id = 1 View: Log_bin should be in the on status [Root @

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

Oracle provides the custom type function. You can define the Record and Table based on your own situation. Record data storage is a Record, A record Table is used to store multiple records. If the Record data type Record is a one-dimensional array,

We know that the role permissions of users are not available in the stored procedure. For example:SQL> select * from dba_role_privs where grantee = 'suk ';GRANTEE GRANTED_ROLE ADMIN_OPTION

A few days ago, it was accidentally discovered that any OS user could obtain the PG database administrator privilege without a password. This is also a BUG. If DBA is improperly configured, it is not easy to disclose data. You can configure

Currently, LAMP and LNMP are two popular open-source Linux Web Services. Known as free and efficient, it is the preferred server architecture for many websites and Web systems. Business data is often a valuable resource. The damage and loss of