sqlplus example

Label:1. Connecting Conn 1.1 Login to the system with Oracle user, enter Sqlplus environment, log in Administrator mode 1Oracle@yas:~>Sqlplus/Nolog2Sql*Plus:release11.2.0.1.0Production onTue Feb2 -: -: + . 3Copyright (c)1982, the, Oracle. Allrights reserved.4Sql>ShowUser; 5 USER is "" 6Sql>Conn/ asSYSDBA7 Connected.8Sql>ShowUser; 9 USER is"SYS" 1.2 Normal USER Login conn User/password 1 SQL> conn T1/T1

One, sys users and system usersThe Oracle installation automatically generates SYS users and system users(1), sys user is superuser, has the highest privileges, has the SYSDBA role, has the rights to create database, the user's default password is Change_on_install(2), the system user is the management operator, the authority is also very large. With the Sysoper role, without the CREATE DATABASE permission, the default password is the manager(3), generally speaking, the database maintenance, usi

After I installed Oracle11grac, why ??? Garbled characters: [oracle @ db ~] $ SqlplusassysdbaSQL * Plus: Release11.2.0.1.0P After I installed Oracle 11g rac, why ??? Garbled characters: [oracle @ db ~] $ Sqlplus/as sysdbaSQL * Plus: Release 11.2.0.1.0 P After I installed Oracle 11g rac, why ??? Garbled characters are as follows:[Oracle @ db ~] $ Sqlplus/as sysdba SQL * Plus: Release 11.2.0.1.0 Producti

Tags: product file Open maintain Connect DOS operation format Privilege oraOne, sys users and system usersThe Oracle installation automatically generates SYS users and system users(1), sys user is superuser, has the highest privileges, has the SYSDBA role, has the rights to create database, the user's default password is Change_on_install(2), the system user is the management operator, the authority is also very large. With the Sysoper role, without the CREATE DATABASE permission, the default pa

Tags: network services Super SQL script Pool parameter strong file Ora hangOne, sys users and system usersThe Oracle installation automatically generates SYS users and system users(1), sys user is superuser, has the highest privileges, has the SYSDBA role, has the rights to create database, the user's default password is Change_on_install(2), the system user is the management operator, the authority is also very large. With the Sysoper role, without the CREATE DATABASE permission, the default pa

Windows 8,oralce11g, command-line1. Input "Sqlplus", enter, prompt: Please enter user name, enter user name, return, prompt, enter password, enter password, return, Report ora-12560:tns: Protocol Adapter error2. Enter "Sqlplus username/password @sid", enter, Prompt "Connect to: Oracle Database 11g Release 11.2.0.1.0-64bit Production".What is the difference between the two mechanisms?Someone online says:"Enc

Tags: strace sqlplus as sysdba eexist file exists statIn the previous article, we said that the X permission for the Bdump directory was missing, resulting in an Oracle database exception.The following is the Linux strace command to track the Bdump directory when the X permission is lost, Sqlplus/as SYSDBA will have what kind of output:The Strace command is derived from the following command: Using Strace i

Oracle sqlplus Export Query ResultsThe results of exporting a query under Sqlplus are saved to a local SQL file, which can be used in the following ways:1. Connect database : sqlplus xmq/[email protected]:1521/DB2, Export SQL Script : set Feedback off -- echo The number of record bars processed by this SQL command, default to on set pagesize 0 -- Output per

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 9.2.0.1.0-production on 2 August-June-2005 11:01:01Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.Connecting to (Description= (address= (protocol=tcp) (Host=oyez) (port=1521))tns-12541:tns: No listener tn

Tags: style historyOne: Installation readline# yum install readline* libtermcap-devel*Two: Install RLWRAP1 compilation Install # TAR-ZXVF rlwrap-0.30.tar.gz# cd rlwrap-0.30#./configure# make# Make Install2 RPM installation (recommended) download: ftp://rpmfind.net/linux/epel/6/i386/rlwrap-0.42-1.el6.i686.rpm, here for Linux 6 i386, other versions go to http:/ /rpmfind.net/linux/rpm2html/search.php?query=rlwrap Select the appropriate version to download the installation.Three: Easy to use rlwrap

Label:In 10g, when ORA-00020 occurs, Sqlplus will report "connected to an idle instance" From:Sqlplus Logon Reports ' connected to a idle instance ' when ORA-20 happens in 10g (document ID 1370000.1) Say the more classic, do not translate, direct reprint:Applies To:Oracle server-enterprise edition-version:10.1.0.4 to 10.2.0.5-release:10.1 to 10.2information in this document applies to any platform.SymptomsWhen the maximum number of processes are reach

Label:Transferred from: http://blog.itpub.net/26110315/viewspace-717249/ Sometimes when you use Sqlplus to log in to the database, when you hit the wrong command to delete the changes, you find the previously typed characterscannot be deleted, but ^h characters are more.sql> show^h^h [[email protected] ~]$ stty-a//Display all terminal settings. Which would have such a field erase = ^?; that represents the terminal.The way to clear characters is ctrl+

Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the source, otherwise hold the copyright legal responsibility.Deep Blue Blog:http://blog.csdn.net/huangyanlong/article/details/45875793when using Xmanager Remote Connection Linux system, use Sqlplus when found, delete keys are garbled, as follows:Workaround:Method One:[Email protected] ~]# Vi. bash_profile-- Add Stty Erase ^h#. Bash_profile# Get the aliases and f

1. Upload rlwrap-0.37.tar.gz to Linux2, decompression rlwrap-0.37.tar.gz[Email protected] mnt]# tar zxvf rlwrap-0.37.tar.gz[[email protected] mnt]# lsrlwrap-0.37 rlwrap-0.37.tar.gz2. Install the Software[Email protected] rlwrap-0.37]# CD rlwrap-0.37[Email protected] rlwrap-0.37]#./configure[[email protected] rlwrap-0.37]# Makemake Install3, realize the sqlplus up and down page functionSu-gridVI. bash_profileAdd at the end:Alias

Label:1. Resolve cannot backspaceMethod 1:stty Erase ^h Under Oracle User, add the following statement in the user Environment profile. Bash_profile Stty Erase ^h Method 2: Operate on the SECURECRT tool Hook up the options in the diagram; In contrast, choose Method 2.2. Solved can't be up or downOracle Sqlplus on Linux cannot use the up and down keys to view commands and fret. The Rlwarp tool can help us solve this problem. Official: http://utopia.kn

What does sqlplus/nolog mean by sqlplus Command Format: www.2cto.com usage: SQLPLUS [[

The question mark is displayed in SQLPLUS. in linux, the question mark is displayed in sqlplus, as shown below: [oracle @ why-server ~] $ Sqlplus/as sysdba SQL * Plus: Release 11.2.0.1.0 Production on Wed May 15 16:20:03 2013 Copyright (c) 1982,200 9, Oracle. All rights reserved .??? : Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit ProductionWith

Common Sqlplus commands are as follows:1. login system user:Sqlplus and then enter the system user name and passwordLog on to another user:Conn user name/password;2. Create a tablespaceCreate tablespace space nameDatafile 'C: "Space name' size 15 M -- storage path of the tablespace, initial value: 15 MAutoExtend on next 10 M -- the automatic increase of space is 10 MPermanent online; -- permanent use3. Create a userCreate user jun -- create username a