Database Administrator

Software environment: 1. Windows 2000 + Oracle 8.1.7 2. ORACLE installation path: C: \ ORACLE Implementation Method: 1. Choose "start"> "Settings"> "Control Panel"> "Administrative Tools"> "services" to stop all Oracle services. 2. Start-> Program->

My system is Ubuntu6.06. The newly installed mysql always has an error prompt when entering the mysql tool:# Mysql-uroot-pEnter password:ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: NO)Use the methods described on

When mysql 5.0 is displayed in Chinese, it becomes? No. However, it may be displayed normally in phpmyadmin. What is displayed on the webpage? . The gb2312 is used. If it is changed to UTF-8, it will not work.Add a statement to the

It took me a lot of effort to run mysql in these two systemsTo sum upAfter running mysqld_safe, check the logs in/var/log/mysql. log.If there is no specific error information in the logYou can modify the log records in the my. cnf file and add the #

When running SQL * Plus in Linux Shell, the history command line browsing function is not provided. On the contrary, in Windows, when running SQL * Plus in the doscommand window, you can use the up and down keys to jump back to the previously

Installing Oracle in linux is a daunting task. Its complexity far exceeds that of installing the linux operating system. If oracle is successfully installed, some linux technologies are also mastered. This article describes how to install oracle 10

(1) data filesEach Oracle database has one or more physical data files ). A database data file contains all the database data. Data in logical database structures (such as tables and indexes) is physically stored in database data files. Data Files

1. Download Oracle Database 10g Release 2 Express Edition for Linux x86Web: http://www.oracle.com/technology/software/products/database/xe/htdocs/102xelinsoft.htmlDownload oracle-xe-universal_10.2.0.1-1.0_i386.deb2. Run dpkg-I oracle-xe-universal _..

Oracle11g has added many new features in backup and recovery, and has improved performance, functionality, security, and operability to varying degrees. This article describes the verification when RMAN deletes archived logs. In versions earlier

The following two methods are available: Put is backup, In is restoration, and java. lang. Runtime is mainly called.Public void Put () throws IOException {// you can pass parameters and modify them by yourself. It is most important to know the ideas

1. startup nomount is not installed and started. In this mode, execute the following commands: re-build the control file and re-build the database. Start the instance, that is, start the SGA and background processes. To start the instance, you only

For Oracle network configuration, we usually use negmgr or netca to connect the client to the database instance. You can also connect to the ASM instance from a client. However, Oracle does not provide a tool for us to complete the configuration. We

Database Identity Authentication Database identity authentication is easy to understand, that is, the Database User Password is stored in the database in an encrypted manner. When a user connects to the database, the user name and password must be

Nulls first/lastThe Nulls first/last function is mainly used in order by sorting clauses, which affects the position of Null values in the sorting result. Simply put, Nulls first indicates that the Null value is always in front of all values during

When using Oracle, you can often use the following methods to view the tables that the current or specified users have permissions on. Method 1: Tables with permissions of the corresponding user are obtained based on the specified user name. SQL>

Today, Oracle SQL plus performed the delete and query operations and then the query operations in PL/SQL. The results of the same statements were different, which made me feel quite depressed, later, I suddenly thought that the data on both sides

In Oracle 11g, full table scan may use direct path read to bypass the buffer cache. Such full table scan is physical read. In 10 Gbit/s, it is read through gc buffer, so there is no direct path read problem. High direct path read may be caused: 1. A

Oracle rac was installed on the VM a few days ago. After the node is started up today, it is found that rac is working abnormally [oracle @ node1 bin] $./crs_stat-tName Type Target State Host-----------------------------------------------------------

Redis persistence introduction: Redis is a memory database that supports persistence. That is to say, redis often needs to synchronize data in the memory to the disk to ensure persistence. Redis supports two persistence Methods: Snapshotting

In Red Hat Linux, the following problems are encountered during the prerequisite detection during Oracle 10g installation: 1. Warning: there is not enough swap space in the memory. If there is a prompt that m is required to be smaller, how m is