Install Oracle on bare devices on AIX

Install Oracle on bare devices on AIX Recently, new systems have been released. I have not prepared documents for installing Oracle on AIX. I have prepared a document for future reference. The simple steps are omitted here. 1. view the system

Configure Cacti to monitor MySQL database status

Configure Cacti to monitor MySQL database status MySQL itself is not powerful in performance monitoring, which makes many MySQL DBAs sleep at night. Fortunately, the MySQL database status is monitored through Cacti (monitoring rather than monitoring.

Oracle 10 Gb database creation and remote access configuration

Oracle 10 Gb database creation and remote access configuration Recently, Oracle was used in the project, with oracle10gb. because many people in the group use the database, and the oracle database occupies a lot of memory, it is placed on a separate

Query errors caused by corrupted MongoDB index files

Query errors caused by corrupted MongoDB index files Problem description: When MongoDB is disabled abnormally, the index file may be damaged, and the data is not reflected in the index when the data is updated. Solution: Use scripts to recreate

Expdp impdp Database Import and Export commands

Expdp impdp Database Import and Export commands 1. Create a logical directory. This command does not create a real directory in the operating system. It is best to create a directory as an administrator such as system.Create directory dpdata1 as 'd:

ORA-01536: exceeds the space limit for tablespace XXXX

ORA-01536: exceeds the space limit for tablespace XXXX /******************** ORA-01536: exceed the space quota of the tablespace XXXX *******************/ /******************** ORA-01950: the table space FMISINDEX has no permissions *****************

Oracle flashback flash back topic

Oracle flashback flash back topic 1. Introduction to flashback:Flashback is used at the following frequency:1> flashback query records that are flashed back to the table for data table record recovery;2> falshabck Table flashback data Table;3>

Oracle functions-advanced

Oracle functions-advanced Below are some of the Oracle functions-advanced: 1. CATSTRExample: select catstr (COLUMN_NAME) NAME_LIST FROM DBA_TAB_COLUMNS where trim (TABLE_NAME) = 't_rz_dkdata '-- the query result is in a column.2. INSTR () string

Use mysqlbinlog to restore data based on location or time point

Use mysqlbinlog to restore data based on location or time point MySQL backup generally uses full backup and log backup. For example, a full backup is performed every day and a binary log backup is performed every hour. In this way, you can use full

Query the size of a table with a lob field in the Oracle database

Query the size of a table with a lob field in the Oracle database Note: Because the lob field has an independent lob segment for storage, for a table with a lob field, you cannot only query dba_segments. The following scripts are from: How to

Oracle ASM errors-ORA-15033

Oracle ASM errors-ORA-15033 Oracle ASM errors-ORA-15033 System Environment: Operating System: AIX 5.3.8 Oracle: Oracle 10gR2 Fault symptom: SQL> create diskgroup datafile 2 normal redundancy Failgroup fg1 disk '/dev/rlv_data1' 3 4 failgroup fg2 disk

Redhat 6 Oracle 11g RAC Installation notes

Redhat 6 Oracle 11g RAC Installation notes I recently installed 11g RAC on RedHat 6. I have encountered several precautions to share with you: Install Oracle 11gR2 (x64) in CentOS 6.4) Steps for installing Oracle 11gR2 in vmwarevm Install Oracle 11g

Oracle Data Pump details

Oracle Data Pump details Comparison Between Data Pump and conventional method: Oracle introduces Data Pump at 10 Gb. Compared with traditional exp/imp, data pump can separate jobs, and can suspend and resume Import and Export tasks, you can restart

[RMAN] use duplicate to copy the database locally

[RMAN] use duplicate to copy the database locally Task: the same host uses RMAN duplicate to copy the database. In the linux operating system, there is a set of running database aux after enmoedu replication. Tutorial steps: 1. master database RMAN

EM database reconstruction manual deletion of Database

EM database reconstruction manual deletion of Database Because the original database has been deleted, you need to use the listener when redoing the oem. At this time, the following error is reported: [Oracle @ localhost ~] $ Emca-repos recreate Jul

Oracle Study Notes: Use of the graphic management tool EM

Oracle Study Notes: Use of the graphic management tool EM Use of common Oracle learning notes tools-EM Graphics Management Tool em Server 1 Ensure Listening Starts -----> grid Lsnrctl status Or Netstat-tunlp | grep 1521 If not Lsnrctl start 2.

Oracle automatic backup solution in Linux

Oracle automatic backup solution in Linux As a DBA, every full-Database Backup can be performed only when others do not use the database (I know there are other methods, this article only considers export ), with the following two parts, you can

Install MySQL 5.5 in Linux source code

Install MySQL 5.5 in Linux source code This article describes how to install mysql5.5 in the source code. The system used is CentOS6.5. 1. Install the corresponding development environmentYum install-y ncurses-develYum install-y libaioYum install-y

Oracle backup and recovery Series

Oracle backup and recovery Series Tutorial Environment Introduction:Create a test user snow. The user has a table and a stored procedure. A task takes effect easily by simulating a user inserting a timestamp every minute like a database to generate

Why MySQL transactions cannot be rolled back

Why MySQL transactions cannot be rolled back When using MySQL, if you find that the transaction cannot be rolled back, but the Hibernate, Spring, JDBC and other configurations do not have obvious problems, don't worry, first check whether the table

Total Pages: 1013 1 .... 448 449 450 451 452 .... 1013 Go to: GO

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

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.