Database Administrator

Innodb_buffer_pool_size of innodb can only be up to 2 GB on 32 machines. In this way, the increase in memory is insufficient to speed up. I heard that the 64-bit environment can use more than 2 GB of memory, so I began to

Installing rlwrap on Linux is very simple,# Tar-zxvf rlwrap-0.30.tar.gz# Cd rlwrap-0.30# Configure; make install # Vi/home/Oracle/. bash_profileAddAlias sqlplus = 'maid sqlplus' You can also use rlwrap on solaris 10 to add the historical echo

Copyright statement: original works can be reproduced. During reprinting, you must mark the original source, author information, and this statement in hyperlink form. Otherwise, legal liability will be held.Http://yueliangdao0608.blog.51cto.com/39702

1. Run the following command to check whether the development kit has been installed:Rpm-qa | grep gcc cpp compat-libstdc ++ glibc-devel glibc-kernheaders binutils2. decompress the packageZcat Linux9i_Disk1.cpio.gz | cpio-idmvZcat Linux9i_Disk2.cpio.

"The input value is not long enough in the date format" reported in Oracle for date conversion" Select (select j. jgmc from t_zzjg j where j. jtpd = t. jtpd) jgmc,T. jtpd,Sum (t. jcj) jcj,Sum (t. sa) sa,Sum (t. la) la,Sum (t. ajbl) ajbl,Sum (t.

Source code compilation and installation of MySQL 5.5.30 0. Install cmake[Root @ www.bkjia.com ~] # Tar-zxvf cmake-2.8.11.2.tar.gz[Root @ www.bkjia.com cmake-2.8.11.2] #./configure[Root @ www.bkjia.com cmake-2.8.11.2] # make[Root @ www.bkjia.com

The single-host multi-instance MySQL solution is to run multiple MySQL database instances on one physical server. Advantages of Single-host and multi-instance MySQL:1. save costs and reduce the number of servers, IP addresses, and cabinets. The

Oracle Database cloning is also called Oracle Database Replication. It can be achieved through user management or RMAN. In addition, Oracle recommends using RMAN because it is easy to use and hides its complicated logic. You can just run a duplicate

These two names are very common in alert log. Apart from Oracle, they are inevitably prone to a variety of problems and some are well solved, but some are heartbroken. Example: ORA-00600 The description given by OERR is as follows: // * Cause:

1. DBA_LOGSTDBY_EVENTSThis view can be viewed as a logical Standby operation log. If an error occurs, you can view the recent logical Standby operations in this view. By default, this view retains only the records of the last 100 events (you can

If you use dbca to create a single-instance database in the Oracle 11g RAC environment, Oracle automatically registers it to the default port 1521 and listener. In most cases, we use non-default listeners and non-default listening ports. In the

./RunInstaller Graphic startup Error PRVF-0002: cocould not retrieve local nodename. The error message is as follows: [Root @ test68 OraInstall2013-09-06_04-43-39AM] # cat installActions2013-09-06_04-43-39AM.log The following lines report an

Environment: Oracle 10g 10.2.0.4 on SUSE 11 + Oracle Data GuardNote: Standby DB is regularly read-only for statistics every morning, and then continues synchronization.Fault symptom:Run the copy datafile command to report the RMAN-10006 error.As

Symptom: After the CRS is restarted on both nodes, this instance cannot start with the CRS. After CRS is started, crs_start-all can be used to set up the resources not started, and no error is reported. Analysis: Find the cause in crsd. log and

Generally, the database processes SQL statements through three processes: parsing (parse), executing (exec), and returning results (fetch) 1. Resolution When a user initiates an SQL statement, Oracle receives the SQL statement to the oracle instance

MySQL master-slave replication is widely used in small ZTE enterprises. There are three key points for configuring MySQL master-slave replication. 1. server-id. The master server-id is smaller than the slave server-id2. Create an account that can be

1. Open PL/SQL Developer. The logon window is displayed. The Username, password, and Database are set when Oracle is installed. The default Username is sys, the default Database is ORCL, And the Connect as option is SYSDBA. 2. After successful

There is such a sentence in the project's stored procedure Select jtpd, jgmc into parm_mrjtpd, parm_mrjgmc From BL_KHXX where jtpd = parm_jtpd; An error is reported every time you debug the stored procedure. ORA-01403: No data found ORA-06512:

1. Configure the master database environment Enable Archiving SQL> alter system set log_archive_dest_1 = 'location =/Oracle/archive_log/arch _ % t _ % s _ % r. arc' scope = spfile; The system has been changed. SQL> ALTER SYSTEM SET

Environment: OS: rhel63_64bit DB: Oracle10gR2 Master/Slave switchover sequence: first from the master database to the slave database, then from the slave database to the master databaseSwitchover:Lossless conversion is usually triggered manually or