Database Administrator

Considering the batch launch of games, I wrote a game mysql deployment script. Because the system environment is the same, mysql is not installed in the script, but compiled and used directly by mysql. #! /Bin/bash #2013/11/20 # Email:

In the production environment, data files in the database will always be deleted by mistake. For example, SA does not know the database, and the online database log is redo01.log, or deleted after cp backup, data files are easy to be deleted by

SQL> execute dbms_repcat.add_master_database (gname => 'rep ', master => 'test', use_existing_objects => true, copy_rows => false, propagation_mode => 'synchronous '); BEGIN dbms_repcat.add_master_database (gname => 'rep ', master => 'test',

Operating System: AIX 6.1Oracle Database Version: 11.1.0.7.01. when exporting with expdp, the error "ORA-04030: out of process memory when trying to allocate 120048 bytes" is reported,The details are as follows: ORA-39082: Object type

Environment Introduction: Dual-host operating system: solaris 10 database version: oracle 11g R1 64bit 1. I received a call in the middle of the night, saying that the database reported a large number of errors. I checked the database and found the

The archive mode switching in the RAC environment is slightly different from that in a single instance, mainly because of the differences in shared storage. In this case, we can switch the RAC database to a non-cluster state and switch the archive

Change the system session mode to disenable restricted to create conditions for the initiation of snp. Alter system disenable restricted session; Job_queue_processes = 10 (oracle10gde default value)Job_queue_interval = N Alter system set job_queue_

Sqlplus login to oracle error ORA-12560: TNS: protocol adapter Error C: \ Users \ Administrator> setORACLE_SID = DDBC C: \ Users \ Administrator> SQLPLUS/AS SYSDBA SQL * Plus: Release 11.2.0.1.0 Production on Monday September 9 16: 41:

1. We will first add the Union unique index, which is generally to remove other fields after the id field ALTER ignore TABLE 'test' ADD unique INDEX ('Loan _ account', 'num', 'name', 'monney _ start', 'monney _ yue ', 'date ', 'end', 'lil', 'jiaoyi

When the Oracle database is started, it starts the Oracle instance based on the parameters provided in the parameter file. These parameters include the database name, sga, pga allocation, control file location, undo, process, and so on. Oracle RAC

Applications used in the RAC environment sometimes want a specific application to only run on the child node of the RAC, or assign a primary node to some applications. In this regard, Oracle 10 Gb can be implemented using services. I. cluster

In some specific circumstances, sometimes you need to connect to the specified instance in RAC from the client, instead of dynamically selecting the client Load_balance or forwarding the server listener Based on the load situation. In this case, you

Description of the switchover_status column in the dynamic performance view of v $ database in Oracle DataGuardHelloblock writing) SESSIONS ACTIVE Active SQL sessions exist in the primary database. These sessions must be disconnected before

The following is a description of the ORA-01555 from the online documentation Database Error Messages ORA-01555: snapshot too old: rollback segment number string with name "string" Too small Cause: rollback records needed by a reader for consistent

By default, sending an out-of-domain email using Reporting Service fails. The following two errors may occur: ERROR 1: Subpartition Error: "The e-mail address of one or more recipients is not valid ."   This error usually occurs when the SMTP

1. invalididentifier adds a comma at the end. 2. Change missingkeywordsreference to references. 3. missingrightparenthesisdefaultnotnullunique should be placed before the constraint 4. ORA-009922:

1. Check the oracle instance status: selectinstance_name, version, status, database_statusfromv $ instance; 2. Check the oracle listening process: $ lsnrctlstatus 3. $ ps-ef | grep "ora _" | grep-vgrep Oracle Data File writing process, the output is:

Create a new table: SQL> create table invoice 2 ( 3 invoice_id number, 4 vendor_id number, 5 invoice_number varchar2 (50 ), 6 invoice_date date default sysdate, 7 invoice_total number (9, 2 ), 8 payment_total number (9, 2) default 0, 9 constraint

Http://boylook.itpub.net/post/43144/520539;Well, since the last experience, we have to pull rowid in Table creation during the experiment to eliminate interference:SQL> create table t2 (ctn varchar2 (10), num number, r rowid );Table created.SQL>

Http://boylook.itpub.net/post/43144/520543 The biggest feature of MV data migration is its flexibility, which enables cross-platform and cross-database version migration and data restructuring and optimization. The implementation principle of this