Database Administrator

When I first arrived in the morning, my friend said that the database could not be started. Remote Start Up, prompt ORA-00600: Internal error code, parameter: [kcratr1_lastbwr] Read alert *. log, which is similar to this information. The tracing

In the clusterware and asm environments of Oracle 11g R2, we will run the Oracle 10g rdbms environment for the purpose of upgrading or migrating data. When using a 10 Gb rdbms to create a database, you must make some adjustments in advance.

ORA-01555: the snapshot is too old. A classic problem for Oracle DBAs.Root Cause: consistency reads the problem. I saw a classmate on the Internet. For example, I thought it was good. I 'd like to use it:Suppose there is a table named table1 with 50

Background_dump log: [Oracle @ HBCADB001 trace] $ tail-f/u01/sys_software/oracle/product/11.2.0/grid/log/hbcadb001/alerthbcadb001.log The warning Log File alert_sid.log stores routine information and error information. Its path is BDUMP. SQL> show

Rowid is a pseudo column that uniquely identifies a row in a table. It is the internal address of the row data in the physical table. It contains two addresses. One is the address pointing to the data file that contains the block of the row in the

Redis's master-slave replication function is very powerful. One master can have multiple slave instances, and one slave can have multiple slave instances. In this way, a powerful multi-level server cluster architecture is formed. Next I will

Using dbca to clone an instance does not need to be as tedious as restoring a Data Pump. It is similar to rman in terms of table space creation, User Creation, authorization, copy, and restoration. However, there is still a gap between efficiency

Current Environment DescriptionOperating System: AIXCluster software: HACMPThe following are the storage usage of the existing B-Host: Hdisk2 00c8970083c14f90 xxoraHdisk3 00c8970083c150c6 xxoraHdisk4 00c8970083c151d8 xxoraHdisk5 00c897b01a96a7a4

Baidu search has many articles about how to add and delete nodes, and this operation does not have much technical content. However, I tested it myself and recorded it for future queries, at the same time, I hope to provide some help to my friends in

Summary by year, statistics: Select sum (mymoney) as totalmoney, count (*) as sheets from mytable group by date_format (col, '% y '); Monthly summary, statistics: Select sum (mymoney) as totalmoney, count (*) as sheets from mytable group by

In the Oracle RAC cluster, the management of various resources also has the owner and permission issues. Crs_getperm and crs_setperm are a pair of commands used to view and modify the owner, group, and permissions of resources in the cluster. The

Case Scenario-when an Oracle database is exported: C: \ Documents ents and Settings \ Administrator> exp lsxy/lsxy @ lsxy_db file = E: \ lsxy. dmp owner = lsxy Export: Release 11.2.0.1.0-Production on Monday November 26 14:07:18 2012 Copyright (c) 19

The main problems encountered during Oracle 11gR2 installation are: 1. After the system parameters are set, the data set in the condition detection process during database installation is completely different from that detected by the installer,

Trigger execution sequence Combined trigger Enable and disable triggers Trigger execution sequence Oracle allows more than one trigger to establish the same time point, but it never guarantees their execution order. The Oracle 11g trigger syntax now

At present, many tutorials on the internet talk about MongoDB sharding configuration, but most of them have not gone through practical practices and are reproduced randomly. In addition, the different configurations of MongoDB versions are messy,

Recently, after reading the concept, I suddenly felt empty. Not much gossip. I used PLSQL to write a calendar printing function. Create or replace package display_date isProcedure display_spec_mon (year number, month number );End;   Create or

1 Requirement Send the important database AWR to the DBA mail on a regular basis every day. After receiving the AWR mail, the DBA simply checks whether the database has abnormal waiting tasks and abnormal SQL statements, try to avoid analyzing

After the page is not operated for a long time, the program will report an error when the page is operated again. The exception is as follows:   Com. mysql. jdbc. exceptions. jdbc4.CommunicationsException: Communications link failure Thelast packet

Limitations when using Oracle sequence currval and nextval Create a sequence Create sequence test_seq Minvalue 1 Max value 10000000 Start with 1 Increment by 1 Cache 20; Sequence values cannot be used in the delete, select, and update

Download the p8202632_10205_linux.zip patch to metalinkand upload it to the server. Perform the following upgrades:   1. Stop RAC [Oracle @ b87 ~] $ Srvctl stop database-d racdb [Oracle @ b87 ~] $ Srvctl stop asm-n b87 [Oracle @ b87 ~] $ Srvctl stop