Database Administrator

Oracle Study Notes: sqlplus User Logon 1 sqlplus Login Local login (log on to the database server) Oracle Logon Sqlplus account name/password as role name 1.1 sys Login Example: sqlplus sys/oracle ERROR: ORA-28009: connection as SYS shocould be as

MySQL performance profiling tool (pt-query-digest) This tool is also from percona-toolkitOther tools in this tool setTroubleshooting of abnormal shutdown of MySQL Slave (pt-slave-restart) Verify MySQL master-slave consistency (pt-table-checksum & pt-

MyIsam is relatively simple to publish, just copy all the files in the library. The procedure of copying Innodb is similar to that of MyIsam, except that the table content in the Innodb Engine no longer exists in the same database directory (MyIsam

Keywords: host string in Oracle If the local SQL * Plus is used to connect to the local database, the "host string" can be blank. To remotely connect to the xp oracle database, use the following method:1. Start oracle-related servers in windows;2.

Finally, Oracle 10 Gb is successfully installed on RedHat Enterprise Linux 5.5 x64. The entire process is recorded as follows: I. Preparations before RHEL5 Installation 1. Set swap Partition Oracle 10 Gb installation requires that the swap space be

Mysql Command rename table syntax Rename table tbl_name TO new_tbl_name [, tbl_name2New_tbl_name2,...]Renaming is performed in atomic mode (atomically), which means that the table cannot be modified by any other thread when the renaming is running.

Oracle RAC also has HA (High Availiablity) and LB (LoadBalance), and its High availability is based onFailover (Failover)It means that the failure of any node in the cluster will not affect the user's use, and the user connected to the faulty node

ORA-00600: internal error code, arguments: [keltnfy-idmlnit], [46], [1], [], [], [], [], [], [], error When DBCA reaches 3%, an error is returned. An error is reported because/etc/hosts does not match/etc/sysconfig/network. [Root @ ocm2 ~] #

Oracle data comparison (DBMS_COMPARISON) and dbmscomparison Today is. I feel ashamed to have received an invitation from csdn to apply for a blog expert. I have never been able to write anything since I changed my job. Today, one of my colleagues

Sometimes you may use SQLPLUS spool table data. How can you speed up the spool? SQLPLUS has a row prefetch Option In SQLPLUS, the default arraysize is 15. SQL> show arraysizeArraysize 15 It indicates that only 15 rows of records are transferred from

View and modify the Oracle encoding format and modify the oracle encoding formatZookeeper first checks the encoding of the oracle databaseSQL> select * from nls_database_parameters where parameter = 'nls _ CHARACTERSET ';PARAMETER--------------------

Detailed configuration of the IDC charging system and detailed configuration of the Charging System Before you knock on the data center charging system, we need to configure the original system for use. The following is a detailed description of my

Environment: Database: 64-bit Oracle10.2.0.1.0 under AIX5.3 TSM5.4: Windows2003 With database: IBM3100 Problem description: 1. The error 3D32B80D occurs in the aix system. As follows: JTXXDBS01:> errpt | more Identifier timestamp t c RESOURCE_NAME

10.2.0.1.1 Start and Stop grid control, 10.2.0.1.1grid1. Stopping Grid Control and All Its Components1. stop OMS service [oracle @ ocm2 oms10g] $ cd/u01/app/oracle/OracleHomes/oms10g/bin/[oracle @ ocm2 bin] $. /emctl stop omsOracle Enterprise

Enable PHP OCI8 extension on LinuxTo add an Oracle connection to Linux, You need to recompile PHP.1. Download and install Apache Cd apache_1.3.31 ./Configure -- prefix =/usr/local/apache \ -- Enable-module = so \ -- Enable-shared = max \ --

MySQL join table, mysql joinOne of the most powerful functions of join SQL is to join tables in the execution of data search and query. Joined tables are based on Relational Tables. The following table lists the relationships. If multiple items

Mysql storage engine and mysql Storage08-mysql storage engine ---- Storage engine Introduction (1 ),InnoDBEngine InnoDB is a storage engine of mysql. innodb provides transaction logs, rollback, crash repair capabilities, and multi-version

Football and oracle series (4): from Brazil to Germany, think of the different RAC topology comparison !, OracleracFootball and oracle series (4): from Brazil to Germany, think of the different RAC topology comparison! Preliminary review: I was

Example (5) modify the column value on the primary key. The update operation is split into two statements. Continue with "Example of the upload data experiment (4) Verify that the upload data finds out the non-synchronization caused by the updata

Part 1 Database SQL language Database script file Layout   The Code layout of database script files has the following significance: (1) demonstrates a good logic structure of the Code, improving the accuracy, continuity, readability and