PHP

A test user scott was created manually and no problem was found during Remote logon. In this case, some users in the database restrict logon. See error no.: ORA-20001 A test user scott was created manually and no problem was found during Remote

Oracle provides DBCA to create databases. For Beginners, using DBCA to create databases simplifies a lot of work and settings, allowing them to implement all functions directly on the interactive interface. However Oracle provides DBCA to create

Using Hard links to delete large MySQL files in seconds, when multiple files point to the same inode and inode connections Ngt; 1. deleting any file is extremely fast Using Hard links to delete large MySQL files in seconds, when multiple files point

Xtrabackup is a tool used to back up InnoDB data. It supports online Hot Backup (which does not affect Data Reading and Writing during Backup) and is a great tool for InnoDBHotbackup commercial backup tools. Xtrabackup is a tool used to back up

ORA-02097, ORA-00837 (a small problem encountered when modifying memory_target) ORA-02097, ORA-00837 (a small problem encountered when modifying memory_target) Today I saw a little questions about ocp, I did a small experiment, encountered two

In Oracle, check whether the index SELECTheight needs to be reconstructed, * HeightoftheB-Tree * blocks, * Blocksintheindexsegment * na In Oracle, check whether you need to reconstruct the index SELECT height,/* Height of the B-Tree */blocks,/*

Monitor Data Backup recovery progress (EXPDPIMPDPRMAN) Monitor Data Backup recovery progress (EXPDP/IMPDP/RMAN) 1. view the progress of EXPDP/IMPDP1. Two views When you export a large volume of data, some people may be anxious to see the

When shutdownimmediate is used to shut down the database, hang is used to view the alert Log, and SHUTDOWN: Activeprocessespreventshutdownoperation is encountered. When shutdown immediate is used to shut down the database, hang is used to view the

The database instance name is dave. Because it is made into RACstandby, the database's db_unique_name is changed to dave_st. This is no problem in a single instance, The database instance name was originally dave. Because it was made into RAC

When inserting a table under Oracle, you must update the value of another field based on the value of one field. Of course, it can be easily implemented through the program, but this field is only a number When inserting a table under Oracle, you

Viewactsasavirtualtable. Viewsareavailableinbinaryreleasesfrom5.0.1andup. The view is supported from 5.0 and is a virtual View acts as a virtual table. Views are available in binary releases from 5.0.1 and up. The view is supported from 5.0 and is a

Because the rm and find methods Delete the actual archive logs and release the space, the archive information stored in the control file is not completely cleared. Still occupying some space Because the rm and find methods Delete the actual archive

1. Download The MySQL5.5deb installation package cdusrlocalsrcsudowget-Omysql-5.5.22-debian6.0-i686.debdev.mysql.comgetDown 1. Download MySQL 5.5 deb installation package cd/usr/local/src sudo wget-O mysql-5.5.22-debian6.0-i686.deb

1. The default port for connecting to mongodb is 27017. Therefore, we connect to mongodb: $ mongodbnewMongo ( 1. The default port for connecting to mongodb is 27017. Therefore, we connect to mongodb: $ mongodb = new Mongo ( 1. Connection The

This view can be viewed as a logical Standby operation log. If an error occurs, you can view the recent logical Standby operations in this view. By default This view can be viewed as a logical Standby operation log. If an error occurs, you can view

The Oracle listener is a server program used to listen to all requests from the client and provide database services for it. Therefore, listener management and maintenance are very important. Ben The Oracle listener is a server program used to

Three database instances run normally on a RAC (ORACLE11.2.0.3) with two nodes. Recently, if you want to switch the archive mode of the database, you will have to stop a database that has not been officially invested. Three database instances run

For high-precision items, such as money, I will use the decimal type and will not consider float or double, because they are prone to errors. numeric and decimal are synonymous, num For high-precision items, such as money, I will use the decimal

Let me start the database manually. I decided to spend some time studying the settings of Oracle Auto-restart with Linux. The specific method is as follows: Let me start the database manually. I decided to spend some time studying the settings of

RMAN-00600: internalerror, arguments [10019] [krmxcr] [] [] [], today do physical dg, a rac with a single machine dg. Perform recovery from different machines first. RMAN-00600: internal error, arguments [10019] [krmxcr] [] [] [], today do physical