Database Administrator

In linux, when init. crs is not modified, cluster software is always automatically integrated with the system during startup. The database raclinux In addition, you can also view the crs-stat-t to manually start a service that has not been started. [

In Linux, if no prompt is displayed when the listener is started, check whether the content format of your/etc/hosts file is correct. If not, change it; after the change, start the lsncrtl start command again, may prompt TNS-01150 and TNS-01153

There are a lot of useful things in Ubuntu 10.04, and so is the well-known MongoDB system. Related reading: Installing MongoDB on Ubuntu 10.04 As long as sudo apt-get install mongodb should be installed. However, you may find that it cannot be

Case: Add students and return to all students in the class. Create or replace procedure add_stu (P_sid stu. sid % type,P_sname stu. sname % type,P_cid stu. cid % type,P_data out sys_refcursor -- output variable, system reference cursor)AsBeginInsert

Installation environment: RedHat es 5.5 64-bit, 8 GB system memory, 10 Gb swap, Oracle 11G R2 Standard Edition 1. Preparations before Oracle InstallationCheck the packages and install them all:Binutils-2.17.50.0.6Compat-libstdc

This knowledge point is only applicable to Oracle 9i and later versions. To view table data changes, use the SQL statement: select * from user_tab_modifications; The fields in the user_tab_modifications table are as follows. From this table, you can

ORA-16014 error and flash space full Create table user as select name from t_userinfo created yesterdayThe t_userinfo table is very large. After a while, I have been reading and writing the hard disk for three hours.PL/SQL DEVELOPER cannot be

Ora-01450 is an error that may occur during index maintenance. First, let's take a look at the relevant information of 01450 through oerr: SQL> ho oerr ora 0145001450,000 00, "maximum key length (% s) exceeded"// * Cause:// * Action: Haha, Oracle

Solve the libpthread. so.0 problem in Oracle 10gRAC InstallationI. Problem The CRS of 10.2.0.1 encounters the same problem in the following situations on linux5:1. rootOracle CRS stack installed and running under init (1 M)Running vipca (silent) for

Experiments show that Oracle11gR2 creates objects such as tables and indexes without data. In order to save space, oracle does not allocate segment, but allocates segment only when there is a dml operation, even if the dml is rolled back, the

ORA-01555 ultra-long Query Duration time Symptom:The Alert Log reports a ORA-01555 error, but what is incredible is the ultra-long Query Duration (1382909202 sec ).Mon Oct 28 05:26:42 2013ORA-01555 caused by SQL statement below (Query Duration = 1382

First, download the database you need to install.Second, configure your yum source. If it is CentOS, you do not need to configure the yum source.Third: Put the mysql-xxx.tar file you downloaded and the script in the/usr/local/src directory.4.

Remote settings of MySQL Databases in Linux 1. Start the service and log on[Root @ localhost ~] #/Etc/init. d/mysqld restartStopping mysqld: [OK]Starting mysqld: [OK][Root @ localhost ~] # Mysql-u root-pEnter password:Welcome to the MySQL monitor.

Data Guard Services   The following three parts constitute Data Guard's log Data transmission, log Data application, and change the database role: A), log transmission Services (Redo Transport Services) B) log application service C) role conversion 1

Operating Environment: CentOS 6.4 64-bit First, create the/ibddir directory and modify the owner of the/ibddir directory and the corresponding group: chown-R mysql: mysql/ibddir Operation 1: Create table 'd _ TF_DATA_AGGREGATION_MYISAM '( 'Strative _

Because the identifier of the business table is not added during data conversion, multiple processes must perform operations on the same table to improve the update efficiency. 1. Write the corresponding stored procedure: Create or replace procedure

There are three Oracle encryption methods: transparent encryption, password encryption, and dual-mode encryption. By default, Oracle disables the encryption function:RMAN> show all;Configure encryption for database off; # defaultConfigure encryption

In MySQL5.5, if you want to modify the size of the ib_logfile (redo log) file, follow these steps: 1. set global innodb_fast_shutdown = 0; Ii. mysqladmin shutdown 3. Modify the innodb_log_file_size parameter value in the my. cnf file. Iv. mv

Because there are Too many online mysql instances, the Too connector connections problem is often encountered. This problem is also the most common problem. The following describes the solutions to this problem based on your own experience. When

Today is. During the database performance tuning process, I suddenly moved to the previous email with the following information: From the log, it is found that there is a row-level exclusive lock contention, resulting in a deadlock. Problem