Database Administrator

Database Version: Oracle 10.2.0.5-64Number of nodes: 2Operating system version: CentOS 5.6-64Awr report today finds gc buffer busy wait timeGc buffer busyThis wait event, also known as global cache buffer busy prior to Oracle 10g, specifies the time

ORA-01552: cannot use system rollback segment for... error resolvedFault symptom:Today, the database is not completely restored, but several tables need to be created as the base table for recovery when preparing the environment. When creating a

If you want to install the sample user in Oracle11gR2, you can use the example provided in the oracle official documentation. You can create an instance at the same time. You can also create a database after installing the database software database.

Master-slave synchronization: 1. Create a database directory Mkdir/mongodb/masterdb Mkdir/mongodb/slavedb_1 Mkdir/mongodb/slavedb2. 2. Start the Master/Slave servers respectively.Start the master server to listen to port

Environment: OS: Red Hat Linux As 5DB: Oracle 10.2.0.4 10 Gb later, Oracle launched the Storage method managed by Using ASM (Auto Storage Management). As the Oralce version keeps changing, the ASM storage management method is becoming more and more

1. Create Table T2SQL> create table t2 (A1 number (10 ),A2 char (10) tablespace users; 2. Insert two rows of dataSQL> insert into t2 values (33, 'cc ');SQL> commit;SQL> alter system switch logfile;SQL> insert into t2 values (44, 'dd ');SQL> commit; 3

OS: RHEL Server 6.3 MySQL:Mysql-5.5.25a.tar.gz Dependent packages: Ncurses-5.9.tar.gz Bison-2.5.tar.gz Install MySQL 1. Install the dependency package (1) ncurses [Root @ test ~] # Cd/data1/lnmp/ [Root @ test lnmp] # tar-xzf ncurses-5.9.tar.gz [Root

1. DUMP DatafileBlock example There are three types of SCN in a data block of Oracle: The Block header SCN, the CSC (cleanout SCN) and the commit SCN recorded in ITL. If we want to view the content of a block or some blocks, we can dump these blocks

Before the server process obtains the redo allocation latch for redo log buffer allocation, You need to sniff the redo log file to check whether there is sufficient space. If the space is insufficient, the sp will send a request for the switch log

In Oracle, copy the data of a table to another object. Usually there are two methods: insert into select and select into from. The former can copy N rows (0 to any number) from the select statement to a new table, and the latter can only copy the

This error was reported when two linux Red Hat 4 hosts were used to build RAC (10 Gb). The problem was solved later. I just set up RAC, can open Node 1, open Node 2, this error is reported, view the log of Node 1 as follows: SQL>Select * from v $

Oracle time addition and subtraction Recently, due to the time-frame addition and subtraction tests, I found some time addition and subtraction algorithms on the Internet, which can solve the pressing problem and help more Oracle

Use MySQL to generate a random password.DELIMITER $$CREATE    FUNCTION `t_girl`.`func_rand_string`(f_num tinyint unsigned,f_type tinyint unsigned)    RETURNS varchar(32)    BEGIN      -- Translate the number to letter.      -- No 1 stands for string

The installation of the Oracle RAC database is more complex than that of a standalone database, because the entire installation process involves network, operating system, and storage. Improper configuration of one link may lead to installation

The incremental checkpoint is used to balance the load. It is triggered by the fast_start_mttr_target parameter and is incrementally written out. Therefore, CHECKPOINT_CHANGE # is delayed and will not be updated immediately.Three methods are used to

No indexof () function in OracleHowever, an instr () method is provided for specific usage:Select instr ('South city of Baoding City ', 'city', 1, 1)-1 from dual;Explanation: 1. 'baoding City South region' => it can be an expression or a specific

The following experiments are only performed in MYSQL 5.0.45. Method 1: Use the mysql command to lock the table. Public VoidTest (){ String SQL ="Lock tables aa1 write"; // Or String SQL = "lock tables aa1 read "; // If you want to lock

1. Find the mwa. cfg configuration file. In 11i: $ MWA_TOP/secure/ In R12: $ INST_TOP/admin/install/ 2. Set mwa. cfg Trace level: mwa. LogLevel = TRACE 'Mwa. logdir' is the log output path. In R12, mobile logs are written to $ INST_TOP/logs.

Stop an Application Server Use the application system administrator user to log on Cd $ INST_TOP/admin/scripts (or cd $ ADMIN_SCRIPTS_HOME) In this case, run the following command in/u01/Oracle/mc3yd213/inst/apps/mc3yd213_bej301441/admin/scripts to

Oracle rac ocr and voting disk management tips. For more information, see. The Oracle Cluster Registry (OCR) file is a key component of CRS. Used to maintain information about High Availability components in the Cluster. For example, the Cluster