1. Download Oracle 9i 10g 11g (Please use thunder to create a task)
Oracle Database 11GRelease 2 (11.2.0.1.0) for Microsoft Windows (32-bit)
Http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_database_1of2.zip
Http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_database_2of2.zip
Http://down
Tags: www. ORACL book data. com github Source code download HTTP 11gBackgroundIn the search for the source of the book, the search to provide is required to download the C-currency. More stubborn (in fact, poor).In the preface to this book, it is mentioned that the source code can be downloaded from www.appress.com.The following is a link to the book on the site:https://www.apress.com/us/book/9781430229469C
application Suite E-commerce Suite (E-business Suite), and through the application of their own E-commerce suite successfully launched E-commerce.
Today, Oracle has a Trinity E-commerce strategy that includes platform products, applications, and services, providing users with the most complete E-commerce technology and consulting services. Oracle9i is a new generation of complete, simple e-business infrastructure platform products, composed of oracl
:
The installation of Oralce 9i requires at least MB of memory. Run the following command to check the memory size of the Host:
grep MemTotal /proc/meminfoMemTotal: 900252 kB
900252kB is the memory size of your system.
Exchange zone:
The size of the swap area is generally twice the size of the memory, at least MB or more. Of course, the larger the size is, the better. Run the following command to view the size of the swap area:
This article will introduce the installation process of Oracle Database 9i in Open Unix 8. If you have experience installing Oracle, you can use the quick installation manual. If you have never installed Oracle databases before, from this article, we will be familiar with the oracl
Oracle
1, uncompress and unpack downloaded files
One step procedure (uses less disk spaces and is faster):
Zcat lnx_920_disk1.cpio.gz | Cpio-idmv
Zcat lnx_920_disk2.cpio.gz | Cpio-idmv
Zcat lnx_920_disk3.cpio.gz | Cpio-idmv
Two Step procedure:
# uncompress
Gunzip lnx_920_disk1.cpio.gz lnx_920_disk2.cpio.gz lnx_920_disk3.cpio.gz Linux9i_Disk3.cpio.gz
# Unpack the downloaded files:
CPIO-IDMV CPIO-IDMV CPIO-IDMV
Now should have 3 directories con
Oracle
Install Oracle 9i/10g on RHEL as 3
Author: ern (yaoyongping@gmail.com)
This article describes the steps and knowledge necessary to install Oracle 9i/10g on red Hat Enterprise Linux Advanced Server 3 (RHEL as 3). A lot of related articles, this article mainly focuses
Oracle Background information
Before we introduce Oracle 9i, let's introduce some information about Oracle company to give our friends more insight into Oracle.
In 1977, Larry Airison and Bob Miner and Ed Oates created a software development lab (Software Development Labor
This paper (howto) describes step-by-step installation of Oracle 9i database software on Fedora Core 2, 3, 4, 5 and 6.
This paper covers following steps:
Pre-instalation tasks
Download Install
Post-instalation tasks
Common installation errors
Pre-instalation tasks
1. Create Oracle user accou
Red Hat Enterprise Linux AS4, C ++ OCCI connect Oracle 9i
Red Hat Enterprise Linux AS4, C ++ OCCI connect Oracle 9i, provided that Oracle 9i has been installed.
1. Download the correspo
being used, or with 'extproc _ connection_data 'for an external procedure call.
I carefully checked the configuration of all the files and found that the listener name caused an error (sid_list_newlistener). Therefore, I suggest you carefully check all the configuration files if this error occurs.
(4) recommended reading:
Managing Oracle heterogeneous services using transparent gateways:Http://download
When a client of Oracle 9i or later is connected to a server of Oracle 8i or later versions, all the Chinese data queried becomes garbled. The query finally solved the garbled problem.
The development tool is ASP. NET (C #) + Oracle, using system. Data. oracleclient to connect to the
I. Preparations
◆ 1. Download oracle 9i for linux
◆ 2. Download patches
P3006854_9204_LINUX.zip before running runInstaller.
(The extracted name is rhel3_pre_install.sh)
◆ 3. Modify the kernel parameters (you don't need to modify the kernel parameters unless rman is used. You have to set the kernel parameters if necess
:/Program files/oracle folder.
Delete the C:/oracle folder.
The Oracle 9i Uninstall method is attached, similar to the Uninstall method:
1, Start-> Settings-> Control Panel-> Management Tools-> ServicesStop all Oracle Services.
2, Start-> Program->
Incorrect practice:
To port the data in the oracle 9i database to a lower version of oracle 8i, first use the exp command to export the command line in oracle 9i ):
Exp username/password @ Global SID file = export database file name owner = user
Copy the exported database fi
If you want to restore a database on a colleague's machine to your own machine, the DMP file provided by the colleague cannot be used. I suddenly thought of Oracle 10 Gb, and I was still in the Oracle 9I stage. Back up again with your own 9I client, resulting in a EXP-00003 error. I checked on the Internet that the BLO
1. Create the same directory as the 9i data file, control file, and redo file on the target server where Oracle 10g software is installed (the data files of the two databases must be in the same location, otherwise, you need to use alter database rename file 'original location 'to 'destination location ')
2. Shut down the 9i source database, copy
Basic Data Types of Oracle 9i
Data Type
Description
Char
Fixed-length bytes data with a maximum length of 2 kb
Nchar
Data of UNICODE character set with a fixed length of 2 kb
Varchar2
Variable-length bytes data up to 4000 characters
Nvarchar2
Stores variable-length bytes data of the
Now there is a need to use Exp/imp to import 11g of database data into 9i, to solve this problem generally think of three ways of thinking, try (in fact, from the high version of the server to support the low version of the client principle, you can probably guess the use of 9i client to handle the problem)
Method 1: Export imports all use 11g clients
--11G Client Export
[
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.