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 database on the 1.120 server does not su
1. For the installation process, refer to the article "installing Oracle Database 10 GB on Linux x86" on the Oracle Website:
Http://www.oracle.com/technology/global/cn/pub/articles/smiley_10gdb_install.html
2. After the installation is complete, set to automatically start the Oracle service:Create or modify the/etc/ora
The RedHat Enterprise Linux 5 installation was successful, but many errors occurred while installing Oracle.
The official Oracle 10g version website is here.
You do not need to register for downloading with thunder. You need to register for IE downloading.
1. Install related software packagesThe list is as follows:Binu
Test environment: Install Oracle Enterprise Linux 5.8 64-bit Virtual Machine in VMware Workstation v9.0.2
Install software: jdk-7u40-linux-x64.rpm?apache-tomcat-7.0.53.tar.gz
Installation instructions: Download jdk-7u40-linux-x64.rpmand apache-atat-7.0.53.tar.gz from the off
Operating System: RedHat linux 5 (Enterprise Edition)
Software: Oracle 10g R1
Preparations:
Download the official oracle 10g install for linux documentation
Software to be installed in Linux:
GNOME Desktop Environment/KDE
X Window
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_disk1.cpio.gz | Cpio-idmv
Zcat ship_9204_linu
Tags: vlm x265 lmos jsf2 RTK SRM LVM csdn file
Enter OEL
Click Skip
Click Next
Select default
Select default
Select OK
In the Red box, select Create custom layout
Click New
Select Swap,size in file System Type now 4096
At mount point Select/
In additional size options select Fill to maximum allowable size
To view the partition, click Next
Click Next
Click Edit
In the Virtual network editor in
I. preparations:Go to www.oracle.comto download linux_x86_11gr1_database.zip (x86 represents the architecture of the computer and is usually x86 ).2. Create necessary users, groups, and directories# Mkdir-p/u01/Oracle# Groupadd dba# Groupadd oinstall# Useradd-g oinstall-G dba/u01/oracle# Passwd oracle password setting# Chown-R
Click Continue
Click Forward
Click Finish
After reboot, enter the system, username root
User password
installing VMware Tools
Open Terminal
Enter Cp/media/vmware\ tools/vmwaretools-9.6.1-1378637.tar.gz.
Unzip, Tar-xvzf vmwaretools-9.6.1-1378637.tar.gz
RM vmwaretools-9.6.1-1378637.tar.gz
Enter Y
CD vmware-tools-distrib/
Installation./vmware-install.pl
Enter 12 times, to select the resolution, input 3, retur
Follow the configuration of your machine
Processor configuration
Follow the configuration of your machine
Memory for this virtual machine
Network type
Select I/O Controller type
Select disk Type
Select disk
Allocate the disk capacity of the virtual machine, depending on the size of your disk
Specify disk files
Click on Custom Hardware
Ready to create virtual machine
Hardware
Remove Hardware Last View
[Study hard] instal
Install Quick Installation Guide 10g Release 2 (10.2) for Linux x86.
Problems encountered during installation:
Start Oracle Universal Installer/tmp/OraInstall from the following address. please wait... [oracle @ nj15 database] $ Exception in thread "main" java. lang. internalError: Can't connect to X11 window server using 'localhost: 100' as the value of the DISP
1. Prepare the environment1.1. Software InformationVirtual Machine: VirtualBox 4.2Operating System: Oracle Linux Server release 5.9OCFS2: ocfs2-2.6.18-348.el5-1.4.10-1.el5.x86_64.rpm1.2. Host Configuration1.2.1. Hosts file[Root @ skynode1 ~] # More/etc/hosts# Do not remove the following line, or various programs# That require network functionality will fail.127.0.0.1 localhost# Skynode1192.168.1.241 skynode
Test environment: Oracle Enterprise Linux 64-bit (5.8 version) + Oracle 11g 64-bitDescription: The oracle11g64-bit software is installed at/u01/app/oracle/product/11.2.0/dbhome_1, the database name is the default Orcl,linux the IP
Since Oracle 10g Release 2 was released earlier than rhel5.4, the official Oracle documentation does not provide the 10gr2 installation manual on rhel5.4. I will write a separate article on installing 10gr2 on rhel5.4, this document describes how to delete database software. In fact, the idea is simple: Delete the relevant files. There are two methods: manual deletion on the Character interface and deletion
compile it with the following command:g++296 -o oci-i/opt/oracle/product/rdbms/public/-i/opt/oracle/product/rdbms/demo/-i/home/oracle/ instantclient10_1/-l/opt/oracle/product/lib/-l/opt/oracle/product/rdbms/lib/oci. CPP -lclntsh-locci/usr/lib/libstdc++.so. 5 -wall-o-GTake a
, as long as the Linux x86 host is running a multiple of 24.8, it is possible to raise the bug because the time () function value is null, causing an infinite dead loop, thus exhausting the CPU. Solution Three kinds:1 reboot the host;2) dozen patch set, such as upgrade to 10.2.0.4;3 The bug alone to play temporary patch 4612267.The first method does not completely solve the problem, in the future as usual; the second method, the upgrade time is long,
Similarities and differences between Oracle Enterprise Edition, Standard Edition, and other versions, oracle Enterprise Edition
For different development and deployment environments, Oracle divides the same series of Oracle datab
Similarities and differences between Oracle Enterprise Edition, Standard Edition, and other versions, oracle Enterprise Edition
For different development and deployment environments, Oracle divides the same series of Oracle databa
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.