Database Administrator

Oracle RAC background process Introduction There are more processes in the Oracle RAC database than in a single instance database. These processes are unique to RAC and are set to implement cluster database functions. This article will introduce RAC-

ORA-07274: spdcr: access error, access to oracledenied. Symptom: The ORA-12545 error is reported when SQL plus/as sysdba logs into the database, as follows: [Oracle @ source ~] $ Sqlplus/as sysdbaORA-12545: Connect failed because targethost or

Install Oracle 10g + RAC in RedHat 5.5 The cost is relatively low, the technology is mature, and the function is powerful. This solution will become more and more favored by small and medium-sized enterprises. I. Preparations before the

Build a MySQL cluster in Linux I. Objectives 1. Install MySQL-Cluster software packages. 2. configure management/data/SQL nodes in sequence. 3. Start and test the MySQL-Cluster architecture. Ii. Solution Use six RHEL 6.5 virtual machines ,. Among

Oracle 11g column-to-row listparts It is a little difficult to switch between the first 11g of Oracle, and it is very simple after 11g. Currently, a test table records the approval information of a document. The id is the primary key of the Approval

Generate awr report and awr report References: Http://343766868.blog.163.com/blog/static/48314056201110124513396/Overview Oracle stores critical system statistics and load information at a certain frequency to generate snapshots. All snapshots are

Sort related concepts in oralce and oralce 【Database Name] Concept:It is a database identifier, which is equivalent to our ID card. If multiple databases are installed on one machine, each database has a database name, when these database names are

The ID and data id of the saved data record are queried when the data is saved. The record ID of the data is retrieved when the data is saved. Insert into Table (a, B) values (1, 2) select @ identity How can I save the access database and return the

Hibernate and hibernateIn this example, the relationship between students and teachers is a typical multi-to-many relationship. A teacher can have multiple students, A student can have multiple teachers. A student table is required to store student

Mysql Command for viewing table structure and table creation, mysql Command for viewing table structure 1, desc tablename; mysql> desc authors;+-------+--------------+------+-----+---------+----------------+| Field | Type | Null | Key |

[MonogoDB] The high update operation of MongoDB, monogodbmongodb In the last four blog, we talked about the high query operation of mongodb. Now in this blog let's know about the high update operation about monodb.1. Saveas for save (), whose

OGG-01224 Bad file number, ogg-01224bad Today, when reading the OGG log, found the following OGG-01224 Bad file number error, read the information to know the port is not available, looked at the mgr parameters, found that is set DYNAMICPORTLIST

GCS shadows traversed, 4001 replayed, traversedreplayed The following error is found in the log of the first node of the rac set in the inspection instrument today:LMS 8: 7888 GCS shadows traversed, 4001 replayedLMS 2: 7957 GCS shadows traversed, 40

[11g architecture, 5] rowid, 11g architecture rowidI. rowidThe extended rowid is displayed in a 64-based encoding scheme. The rowid is a data ID card number. It has a total of 18 bits, 6 bits, 3 is the file number, 6 bits, and 3 bits. The first 15

[MongoDB] Download the mongoDB, mongodbdownload First open the broswer and type the following url in the address bar. Http://www.mongodb.com/ Then you will view the next page. Click the download mongodb button, and then register a

Rman compatibility overview, rman OverviewIs Microsoft keyboard compatible? Key-bit conflict!Changing the key position. However, some keyboards still conflict with each other. There is no way to change the keyboard.We recommend that you do not buy a

MySQL grouping and sorting takes the first N records and generates an automatic number sequence -- group by after limit plus rownumber, -- grouprownumber My colleague asked me to group by column and then extract the first few items from each

Network-related or instance-specific errors occur when you establish a connection with SQL Server !, Sqlserver When I was working on a data center charging system, my database often encountered "network-related or instance-specific errors when

Oracle modifies the field type and length, and oracle modifies the field Modify the field name in Oracle Alter table name rename column old field name to new field name Modify the field type and length in Oracle Alter table name modify Field

Is it true that Select * does not go through the Index ?, Select Index The index indicates that the execution plan of the SQL statement uses 1. Clustered index search 2. index search, and the where clause must be included in the query