Database Administrator

Database startup reports ORA-27154 ORA-27300 ORA-27301 ORA-27302 Error Today, my colleague encountered an Oracle startup problem, SQL> startup ORA-27154: post/wait create failed. ORA-27300: OS system dependentoperation: semget failed with status: 28 

Use shell to check whether the Oracle partition table contains default partitions In a system with large data volumes, partition tables are common. There are multiple types of partitions. You can select the partitions you need based on your business

Preliminary understanding of Oracle Partitioning technology I. partition type 1. Range Partitioning) Applicable to continuous/time-based data 2. Hash Partitioning) Suitable for non-continuous/fixed data records 3. Combined partition Range-Hash Range-

Oracle uses shell scripts to view procedure information A schema may contain a large amount of procedure. Sometimes, to view specific information, you must use tools such as toad and plsql dev. Sometimes, you can try to get rid of the graphic tool,

The index and index of the partition technology Partition series: Oracle Partitioning technology-first understanding http://blog.csdn.net/wanghui5767260/article/details/39158873 Index on Partitioning technology:

Simple installation of mysql and mysqlFor simple installation of mysql, we can download the binary distribution version of Mysql directly from the Mysql official website, such as LInux x86_64, and decompress the package to use it in green.

[11g architecture, 4] AMM (Automatic Memory Allocation Management), 11 gamm1. AMM (automaitc memory managerment)1. Automatic Management of oracle 10g SGA: SGA_TARGET specifies the maximum memory size that SGA can use. The size of each memory in SGA

Problem cases caused by HTTP500 errors and http500 Problems **************************************** ******************************** ****************  Original Works are from the "Deep Blue blog" blog. You are welcome to reprint them. Please note

Installation and Use of redis in linux, linuxredisZookeeper redis: 1. download: wget Repository :. /redis-server .. /redis. after config, you can add a configuration file to make the server run in the background and become a daemon. 4. log on to the

WAS cluster series (11): cluster creation: Step 9: Release the verification program, was Cluster(1) install the lab packageClick OK to go to the following page: Click "Next", for example: Note that the following steps are important. You need to

WAS cluster series (9): cluster creation: Step 7: add nodes and was Clusters(1) confirm the two-node time synchronization Make sure that the time error between nodes is controlled within 5 minutes. Otherwise, the addition of nodes will not be

Oracle: view the table space where the user is located; oracle: view the user's location View the tablespace of the current user select username,default_tablespace from user_users; Modify the user's default tablespace Alter user Username default

11g rac minor problems encountered when installing and running ASMCA: ASMCA detected pre 11gR2 ASM, but it does not have a local instance configure, win3211gr2client Problem description: 11g rac installation, GI has been installed, the status of

SQL advanced (7) Date function, sqldate FunctionSQL advanced (7) Date function SQL Date when we process a Date, the most difficult task is to ensure that the format of the inserted Date matches the format of the Date column in the database.As long

An error occurred while querying all database tables in MySQL. An error occurred in the MySQL database table. 1. Error description 1 queries executed, 0 success, 1 errors, 0 warnings query: show tables error code: 1046No database selected

Detailed process of user interaction with Oracle DB, process of user oracledb Interaction with Oracle DBThe following example describes the Oracle database operations at the most basic level. This example shows an Oracle DB configuration in which

Summary of common grep usage and grep Grep-E 'l \ {2, \} '2.txt grep-E' h (ell | a) o 'test.txt grep '[a-z] \ {5, \} 'test.txt grep-xf a.txt B .txt // query the row grep-vxf B .txt a.txt that a and B exist together. // The row that queries a is not

Use SQL statements to add an auto-incrementing primary key or delete a primary key or an SQL primary key to a table. When I first met this requirement, I searched the internet and found that I couldn't do it. I had to delete the primary key column

Mysql exports the queried data as excel and mysqlexcel Now you need to export some data from the mysql database to excel and print it. In fact, it is very easy to implement the above requirements, as long as you write the SQL statement, and then

Summary of keywords of database query statements, and Keywords of database statementsAfter reading the niuyun video, I wrote the background code in the first 17 episodes, especially when talking about query statements. I suddenly felt that the