Today, a Linux server has expanded its memory to 4 GB. The developer modified the SGA result and the database cannot be started.When the startup fails, the following error occurs:[Oracle @ neirong oracle] $ sqlplus "/as sysdba"SQL * Plus: Release 9.2
In the actual working environment, if you Truncate several data dictionary tables in the database during operation, the database will no longer be available, this article will give a detailed explanation of a related case.
The example is as follows:
Environment: Linux RedHat5DB2 FOR Linux 32bit
Because the installation directory cannot be changed in this version, it is installed under/opt by default. Therefore, you must allocate enough space to the/directory in advance or allocate space for/opt.
1. Create a space for the db Data File
Mkdir-p/db2root/testdb/lv_db2dbMkdir-p/db2root/testdb/lv_db2indexMkdir-p/db2root/testdb/lv_db2logMkdir-p/db2root/testdb/lv_1_bsMkdir-p/db2root/testdb/lv_temptbsTouch/db2root/testdb/lv_usertbsChown-R db2inst1:
There are many formatting tools in the Oracle database to improve the readability of the results. Our database design and software development are well-rounded.
For example, it is an employee salary table in the employee salary management module.
After logging on to JR today, I found my title was "veteran expert ". Flattered. It only means that I have been here for a while. JR has done a good job and provided a platform for communication.
Let's get down to the truth. Recently I encountered a
MySQL 5.6 master-slave replication Part 4 [some ignored Operation Details]
1. STOP SLAVE There are two types of threads responsible for synchronization from the server:1) IO thread2) SQL thread IO thread is responsible for obtaining binary logs on
Basic Ideas
MongoDB is used as an in-memory database, that is, it does not allow MongoDB to save data to a disk at all, which has aroused more and more people's interest. This method is extremely useful for the following applications:
RHEL6 ASM installation of Oracle 11g R2 tutorial directory:
I. Preparations before installationIi. Install the grid infrastructure3. Install database software4. Create a listener5. Create a database instance
I. Preparations before installation
1.1
Recently, I found that two MySQL servers suddenly went viral at noon (suddenly) and kept failing. Restarting mysql also fails. You can only see information similar to the following:
Forcing close of thread 12232 user: 'root'
Use mysqladmin to easily
I. Preparations 1. Download mongoDB
: Http://www.mongodb.org/downloads
Select the appropriate version
Related documents: http://www.mongodb.org/display/DOCS/Tutorial
2. Install mongoDB
A. Pressure-free mode:
Open the downloaded mongodb-xxx.zip file,
When using RMAN to clone a database, if the secondary database (new database) uses a different path from the target database (original database), there is a problem of location conversion. In Oracle, the control file is used to locate the data file
Add the MySQL service to the System Service of the server in Linux
1. Understand the MySQL program path MySQL data DIRECTORY:/home/mysql/dataMySQL program Directory:/usr/local/mysql5 2. Modify the MySQL Service Startup Program [Root @ www.bkjia.com ~
1 engine description
The local MySQL database must use the FEDERATED storage engine to access the data in the table of the remote MySQL database. it is similar to the Database Link (DBLINK) in Oracle ). to allow this storage engine, use --
Field constraints for creating an Oracle database:
Non-empty ConstraintUnique ConstraintConstraints on Field ValuesDefault ValueForeign key constraint
Create table tab_class (Class_id number primary key,Class_name varchar2 (10) not null
Delete Oracle 11g R2 in Linux 6.4
Close DatabaseSQL> shutdown [immediate]
Stop Listener[Oracle @ ora920 oracle] $ lsnrctl stop
If an application service exists, stop the application service first.[Oracle @ ora920 oracle] $
Today, I met a ORA-12154 problem in the group. Here I will record the solution process.The reason is that when a person in the group asks his Windows client to connect to the Oracle server using the easy connect method, the following error is
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.