It's really easy.
Procedure
Modify the RedHat-release file: Red Hat Enterprise Linux 4
Modify the profile file: Add appropriate environment variables: ORACLE_HOME, oracle_sid, etc.
Create the oracle_setup directory accordingly. Set the
. Automatic Installation selected during installation. Because the user name and password have been forgotten for a long time, I have tried several default user names and passwords (attached in the table ).Default User NameAnd password), all prompts
Set the character set of window: Regedit-> HKEY_LOCAL_MACHINE-> Software-> Oracle-> homeo-> nls_langWindows: SimplifiedAmerican_america.zhs16gbk
View character set in DOS: Echo % nls_lang %
Data Migration in different databases and data exchange
This article mainly introduces the differences between Oracle versions. From Oracle database-related products, from oracle2.0 (no 1.0) to oracle7.3.4, it is a relatively simple version of Oracle, starting with oracle8, the identifier of a database
PrefaceThis article describes DBA's daily responsibilities in monitoring Oracle databases and how to use shell scripts to perform repeated monitoring. This article first reviews some common DBA Unix Commands and explains how to regularly execute DBA
-- ======================================
-- Oracle listener log configuration and management
-- ======================================
The Oracle listener is a server program used to listen to all requests from the client and provide database
I,
Listener (listener)Listener is a server-based network service of Oracle. It is mainly used to listen for connection requests from clients to database servers. Since it is a server-based service, it only exists on the database server, and listener
Installing oracle in Linux is a daunting task. Its complexity far exceeds that of installing the Linux operating system. If Oracle is successfully installedAt the same time, I also mastered some Linux technologies. This article describes how to
Exception in Oracle
1. Advantages of exceptions
If no exception exists, check whether each command succeeds or fails in the program, as shown in figure
Begin
Select...
-- Check for 'no data found 'Error
Select...
-- Check for 'no data found
What is savepoint?
Use
The SAVEPOINT statement to identify a point in a transaction to which you can
Later roll back.
For example:
SQL> SELECT * FROM SCOTT. DEPT;
DEPTNODNAME LOC---------------------------------10ACCOUNTING NEW YORK20 RESEARCH
OverviewThe basic data types of oralce and their storage methods are comprehensively and deeply analyzed through instances. Based on ORACLE 10 Gb, this article introduces the new data types introduced by ORACLE 10 Gb. This gives you a new
/**//*
-- Create a table
Create table student (
Recordid number (38 ),
Sid int not null,
Sname varchar2 (50 ),
Sdate date,
Sage number (3)
);
*/
-- Delete a table
-- Drop table student;
-- Insert data
/**//*
Set serveroutput on -- allow server
Introduction: Oracle DatabaseIt is widely used in various fields of society, especially in the Client/Server mode. However, application developers often encounterSystem PerformanceAs the data volume increases significantly, to solve this problem,
Oracle 10gExploitationUtlsampl. SQLCreateScott userAnd sample data are the main content we will introduce in this article. We know that many demo programs use the tables of scott users and their users as examples. Therefore, quick creation of this
1. Writing Purpose
Unified naming and coding specifications are used to standardize database naming and encoding styles for reading, understanding, and inheritance.
2. Applicability
This specification applies to the development of all application
PL/SQL USE INSERT... to INSERT multiple rows in a SELECT statement, we usually use the INSERT command to INSERT rows into a table. Sometimes, you need to add specific data to the target table based on the records of existing tables and views, you
X86 DBCA and netca give java hotspot error if on X86_64 HARDWARE cannot be started when DBCA command is used to create a new database. The running environment is where the host machine 64bit + AMD cpu, while the client is Linux 32bit + Grid
Rman Based on Time Incomplete recovery SQL> select sysdate from dual; SYSDATE-------------------2013-07-31 22:36:51 run {SQL 'alter session nls_date_format = "yyyy-mm-dd hh24: mi: ss "'set until time' 2013-07-31 22:45:51 'restore database; recover
The ORACLE tutorial is: Oracle-based high-performance dynamic SQL program development.
Abstract: This article summarizes the development of dynamic SQL programs and provides several development skills based on the actual development experience of
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service