2.4.1 Process Structure
There are two major classes of processes in Oracle 9i network environments.
1. User process
A user process is a program that runs on the client's memory, such as "SQL Plus", "Enterprise Manager," running on the client. The user process is making an operational request to the server process.
2. Server process
The main server process is shown in table 2.5.
Table 2.5
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://download.oracle.com/otn/nt/oracle11g/112010/win32
Data Scheme objects
Table 7.1 Oracle 9i data scheme objects
Name
Meaning
Data tables
A table is a database object that holds user data. Tables in a database can be divided into system tables and user tables, depending on the functionality. The system table is used to store data that manages user data and the database itself, also known as the Data dictionary table, the user t
If you encounter a problem when installing Oracle 9i enterprise on Redhat Linux5, please read the following article to help you solve the problems related to the actual application of Oracle 9i enterprise. The installation steps are as follows:Environment: Red Hat Enterprise Linux 5 (RHEL5), Oracle9i (9.2.0.4.0)For RHE
I have been learning Oracle 9i Database for many years. Now I will give a brief description of the basic entry-level operations of Oracle 9i Database. I hope I will be able to learn from Oracle 9i Database beginners.
Initial userU
We all know that Oracle 9i has powerful functions, including the migration function. We can migrate data from a variety of different databases to Oracle. Oracle Database is a newly released migration tool that provides a simple and easy solution for migrating data from Access 2000 to
The following articles teach you how to uninstall Oracle 9i correctly. We uninstall Oracle 9i in the actual operating system of win2000 Enterprise Edition, if you are interested in the actual operations, you can click to view the following articles.
1. Stop all Oracle servi
Oracle 9i Server
Oracle 9i includes processes, memory structures, files, and other componentsThe Oracle 9i server is composed of an Oracle instance and an
Js|oracle
Recently, due to the project, the system needs to be transformed into another environmental system. That is, the Resin + Ms SQL developed JSP program into the WebLogic + Oracle JSP program. Oracle I played it six years ago, I forgot how to use it long ago. From the cooperation project company to get the genuine installation disk installed, suddenly do n
Oracle| issue recently on the Linux platform to write a program need to use Oracle 9i Client call Pl/sql, when debugging found that there is a memory leak problem, the program has bugs, checked n times also did not find problems (whining, depressed dead), It was later found that the Oracle
Unmount Oracle 9i under XP
Keywords: oracle Environment: Windows XP + oracle 9i
1. Stop all Oracle services: Choose Control Panel> Management Tools> services> stop all oracle servic
and save the feature Designe item in License.dat, restart license Manager;5, problem solving.
Resolve Oracle 9i and Tomcat Port conflicts (reprint)
Programme I:
Installed the system, found in the debugger, Tomcat 8080 port has been used, so run Netstat-ano view port usage, found that 8080 port by Oracle listener to occupy, so combined with the Internet to find
Separate the strings 1, 2, 3, 4, 5 with commas (,) and output them as rows. That is, 12345 is handwritten. The Oracle10G and above tables are as follows: SQLselect * fromt; IDNAM ..
Separate the strings 1, 2, 3, 4, 5 with commas (,) and output them as rows. That is, 12345 is handwritten. The Oracle10G and above tables are as follows: SQLselect * fromt; IDNAM ..
Separate the strings '1, 2, 3, 4, 5 'with commas and output them as rows, that is
12345
With one hand written,
For the installation process of Oracle 9i in Ubuntu, refer to this article. This article is mainly based on kubuntu to install Oracle 10g. Refer to this article to easily install 10g, however, oracle 9204 has encountered many obstacles and the installation is complete.
The installation process is as follows:
1. Space R
oracle| Process | data | database
Oracle 9i Database Migration process
Author: unknown
Database movement, often occurs during the implementation of a project, and for experienced DBAs, database movement is very easy. But for some people who only know the system and are not very knowledgeable about the database, Oracle's move is less than capacity.
For example,
Oracle 9i provides a total of 16 scalar data types, as shown in table 7.4.
Table 7.4 Oracle 9i scalar data types
Name
Meaning
Char
Used to describe fixed-length character data, length
Varchar2
Used to describe variable-length character data,
NChar
Fixed-lengt
Oracle 9i Predefined roles
Table 8.2 Oracle 9i Predefined roles
Role name
Description
CONNECT
Database connection role, used to connect to a database, with the right to create clusters, database links, sequences, synonyms, tables, and views, and modify sessions
Dba
The datab
Transactions are the basic unit of database operations in Oracle 9i, and 3 transaction control commands can be used in pl/sql programs.
Commit command
A commit is a transaction commit command. In Oracle 9i databases, in order to ensure data consistency, the client area is set up for each client in memory, and the tra
In front of this article, a lot of such articles are searched on the Internet. Why should we write it out? The reason is that most articles on Oracle 9i on the Internet are incorrect, and no matter what the sender is, the installation method mentioned below is available, if a software installation has no technical content, why should we hide it? But I declare in advance: the best way to install it is to use
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.