Oracle network address Overview

---- Getting started ----

Getting started
Http://www.cnoug.org/viewthread.php? Tid = 17449 & H = 1

Oracle getting started --> strongly recommended
Http://www.cnoug.org/viewthread... BPG = 1 & age = 0

How do I get started with Oracle?
Http://www.cnoug.org/viewthread.php? Tid = 23373

Getting started
On: http://www.cnoug.org/viewthread.php? Tid = 21207
Under: http://www.cnoug.org/viewthread.php? Tid = 21650

Skills required by DBA
Http://www.cnoug.org/viewthread.php? Tid = 19454

OTN now provides the Oracle database to be downloaded and the download method.
Http://www.cnoug.org/viewthread.php? Tid = 11039 & H = 1

Oracle 8.1.6 for win2000 system file explanation
Http://www.cnoug.org/viewthread.php? Tid = 15080 & H = 1

What are the differences between internal, sys, and system users?
Http://www.cnoug.org/viewthread.php? Tid = 14857 & H = 1

Some experiences in using net
Http://www.cnoug.org/viewthread.php? Tid = 19126

Comprehensive Oracle knowledge stickers
Http://www.cnoug.org/viewthread.php? Tid = 18893

Oracle Application FAQ 1000
Http://www.cnoug.org/viewthread... ighlight = 1000% ce % Ca

Oracle8i and Microsoft SQL Server7.0
Http://www.cnoug.org/viewthread... bsql % 2B % B1 % C8 % BD % cf

Compare SQL Server with Oracle and DB2
Http://www.cnoug.org/viewthread... bsql % 2B % B1 % C8 % BD % cf

Oracle 10g download version and license version are different
Http://www.cnoug.org/viewthread.php? Tid = 13817 & H = 1

Introduction to Oracle 8.1.6 for win2000 system files
Http://www.cnoug.org/viewthread.php? Tid = 23164

How to effectively use data dictionaries
Http://www.cnoug.org/viewthread.php? Tid = 25457

How to install help for sqlplus
Http://www.cnoug.org/viewthread.php? Tid = 1710

On September 21, SQL was passed
Http://www.cnoug.org/viewthread.php? Tid = 25259

How to find the storage location of system files
Http://www.cnoug.org/viewthread.php? Tid = 30263

Oracle Overview
Http://www.cnoug.org/viewthread.php? Tid = 31721

List and description of buffer commands in SQL * Plus
Http://www.cnoug.org/viewthread.php? Tid = 33154

Oracle Database startup and shutdown Methods
Http://www.cnoug.org/viewthread.php? Tid = 36038

V $ session view application
Http://www.cnoug.org/viewthread.php? Tid = 38191

Sqlplus command usage
Http://www.cnoug.org/viewthread.php? Tid = 16867

Oracle Database FAQ diagnosis method --- (Common Errors)
Http://www.cnoug.org/viewthread.php? Tid = 56386

SQL Basics
Http://www.cnoug.org/viewthread .... ghlight = & page = 1

Some common materials that allow beginners to learn
Http://www.cnoug.org/viewthread.php? Tid = 60981

Basic Oracle Problems
Http://www.cnoug.org/viewthread.php? Tid = 57897

 

 

I. Windows Platform

Oracle8i cannot be installed in Win2000 environment on Pentium 4
Http://www.cnoug.org/viewthread.php? Tid = 4639 & H = 1

Schematic Oracle9i installation-Win2000 Platform
Http://www.cnoug.org/viewthread.php? Tid = 10815 & H = 1

9ir2 Installation
Http://www.cnoug.org/viewthread.php? Tid = 10251 & H = 1

Install 10g for Windows 32bit
Http://www.cnoug.org/viewthread.php? Tid = 13816 & H = 1

An error occurred while installing Oracle9i on XP.
Http://www.cnoug.org/viewthread.php? Tid = 14806 & H = 1

The fastest solution to Oracle 8.1.7 installation faults
Http://www.cnoug.org/viewthread.php? Tid = 11113 & H = 1

Oracle 10 Gb installation requirements
Http://www.cnoug.org/viewthread.php? Tid = 13818 & H = 1

Installing the Oracle database Client
Http://www.cnoug.org/viewthread.php? Tid = 10883 & H = 1

Oracle Database 10g for Windows Installation
Http://www.cnoug.org/viewthread.php? Tid = 69177

Ii. UNIX and Linux platforms

Installing Oracle Database 10g on Linux x86
Http://www.cnoug.org/viewthread.php? Tid = 31202

Install Oracle 9i in Linux
Http://www.cnoug.org/viewthread.php? Tid = 13549 & H = 1

Installing Oracle 9ir2 on Red Hat 9
Http://www.cnoug.org/viewthread.php? Tid = 11975 & H = 1

Install Oracle 9.2.0 on Redhat advance Server 3 and upgrade it to 9.2.0.4
Http://www.cnoug.org/viewthread.php? Tid = 12601 & H = 1

Installing Oracle 9ir2 on RHEL as 3 step-by-step
Http://www.cnoug.org/viewthread.php? Tid = 11105 & H = 1

Install Oracle 9i in Red Hat Linux 7.3
Http://www.cnoug.org/viewthread.php? Tid = 9379 & H = 1

Oracle 8i installation manual under RedHat 7.2
Http://www.cnoug.org/viewthread.php? Tid = 4684 & H = 1

Rh7.2oracle9i Installation notes
Http://www.cnoug.org/viewthread.php? Tid = 10371 & H = 1

Brief process for Fedora Core 3 to install Oracle 10.1.0.3
Http://www.cnoug.org/viewthread.php? Tid = 39133

How to install oracle in SuSE Linux
Http://www.cnoug.org/viewthread.php? Tid = 14502 & H = 1

AIX Oracle 8i Installation
Http://www.cnoug.org/viewthread.php? Tid = 5881 & H = 1

Oracle for ibm aix Installation Guide
Http://www.cnoug.org/viewthread.php? Tid = 11038 & H = 1

Oracle9i (9201) Installation manual on aix51-ML05
Http://www.cnoug.org/viewthread.php? Tid = 10089 & H = 1

Install Oracle Database in SCO Unix
Http://www.cnoug.org/viewthread.php? Tid = 9803 & H = 1

Complete oracle8.1.7 for Solaris x86 installation manual
Http://www.cnoug.org/viewthread.php? Tid = 18545

An installation error in linux 9.0
Http://www.cnoug.org/viewthread.php? Tid = 11822 & H = 1

Create Oracle 9204 RAC on Redhat
Http://www.cnoug.org/viewthread.php? Tid = 22639

Oracle9204 is successfully installed on rhas3.
Http://www.cnoug.org/viewthread.php? Tid = 25298

9i RAC for Linux installation (English version)
Http://www.cnoug.org/viewthread.php? Tid = 26610

Install Oracle 11.59 for Linux ERP
Http://www.cnoug.org/viewthread.php? Tid = 28153

Oracle is installed in RedHat A3. The graphic interface displays Chinese characters. The problem is solved successfully.
Http://www.cnoug.org/viewthread.php? Tid = 30405

Install oracle10 -- ZT on Solaris 10/x86
Http: // 218.94.123.17/viewthread. php? Tid = 46686

Install Oracle 9i/10g on RHEL as 3
Http: // 218.94.123.17/viewthread. php? Tid = 44867

10gr2 + Redhat Enterprise Linux as4 installation (including self-starting) Summary
Http: // 218.94.123.17/viewthread. php? Tid = 77252

 

---- Initialization (configuration part )----

all scripts and instructions for manually creating databases
http://www.cnoug.org/viewthread.php? Tid = 4647 & H = 1
Oracle database network installation and configuration
http://www.cnoug.org/viewthread.php? Tid = 10549 & H = 1
how to delete oracle in Windows
http://www.cnoug.org/viewthread .... MP; BPG = 3 & age =-1
http://www.cnoug.org/viewthread .... MP; BPG = 3 & age =-1
dual-Machine Fault Tolerance solution
http://www.cnoug.org/viewthread.php? Tid = 10253 & H = 1

9i create standby database on Windows
Http://www.cnoug.org/viewthread.php? Tid = 23039

How to configure OMS for OEM
Http://www.cnoug.org/viewthread.php? Tid = 10457 & H = 1

How to connect to the Oracle database and how to solve the fault
Http://www.cnoug.org/viewthread.php? Tid = 15661 & H = 1

How to configure multiple databases in Oracle
Http://www.cnoug.org/viewthread.php? Tid = 5610 & H = 1

Solutions to Oracle database character set Problems
Http://www.cnoug.org/viewthread.php? Tid = 15066 & H = 1

Cleverly converting Oracle database character sets
Http://www.cnoug.org/viewthread.php? Tid = 7316 & H = 1

Management of super-level user permissions in Oracle
Http://www.cnoug.org/viewthread.php? Tid = 4823 & H = 1

I just installed 9i, but I don't know the account and password
Http://www.cnoug.org/viewthread.php? Tid = 5647 & H = 1

After oracle is installed, why can't IIS Web sites be used? For more information, see!
Http://www.cnoug.org/viewthread.php? Tid = 17727

Solve the three-step problem that the node database cannot be found after the OEM Configuration
Http://www.cnoug.org/viewthread.php? Tid = 18889

Broke the 2 GB memory limit of Oracle for Win2k
Http://www.cnoug.org/viewthread.php? Tid = 7181 & H = 1

How to connect two Oracle servers
Http://www.cnoug.org/viewthread.php? Tid = 4646

Win2000 domain mode and win2003 + ora816 cannot be started by yourself
Http://www.cnoug.org/viewthread.php? Tid = 20786

Restrictions on the size of Oracle physical files
Http://www.cnoug.org/viewthread.php? Tid = 23011 & SID = dln1a9e0

Solution to Oracle connection across CIDR blocks
Http://www.cnoug.org/viewthread.php? Tid = 25531

What should I do if I forget the database administrator and password?
Http://www.cnoug.org/viewthread.php? Tid = 18304

About Installing Oracle raw device in Linux
Http://www.cnoug.org/viewthread.php? Tid = 26708

Use of spfile
Http://www.cnoug.org/viewthread.php? Tid = 34975

 

 

 

 

 

---- Document ----

SQL Training Content
Http://www.cnoug.org/viewthread.php? Tid = 15068 & H = 1

Oracle Training Course (word)
Http://www.cnoug.org/viewthread... BPG = 1 & age = 0

Oracle Classic Books
Http://www.cnoug.org/viewthread... BPG = 1 & age = 0

Oracle8i backup and recovery manual
Http://www.cnoug.org/viewthread.php? Tid = 18130

An electronic version of ora8i DBA
Http://www.cnoug.org/viewthread.php? Tid = 3176

Introduction to cluster and OPS technologies and their applications
Http://www.cnoug.org/viewthread.php? Tid = 5345

How to change Instance name
Http://www.cnoug.org/viewthread.php? Tid = 19676

Differences between SQL Server and Oracle Functions
Http://www.cnoug.org/viewthread.php? Tid = 19965

Data Warehouse
Http://www.cnoug.org/viewthread.php? Tid = 19151

Oracle Functions
Http://www.techonthenet.com/oracle/functions/index.htm

Summary of table and index topics
Http://www.cnoug.org/viewthread.php? Tid = 20711

Oracle8i_9i database Basics
Http://www.cnoug.org/viewthread.php? Tid = 21207

Oracle internal research (Classic Forum)
Http://www.cnoug.org/viewthread.php? Tid = 886

Oracle9i Database management lecture
Http://www.cnoug.org/viewthread.php? Tid = 22946

B + tree
Http://www.cnoug.org/viewthread.php? Tid = 23693

Hash Index
Http://www.cnoug.org/viewthread.php? Tid = 23694

SQL, PL/SQL lectures (PPT)
Http: // 218.94.123.17/viewthread. php? Tid = 23993

DBA learning materials
Http://www.cnoug.org/viewthread.php? Tid = 66890

 

 

---- Learning notes ----

Oracle structure and management notes
Http://www.cnoug.org/viewthread.php? Tid = 17985

Oracle Network Management notes
Http://www.cnoug.org/viewthread.php? Tid = 17986

Oracle optimization notes
Http://www.cnoug.org/viewthread.php? Tid = 17988

Oracle8i backup and recovery notes
Http://www.cnoug.org/viewthread.php? Tid = 17984

SQL, PL/SQL notes
Http://www.cnoug.org/viewthread.php? Tid = 17974

 

 

---- Daily management (daily application )----

How to Set Oracle9i to auto-start on the IBM aix5l System
Http://www.cnoug.org/viewthread.php? Tid = 10468 & H = 1

Can I install a new database on a different disk?
Http://www.cnoug.org/viewthread.php? Tid = 14498 & H = 1

Oracle ofa Structure
Http://www.cnoug.org/viewthread.php? Tid = 25669

An error occurred while loading the database during installation. areasqueries
Http://www.cnoug.org/viewthread.php? Tid = 3746 & H = 1

Can I use ODBC to connect to Oracle without installing the oralce client?
Http://www.cnoug.org/viewthread.php? Tid = 14970 & H = 1

Log on to the database (how to use the initial installed locked account)
Http://www.cnoug.org/viewthread.php? Tid = 16664 & H = 1

Similarities and differences between truncate, delete, and drop
Http://www.cnoug.org/viewthread... MP; BPG = 3 & age =-1

How to use bare devices in oracle9
Http://www.cnoug.org/viewthread.php? Tid = 17990

Oracle Data Dictionary
Http://www.cnoug.org/viewthread... MP; BPG = 3 & age =-1
Http://www.cnoug.org/viewthread... MP; BPG = 3 & age =-1

Null Usage Details
Http://www.cnoug.org/viewthread... MP; BPG = 3 & age =-1

Converting from non-archive mode to archive mode in Oracle databases
Http://www.cnoug.org/viewthread.php? Tid = 15081 & H = 1

Regularly split tables with stored procedures in Oracle
Http://www.cnoug.org/viewthread.php? Tid = 17081 & H = 1

Common Oracle errors Code Analysis and Solution
Http://www.cnoug.org/viewthread.php? Tid = 15075 & H = 1
Http://www.cnoug.org/viewthread.php? Tid = 15076 & H = 1

Oracle client Programming
Http://www.cnoug.org/viewthread.php? Tid = 15065 & H = 1

Research on Oracle recovery Internal Structure
Http://www.cnoug.org/viewthread.php? Tid = 16938 & H = 1

PL/SQL single-row functions and group functions
Http://www.cnoug.org/viewthread.php? Tid = 17281 & H = 1

805 installation on a single machine, oracletnslistener80 cannot be started
Http://www.cnoug.org/viewthread.php? Tid = 5002 & H = 1

Help! Unable to start listener
Http://www.cnoug.org/viewthread.php? Tid = 13528 & H = 1

Problems with ORA-12560: TNS: protocol adapter errors
Http://www.cnoug.org/viewthread.php? Tid = 16728 & H = 1
Http://www.cnoug.org/viewthread.php? Tid = 10998 & H = 1
Http://www.cnoug.org/viewthread.php? Tid = 3004 & H = 1

Password Change
Http://www.cnoug.org/viewthread.php? Tid = 7928 & H = 1

How to input blob Field Values
Http://www.cnoug.org/viewthread.php? Tid = 15016 & H = 1

Select rows m to N from the relational database
Http://www.cnoug.org/viewthread.php? Tid = 15067 & H = 1

Import data from Oracle to excle
Http://www.cnoug.org/viewthread.php? Tid = 15871 & H = 1

Some useful tools for Oracle beginners
Http://www.cnoug.org/viewthread.php? Tid = 16730 & H = 1

The syntax for modifying select statements is often used in iSQL * Plus.
Http://www.cnoug.org/viewthread.php? Tid = 15371 & H = 1

Randomly generate a random number between 100 and 999.
Http://www.cnoug.org/viewthread.php? Tid = 15583 & H = 1

Copy and paste skills in sqlplus
Http://www.cnoug.org/viewthread.php? Tid = 16389 & H = 1

View Database SQL
Http://www.cnoug.org/viewthread.php? Tid = 17062 & H = 1

Encrypt the stored procedure and grant it to other users for execution
Http://www.cnoug.org/viewthread.php? Tid = 17079 & H = 1

Get and use variables in the *. SQL File
Http://www.cnoug.org/viewthread.php? Tid = 17078 & H = 1

Direct BDE access to Oracle in Delphi
Http://www.cnoug.org/viewthread.php? Tid = 17063 & H = 1

Can I change the Oracle working directory? How to change
Http://www.cnoug.org/viewthread.php? Tid = 17778

How to add a unique constraint to a table (store or delete redundant data)
Http://www.cnoug.org/viewthread.php? Tid = 4426

Oracle startup after installing the ripple patch (discussion)
Http://www.cnoug.org/viewthread.php? Tid = 18011
Http://www.cnoug.org/viewthread.php? Tid = 17136

Complete print of common Oracle commands
Http://www.cnoug.org/viewthread.php? Tid = 18203

Use SQL * loader to export Excel Data to the Oracle database
Http://www.cnoug.org/viewthread.php? Tid = 7136

Use a sequence generator + trigger to automatically add one Field
Http://www.cnoug.org/viewthread.php? Tid = 18700

How does function return a dataset?
Http://www.cnoug.org/viewthread.php? Tid = 4223

Sqlldr usage Summary (zt)
Http://www.cnoug.org/viewthread... MP; Highlight = sqlldr

Why cannot I start Oracle databases in Win2000?
Http://www.cnoug.org/viewthread.php? Tid = 966

How to use SQL * Plus for simple reports in Oracle?
Http://www.cnoug.org/viewthread.php? Tid = 19573

About the date type !!! -How to get the time accurate to 1‰ seconds
Http://www.cnoug.org/viewthread.php? Tid = 17447

How to Use the cron process for Automatic Execution (Summary)
Http://www.cnoug.org/viewthread.php? Tid = 14728

Use of logminer
Http://www.cnoug.org/viewthread.php? Tid = 20694

Use of complex query statements
Http://www.cnoug.org/viewthread.php? Tid = 21185

SQL row/column conversion practice
Http://www.cnoug.org/viewthread.php? Tid = 21713

A text occupies several bytes.
Http://www.cnoug.org/viewthread.php? Tid = 22236

Restrictions on the size of Oracle physical files
Http://www.cnoug.org/viewthread.php? Tid = 23011

Sqlplus command User Guide
Http://www.cnoug.org/viewthread.php? Tid = 10132

Oracle Data Operation and Control Language
Http://www.cnoug.org/viewthread.php? Tid = 12523

How to determine Repeated Records in Oracle database tables
Http://www.cnoug.org/viewthread.php? Tid = 24495

One reason why oracleorahome90agent cannot be started
Http://www.cnoug.org/viewthread.php? Tid = 11132

How to determine whether a field contains Chinese Characters
Http://www.cnoug.org/viewthread.php? Tid = 25691

Job usage Summary
Http://www.cnoug.org/viewthread.php? Tid = 29098

How to access Oracle in the JSP of ipvsws 2000
Http://www.cnoug.org/viewthread.php? Tid = 31367

Common command line tools for ORACLE Server (Oracle 8.1.7 for Windows)
Http://www.cnoug.org/viewthread.php? Tid = 31699

Introduction to common Oracle services in Windows
Http://www.cnoug.org/viewthread.php? Tid = 31761

ORA-01555 "snapshot too old"
Http://www.oracle.com.cn/viewthread.php? Tid = 31866

Directly modify the name of the Oracle table column in the data dictionary (not recommended, but you can try it when there is no way)
Http://www.cnoug.org/viewthread.php? Tid = 31852

Common Oracle management tools software download URL (including a toad Chinese instructions)
Http://www.cnoug.org/viewthread.php? Tid = 24698

Introduction and Application of Oracle temporary tables (temporary table) (see the fifth floor)
Http://www.cnoug.org/viewthread.php? Tid = 34212

Understand and use Oracle 8i analysis tool-logminer
Http://www.cnoug.org/viewthread.php? Tid = 28201

Partition Table operations in Oracle Database
Http://www.cnoug.org/viewthread.php? Tid = 62894

 

 

---- Daily management (backup and recovery )----

I cannot import data because of different character sets!
Http://www.cnoug.org/viewthread.php? Tid = 7602 & H = 1

"Loaded" during database recovery
Http://www.cnoug.org/viewthread.php? Tid = 6184 & H = 1

Exp and IMP usage and introduction (zz) If you have any problems in this regard, first look at this post. We strongly recommend that you !!!
Http://www.cnoug.org/viewthread.php? Tid = 14188

Exp and IMP commands
Http://www.cnoug.org/viewthread.php? Tid = 15088 & H = 1

Automatic Backup of Oracle scheduled tasks in Win2000
Http://www.cnoug.org/viewthread.php? Tid = 14402 & H = 1

Database Replication in Oracle
Http://www.cnoug.org/viewthread.php? Tid = 17073 & H = 1

The data block is broken and cannot be started. How can this problem be solved?
Http://www.cnoug.org/viewthread.php? Tid = 22398

Oracle 9i RMAN reference User Manual
Http://www.cnoug.org/viewthread... = z71oddme # pid124460

Oracle 9i physical backup database Reference Manual
Http://www.cnoug.org/viewthread.php? Tid = 22640

Automatic database backup script
Http://www.cnoug.org/viewthread.php? Tid = 20864
Http://www.cnoug.org/viewthread.php? Tid = 37483
Http://www.cnoug.org/viewthread.php? Tid = 42027

Export/import usage tips and Common Errors
Http://www.cnoug.org/viewthread.php? Tid = 23596

Knowledge about using resetlogs
Http://www.cnoug.org/viewthread.php? Tid = 146

Summary of online RMAN backup in oms
Http://www.cnoug.org/viewthread.php? Tid = 30874

EXP/imp of different Oracle versions
Http://www.cnoug.org/viewthread.php? Tid = 36930

Oracle8i standby database implementation solution
Http://www.cnoug.org/viewthread.php? Tid = 37572

Oracle8i/9i exp/IMP experience
Http://www.cnoug.org/thread-36183-1-1.html

 

 

---- Daily management (performance adjustment )----

Oracle Lock Management
Http://www.cnoug.org/viewthread.php? Tid = 5872 & H = 1

Can Oracle restrict a user's access process (/processes ?) Quantity?
Http://www.cnoug.org/viewthread.php? Tid = 19233

Common monitoring SQL
Http://www.cnoug.org/viewthread.php? Tid = 18893

Statspack Analysis
Http://www.cnoug.org/viewthread.php? Tid = 20202

View the table space usage (see the third floor in the post)
Http://www.cnoug.org/viewthread.php? Tid = 18479

Introduction to Oracle locks
Http://www.cnoug.org/viewthread.php? Tid = 14849

How to reduce and recycle temp usage capacity
Http://www.cnoug.org/viewthread.php? Tid = 23682
Http://www.cnoug.org/viewthread.php? Tid = 23673

Oracle optimization classicArticle------ Disk I/O and fragment
Http://www.cnoug.org/viewthread.php? Tid = 37689