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
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
Oracle9i was released on Oracle Open World in October 2000, introducing many new features for Oracle databases, application servers, and development tools. Oracle9i is the industry's first complete and simple software infrastructure for a new generation of intelligent and collaborative applications on the Internet. Oracle9i actually refers to the complete integration of Oracle9i Database, Oracle9i Applicati
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
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
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
:/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->
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
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
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
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
[
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
The ORACLE tutorial is: Oracle 9i product documentation.
I. Enhanced scalability
Oracle9i Real Application Clusters is the next-generation Parallel Server series of Oracle. Oracle9i Real Application Clusters designs fast and efficient shared Cluster High-speed buffer registers for accessing the same data, thus providin
Oracle 10 Gb dmp how to import 9i Problem description: How to migrate database objects in oracle 10 Gb to 9i. the 10g and 9i servers are respectively built on two machines in the LAN and can access each other. problem Analysis: Some information has been found online, indicat
The Oracle tutorial you are looking at is Oracle 9i product documentation.
I. Enhanced ScalabilityOracle9i Real application clusters is Oracle's next-generation parallel server series. Oracle9i Real application clusters provides transparent application scalability by designing a fast and efficient shared cluster cache register for accessing the same data. Oracle9
[Switch] solution to Chinese Character garbled characters on the Oracle 9i or above Client Connected to the Oracle 8i and 8i servers
When a client of Oracle 9i or later is connected to a server of Oracle 8i or later versions, all
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
Author:
Piner(For reprinting, please indicate the source of this article:
Ixdba.com)
Permanent Link:
Http://www.ixdba.com/html/y2008/m12/297-oracle-9i-after-performance.html
If you ask an Oracle DBA what is the most difficult to learn about Oracle, it is estimated that the optimization will be answered in. Indeed,
This chapter describes two main components of the Oracle 9i Network-the installation and configuration process of the database server and the management client. The purpose of this chapter is to help readers understand how to install Oracle 9i and how to configure Oracle
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.