Sqlplus Editing command line usageKeywords: Oracle sqlplus command-line usageOracle database has a lot of query tools, such as the famous plsql, accustomed to the graphical interface, and then face the character interface Sqlplus is really a torture, but I do not know that the immortal said "existence is reasonable."Sometimes it just needs to work in the context
Frequently used:
Sqlplus username/password for example: normal user login sqlplus Scott/tigersqlplus username/password @ net_service_name For example: sqlplus Scott/tiger @ orcl
Sqlplus username/password as sysdba For
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 SYSDBA or SYSOPER
The sys a
treated as a comment. Similar to remark.
Set pause: Causes the screen to appear paused between pages.
Save: Saves the SQL query you are building to a selected file.
Host: Sends commands to the main operating system.
Start or @: tells Sqlplus to execute instructions that have been stored in the file.
Edit: Allows you to quickly leave Sqlplus and enter the editor you choose.
Define_editor: Tell
The following figure shows two steps for installing the Oracle database server software and client software:
Through the above process, we know that the server and the client have a file to be configured, the server is the listener configuration file, and the client is the network service name configuration file. The descriptions are as follows:
The server listener file is stored in the listener. ora file, which includes the listener protocol, address, and other related information. Howev
example, an oracle user can execute this command, while other common users report an error of insufficient permissions when executing this command.
For $ ORACLE_SID value Modification, add export ORACLE_SID = xxx to the. bash_profile file in bash shell mode, and then make the modification take effect: source. bash_profile. In this way, sqlplus/as sysdba connects to the $ ORACLE_SID value configured in the
connect to the database, it does not generate the 10046 trace file, and it does not appear to execute SQL, which means that no initialization action is performed and the necessary information is queried. Perhaps this is called the "primary Connection" of the history of it.
Because the Prelim method is used to connect, no SQL statements are executed, so the database can be connected to some hang in the database. For example, because the library cache
with the general UNIX design philosophy: read commands from standard input and write the results to standard output .Two non-interactive ways to use Sqlplus 2Sqlplus in non-interactive mode, SQL commands are available from two locations: one is through the external file, but through the standard input.2.1 via external command filesqlplus 用户名/密码@服务器IP/侦听服务名 @命令文件名
Let's give an example.The command file name is 1.sql and the contents are as follows: s
Tags: manage basic over NEC ADE release exit Hang CTIStarting with oracle10g, Sqlplus provides a parameter option-prelim, with this parameter, when the system is already hang. We can connect to the SGA instead of the database, i.e. no session is created. A. The following steps allow you to obtain system information:Sqlplus-prelim/as SYSDBAOradebug SetmypidOradebug Unlimit;Oradebug Dump SystemState 10 For a 9i database, 9IR2 works correctly by installi
/nologsql * Plus: Release 10.2.0.1.0-production on Tue Mar 30 14:04:45 2010 copyright (c) 1982,200 5, Oracle. all rights reserved. SQL> conn Scott enter password: connected. SQL> exit/* use exit or quit to exit */SQL> exitdisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-productionwith the partitioning, OLAP and Data Mining options [Oracle @ Linux ~] $ Sqlplus "/As sysdba" SQL * Plus: Release 10.2.0.1.0-production on Tue Mar
Environment: win7_64 bit, database version oracle11g_r2In the cmd window, use the following three commands to connect to the database normally:C:\users\administrator> Sqplus/nologC:\users\administrator> sqlplus Sys/[email protected] as SYSDBA;Sql> conn Scott/[email protected];However, use the following command to connect to the database to report a ora-12560 error:C:\users\administrator>sqlplus/as Sysdba;Wo
Abstract: in daily work, I think MySQL plus is used in 99% to log on to your database and manage, optimize, configure, and maintain the database. If there are more than n databases
Abstract: in daily work, I think MySQL plus is used in 99% to log on to your database and manage, optimize, configure, and maintain the database. If there are more than n databases
What is the local mode? It only works in the current directory. For example, we configure
By default, oracle10g sqlplus installed on Linux does not support ECHO, which makes it inconvenient to use. To support echo function, we need rlwrap.
By default, oracle 10 Gb sqlplus installed on Linux does not support ECHO, which makes it inconvenient to use. To support echo function, we need rlwrap.
By default, Oracle 10 Gb sqlplus installed on Linux doe
Tags: sqlplus configuring variables how the Oracle command prompt appears as a user nameHow the Oracle command prompt appears as a user nameFor example: Sqlplus/as sysdba After the command prompt is sys>Fang Yi: Temporarily modify the sqlplus configuration variableSql> Show User--The output is the current user, take th
Python calls SQLPlus to operate and parse the Oracle database, sqlplusoracle
Let's look at a simple example of using python to call sqlplus to output the result:
import osimport sysfrom subprocess import Popen, PIPE sql = """set linesize 400col owner for a10col object_name for a30 select owner, object_name from dba_objects where rownum
If you use Python to query
as follows:Column columnname [format] [heading]For example, column login_id format A32 heading trademanager IDHeading trademanager ID indicates that the login_id field name in the result set is: trademanager ID;The function is the same as select login_id as trademanager ID from;
The settings of the session parameters are very professional and complex, which is not involved by developers. However, we can set two parameters on our own;The first is to s
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 a database instance
Startup -- start the control file and data file whi
Let's look at a simple example of using Python to call Sqlplus to output results:
Import osimport sysfrom subprocess import Popen, PIPE sql = "" "Set linesize 400col owner for A10col object_name for A30 se Lect owner, object_name from Dba_objects where rownum
Querying Oracle with Python is, of course, best used with the Cx_oracle library, but sometimes constrained to install Python's third-party library,
Today I encountered a strange problem:
Using sqlplus on the client allows normal users to log on, but neither system nor sys users can log on, prompting ORA-12154: TNS: unable to resolve the specified connection identifier
[@ More @] SQL> conn system @ webdataEnter the password:ERROR:ORA-12154: TNS: Unable to parse the specified connection identifier
SQL> conn xgplat @ webdataEnter the password:Connected.
I thought the client was a 32-bit server.
Tips for using sqlplus
During Oracle maintenance, Oracle currently has many easy-to-use client tools, such as PLSQL, delveloer, and toad. However, as a database administrator, you also need to deal with sqlplus frequently, some common operations often need to be completed in sqlplus. If sqlplus is unfamiliar, it will
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.