1.oracle InstallationRefer to http://wenku.baidu.com/view/d01ffd43336c1eb91a375d68.html, no longer repeat here2. Command line sqlplus Connect Oracle(1) Check the monitoring statusc:\>lsnrctl StatusLsnrctl for 32-bit windows:version
1. Oracle Installation
Please refer to the following link for more information: http://wenku.baidu.com/view/d01ffd43336c1eb91a375d68.html.
2. Use the command line sqlplus to connect to Oracle
(1) Check the listening status
C: \> LSNRCTL
The DML, DDL, and DCL statements we usually call are SQL * plus statements. After they are executed, they can be stored in a memory area called SQL buffer, in addition, only one SQL statement can be saved recently. We can modify the SQL statement
Here are two ways to log in, with Sqlplus login need to enter the host Word:If you are using native Sql*plus to connect to the native database, the host string can be empty.If you are connecting to an Oracle database remotely from XP, you can use
Today, a strange problem has been found that the SRVCTL and Crs_start commands cannot start an Oracle RAC instance, but with Sqlplus it can start normally. The final reason for this is that the state of the database becomes disable in OCR, and this
first, Sqlplus and SQLPLUSW are collectively referred to as Sqlplus, which is a command-line execution tool for Oracle. second, there are two modes of operation of Sqlplus:1. Run in command Line window. Sqlplus2. Run in the window. SQLPLUSW Thirdly,
ORACLE10G is installed and intends to use Sqlplus to log into the database for operation. When Sqlplus is turned on, you can see that the user name, password, and host string are required. The first two know, but the latter do not understand, check
Keywords: if the host string in oracle is connected to the local database using the local SQL * Plus, ldquo; host string rdquo; can be empty. For remote connection
Keywords: if the host string in oracle is connected to the local database using the
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>
1. Oracle startup and Shutdown1. to enable or disable the Oracle System in a single-host environment, you must first switch to the Oracle user, as shown below:Su-Oracle
A. Start the Oracle SystemOracle> svrmgrlSvrmgr> connect internalSvrmgr>
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.