Database Administrator

System: openSUSE 12.1 x86_64Database: Oracle 10g r2 (10.0.2.0.4) 64-bit1. Check if the operating system fails:Modify SuSE-release under/etcAll values of 12.1 are modified to 9.0. 2. decompress the cpio.gz FileDecompress the fileMethod 1:Zcat lnx_920_

Oracle Import utility allows you to extract data from a database and write the data to an operating system file. The basic format used by imp: imp [username [/password [@ service]. The following describes common usage of imp. 1. Get help Imp help =

During the 11th holiday, it may not be easy. If the database reports an error and a critical business cannot be properly executed on a certain day, it must be processed immediately. Cause Analysis 1, log on to the database, view the host log, the

1. view the current database log ModeSQL> select name, log_mode from v $ database; orSQL> archive log list; (This method requires as sysdba) To archive a non-archive database, follow these steps:1. SQL> alter system set log_archive_dest_1 =

Move the Oracle database audit-related tables to other tablespaces: Because audit-related tables such as AUD $ are stored in the SYSTEM tablespace, it is best to move AUD $ to other tablespaces to protect the SYSTEM tablespace without affecting

To audit DDL operations in the database, you can use DDL triggers. This section describes an example to record all DDL operations in the database. This example can be used in Oracle 8i or later versions. Step 1: Create a tablespace and related log

After the active data guard is deployed, the read-only query can be handed over to the standby database for execution, and the routine database backup work can be performed on the standby database to relieve the pressure on the primary database,

I. Code /** Connect to the Oracle database * Database Name: abc * Table Name: my_oracle * User name: system * Key: 123 * Port: (default) 1521 */ Void MainDialog: connectOracle (QString sIp, int iPort, QString sDbNm, QString SUSErNm, QString

When a friend encounters a problem today, the following information appears in the alarm log: ORA-1591: lockheldbyin-doubtdistributedtransaction1.92.66874 Query the dba_2pc table and no distributed transaction information is

It has been several months since reids was studied and used. I have summarized a lot of documents and related materials. In the next time, I will share some relevant materials, this article also describes how to use it in our applications. The

1. Redis IntroductionRedis is a key-value storage system. Similar to Memcached, Memcached supports more storage value types, including string, list, set, and zset ). These data types support push/pop, add/remove, Intersection Set and difference set,

As a DBA, one of the common scenarios is: Create a tablespace: Create tablespace ThinkDatafile '/u01/app/Oracle/oradata/orcl/think. dbf' size 100 MAutoextend on next 10 M maxsize 4096 MExtent management local uniform size 256 KSegment space

How to solve a Java error when installing Oracle 11gR2 on AIX 6.1: Sys-/tools/database>./runInstallerStarting Oracle Universal Installer... Checking Temp space: must be greater than 190 MB. Actual 7005 MB PassedChecking swap space: must be greater

Fault symptom Oracle Database 11g Database common user login prompt ORA-28002: the password will expire within 7 days [11: 01: 00oracle @ dvd db_1] $ sqlplus wang/oracle SQL * Plus: Release 11.2.0.1.0 Production on Fri Nov 16 11:01:23 2012 Copyright

Linux: RHEL 6.3 Oracle: oracle 11g R2 (11.2.0.3) RHEL 6.3 is installed on two servers, oracle is installed on two servers, software is stored locally on the server, and database files are stored on the shared disk (iscsi used ), the first oracle

Problem: when using an implicit cursor like select into from tablename, if no data is found, an error in the ora-01403 is reported. Each time an explicit cursor is used, it is very troublesome to open the value. An experienced instructor suggested

Background Master-slave switchover is a necessary step for the high-availability MySQL architecture (that is, the use does not occur, but must be prepared ). Generally, it is set to double M (M1, M2). If the current status is M1 and M2 is read-only,

Oracle RAC client failover (failover). When using the TFA method, the client does not need to send a connection request again when the connected instance or node fails, the previous database operations can still be continued, which is called

When the Oracle database is connected to hang, there are two listener, one is the other sub-processThe process is as follows:1. When a problem occurs, the user connects to the hang and two listener occurs. The existing connection is normal.$ Ps-ef |

Ora_rowscn For each row of data, ora_rowscn returns the approximate time that each row was last modified. this is useful for determining when a row of data is modified. because Oracle uses transaction commit to track the data blocks of rows for scn,