Database Administrator

Since Oracle said it was about to provide Linux support at half the price, choosing Oracle or Redhat has become a big problem. However, Gartner recommends that users who want to use Oracle services first test system compatibility and decide whether

The installation speed is too fast. A command is completed in two or three minutes.# Installing Oracle with Linux characters# Local hardware configuration:* Hardware:* CPU: ALTHON64-K8-2800 + box* Motherboard: MSI K8T-NEO-V* Hard drive: WDC WD1600BB-

When logging on to phpPgAdmin: If you always get a "Login failed" and confirm that you have used the correct username and password and can log on normally in pgadminIII! Solution: Modify php. in the ini configuration file, set extension = pgsql. so

Like Mysql in windwos, the default settings are latin1. they are not the gbk we need, or big5. so we still need the user's settings:Whether the login uses telnet or directly enters mysql in Linux: Find the my. cnf file

Yesterday BitTorrent announced the closure of source code, and today's famous database software MySQL also announced the closure of source code.MySQL has announced that it is about to shut down the source code of the MySQL Enterprise Server. This

There is no theoretical basis as described below, which is purely an experience. MySQL uses version 4.1 or later, and uses the default for whatever character set it is. You do not need to set MySQL. Then an example of using GB2312 and UTF-8 is

OpenSER homepage: http://www.openser.org Download: http://www.openser.org/pub/openser/latest-1.2.x/src/openser-1.2.2-tls_src.tar.gz Preparation Test Platform for Fedora8, pre-installed MYSQL-5.0.45; Need to install the corresponding MySQL-devel-5.0.4

How to start em and isqlplus of Oracle10g in Linux: Note: $ ORACLE_HOME is the installation path of oracle. 1. Use EM (enterprise Management) 1.1 start EM $ ORACLE_HOME/bin/emctl start dbconsole If the following information appears, it indicates

1. First, check the name and file of the tablespace. Select tablespace_name, file_id, file_name, round (bytes/(1024*1024), 0) total_spacefrom dba_data_filesorder by tablespace_name; 2. Add data files Alter tablespace users add datafile

Database performance optimization involves all aspects of the entire database operating environment, such as the operating system, Oracle itself, storage, and network. The operating system is the cornerstone of Oracle's stable operation and maximum

Environment: OS: AIX Version 6.1 Oracle: 10.2.0.5 rac (node rac2) I. Problem Description At, I received a text message, and the database crashed. I immediately connected to the database and found in the log: From the log, the problem is obvious:

Fault recovery for loss of inactive log groupsIf the database loses a non-active log group, because the inactive log group has completed the checkpoint,The database does not suffer data losses. In this case, you only need to re-create the log group

One Oracle instance is configured with multiple listener or multiple ports The content of the listener. ora file is as follows: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME

Environment MySQL 5.1 + command line tool Problem MySQL table field settings Default Value Solution -- SQL: Create table test (I _a int NOT NULL DEFAULT 1,Ts_ B timestamp NOT NULL DEFAULT NOW (),C_c char (2) not null default '1'); -- The

MySQL Import and Export Database Files Method 1: To use a graphical auxiliary tool, you first need to install MySQL GUI Tools v5.0. It is a visual interface of the MySQL database management console and provides four very useful graphical

Oracle dynamic performance view v $ event_name The V $ EVENT_NAME view lists a set of waiting events. It provides information about sessions that must be waiting for processing: Official Document referenceV $ EVENT_NAME V$EVENT_NAMEDisplays

1. Use imp/exp to perfectly migrate 10 GB (Table + data) to 11 GB. Everyone on Earth knows. 2, 11g (Table + Data) Perfect migration to 10g, the following solution: 1. Use the expdp command to back up data on the 11g ServerExpdp userid =

There are many methods to enable and disable Oracle by using SHELL scripts. In this example, we compile a simple script to call the three scripts that come with Oracle10g. Now let's start by simply editing the three scripts that come with Oracle.

The following error is reported when you execute the mysql command after installing mysql in Linux5.6: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql. sock' (2) 1. Check/etc/rc. d/init. d/mysqld status to see

Oracle does not have the primary key auto increment function. You need to whitelist the sequences and triggers to automatically increase the primary key. Example: Create a Table menu: Create table menu (menuId number (10) not null primary key,Name