[Email protected] ~]# su-oracle[Email protected] ~]$ sqlplus '/as sysdba 'Sql*plus:release 11.2.0.1.0 Production on Tue APR 22 17:10:52 2014Copyright (c) 1982, Oracle. All rights reserved.ERROR:Ora-12162:tns:net Service name is incorrectly specifiedEnter User-name:ERROR:Ora-12162:tns:net Service name is incorrectly specifiedEnter User-name:ERROR:Ora-12162:tns:net Service name is incorrectly specifiedSp2-0157:unable to CONNECT to ORACLE after 3 attempt
Tag: Use Oradebug in Sqlplus to locate the trace file generated by alter session 10046 event [[emailprotected]~]#su-oracle[[emailprotected]~]$sqlplus /assysdbasql>select*fromv$ Versionbanner-------------------------------------------------------------------------------------------Oracle Database11gEnterpriseEditionRelease11.2.0.3.0-64bit productionpl/sqlrelease11.2.0.3.0-productioncore11.2.0.3.0 production
Today in the Sqlplus test encountered the problem of Chinese garbled, when it comes to garbled problem is the first thought is the character set inconsistency.
Problem Description: Error caused by password input error when logging in, but display result is garbled.650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/7C/74/wKioL1bQV4mTHJwZAAAP0-RADRY688.png "title=" garbled. png "alt=" Wkiol1bqv4mthjwzaaap0-radry688.png "/>
650) thi
An error occurred while logging in to the database with Sqlplus "/as sysdba" when the database was successfully installed, possibly for the following two reasons:1, Sqlplus processing program is generally in the Oracle installation directory under the $oracel_home/bin directory, which should have Sql.exe executable file, if not, the Oracle database installation file has a problem2. If there is a Sql.exe fil
Friends familiar with Oracle know that SQL Plus is an important tool for dealing with Oracle. SQL Plus itself has a lot of commands that can help us do a lot of things, including producing standardized reports, providing human-computer interaction, and so on. Below, I will briefly explain, for everyone to refer to:
A Help command
Help helps us find SQL plus the use of each command
Example:
Sql> Help Accept
ACCEPT
------
Reads a line of input and sto
Oracle uses sqlplus to query a table space according to the condition. Everyone knows that oracle queries the table space according to the condition, but the query time of the table space seems to be a bit different from that of www.2cto.com: 1 select user_id, username, default_tablespace from dba_users; common condition query: 1 select user_id, username, default_tablespace from dba_users where USERNAME = 'system'; you will find that the above stateme
When using sqlplusw or sqlplus, the actual number of words without modification sqlplusw is usually a specified number of words in a row by default, resulting in a line of query results, which is inconvenient for us to read data. Two commands: 1. SET the record length displayed on each line: set linesize 300; (but the page is displayed, that is, duplicate table field names ). 2. SET the number of records displayed on each page: set pagesize 30; 2. Run
Recently, there are a bunch of Delete statements to be executed. The 34 Delete statements are written as one PROCEDURE for execution, but the execution plan and time of a single DELETE statement cannot be seen during execution.
Recently, there are a bunch of Delete statements to be executed. The 34 Delete statements are written as one PROCEDURE for execution, but the execution plan and time of a single DELETE statement cannot be seen during execution.
There are a bunch of Delete statements
Sqlplus learning notes (1) create a table and insert data [SQL] create table user_emp (id number (4), passwd char (4), name char (20 ), phone char (20), email varchar2 (50); prompt Table Created indicates that the Table has been successfully Created> data type
In SQLPLUS, you can view the table structure in oracle, modify the table field in SQL statement 1, view the table structure in desc table name 2, modify the table field in SQL statement, and use the rename keyword to modify the field name: www.2cto.com alter table name rename column old field name to new field name; Use the modify keyword to modify the Data Type: alter table name modify Field name data type; use the add keyword to add the alter table
The command is as follows:
Oracle server address: 192.168.2.181 port: 1521
Username: jans2002
Password: password123
Service name Sid: dbsvr
If you do not need netmgr to create a service name, you can directly write the IP address port and service name in the command line as follows:
Sqlplus jans2002/password123@192.168.2.181: 1521/dbsvr @ filelist.SQL
The content of the filelist. SQL file is as follows:
SetServeroutputOnBeginDbms_output.put_
1. Open the command line window and enter the following command: sqlplus/nolog and press Enter. The prompt SQL>,Enter Conn/As sysdba to log on. If it fails, try again with the password of the conn sys/sys user as sysdba.
2. Check where the current database files are generally stored: input: Select name from V $ datafile;Name--------------------------------------------------------------------------------D: \ oracle \ oradata \ orcl \ system01.dbf
D
Create table a (content clob );
Select content from;
The displayed content is part of the cotent content and garbled characters. Because a is of the clob type, it cannot be displayed directly from the select result. You need to use the Oracle system package dbms_lob for processing, to display the content correctly.
Select dbms_lob.substr (content) from;
In this way, the content in the content can be printed and output, but you will find that the output content may not be comprehensive.
This
1.Set the total number of lines displayed on the page
1)View the currentPagesize,The default value is14:
SqlplusCode
1.Show pagesize;
2)SetPagesizeSet100,You can display more than enough rows at a time.:
SqlplusCode
1.Set pagesize100;
2.Set the row width
1)View the currentLinesize,The default value is80:
SqlplusCode
1.Show linesize;
2)Set100Or wider.:
SqlplusCode
1.Set linesize100;
Modify the default value of page display and row
However, this method requires you to reset it the nex
Oracle software version: 10.2.0.5
Oracle Installation Directory:/u01
Copy the entire Oracle directory from the source server to the target server in lync mode.
It is reasonable to say that software migration will not cause serious errors. However, when you connect to oracle through sqlplus and plan to start the database, report:
ORA-15180: cocould not open dynamic library odm library, error[Failed to expand the library nam]
This error is caused when t
In Linux, The SQLPLUS return key cannot be used to display ^ H by hitting the return key. This is caused by a keyboard ing problem. There are several ways to solve this problem: (1) Use the delete key instead of the Return key. (2) Use the ctrl + backspace key www.2cto.com (3) to execute the command stty erase ^ H to modify the terminal row settings. Note that after the command is modified, the original deletion with the delete key and the ctrl + retu
Sqlplus output display adjustment SQL> set linesize 32767
Set the linesize to the maximum. You can try 99999 first and the system will prompt that the value is out of the range.
SQL> set heading off
In fact, the display effect is still unsatisfactory. It is not as automatic table output as MySQL, and needs to be improved.
Set echo on/off: whether to display the commands to be executed in the scriptSet feedback on/off indicates whether to display th
-- Use sqlplus to output data in a table to a text file in a specified format
Set term off -- remove Screen Display
Set feed off -- remove the number of lines displayed for output
Set pagesize 0 -- no page feed
Set linesize 2000 -- set the length of the row to ensure that the sum of the length of all the output fields is displayed.
Set space off -- set the number of spaces between output Columns
Set trims on -- Remove trailing Spaces
Spool E:/x
to the Afiedt.buf file for editing
The edit filename edits the. sql file specified in the current directory into the editor
Clear screen clears the current display
Two. Oracle sqlplus Statement Edit command
First we enter this instruction:
SELECT emp_id, Emp_name
From Employees
The input command can then add a statement after the previous instruction, such as after the statement is run:
Input WHERE emp_age > 30
The following instructions can
Failure phenomenon:
$ sqlplus/as SYSDBA
Sp2-1503:unable to initialize Oracle call interface
Sp2-0152:oracle May is functioning properly
Analysis: Online are said to be timezone and Timezlrg file permissions are not correct, but I do not have these two files,
What to do, and look at the following analysis
--See if TimeZone and Timezlrg files are normal
$ cd/home/oracle/database/oracore/zoneinfo
$ ls-lt
Total 16
-rw-r--r--1 Oracle DBA 4672 Jun
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.