Oracle HowTo: How to expand SGA to over 1.7 GB in Linux Server

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

Database unavailability caused by Truncate in the Oracle Data dictionary table and Countermeasures

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:

DB2 installation in Linux: SQL1220N

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.

MySQL password Problems

1. mysqladmin-uroot-poldpassword password newpassword2. mysql> update mysql. user set password = PASSWORD ('new password') where User = 'root ';Mysql> flush privileges;Mysql> quit3. mysql-u root mysqlMysql> UPDATE user SET password = PASSWORD ("new

Manual database creation for DB2 in SUSE Linux

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:

Implementation of Oracle database to improve query result readability

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.

Solve the Problem of MySQL5 database connection timeout

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]

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

Chinese garbled characters exported from Hive to MySQL

I. mysql Encoding Mysql> show variables like 'collation _ % ';+ ---------------------- + ------------------- +| Variable_name | Value |+ ---------------------- + ------------------- +| Collation_connection | latin1_swedish_ci || Collation_database |

Use MongoDB as a pure memory database (Redis style)

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:

Installing Oracle 11g R2 using RHEL6 ASM

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

Oracle 11g Remote Database Export

1. Create a TNS string:Zqxt =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP) (HOST = 132.97.172.186) (PORT = 1521 )))(CONNECT_DATA =(SERVICE_NAME = ora11g)))2. query the tablespace SQL of remote data: 1) select distinct 'select

Solve the unauthenticated user error in MySQL

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

MongoDB Getting Started Guide and example

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,

Method for converting the cloned file location in the RMAN Database

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

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 ~

Example of using MySQL FEDERATED engine, similar to Oracle DBLINK.

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 --

Create and maintain field constraints for Oracle databases

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

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] $

Resolution of EasyConnect error with ORA-12154 (failed to parse the specified connection identifier)

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

Total Pages: 1013 1 .... 280 281 282 283 284 .... 1013 Go to: GO

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.