1. Preparations for configuration in Linux
Environment: Linux: RedHat Enterprise 5.4, DB: Oracle 11g R2 X64, Oracle installed in the/home/oralce_11 directory.
The configuration process is as follows: (most of the content is online, and individuals follow the online steps)
1) Check the basic requirements (this must meet the requirements for the awesome server and
, and fully execute required permissions, and ensure that enterprise operations are not affected.
"Oracle has unparalleled technology and profound industry experience in both the cloud and database fields," said Yu sicheng, vice president of Oracle and general manager of tec
Finally, Oracle 10 Gb is successfully installed on RedHat Enterprise Linux 5.5 x64.
The entire process is recorded as follows:
I. Preparations before RHEL5 Installation
1. Set swap Partition
Oracle 10 Gb installation requires that the swap space be about 2 physical memory. Therefore, linux partitions need to be customized.
Swap space (swap) is generally set to 1
installation file to the/oraapp directory (if not, create it yourself), unzip, installUpload command RZUnzip Command Zcat 10201_database_linux_x86_64.cpio.gz | Cpio-idmv11, using Xmanager remote connection linux,root user login, open terminal, switch to Oracle user, and then perform the installationcd/oraapp/database/./runinstaller performing the installation12, the installation, select Custom, select the
Enterprise|oracle
1) Hardware Environment
At least 512MB RAM, but 256MB due to test enough
Hard drive must be at least 6G (2G system +4g database)
2) Installation RHEL3ASU2
Choose the minimum installation, about 500 MB.
Turn off the firewall.
Fixed IP, no DHCP
Swap is twice times the ram and at least 400MB
3) Extract the installation files
Zcat ship_9204_linux_
,
Object
);
This method cannot be added.
Later, I went online for a long time and there was no progress. When I got up this morning, I still couldn't do anything. I occasionally opened the Enterprise Library release notes. rtf file in the Enterprise Library installation directory and found that there was such a paragraph
2.4 Data Access Application Block: Default
The company I serve not only has an Oracle database, but also has a SQL Server database, so I often meet people asking me two questions.
The first type is usually "can you teach me to use Oracle?" In the beginning, my polite answer to this is generally "yes, I'm actually going to do an
Enterprise Manager configuration Failure-listener not started or the database service is not registered to the listener solution
Environment: Win7 64-bit system, oracle11g database
Problem Description: Install oracle11g under the Win7 64-bit system, and when creating a database
returns the decrypted data (byte array ).
If we need to expand the custom encryption and decryption methods, we need to start with the above two interfaces and determine whether discrete encryption or symmetric encryption is required to implement different interfaces.
The above is the information about the enterprise database cryptographer module. It mainly introduces common classes of the crypto
, UNIX, and Windows Optimizer.
A detailed description of how PostgreSQL optimizes queries: Explaining the Postgres query Optimizer. This is very easy to understand because it is not introduced from the PostgreSQL algorithmic perspective, but rather shows the PostgreSQL query plan.
SQLite Official Optimization Document: The SQLite Query Planner. It's easy to read, it's easy to tune your rules for SQLite, but it just explains how the optimizer works.
Introduction to SQL Server 2005 tun
name. To this, the database recovery, is complete, can access the system, the normal access to the database T-SQL for database full backup recovery The first thing to do is to create a new database, where I no longer explain Basic Steps for Restore 1) RESTORE database from
I. Environment Description:Original Server 192.168.1.110 Windows Server 2003 system character set: ZHS16GBKThe new ECS 192.168.1.120 RedHat Enterprise Linux system character set is WE8ISO8859PI.
Ii. Problem description:1.110 The database on the server is a Chinese character set, and the values of multiple columns in the data table are Chinese.The character set in the da
The Oracle tutorial being looked at is the comparison of Oracle and SQL Server in enterprise applications. The company I serve not only has an Oracle database, but also has a SQL Server database, so I often meet people asking me t
The Unity module is still difficult for me to learn. Many things are the first time I learned, and some things are not easy to understand. So the content behind the Unity module should be understood by myself, let's add them later. Let's start with the subsequent chapters. After reading about the content behind Unity, we plan to leave four blogs for it. Therefore, the data access module starts from and thanks for your support.
Next let's go back to the question.
Introduction to Data Access Appli
improves the processing performance. 2. A cost-effective DS400 Optical Fiber storage device can be used to build an entry-level SAN. 3. the full redundancy design can effectively avoid single point of failure (spof) on a single device and improve system availability. 4. with the database's parallel processing function, the number of servers can be expanded as needed.
Solution connection diagram:
Recommended configuration scheme:
Category
Product NO.
Product Description
Quan
.
6: If Oracle Application Express is installed on the database, you must set apxrelevels. copy the SQL file from the Oracle 11gR2 (11.2) ORACLE_HOME/apex/directory to a directory outside the Oracle Home Directory, such as a temporary directory on the system. Write down the new location of the file.7. Back up the 11
file : [root@jmilk bin]# pwd
/u01/oracle/bin
[root@jmilk bin]# vim netcaCreate a databaseDBCA programs can perform database options such as creating databases, deleting databases, managing database templates, and configuring existing databasesConfiguring the database configuration Assistant [
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.