oracle directory

After Oracle 10g installation is complete, its directory structure differs greatly from that of oracle9i. The main structure of the Oracle Database 10g and Oracle9i file directories is shown in the following illustration. The ora92 in the Oracle9i file directory structure is replaced with db_1 in the

The path and archive directory where database resides must be separatedThe location of the database is the path of the Redol log file, the path where the datafile is located, the path of the control fileThe archive path mentioned here refers to the archive destination of the database.The path to the database must be in a different file system than the archive path, or it must be in a different ASM disk group.Why is it so mandatory?You can assume the f

Oracle OCP 11G 053 (1-200) Answer resolution directory 　 V13.02 version, 711 questions File version:3.2,200 problem version:5.4 1 http://blog.csdn.net/rlhua/article/details/16369867 490 2 http://blog.csdn.net/rlhua/article/details/16527169 491 3 http://blog.csdn.net/rlhua/article/details/14057145 142 7

Generally, directory is created to use a Data Pump to import/export data. In fact, directory has many other functions, which will not be described in this article. 1. New directory syntax Create [or replace] DirectoryDirectoryAs'Pathname'; For example: Create or replace directory dump_dir as 'd: \ dump \ dir' Set

1. Introduction to the experimental environment 1.1 soa Original Database database name comsoa instance name COMSOADBID 4133565260 database version windows64bit10.2.0 data file directory H:\ORACLE\ORADATA\ Comsoapfilecomsoa.__db_cache_size=1291845632comsoa.__java_pool_size=16777216comsoa.__large_pool_size= 16777216comsoa.__shared_pool_size=805306368comsoa.__streams_pool_size=0*.audit_file_dest= '

Today is 2014-05-27, today encountered a Lib problem, record again. This is a case, but also a way to solve the problem of the process.When we use Sqlplus to log in to a UNIX database, there is a possibility of a similar problem: xxxxxx bad ELF interpreter:no such file or directory. The cause of this problem is also the problem of Lib. The normal situation is as follows:[Email protected] ~]# su-oracle[[emai

Label:Http://techxploration.blogspot.com/2012/01/resolving-sp2-0750-you-may-need-to-set.html Resolving sp2-0750:you may need to set Oracle_home to your Oracle software directory If your set up Oracle Database XE 1 1G in Linux and your encounter the following error when starting up SQL Plus: $ sqlplussp2-0667:message file SP1Sp2-0750:you need to set Oracle_home to

than 40 g. Environment Description: Rhel6.2+oracle11_r2 Partition:/200g,/u01 50G,/archvielog 500G,/app 3.0T Zoning also from the planning of disk space use, in fact, before planning to think that the/u01 space is too small, this thought 50G is enough, but later proved to be wrong, mainly temp,undo files occupy too much space (some methods can be free from the creation of undo, such as: 1, insert/*+ Append/into TABLE_NAME, 2, set the table to not write the log, the temp file must be free of t

First, create a recovery directory 1, the establishment of the table space Create tablespace rc_data datafile '/u01/app/oracle/oradata/ocp/rc_data.dbf ' size 50m; 2, build users Create user RC_OCP identified by RC_OCP default tablespace rc_data quota on unlimited; 3. Authorization Grant Connect,resource,recovery_catalog_owner to RC_OCP; 4, create a directory