Database Administrator

Oracle case study ORA-01722 troubleshooting 1.1. ORA-01722 Date: Environment: test environment [Scenario description] During Database Upgrade, execute SQL> @? /Rdbms/admin/catupgrd. SQL script reports an error and exits. Install Oracle 11gR2 (x64)

Dual in Oracle For Oracle dual, we need to clarify the following points: First pointDual is not a acronym but a complete word. Dual refers to logarithm, Which is dual and dual when used as an adjective. Second pointThe dual table in Oracle is a

Build and manage Oracle 11g Active Data Guard Note: You can refer to the notes and ideas of many people on the Internet, and sort out notes after your own hands-on experience for your reference only. Data Guard differs from RAC in that in general,

How to Create a tablespace in Oracle Create a tablespace in Oracle CREATE [UNDO] TABLESPACE tablespace_name[DATAFILE datefile_spec1 [, datefile_spec2] ......[{Mininum extent integer [k | m]| BLOCKSIZE integer [k]| Logging clause | FORCE LOGGING|

RMAN backs up the database and restores it to another machine. 1. dbid and data file name query on the source database run in archive ModeSelect dbid from v $ database;Select file #, name from v $ datafile;Create pfile from spfileSelect * from v $

INSTR and SUBSTR functions in Oracle 1. INSTR Functions Syntax:Instr (string1, string2 [, start_position [, nth_appearance])Parameters:String1: Source string to be searched in this string.String2: string to be searched in string1.Start_position:

Greenplum synchronization to Oracle script Developed a solution to synchronize data from Greenplum to Oracle, and wrote a script for regular scheduling. Installing Oracle 12C in Linux-6-64 Install Oracle 11gR2 (x64) in CentOS 6.4) Steps for

Use of innodb_memcache Innodb_memcache is compatible with the memcache protocol and can be used by mysql to provide memcache with the replication function! GET[root@www share]# echo 'get aa'|nc localhost 11222VALUE aa 0 12HELLO, HELLOEND Get

Error Caused by ORA-09925: Unable to create audit trail file When I practiced manual Oracle database creation today, I set the path in the parameter file audit_file_dest incorrectly and reported an error during startupnomount, After modification,

Detailed description of Oracle user Creation 1. User conceptsThe user, that is, the user, is generally the "person" who accesses the Oracle database ". In Oracle, users can control various security parameters to maintain database security. These

How Does Oracle 11g modify AWR retention period less than 8 days? Oracle Database 11g has a system-defined Moving Window Baseline by default. This Baseline corresponds to all AWR data during the AWR retention period.Only one Moving Window Baseline

Install SQL Developer on RHEL5 The process of installing SQL Developer is relatively simple. You should first install java support and then install the SQL Developer software. The order can also be reversed. Then configure the Java point of SQL

Correct usage of MySQL triggers I. Basic syntax for creating a trigger:Create trigger name BEFORE | after trigger event ON table name for each row trigger statementTrigger events include INSERT, UPDATE, and DELETE. MySQL trigger application

Reconstruction after physical DG slave database corruption Because the data is rebuilt, the data files, log files, and dump files in the physical slave database that were rebuilt in the original DG Environment can be deleted. Remember that the

Preparations before installing Oracle 11g RAC in Linux Installation environmentOperating System: RHEL6.2 64bitOracle Database Version: 11.2.0.3Oracle Grid: 11.2.0.3 Software: RHEL6.2 64bit, linux_11gR2_grid, linux_11gR2_database Configure rac ip ----

Change the Oracle database connection Port The default database listening and connection ports of Oracle databases are 1521, but sometimes the default ports need to be changed in the project. In this way, the customer requirements are usually based

Verify MySQL master-slave consistency (pt-table-checksum & pt-table-sync) Percona-toolkit-2.2.8-1.noarch.rpm has two tools to verify MySQL master-slave Data Consistency Installing tookkit requires some dependent packages Yum install perl-DBI

In-depth Oracle RMAN backup analysis-online backup RMAN> backup database plus archivelog; This command will trigger the following operations: 1. The process uses the alter system archivelog current command to complete log switching. 2. The process

[RMAN] Recovering data from RAC to a single-host environment Data Recovery from RAC to a single-host environment I. Summary With more and more RAC environments, the need to migrate RAC data to a single-host environment also increases. How can we

Oracle OS verification Logon Username and password are our most common security authentication policies and the most common security protection policies we use in various application system software. It is a natural responsibility for Oracle to