Database Administrator

System Environment:1. Operating System: Windows 2000 Server, 128 MB of machine memory2. Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition3. installation path: D: \ ORACLESteps for creating a database:1. manually create related directoriesD: \

This article uses seven simple steps to set the root password of the MySQL 5.0 database.Operating System: DEBIAN LinuxMySQL database version: 5.0.27(1) log on with the root permission of the system;(2) stop the MySQL server: MySQL. server stop;(3)

1. After sqlplus '/as sysdba'SQL> select username, password from dba_users where username = 'enable ';USERNAME PASSWORD------------------------------------------------------------ENCLE E5406F88BEEF81082. Change the password and log onSQL> alter user

Environment: OS: rhel4MySQL version: 4.1Master database 192.168.1.115Slave database 192.168.1.1161. Create/etc/my. cnf in the master database and modify the key value in [mysqld] to open the master item.Server-id = 1Log-bin2. Add users to the master

I heard someone say they want to buy a genuine Oracle version, saying that it is pirated. oracle will find you legally responsible. In fact, we use genuine oracle products. If you feel that you are very competent, you can solve oracle problems. You

1. Install the Oracle Database hardware and software environment in Linux:Hard Disk 120 GB2 GB memorySystem Environment ipvsxp ProLinux running environment VMWareWorkStation4.5.2Ii. preparations:1. Create an Oracle user account:# Groupadd dba #

Symptom C: \ Users \ CHEN> sqlplus "/as sysdba" SQL * Plus: Release 11.2.0.1.0 Production on Wed Oct 10 13:31:28 2012 Copyright (c) 1982,201 0, Oracle. All rights reserved. Connected: Oracle Database 11g Enterprise Edition Release

A new feature of PostgreSQL 9.2 is the range type range types. With this name, you can easily guess the purpose of this type. It allows you to define a value range for a column of data. This simple feature eliminates the need to define two fields to

After Oracle is installed, there is a default database. In addition to this default database, we can also create our own database. To avoid the trouble, you can use the 'database Configuration Assistant 'Wizard to create a Database, an error will

Using Toad to manage local databases is more intuitive and convenient than using sqlplus, and easier to operate. For some large tables, the query results are clear at a glance. In general, the following steps are required: Step 1: Install the local

# Rpm-qa | grep-I mysql view installed mysql versions Delete an existing mysql version To install the server and client, go to the Oracle official website to download: # Rpm-ivh MySQL-server-5.5.28-1.linux2.6.i386.rpm # Rpm-ivh MySQL-client-5.5.28-1.

Kill Session Before using drop user cascade, kill session is usually used to terminate the currently connected session. However, if a long running transaction has not been committed, it usually takes a long time to kill a session. In addition, it is

Environment: Idle> select * from v $ version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-ProdPL/SQL Release 10.2.0.1.0-ProductionCORE 10.2.0.1.0 ProductionTNS for

1. LISTENER (LISTENER) Listener is a server-based network service of Oracle. It is mainly used to listen for connection requests from clients to database servers. Since it is a server-based service, it only exists on the database server, and

New Features of Oracle flash Query Starting from oracle9i, oracle provides the flashback query feature, allowing data in the rollback segment to be flashed back, the following example shows the new features provided by oracle9i. SQL> update emp set

Symptom: When installing Oracle Grid11gR2, an error is reported: INS-40904 ORACLE_HOSTNAME Does not Resolve to a Valid Host Name Problem Analysis: The cause is that the ORACLE_HOSTNAME parameter does not parse the valid host name. Solution: 1.

After installing MySQL on CentOS, remote access control is disabled by default. You can enable the following settings. Log on to MySQL:Mysql-uroot-p To change the password, the first time:Mysqladmin-u root password NEWPASSWORDAlready

1. Open pl_ SQL and log on to the user who needs to export the database Ii. Create an SQL copy Select 'alter table' | table_name | 'allocate extent; 'from user_tables where num_rows = 0 The query result is as follows: 3. Create an SQL window

Oracle encountered a ora-30962 Error 30926,000 00, "unable to get a stable set of rows in the source tables"// * Cause: A stable set of rows cocould not be got because of large dml// Activity or a non-deterministic where clause.// * Action: Remove

Oracle RAC backup and recovery Voting Disks reference: Example of adding or deleting a voting Disk: Environment: [Oracle @ node2 ~] $ Uname-Linux node2 2.6.18-164. el5 #1 SMP Tue Aug 18 15:51:54 EDT 2009 i686 i686 i386 GNU/Linux SQL> select * from v