dba

#用户设置 GROUPADD-G 1000 Oinstall GROUPADD-G 1100 dba Useradd-u 1001-g oinstall-g dba Oracle Mkdir-p/oracle Chown-r oracle:oinstall/oracle Chmod-r 755/oracle Mkdir-p/kk #修改环境变量配置 Export Oracle_base=/oracle Export Oracle_home= $ORACLE

Most WEB applications today need to adopt at least some basic security policy. For example, a Web site that provides password-protected content, only Web sites with admin backend, blogs and personal magazines, E-commerce sites, intranet, and so on.　　

1.MySQL 5.1 stored programs and functions work on replication? Yes, the standard behavior performed in stored programs and functions is copied from the primary MySQL server to the from server. 2. Can the stored programs and functions created on

Part Two: The practice of Dynamic Business application construction--The story of two adaptive systems Productivity improvement is the basic component of the improvement of living standard. The experience of the United States shows that the strong

This article mainly introduces the installation of Oracle database and the creation of database in silent way. Create users, user groups and environment settings and graphical installation is the same, the specific setting of the way please refer to

In most cases, modifications to the primary database will be propagated to the physical standby database and applied without the need for additional operations on the physical standby side, except that, depending on the actual configuration, some

Oracle Introduction to the new features of Oracle 10G I release (i) by fenng 2003-6-8 Oracle (www.oracle.com) has long claimed that Oracle 9i databases are only a transitional product, and that real technological innovation is likely to be in

As an Oracle DBA, a number of problems with character sets are frequently dealt with at work. But when you really want to write something about it, you suddenly don't have a clue. After a half-day, or decided to use the two character set as an

Starting with Oracle 10g, Oracle provides a new feature for automatic SGA management (ASMM, or automatic Shared Memory Management). The so-called asmm, means that we no longer need to manually set the shared pool, buffer pool and other memory pool

oracle| Skills | data | Database in an Oracle database, DBAs can make possible adjustment decisions by observing a certain table or view to see how the current space is being used. I. Free space in the table space By observing the free space of

J2ee Two: Creating a DatabaseSmall test Oracle 8i (by the way we practice practicing) (for convenience, I will Oracle 8i abbreviated 8 i)8i and 9i are indeed somewhat different, but in the interface is not very different, or to my Oracle 8i as an

1. Backup is more important than anything We need to know that the system is always going to crash, there is no valid backup just waiting for the day to die! I often joke that the only thing that will wake the DBA in a dream is that there is no

The implementation of MySQL master-slave replication 1, the implementation of MySQL replication principle MySQL supports one-way, bidirectional replication, asynchronous replication, one server acting as the primary server during the replication

oracle| Data Author: anon Source: InterNet Add Time: 2003-7-20 The following table collects almost all the views or aliases in the Oracle data dictionary, and for each view or alias field, use the ' Describe ' statement to query. Name Description:

If you do not have a long DBA, the backup of the database some worry, hoping to find a way to ease your backup solution, then this article is absolutely suitable for you. On the database backup recovery principle, we are more or less familiar with.

　　This example, run in MySQL5.0 and above version. The simple format that MySQL gives user permission commands can be summarized as: Grant permission on database object to user 　　One, grant ordinary data user, query, insert, UPDATE, delete all

Solve the problem ORA-01157 problem how to solve? Environment: Redhat 9 + Oracle 817 Question: After yesterday's sudden power off, the database was prompted for this error after it was started. The data is not archived, and the data file is also

Oracle Oracle DAB two day crash course The purpose of this course is to supplement the DBA's two-day quick (2 days dba) manual. In this course, you will learn more about the tasks outlined in the DBA's two-day quick (2 days dba) manual, and

1. Introduction Today's IT environment is undergoing drastic changes, and companies that rely on a single relational database management system (RDBMS) to manage data are beginning to diminish. Analysts report that more than 90% of companies today

Experiment content: The Redo Log Content format of the DML statement produced in the non-IMU mode is interpreted, the database version: 11.2.0.4 The most detailed explanation is update. Experimental environment Preparation The IMU feature is