Database Administrator

Since the Oracle data format is different from the general microcomputer format, Oracle data cannot be directly called. Although Developer 2000, a front-end development tool provided by Oracle, can access Oracle data and has data access interfaces,

Download all file names:10201_database_linux32.zipFile size (KB ):653061KBModify the sysctl. conf file in the/etc/directory to add the kernel parameters. The key part is described as follows:Added content:Kernel. shmall = 2097152Kernel. shmmax = 2684

Q: How do I install multiple Mysql instances on Windows?A: The specific method is as follows:1. Install Mysql for Windows normally, for example, in the d: \ mysql folder;2. Configure Mysql as usual;3. Copy the folder installed in the backup, such as

1. In SQL, single quotation marks (''') are strongly recommended for strings (''''). Although SQL/Index.html "> MySQL can also use double quotation marks ("), we recommend that you use single quotation marks to ensure consistency with SQL Server and

This article answers the following question: "How stable is the MySQL server ?", And "can I rely on the MySQL server in this project "? We will try to clarify this type of questions and answer some important questions that may concern many potential

1. Problem: When using the mysql database, when a large number of tables are generated and a large number of records are inserted, the/usr/local/mysql/data directory is generated. Into some log files, such as: localhost-bin.001, localhost-bin.002 ...

The simplest solution to the MySQL Chinese encoding problem is: Modify the mysql configuration file/etc/mysql/my. cnf (in CentOS, It is/etc/my. cnf), add the following command under [client: Default-character-set = utf8 [Mysqld] Add the following

We need to debug the PL/SQL process to view the variable content. You can use the following method. Assume that the variable we want to view is output and the type is varchar2. 1. The most basic DBMS_OUTPUT.PUT_LINE () method.You can use DBMS_OUTPUT.

There is an internal limit on the size of Oracle data files, which is: Each data file can contain a maximum of 2 ^ 22-1 data blocks. This limit directly results in the maximum allowed size of each data file. Under 2 K Block_size, the maximum data

Common Oracle Installation errors in Linux: /Tmp/OraInstall2007-12-30_02-16-11PM/jre/1.4.2/lib/i386/libawt. so: libXp. so.6: cannot open shared object file: No such file or directory occurred .. The reason is: the graphical dynamic link library

An error is prompted when you start database listening today: TNS-12545: the connection failed because the target host or object does not existTNS-12560: TNS: protocol adapter error.TNS-00515: the connection failed because the target host or object

1. Check alert logs Symptom description: During routine Oracle maintenance, you often need to check the alert alarm log to check whether the database is faulty. Cause analysis: Oracle 11g modified the log system, instead of using oracle9's alert

Oracle contains three parts: 1: Oracle Server: An Oracle Server. Generally, it can be seen as a machine. We can call it a Server. It can also be seen as a set of software running on the server. It is defined on the official Oracle website as follows:

1. view the current File System[Root @ hp173/] # bdfFilesystem kbytes used avail % used Mounted on/Dev/vg00/lvol3 204800 154080 50384 75%//Dev/vg00/lvol1 298928 83696 185336 31%/stand/Dev/vg00/lvol8 2613248 1010056 1592040 39%/var/Dev/vg00/lvol7 2359

The ORA-06502: PL/SQL: Number or value error: string buffer is too small when a stored procedure is found and the long type returned by the function is too large Long variables in PL/SQL can only store 32768 bytes (32 K)Clob is recommended Hi,I 've

When the application fails, it runs up and finds that the application interface has always reported a wrong logon database user and password. After checking that the Oracle database is restarted, the user name and password policies exceed the

During Oracle learning, we will find that many Oracle knowledge points are in pairs. So, in order to facilitate understanding and memory, I will make a summary of this series. The first part of this series is static or dynamic initialization

Use PL/SQL to connect to Oracle without installing the Oracle client 1. Download a software named Instant Client Package from the Oracle website. This software does not need to be installed and can be used as long as it is decompressed. : Http://www.

The syntax is as follows:# Mysqlslap [options] Common Parameters [options: -- Auto-generate-SQL,-a automatically generates test tables and data, indicating that the SQL script generated by mysqlslap is used to test the concurrency pressure.--

Oracle special symbol & processing, today encountered a problem, the colleague uses the insert statement generated by dynamic SQL, which contains the & symbol, during insert, this & symbol is used as a variable prompt. How can this problem be solved?