Discover connect oracle command line, include the articles, news, trends, analysis and practical advice about connect oracle command line on alibabacloud.com
--- The following is OracleClient
The following describes how to access the Oracle database through the ASP. NET page through System. Data. OracleClient,
In fact, it is relatively simple,
First, let's introduce the environment,
My machine is
Oracle 10 Gb manual database creation using command line
Reprinted: http://tech.ccidnet.com/art/1105/20080807/1536965_1.html
There are two methods to create a database in Oracle. The first is to use ORACLE database builder and dbca, which is a
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:
Use the sqlplus command line tool to create users and tablespaces for oracle, sqlplusoracle
Creating tablespaces and users and assigning permissions using the Enterprise Manager or PL/SQL graphical method that comes with Oracle10g is relatively
1. Oracle startup and Shutdown1. In a single-host environmentTo start or shut down the Oracle system, you must first switch to the Oracle user, as shown below:Su-Oracle
A. Start the Oracle SystemOracle> svrmgrlSvrmgr> connect internalSvrmgr>
Summary
Oracle Database is a well-known leading database system on Unix hardware platforms. Oracle users and administrators are therefore familiar with the Oracle architecture on the UNIX platform and the tools and skills above it, and get the
Recently asked the classmate "why." NET application connecting to an Oracle database is always an error? "I think this is because we usually use Microsoft's products and lack research on other platform products." Microsoft has always had a "platform
This article uses the interface installation method, applies to the LAN Remote Installation Oracle and installs directly on the Linux server.
Through the Internet environment installation has not been tested, the Internet environment by silent
The target database version is oracle8.1.7, the directory database version is oracle9.2.0, and all data files (including control files and On-line log files) are lost. Examples of using RMAN for backup and recovery are as follows:
Tutorial steps:
1.
Recently asked the classmate "why." NET application connecting to an Oracle database is always an error? "I think this is because we usually use Microsoft's products and lack research on other platform products." So much nonsense, I'll talk about
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.