Linux modifies the Oracle database character set instance and the oracle Character Set
1. Log On As a dba in SQL * PLUS
Conn/as sysdba
> Shutdown immediate; (stop the database)> startup mount; (restart the database to change the condition)> alter system enable restricted session;> alter system set job_queue_processes = 0;> alter system set aq_tm_processes = 0
Oracle SQL handler, yesDesigned for Oracle database developers and operatorsA carefully crafted Oracle client tool:Ultra-intelligent SQL Editor;Ultra-convenient table operations(You can update the data warehouse table by modifying the cell data of the table );Export data in multiple formats, including xls, CSV, insert SQL, HTML, and XML;Chinese and English Interf
After installing Oracle 10g R2 under CentOS 6.3, you will find that Oracle does not start on its own, which is normal, because installing Oracle under Linux does not start on its own, you have to set the relevant parameters yourself, First, let's begin by describing how to launch O
You'll need about 2.5 GB for the database software. If you perform a typical database installation and don't a customized database installation, then you'll need about 3.5 GB of disk space.
6, "Binutils" Issue (If you fond following error)
Q: "Error invoking target install of makefile/opt/oracle/product/9.0.1/plsql/lib/ins_plsql.mk"
A:This obviates the need to change binutils
Download the following Binutil RPM version and downgrade Binutil on th
machine also performed very well.
A lot of people have a misunderstanding of Linux, that is, always put Linux and low-end hardware platform to connect together, In fact, starting with the 2.1.XX-series kernel, Linux began to move up the path, after about 1.3, began porting to other hardware platforms, including the so-called fastest CPU---Digital Alpha (currentl
I. PreparationsTo integrate the Linux/Apache/PHP4/FastCGI/Oracle/MySQL environment, you must first prepare the following software packages:(1) Perl interface for database tutorials1. perl5 Oracle DBI Driver: DBD-Oracle-1.03.tar.gz2. perl5 universal database interface program: DBI-1.13.tar.gz3. perl5 MySQL database DBI
home page, you can see a list of CPU patches released each quarter (as shown in the following figure), choose the appropriate CPU patch according to your needs, and choose the patch for July2011 year.Each patch is specific to the database version, you need to find the corresponding database version (shown below), the database version is 11.2.0.1, if not found, the patch does not support the version of the database.
Right click on the database link, which is a detailed des
Migrate the oracle database from one machine to another machine (the same as the linux platform) and set it to a different path with different instance names
Migrate the oracle database from one machine to another machine (the same as the linux platform) and set it to a different path with different instance names
There is an automatic backup script program for rman. I have previously written an automatic backup case for exp backup specific solution (Oracle automatic backup case for Linux platform (using exp tool)
There is an automatic backup script program for rman. I have previously written an automatic backup case for exp backup specific solution (Oracle automatic backu
the number of operating system bits[root@FSWWOA /]# uname -mx86_64X86_64: Indicates that Intel's processor is used, and that the operating system is 64-bitI386: Indicates that it is a 32-bit1.3. Check the hard disk space#查看临时目录空间[root@FSWWOA /]# df -h /tmp#查看硬盘总空间[root@FSWWOA /]# df -hOracle installation is required to have at least 1GB of space in the/tmp directory.The following are the required space for each version of Oracle installation
Oracle
How to install and run Oracle on your Linux machine start action
It can be pretty easy to install Oracle on Redhat, but if you follow Oracle company completely
Documentation is not always easy to walk through. The quickest shortcut is Tom Bisset's homepage:
Http://jo
I. Environment preparation1. experiment environmentOperating System: Oracle Enterprise Linux 5.6Virtual Machine version: VMware 8.0Virtual Machine Hardware configuration: processes 1, ram 1G, disk type SICS, disk size 30G, Nic type NATWhen initializing the system, you must disable the firewall and security policy, without creating any new users.Change the OS ip address to a static ip Address[Root @ oel10g ~
Tags: cal har pen setting Shu official root linking hostLinux platform Oracle 10GR2 (10.2.0.5) RAC installation Part2:clusterware installation and upgradeEnvironment: OEL 5.7 + Oracle 10.2.0.5 RAC 3. Installing Clusterware
3.1 Extracting Clusterware Mounting media
3.2 Starting the installation of Clusterware
3.3 Root user executes script as prompted
3.4 VIPCA Creation (may not be requi
Oracle GoldenGate introduction and installation configuration tutorial
Introduction to Oracle GoldenGate
GoldenGate is a log-Based Structured Data replication software. GoldenGate can capture, transform, and deliver a large amount of transaction data in real time, synchronize data between the source database and the target database, and maintain data latency in s
Configure Oracle 8 for Linux
Before using Oracle 8 in Linux, Oracle 8 should be installed, but the installation documentation provided by Oracle is relatively simple. The author draws on the Installation Method in the Unix operati
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.