Database Administrator

I have always been used to learning C ++ through source code. Last month, I made a fuss about the SGI's STL source code. After all, the configuration process was smooth under Win, you can refer to the STL source code of Hou Jie. I will go deep into

Linux:[Root @ rac1 ~] #Lsb_release-LSB Version: core-4.0-amd64: core-4.0-ia32: core-4.0-noarch: graphics-4.0-amd64: graphics-4.0-ia32: graphics-4.0-noarch: printing-4.0-amd64: printing-4.0-ia32: printing-4.0-noarchDistributor ID:

Database creation script:   Drop TablePerson Create TablePerson ( IdVarchar(32)Not Null Primary Key, NameVarchar(20)Not Null, PasswordVarchar(20)Not Null, SexVarchar(20 ), EmailVarchar(30)

I have never been familiar with Oracle databases before, and I have been using MSSQL. Speaking of the SQL statements of these two databases, there are many differences. I cannot tell the specifics, daniel knows better than me. Here I just want to

Oracle 10g Installation Summary under RedHat Enterprise Linux 5. Two figures are shown first: DBA is the direction of hard work. Oracle DBA is all-encompassing. It cannot even be used in Linux/UNIX. What Oracle should I do. Two parts: 1.

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

Open the/etc/my. cnf file and modify the following settings. If not, add it manually. # Cancelling the external lock of the file system Skip-locking # Do not perform domain name anti-resolution, pay attention to the resulting

1. Clone Process Oracle@www.bkjia.com ~ $ Dbca 1. After running DBCA, select "manage template ". 2. Select "create from existing database (structure and data" 3. Select the name of the instance to be cloned. 4. Enter the Template Name and

I plan to play with RAC on a virtual machine. I made a google call and found that most of the information is based on this post (). I used VMware Server to create shared storage based on bare devices, oracle official information

1 move ExperimentSQL> create table my_objects_move tablespace ASSM as select * from all_objects where rownum Table created   SQL> select value 2 from v $ mystat, v $ statname 3 where v $ mystat. statistic # = v $ statname. statistic # 4 and v $

If you want to create a table with a known table structure in db2, you can use: (1) create table a as select * from B where 1 <> 1; ---- only create a table without importing data. (2) create table a as select * from B ---- create table a, and

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

Here is a test of rman backup and recovery: The database is in the mount status and cannot be connected by other users:SQL> select status from v $ instance; STATUS------------MOUNTED SQL> conn scott/OracleERROR:ORA-01033: ORACLE initialization or

1 about undoThe database can have more than one undo tablespace;Undo segments can automatically grow, shrink on demand 2 about Oracle Data Dump export and importYou can change the table name during the import operation;You can override an existing

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

(UR) UNDO_RETENTION in seconds(UPS) Number of undo data blocks generated per second(DBS) Overhead varies based on extent and file size (db_block_size) UndoSpace = [UR * (UPS * DBS)] + (DBS * 24) In the above formula, 1st and 3 parameters can be

Recently, I was working on an Oracle project for a database. It was also my first project module. It felt a lot of pain, but there were a lot of GAINS. The following are my problems and solutions. I am a cainiao-level expert. If you find any errors,

Hibernate is usually used in three types: hql query, QBC query, and QBE query:1. QBE (Qurey By Example) Retrieval Method QBE is the simplest, but its function is also the weakest. It is not very powerful and only useful in some scenarios. A typical

ERROR-ORA-12541: TNS: No listener 1. If it is on this machine, it means that the Oracle client and the oracle server are on one machine. This problem occurs because the service and listener are not started. Computer --- management ---- Service