The shared script is tested in the ORACLE11G test environment installed in LINUX. If you want to use it in your own environment, modify the relevant parameters. Use sourcehomeoracle. bash_profi
The shared script is tested in the ORACLE 11g test
The maintenance of Oracle11gRac is a little more difficult than that of 10 Gb, and there are more commands. The following is one of the solutions used in the maintenance of 11grac Votedisk, OCR, and various resources.
Oracle 11g Rac maintenance is a
CentOS6.3 32-bit operating system by default will install lib files such as mysql-libs-5.1.61-4.el6.i686, so it will conflict with MySQL5.6.10 installation file, the first installation
CentOS6.3 32-bit operating system by default will install lib
Often encounter problems where Client-dependent tools such as PLSQLDeveloper cannot connect to the Oracle Database Server. So far, it is not completely clear. I will first post to summarize the current problem.
Often encounter problems where
Today I learned about Oracle backup while performing altertablespaceusersbeginbackup; then there is: Row 1st error: ORA-01123: unable to start online backup
Today I learned about Oracle backup after executing alter tablespace users begin backup;
In the past few days, I am going to re-learn and sort out the knowledge system. At the same time, I will divide some things into functional modules. So. Mysql operations become the first key point. I wrote a simple mysql operation class to implement
After the customer's production database server is restarted, the local time is different from the listener connection time, which is 13 hours slower than our actual time.
After the customer's production database server is restarted, the local time
Find the specific trace file based on alert. Note that unlike normal deadlocks, the following Blocker (s) and Waiter (s) are the same sid, and the trace contains the SQL statements being executed and
Find the specific trace file based on alert. Note
Many users encounter Oracle listening configuration problems when learning Oracle databases. The Client cannot connect to the Server ). This article monitors Oracle
Many users encounter Oracle listening configuration problems when learning Oracle
The company developed a public account platform for a hotel alliance. During this period, it was estimated that it would take more than a month to implement other projects, early Development has basically been completed, because this public number
This article mainly introduces a PHP error and exception handling class with a very good display effect. The code is clear and powerful. For more information, see the following ,:
II. Implementation Code
The Code is as
We all know what kind of execution method is selected for Oracle SQL statements starting from 10 Gb, whether it is full table scan, or whether the index is based on the execution cost. How can we see the execution cost?
We all know what kind of
This article describes how to use FFMPEG in PHP to obtain video thumbnails and video durations. For more information, see
The Code is as follows:
// Obtain the thumbnail of the video fileFunction getVideoCover ($ file, $ time, $ name ){If (empty ($
When the operating system where the database is located crashes and the database system is restored, make sure that all the files (installation files, data files, and log files) in the database are in one partition, and
When the operating system
This article mainly introduces how Codeigniter performs URL redirection after user login verification. If you need it, refer to Codeigniter to process URL redirection after user login verification, it mainly involves the My_Controller.php page and
Today I suddenly encountered a ORA-00600 error while shutting down the database normally in the test environment, my database version is 10.2.0.411: 32: 57MYHSZHLC @ SYSgt; shutdownimmedi
Today I suddenly encountered a ORA-00600 error while shutting
The primary role of log resetting is to Discard unused redo logs during Incomplete recovery and ensure that subsequent recovery is not needed. To do this, the reset log option adds all online logs and
The primary role of log resetting is to Discard
According to the ORA-01017 prompt is connected to the other side of the User Password error, so directly use the configured User Password (lsxylsxy) to log on to the database found normal login, further
According to the ORA-01017 prompt is connected
Create a sequence in the Oracle database. When using SQL statements to write data to the database, use the unique value generated by the sequence to implement auto-increment of the primary key value in the table.
Create a sequence in the Oracle
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service