export oracle home

1 Background notesNormally, when we install an Oracle database, we create an Oracle user. Its root directory is/home/oracle. and according to Oracle's OFA architecture, it is also recommended to use directories such as/U01 to install Oracle software

The data pump is a server tool, and the exported files are stored on the server where the database is located. Of course, we know that the files can be controlled through directory objects. The directory object has four levels by default. Of course,

In the use of Oracle databases, Backup recovery is the most critical. When the database fails, it can be restored in a timely manner to reduce unnecessary losses. Next I will briefly introduce the import and export of databases, solutions, tables,

When importing data from IMP in Oracle, hybriddb for MySQL prompts that the character set is inconsistent. The imp import and exp export functions of Oracle are often used in the production environment for data migration. The character set is

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:

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

Abstract: This article describes how to install the oracle9.2.0 database in the RedHat Linux9 environment. Keyword: oracle9i RedHat Linux9 Kernel Parameter environment variable Oracle817 is always used in the RedHat linux7.1 environment. Sort out

First, prepare the single instance database server1. Preparing the operating systemNote: It is recommended to install an Oracle database using the Oracle Linux operating system, which is the operating system for Oracle Linux 6.8.#关闭iptablesChkconfig

Logical backup (Data migration):Backup in Logical StructureMove data across usersMoving databases across databasesSave the original data state for the testVersion upgrade of a databaseConsiderations for Logical Export:EXP program in the directory

Installing the Oracle database silently on Linux [Email protected] ~]# cat/etc/oracle-release Oracle Linux Server Release 7.0 [Email protected] ~]# cat/etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 192.168.1.7