1. What is sqlplus? Sqlplus is an interactive tool for batch query. Sqlplus is installed for each oracle database. Sqlplus works in the command line mode. SQL * Plus has its own command set and environment. Sqlplus provides users with a way to
1 Sqlplus Login Log on locally (log on to the database server) Oracle Login Sqlplus account name/password as role name 1.1 SYS Login Example: Sqlplus sys/oracle ERROR: Ora-28009:connection as SYS should be as SYSDBA or sysoper SYS administrator must
Oracle Study Notes: sqlplus User Logon
1 sqlplus Login
Local login (log on to the database server)
Oracle Logon
Sqlplus account name/password as role name
1.1 sys Login
Example: sqlplus sys/oracle
ERROR:
ORA-28009: connection as SYS shocould be as
Sqlplus provides many common commands. The following describes how to use them.
1-> sqlplus login and exit
Sqlplus-H |-v-H displays the version and help information of sqlplus, and-V displays the login Syntax of its version information:
Is :
View the default tablespace for the current userSql>select username,default_tablespace from User_users;View the role of the current userSql>select * from User_role_privs;View system and table-level permissions for the current userSql>select * from
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
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>
If the Oracle server is loaded with multiple DB instances, enter the username/password @ database name at the user name. If the database server is not on this computer, you also need to add the address of the database server: username/password @ip
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.