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 @

1. Syntax: Wget-c -- http-user = user -- http-password = pwd --output-document?patch.zip "download_url"-o download. log & The parameter meanings are as follows: -C indicates resumable upload.-- Http-user metalink account-- Http-password metalink

There are three standard LOOP methods in MySQL stored procedure statements: while loop, LOOP, and repeat loop. There is also a non-standard loop method: GOTO, but it is best to use this loop method, it is easy to cause program confusion, here is a

I was overwhelmed by ASM recently. Yesterday I met a customer who used WIN2008 + RAC + ASM. Due to the storage problem of emc, the ASM instance has a problem and the data cannot be read, which leads to RAC problems. After two hours, I finally

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

PurposeThis tutorial describes how to install and configure an Oracle WebLogic Server instance. Time required About 1 hour TopicThis tutorial includes the following topics: OverviewScenarioVerification prerequisitesInstall the Oracle WebLogic

After VNC remotely connects to CentOS 5.5 to run the installation file, the following error is reported: Checking installer requirements... Checking operating system version: must be RedHat-3, SUSE-9, redhat-4, UnitedLinux-1.0, asianux-1,

1. Install logminer: To install logminer, you must first run the following two scripts: 1. $ Oracle_HOME/rdbms/admin/dbmslm. SQL 2. $ ORACLE_HOME/rdbms/admin/dbmslmd. SQL The two scripts must be run as sys users. Ii. Create a data dictionary

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

After Oracle is installed, a database is created and no listening service is found. You can solve this problem by using the following method. Run Net Configuration Assistant and select Add Listener Configuration Configuration items are simple.

1. Install the rpm package Nano/v. sh Copy the following content For x64 #! /Bin/bash Rpm-Uvh kernel-headers-2.6.18-194.el5.x86_64.rpm Rpm-Uvh glibc-headers-2.5-49.x86_64.rpm Rpm-Uvh glibc-devel-2.5-49.i386.rpm Rpm-Uvh

SQL> variable jobno number;SQL> beginSQL> DBMS_JOB.submit (: jobno, 'pro_name (); ', sysdate, 'sysdate + 1 ');Dbms_job.submit (: job1, 'myproc; ', sysdate, 'sysdate + 100'); -- runs the test process once every minute for 1/1440 minutes.SQL>

1. Install MySQL ()2. Start Multiple MySQL serversTo enable multiple MySQL servers on a single machine, you can use mysqld_safe to run multiple servers.Of course, it is troublesome to edit the configuration file separately and read the configuration

1. Create a mysql user and user group (it seems that installation is not affected if the user is not created, but security needs to be re-planned ). 2. Compile and install (-- prefix =/usr/local/mysql -- with-charset = utf8 specifies the directory

1. Script and test procedure -- 1. Create a test tableCreate table tab_default (id varchar2 (2), default_sysdate date, default_char_date varchar2 (8), default_guid varchar2 (100 ));-- 2. Add the default value ConstraintAlter table tab_default modify

Manual database creation is a common situation for DBAs because GUI environments cannot be provided in some cases. In fact, it is very convenient to set relevant parameters or values for manual database creation. This document describes the steps

During work, we often observe the space release and Application Performance Improvement brought about by index reconstruction. Space release is easy to understand and measure. How much will index reconstruction affect the performance of applications?

The IMP-00058 ORA-00904 error occurs when migrating the source database partition table data to the historical database. The specific operation and solution are as follows:$ Imp \ '/as sysdba \' STATISTICS = NONEDATA_ONLY = y file =/backup/wxlun20130

The Final Cause of slow loading of phpmyadmin4.0 series is that phpmyadmin's official website is not frequently opened recently, and the phpmyadmin page automatically checks the official online program version updates, so when you go to the

Oracle example:Select extract (year from sysdate) from dual; // return Current YearSelect extract (month from sysdate) from dual; // return Current MonthSelect extract (day from sysdate) from dual; // return Current DaySelect extract (hour from