You can find the following content in the init. ora file in the admin/{Sid}/pfile file:
Audit_file_dest =C:/Oracle/product/10.2.0/admin/orcl/adumpBackground_dump_dest= C:/Oracle/product/10.2.0/admin/orcl/bdumpUser_dump_dest=C:/Oracle/product/10.2.0/admin/orcl/udump Core_dump_dest =C:/Oracle/product/10.2.0/admin/orcl/
Tags: data pump ant action username drop operation user Oracl spanORACLE Directory Directory management steps Oracle 's directory is a directory path in the database and needs to be mapped to the corresponding directory in the
Label:Create directory gives us the flexibility to read and write files in an Oracle database, greatly improving the ease of use and scalability of Oracle.Its syntax is:CREATE [OR REPLACE] Directory directory as 'pathname';This case is specifically created as follows:
Create or replace
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= '
Create directory gives us the flexibility to read and write files in an Oracle database, greatly improving the ease of use and scalability of Oracle. The syntax is: CREATE [OR REPLACE] Directory directory as ' pathname '; This case is specifically created as follows: Create
sql> Create or replace directory Dir_dt as '/home/oracle ';Directory created.Sql> Grant Read,write on directory Dir_dt to Scott;Grant succeeded.Sql*loaderTest One: infile *Common parameters
Parameter name
Meaning
Userid
ORACLE Username/p
Oracle dismounted installation, reported [INS-32025] The problem with the selected installation and the specified software conflict in the Oracle home directory (installed) the solution when I reload again, select the previously installed directory (has been removed clean), there is "[INS-32025] The selected installati
Label: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 separately, includi
industry soon people, a personal character is the first, the ability can be cultivated, as long as not really silly, are can be molded, moral problems harm has been, at the same timeA lot of people to imitate the fame and fortune, the original society is impetuous, coupled with these so-called technology Danale to help Chinese manufacturing technology cattle is very difficult, the reason simple as long as they together with them to flatter them.The real theory and actual practice of the Chinese
1 Problem Description:
Recently, according to the corresponding script on the Internet, the following problems were encountered when testing the Oracle control script on the virtual machine:
After you have created the Oracle control script, execute the following start command times wrong:
# services Oracle9i Stop
The error message is as follows:
Cat:/etc/oratab: No file or
Tags: import roc view oracl standard ACL http www. ProgrammingOriginal: http://www.cnblogs.com/hanzongze/p/oracle-catalog.html
. NET Programmer's Oracle Series (1): Navigation directory
. NET Programmer's Oracle Series (2): Preparing a test environment
. NET Programmer's Or
use a driver that is consistent with the database version, and when there is a bug, replace the newer version of the JDBC driver.If a JDBC jar package you do not know is that version, you can unzip the jar package and then meta-inf\manifest. MF file to find the word "Oracle JDBC Driver version-10.1.0.2.0", we'll know the version.---------------------------------------------------Reference:Http://www.oracle.com/technetwork/database/enterprise-edition/
When the database of Oracle 10.2.0.1 is installed on Redhat 5.4, the result remains stuck at 51%:
CP: cannot stat '/discard/': no such fileor directory
However, it will be skipped after a period of time. In short, the link process was very long. During this period, I also watched a movie. Before that, I encountered the link failure problem due to the lack of an RPM package. So I checked the RPM package thi
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 solution to this problem is also the problem of Lib. The normal conditions are as follows:[Email protected] ~]# su-oracle[
Some other maintenance activities are involved when using the recovery directory, such as upgrading the recovery directory during database upgrades or migrations, manually configuring the database counterpart, and synchronizing the recovery directory after some database operations.
1. Unregister the database in Rman
Before
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.