Database Administrator

Hardware preparation environment: Hard drive: 16 SAS 15 k raid 5 with 512 MCache CPU: AMD 4-core two Memory: 16 GB Software environment: Operating System: RedHat AS4.6 2.6.9-67. ELsmp Mysql: 5.0. Performance Tuning based on different scenarios is as

Environment: Two HP ML570 Linux AS4.5 Oracle 10g The two servers perform Oracle RAC and connect to HP MSA1000 through SAN Switch Fault symptom: Because the cabinet where one Oracle rac node is located is out of power, two rac nodes are down at

The data synchronization function of mysql not only provides load balancing for database queries to a certain extent, but also provides great help for database redundancy, backup, recovery, and load balancing. The data synchronization function can

Supported platforms Supported Oracle Database versions The following Oracle Database versions are supported in the current Oracle GoldenGate 10.4 Oracle 8i (DML support only) Oracle 9.1 and 9.2 (DML and DDL support) Oracle 10.1 and 10.2 (DML and DDL

Google maps are queried based on Oracle. How does Google store maps in Oracle? Here we use the dbms_lob package to briefly understand the process. 1) create a t table: 00:32:04 hr @ ORCL (^ ω ^)Create TableT (a varchar2 (20), B blob ); The

1. PL/SQL Developer remember the Login Password When PL/SQL Developer is used, PL/SQL Developer needs to remember the username and password for logging on to Oracle for ease of work; Setting Method: PL/SQL Developer 7.1.2-> tools-> Preferences->

I. RDA description RDA (RemoteDiagnostic Agent) is a tool used by Oracle to collect and analyze databases. Running this tool does not change any system parameters. The data collected by RDA is comprehensive, it simplifies our daily monitoring and

What pl/SQL must understand:1. process, function, trigger is pl/SQL programming2. process, function, and trigger are in Oracle3. pl/SQL is a very powerful database process Language4. process. functions can be called in java programs. ----------------

Eclipse failed to connect to Oracle Database: ORA-12505, error code: Org. springframework. jdbc. CannotGetJdbcConnectionException: cocould not get JDBC connection; nested exception is java. SQL. SQLException: Listener refused the connection with

Today, the customer received their own test environment, resulting in a table from the source database to the target database, select * from tabname reported ORA-01435: user does not exist, select count (*) from tabname normal, I used to only

Cluster deployment The cache mode of JDG includes Local mode and cluster mode. This project is deployed in multi-node Clustered mode. Data is replicated between subsets of multiple nodes instead of all nodes. Using subset replication can improve

I. concepts related to RMAN backup 1. in RMAN backup, The tablespace does not need to be in backup mode. It backs up data files, archive log files, control files, spfiles, and backup sets, but does not back up online redo log files, temporary files

Environment Description:OS: aix 6.1DB: bare Oracle 10gR2 Device An error occurred while using rman to back up the entire database. If the 71 Data File fails to be backed up separately$ Rman target/ Recovery Manager: Release 10.2.0.1.0-Production on

Solution: Native: listNetInterfaces: [3] When Oracle 10201 RAC is rootI. Problem 10201 when RAC is installed on OEL5, the following error is reported for the root 2nd nodes:[Root @ o10n2 install] #/oracle/product/10.2.0/crs/root. shWARNING:

Oracle EM Grid Control is a centralized monitoring and management tool for Oracle databases, operating systems, and other applications. His developers gradually extended it into an Enterprise Console, or even replaced the network operation

The 11g active data guard implements rman backup for the standby database, so that the database can be backed up without affecting the external services of the primary database. The test is as follows: SQL> select OPEN_MODE, PROTECTION_MODE,

Finally, Nosql products are used. We are using MongoDB, which is currently popular. Of course it is not just a large stream, but a product that uses geospatial indexes. This is my configuration process in Gentoo Linux: 1, download the version you

8.3.4Renaming a Datafile in the Primary Database8.3.4 recommand the data file in the master database (that is, manually modify the same changes in the slave database) When you rename one or more datafiles in the primary database, the change is not

Using rman for cross-database and cross-server migration10g server: 192.168.182.20.oracle 10.2.0.1.0 RHEL 4 32bit 11g Server:Server 192.168.182.131 OEL5.8 _ 32 Oracle 11.2.0.1.0 32bit[Oracle @ oelr5u8-1 admin] $ uname-Linux oelr5u8-1.localdomain 2.6.

Among them, the first is similar to the pattern adopted by MapReduce 1.0, which implements fault tolerance and resource management internally, and the last two are the future development trends, some fault tolerance and resource management are