Database Administrator

1. added the oinstall user group and dba user group, added Oracle users, and added them to these two user groups. The default group is the dba user group;2. Set oracle user environment variables Command:Vi ~ /. Profile (". "indicates hidden files, h-

Installing a database in Linux causes a lot of trouble. The following is one of the troubles: After the innodb database engine is installed, find a lot of information, which is roughly as follows: 1. Remove # skip-before innodb # 2. Delete the

I. version count description This issue is described in the MOS documentation. For details, refer to [ID296377.1]. All SQL statements in Oracle are implicitly sharable. When a user submits an SQL statement, RDBMS performs a hash operation on the SQL

1. To create a global DBLink, you must first confirm that you have the permission to create a dblink: Select * from user_sys_privs where privilege like upper ('% Database link %'); If not, you must use the sysdba role to grant permissions to

Recently, when I was working on two sets of AIX5.3 + 10.2.0.4 RAC, I didn't find the AIX Toolbox for Linux Applications for POWER Systems CD. To make it simple, I used RSH as the remote node file copy method. After the database is installed, it is

1. Create oinstall, dba, and quota groups2. Oracle users 3. system parameter optimization (aio has been dynamically configured in AIX 6L and does not need to be configured. Running rootpre. sh to warn aio problems can be ignored) 4. Check the system

1. Description of the pseudo column on the official website From: 11gR2 Http://download.Oracle.com/docs/cd/E11882_01/server.112/e17118/pseudocolumns007.htm#SQLRF50953 Foreach row, ORA_ROWSCN returns the conservative upper bound system change number (

Oracle network perimeter Configuration Supports three application connectionsC/S application connection: sqlplus sys/x2145637 @ orclJava application connectionWeb client application connection Supported protocolsTCP/IPTCP/IP with SSLNamed

The index corresponding to a primary key becomes garbled. For SQL plus query: SQL> select INDEX_NAME, INDEX_TYPE, TABLE_NAME, UNIQUENESS from user_indexes where 2 table_name = 'oo _ OMS_USER '; The index name has three rows and is garbled: XP @ #@ R

It is important to back up your database when database tables are lost or damaged. In the event of a system crash, you must be able to restore as much data as possible from your table to the State at the time of the crash. This document describes

In Oracle databases, backup scripts can be executed on the command line, but cannot be executed on crontab. How to determine whether crontab is valid for oracle users in Linux. You can write a simple script that only contains the date command and

This article mainly explains the problem of MySQL optimization in the CentOS system, and describes some basics of MySQL optimization. MySQL optimization is divided into two parts. Physical server hardware optimization and MySQL optimization. The

DB_UNIQUE_NAMEDB_NAME In general databases, we can see that there is no special difference, but in Multi-instance and multi-data systems, these two are often mentioned. I accidentally think of the two as one stuff. Actually not. My personal

Command summary for Oracle Installation in Linux Su root Mkdir-p/up1/oracle Groupadd oinstall Groupadd dba Useradd-g oinstall-G dba-d/u01/oracle Passwd oracle Chown-R oracle: oinstall/u01 Su-oracle Vi. bash. profile ORACLE_BASE =/

1. The following describes the Oracle stored procedure! 2. Focus on the preparation, debugging, and application of stored procedures, rather than the introduction of too many syntaxes! 3. As long as you know the SQL statement, you can continue

The test is successful between two Oracle databases. The following is a summary: Requirements:There are two Oracle database servers A and B (A and B can be on the same Intranet or two independent machines on the Internet ). Both A and B have

1. parameter description Generally, the default value of db_block_size is 8 KB. From this perspective, the block size of the database is the same. However, Oracle can configure Multiple Block Sizes.   SYS @ anqing1 (rac1)> show parameter

Today, I started to understand the Oracle architecture and want to write down every part of the learning records. If something goes wrong, please point it out. Thank you. Related reading: Oracle System Overview-Data Dictionary Oracle System Overview-

1. Install XtraBackup If it is a 32-bit system, just put the content of xtrabackup0.9.zip in the bin directory of mysql. You can also compile the database together. Take 5.0.88 as an example:First download the source code:

The task is very simple. Copy the virtual machines in Beijing to a machine on the site, let them run, and simulate the real environment for users to perform exercises. In this case, if the production database fails, O & M personnel can switch