Database Administrator

1. Explanation of imp Command Parameters [Oracle @ linux exp] $ imp help = y Import: Release 10.2.0.4.0-ProductionOnWednesday, September 16, October 5 15:48:13, 2011 Copyright (c) 1982,200 7, Oracle.AllRights reserved. By entering the

ORA-01031: insufficient privileges solution ################################### ############ NAME: troubleshoot connect internal.txt## DESCRIPTION:# Connect internal# Connect/as sysdbaPassword problems: # Refer (METALINK, OracleDOC ),# Metalink

Oracle 11g, ibm pc, winxp, dual-core 3 GHz, 3g memory 1. view the table structure SQL> desc test;Name Type Nullable Default Comments----------------------------------------------------Id number (8)SER_CODE VARCHAR2 (128)SOAP_ACTION VARCHAR2

By default, the RPM package or source code package of MySQL does not provide a graphical management tool. phpMyAdmin is the most famous among these tools. PhpMyAdmin is a PHP-based MySQL database management tool. PhpMyAdmin allows administrators to

MySQL replication Overview MySQL supports unidirectional and asynchronous replication. One server acts as the master server during the replication process, and one or more other servers act as slave servers. MySQL replication tracks all database

1. After some environment variables are configured during Oracle Installation, restart and log on to localhost login: InterfaceCause:======================================# Vi/etc/pam. d/loginAdd the following content at the end of the fileSession

A problem occurs when running the root102.sh script on node 2. You can only run the root102.sh script again, but the shut down ocssd prompt is displayed. bin, crsd. bin, evmd. after the three processes are killed, the system restarts and the script

1. modify the configuration of remote linux machines The configuration in the vim/etc/sysconfig/i18n file is as follows:LANG = "zh_CN.GBK" SUPPORTED = "zh_CN.UTF-8: zh_CN: zh: zh_CN.GBK"SYSFONT = "latarcyrheb-sun16" 2. Modify the Oracle environment

Dbca encountered this error when it reached 14%. After a netizen prompts me to check whether all libaio has been installed and check the installation of the next package: [Root @ R1 bdump] # rpm-qa | grep libaio Libaio-0.3.106-5 However, the

Recently, GoldenGate was used to migrate Windows Oracle10g to Linux Oracle11g. Record a problem:After the data is synchronized to Oracle11g, the test finds that the primary key conflict occurs when some applications insert data. Some tables that use

A table is knownTThe structure is as follows: TableT Name Subject Score Varchar2 (10) Varchar2 (10) Number (3) Cannot be blank Cannot be blank 　 (1)Create a table named according to the

I. Preparations before installationDownload Mysql source package: Recommended official site http://www.mysql.com/Configure the Ubuntu EnvironmentAdd a mysql user group and user:Groupadd mysqlUseradd-g mysqlCreate the directory required for

The following are common scripts for Oracle DBAs. 1. Check data buffer and shared zone hit rate Declare Reads_value number (15 ); Direct_value number (15 ); Lob_value number (15 ); Consical_value number (15 ); Db_value number (15 ); X number;

Since the level of developers is high and low, dba has limited energy, and it is impossible to solve the SQL statement problem in time! We plan to solve the slow database operation problem by imitating the methods of redo logs! 1. View

Specific installation and configuration:1)Preparations:Six machines with IP addresses192.168.0. (231-236)MGM node: 192.168.0.231 (232) SQL node: 192.168.0.233-234NDBD node: 192.168.0.235-236The system is RedHat AS 5.0The basic components are

Oracle memory configuration file: % Oracle_HOME % \ ora92 \ database \ SPFILETIANCI. ORA File Actually: SPFILESID. ORA file SID is a database service Run cmd Input sqlplus/nolog Enter the conn user name/password as sysdba Copy the Oracle \

Oracle in Linux is running after installation. Run ps-ef or top-u oracle. You can see the processes run as Oracle users. On the graphic interface, run $/usr/share/oracle/oracle11gR2/product/11.2.0/dbhome_1/sqldeveloper. sh to display the free Oracle

1. query result set (1) Data Structure Typedef struct st_mysql_res { My_ulonglong row_count; // number of rows in the result set (long or long) Unsigned intfield_count, current_field; // Number of columns in the result set, current

1. Automatic growth of identity: Applicable to MySQL, DB2, and ms SQL Server. It uses the primary key generated by the database to generate unique identifiers for long, short, and int types. Use auto-increment fields of SQL Server and MySQL. This

Data Table connections include:1. Inner join (natural join): Only the rows matching the two tables can appear in the result set.2. external connections: including(1) left Outer Join (the table on the left is not restricted)(2) Right Outer Join (the