Database Administrator

Install the Oracle 10gR2 database on the text interface of Fedora 14 (32-bit i686: 1. Create users and user groups[Root @ xinchang ~] # Groupadd-g 502 dba[Root @ xinchang ~] # Groupadd-g 503 running[Root @ xinchang ~] # Groupadd-g 504 asmadmin[Root @

After upgrading Ubuntu to 10.04, the following error occurs when connecting to mysql:Can't connect to local MySQL server through socket '/var/run/mysqld. sock' After reading this, mysql is not started. RunSudo start mysqlUnable to start, no

Auto start/stop Oracle Database Under AIX 1: Modify/etc/oratab and change "N" to "Y" to enable auto start. $ Vi/etc/oratab# This file is used by ORACLE utilities. It is created by root. sh# And updated by the Database Configuration Assistant when

The distinct keyword can only be used to filter all records in the query field that are the same (the record set is the same). If you want to specify a field, it does not work. In addition, the distinct keyword is sorted, Which is

1. A table field in Oracle is of the Date type. The error message "Incorrect format" is always returned when you insert data into the file. Solutions: 1. Temporary Modification SQL> alter session set nls_date_format = 'yyyymmdd '; This method

Prerequisites 1. the Linux environment already exists. Oracle has been installed. This demo Runtime Environment Local Environment RedHat linux as 4, ORACLE 10GLocal Database sid orcl, ip: 127.0.0.1, User name: kingbi, password: kingbi, table

1. Install unixODBC and freetds in Linux Source code package: freetds-0.82.tar.gz?unixodbc-2.3.0.tar.gz 1. Install unixODBC Gunzip unixODBC-2.3.tar.gz Tar zxvf unixODBC-2.3.tar ./Configure -- prefix =/usr/local/unixODBC Make Make install 2. Install

1 Swingbench 1.1 Overview This was developed by an Oracle UK employee on the basis of a abandoned project. The current stable version is 2.2, the latest version is 2.3, based on JDK1.5. This tool is free of charge and can be freely downloaded from

1. Download the binary version. Many websites now have related downloads, which are about 384 Mb in size and about MB in decompression. My downloaded version is: mysql-5.1.45-linux-i686-glibc23 2. The glibc2.3 version is required from the file name.

A colleague deleted an important Oracle table and failed to run the project! Fortunately, a DBA friend suggested that the flashback table of oracle can restore data. After using the flashback table, the results will be good and we will learn it

Generally, it can be divided into three steps:1. Install the Oracle client. Next, you can proceed. You don't have to change anything.2. Configure the local name to parse tnsnames. ora, without directly entering the connection string.3.

Install Quick Installation Guide 10g Release 2 (10.2) for Linux x86. Problems encountered during installation: Start Oracle Universal Installer/tmp/OraInstall from the following address. please wait... [oracle @ nj15 database] $ Exception in thread "

// Overview// Basically, when you want a PLSQL (or java or c) program as a data source rather than a table,// You may use the pipeline function ).// The pipelined function operates like a table.// A pl/SQL function may be used in the database of the

1. SQL statement 1: -- 1. view the table space name and size. SELECT t. tablespace_name, round (SUM (bytes/(1024*1024), 0) ts_size FROM dba_tablespaces t, dba_data_files d WHERE t. tablespace_name = d. tablespace_name Group by t.

Oracle does not have a hexadecimal to binary function. For ease of work, I wrote Create or replace function hex_to_bin (hex varchar2) return varchar2 isV_hex varchar2 (10000 );V_len number;V_var varchar2 (10000 );V_result varchar2 (10000): =

Environment: Oracle 11gr2 + dataguard 128 GB memory +-core cpu + high-performance storage server Uname- Linux dbhost 2.6.18-238. el5 #1 SMP Sun Dec 19 14:22:44 EST 2010 x86_64 x86_64 x86_64 GNU/Linux Symptoms: During rman backup, the system memory

When using a data pump to export data, sometimes we need to filter out some data that does not need to be exported according to the conditions. In this case, we need to use the parameter query. The following is a small example of simple query. In

Trigger There are two common types: Row Trigger and Statement Trigger) There are also: Instead of Trigger and Event trigger. Example 1-Row Trigger: Create or replace trigger client afterinsert on tt1 for each

1. Check whether the rpm is completeRpm-q -- qf "% {name}-% {version}-% {arch} \ n" binutils compat-libcap1 compat-libstdc ++-33 compat-libstdc ++-33. i686 elfutils-libelf-devel gcc-c ++ glibc. i686 glibc-common glibc-devel glibc-devel.i686

Today, when I drop a user, it's time for hang to stop and don't care. After an hour, the result has not been deleted. There are not many objects in this user, and they are not big either, so I checked the alert Log and found the following