Database Administrator

Test environment: Oracle 9.0.4 in Linux 1. log on with an oracle userIf you want to install it again, you 'd better back up the data first. The script includes the user's login script, the script for automatic database startup and shutdown, and the

1. Composition of the NLS_LANG ParameterThe NLS_LANG parameter consists of the following parts:NLS_LANG = _. The meanings of NLS_LANG are as follows:LANGUAGE:-Oracle message language-Display month and day in dateSpecified by TERRITORY-Currency and

Install MySQL5.0.37 in Linux using the following three packages:MySQL-client-community-5.0.37-0.rhel3.i386.rpmMySQL-server-community-5.0.37-0.rhel3.i386.rpmPerl-DBI-1.53-2.fc7.i386.rpm(The following steps require root permissions)1. Verify that

After MySql is installed, there is only one ROOT user with super management permissions, and ROOT restrictions can only be used on the local database. What if we want to remotely manage MySql? In fact, we need to add a Super User with super

For example, if my user name is root and the password is 123 SQL script, the C disk name is test. The SQL database name is test. There are two ways to execute the script 1: Open CMD and enter the following command (directory conversion is not

Mysqlhotcopy runs as follows: [Root @ local_slavedb ~] # Mysqlhotcopy test/tmp Invalid db. table name 'test. test'. 'mytest' at/usr/bin/mysqlhotcopy line 855. Solution: Suggested fix: A quick and dirty fix is to strip the database prefix from

A. show tables or show tables from database_name;-displays the names of all tables in the current MySQL database. B. show databases;-displays the names of all databases in MySQL. C. show columns from table_name from database_name; or show columns

If there is a problem with the MySQL DATA table, you can use the -- recover -- quick parameter to fix it: Linux # myisamchk -- recover -- quick tbl_name Linux # isamchk -- recover -- quick tbl_name If the preceding method cannot solve the problem,

1. Obtain the Oracle 10g Installation File 2. Configure the installation environment for Debian 2.1 configure sysctl. conf # Vi/etc/sysctl. conf Add the following content to the end of the file: Kernel. shmall = 2097152 Kernel. shmmax =

Sometimes it is not convenient to log on to the Linux graphical interface to install the Oracle client. We can use the silent mode to install, upgrade, and delete the oracle client (instead of the OUI ). Platform: RHEL4.5, oracle10.2.0.1 1. Silent

Skip-lockingKey_buffer = 384 MMax_allowed_packet = 3 MRead_buffer_size = 20 MMyisam_sort_buffer_size = 128 MQuery_cache_size = 64 MThread_concurrency = 8Set-variable = back_log = 1024Set-variable = interactive_timeout = 7200Set-variable =

Oracle uses a variety of different mechanisms to manage database security, including two mechanisms: mode and user. The mode is a set of mode objects, such as tables, views, processes, and packages. The first database has a set of modes. Each Oracle

Install the innodb Engine (mysql5.1 is not installed by default) You can add the -- with-plugins = innobase parameter to configrue during compilation and installation. If you have installed innodb before, you can also install the innodb

Error message for rman backup in Linux Obviously, the rman command cannot be found. There is a problem with the path or the environment variable. [Oracle @ RedHat/] $ mailMail version 8.1 6/6/93. Type? For help."/Var/spool/mail/oracle": 13 messages 1

When you use the delete obsolete command to delete obsolete backup files, if the following error occurs (RMAN-06207 & RMAN-06208), you need to use the CROSSCHECK command to resolve it: RMAN-06207: WARNING: 2 objects cocould not be deleted for DISK

By default, only the date is displayed on the RMAN backup and recovery interface, but there is no specific time. Sometimes you need to view the specific time, for example, to view multiple Incarnation events of the current day. To solve this problem,

A colleague said that a PERL script on the production machine always reports a deadlock error, and the concurrency is enabled in the script: the error is as follows: Failure: ORA-12801: error signaled in parallel query server P126, instance

Because the project needs to change Oracle_sid (tested) to nid, the result is half lost and the database is suspended. Finally, you cannot reinstall the database. When I started the database today, the error was: ORA-01103 Database Control File andD:

Temporary Oracle tablespace is an important part of Oracle databases. Although this part is not presented in the cont architecture, its importance cannot be ignored. Especially for large-sized frequent operations, such as index creation and sorting,

V $ database. CHECKPOINT_CHANGE # (last scn checkpointed)V $ database. CONTROLFILE_SEQUENCE # (control file sequence number incremented by control file transactions)V $ database. CONTROLFILE_CHANGE # (last scn in backup control file; null if the