Common commands:Connect to sqlplusRun CMD in the command line to enter. For example, to log on in SYS mode, the command is as follows:(1). sqlplus "sys/zhb126 as sysdba"
(2). sqlplus/nolog connect sys/zhb126 as sysdba
(3). sqlplus Scott/Tiger
Start
Common commands:Connection SqlplusCommand line to run CMD entry, such as logging in the SYS mode, the command is as follows:(1). Sqlplus "sys/zhb126 as SYSDBA"(2). Sqlplus/nolog Connect sys/zhb126 as Sysdba(3). Sqlplus Scott/tigerStart a DB
Explain the Oracle SQLPlus runtime environment, common Oracle System Function instances, and sqlplus instances
1. Introduction to the SET command
Set command sets the running environment of SQL * Plus. The syntax FORMAT OF THE set command is:
SET
1. What is the initial password after oracle is installed?
Internal/Oracle
Sys/change_on_install
System/Manager
Scott/Tiger
Sysman/oem_temp
2. What is the initial Default User and password of Oracle9iAS Web Cache?Administrator/Administrator
3. How
I. Startup and shutdown of Oracle1, in a single-machine environment2, in the dual-machine environmentIi. What kinds of startup methods are available for Oracle database?1, startup Nomount non-installation start, this way startup executable: Rebuild
When a DBA logs on to a local or remote database, it is common to log on to the database using the "sqlplus username/password @ Connection Service name" method to save time, if we replace Oracle SQLPlus with our own implementation, and record its
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>
From http://baike.baidu.com/view/1239908.htm
SQL * Plus is one of the most commonly used tools with strong functions, mainly including:
1. database maintenance, such as startup and shutdown, is generally performed on the server.2. Execute SQL
I. Startup and shutdown of Oracle1, in a single-machine environmentTo start or shut down an Oracle system, you must first switch to an Oracle user, as followsSu-oracleA. Start the Oracle systemOracle>svrmgrlSvrmgr>connect
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.