Database Administrator

Oracle 10.2.0.4: OEM bug 8350262 1. Discover Problems Today, in the OEL 4 environment, we upgraded from 10.2.0.1 to 10.2.0.4, and then created the database in dbca. The database didn't move during the 91% period and waited for a long time. Finally,

First, you must understand that the physical structure of the database is determined by the operating system files of the database. Each Oracle database consists of three types of files: data files, log files, and control files. Database files

Install There are two ODBC types in linux: unixODBC and iodbc. Because wxGTK supports iodbc, you must install iodbc before installing wxGTK. When freetds is installed later, unixODBC may also be installed based on the environment and dependency. The

Three default system users Username and password Sys change_on_install (highest Network Administrator) Manager system local administrator Scott tiger common user 1. Start the cmd command of the Oracle listener: 1: name of the lsnrctl start listener (

Today, a vendor asked me a question. If you want to change the data type of a field in a table, whether it is a field type in View also responds to automatic changes. At that time, I thought it would be changed automatically. However, the vendors

Object-Oriented Programming (Chapter Summary), object-oriented programming chapter1. Object-oriented has three main features: encapsulation, inheritance, and polymorphism.2. If a class drug settings inherit, you must specify NOTFINAL; otherwise,

How to download the Grid method (Oracle RAC) on the OTN website, otngrid How to download grid software required by RAC Register an account and log on to the OTN website. Go to the download options and find the "server and storage system"

Because the RedHat Linux 5 system is launched 10 Gb later than Oracle, the official documents only support Oracle 10 Gb installation in RedHat 4. 1. You need to modify the operating system configuration file of RedHat 5 and change RedHat 5 to

The original version of a testing database of the company is Oracle 11gR2. Some of the 10g syntax is somewhat different. The boss said to re-build the test database and use the 10G version. Although it can be shut down, the data volume is not big,

Unable to connect to MySQL 1. Error description Error No. 2003 Can't connect to MySQL Server on 'localhost' (10061) 2. Error cause Open the task manager and close mysqld-nt.exe. 3. Solution Mysqld-nt.exe is a MySQL Daemon database service

Duplicate entry '000000' for key 1, duplicateentry 1. Error description 939 10:27:13, 104 ERROR (com. you. conn. JDBCConnection: 97112)-com. mysql. jdbc. exceptions. jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '20140901' for

This blog is translated from: Http://blog.mongodb.org/post/87200945828/6-rules-of-thumb-for-mongodb-schema-design-part-1? Mkt_tok = 3RkMMJWWfF9wsRonsq7Ldu % 2FhmjTEU5z14uUsUKGxhokz2EFye % 3D % 3D Note: This translation is not strictly translated. It

(1) In the English version of Oracle, the default date format is 'dd-MON-YY ', for example, '01-JAN-98' In the Chinese version of the Chinese version, the default ORACLE date format is 'day-month-Year', for example, '21-January-2003-'or '21-January-0

After Oralce is installed in normal steps and dbca is used to create a database, an error is reported, as shown in: The following error is reported in the Oracle Installation Log: [Thread-40] [12:23:54. 055 CST] [BasicStep.

I. Hot Backup Cold backup occurs when the database is shut down normally. When the database is shut down normally, it will provide us with a complete database. This article describes how to copy key files to another location during cold backup. The

Modified the Oracle 10g inside the SPFILE ***. ORA file, the database can not get up, hold the wrong ORA-27046: file size is not a multiple of logical block size. The reason is that the dynamic server parameter file (SPFILE) is a binary file and

MongoDB Sharding Cluster is a horizontally scalable mode. It is very powerful when the data volume is large. I have been trying to study three roles to build a MongoDB Sharding Cluster: 1. Shard Server: mongod instance, used to store actual data

Definition of implicit commit It is also known as automatic submission, that is, the process of executing the commit statement is not displayed, and the operations in the session are automatically submitted to the database. Implicit submission 1.

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,