Database Administrator

The control file is successfully restored after the catalog is configured in Oracle. Besides, the configuration of catalog is as follows: 1: catalog Database:Export Oracle_SID = ezhoudg1> Create a tablespace in the catalog Database for

Oracle CRS-0184 cannot talk to crs daemon Oracle 11g rac crs process restart Error 1. The above error occurs when you create a rac cluster. Delete the/etc/oracle/scls_scr/rac1/oracle/cssfatal file on node1.

MongoDB 2.6.4 master-slave Synchronization MongoDB standalone Master/Slave Mode 1: Start the master [Bkjia @ bkjia04 mongodb-linux-x86_64-2.6.4] $ mongod -- dbpath/home/bkjia/mongodb-linux-x86_64-2.6.4/data -- port 10000 -- master2014-09-05T15: 11: 5

Simple Analysis of Oracle Data Storage In the database storage structure, we know that a table is generally stored in the corresponding data file, and the data file can be divided into multiple segments. Generally, a table corresponds to a data

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

Install Oracle Enterprise Cloud Control 12C in Linux 6.3 The installation of Oracle enterprise cloud control 12C is a complicated process, because it depends on Kernel El database and Oracle Weblogic. Now Oracle has integrated Weblogic into the

Brief Introduction to MongoDB Data Models MongoDB data is particularly flexible. Compared with SQL databases, it does not need to define the table structure before inserting data. MongoDB collections do not emphasize fixed document structures. This

Unless TOP or for xml is also specified, the order by clause is in the view, inline function, derived table, subquery, xmlorder Error: Unless TOP or for xml is also specified, the order by clause is invalid in views, inline functions, derived

Picked Lamport scheme to generate SCNs, lamportscns Fault symptom: Database Node 1 fails to open the database instance after it is suspended and restarted. The warning log has no error. There is only one record: Picked Lamport scheme to generate

Atitit. hbnt orm db new update best practices o99, ormo99 Atitit. hbnt orm db new update best practices o99   1. merge and save. 1 2. The POJO object is in the free, persistent, and hosted state. Use of merge. 1 3. @ DynamicInsert @ DynamicUpdate 2 4

New methods for configuring synchronous replication in mysql5.6 and solutions to common problems, new methods for mysql5.6 Mysql5.6 adds a method that does not need to set the log_bin file and log location. Before that, we need to view the master

Mysql obtains the current time and compares it with the time in the field a few days ago. mysql current timeDelete from zhongqiu WHERE caretatime The caretatime field is a time field.'Caretatime' timestamp not null default CURRENT_TIMESTAMP,-14 days

WAS cluster series (14): WAS cluster optimization, cluster was **************************************** ******************************** ****************  Original works, from the blog of "Deep Blue, Welcome to reprint, reprint, please be sure to

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.

[Oracle11g, 9] control file, oracle11g ControlI. Role of the control file: 1. records the physical status of the database. 2. Maintain database consistency. The control file records the database system scn number, the data file scn number, and the

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 (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

Access from the SQL server is not allowed. access from the SQL Server I remember that I added sqlservr.exe to the internal access table of the firewall, and telnet can also be connected, However, SSMS cannot be connected, and the instance name is