Last night a friend consulted me, his database (win2008 11.2.0.1) appeared a large number of ora-00600[17059], the following error, so that help analyze the reasonsAlert Log ErrorSat Mar 19 21:31:02 2016Errors in File D:\app\administrator\diag\rdbms\
Fatal NI Connect error 12170.
VERSION Information:TNS for 64-bit windows:version 11.2.0.1.0-productionOracle bequeath NT Protocol Adapter for 64-bit windows:version 11.2.0.1.0-productionWindows NT TCP/IP NT Protocol Adapter for 64-bit
First, view Oracle client version:sqlplus-v
Second, see Oracle client version is 32bit or 64bit
Method One:
Step 1: Run the sqlplus/nolog command, if your server has more than one client version installed, then you should go to the bin
During the development of Oracle applications, accessing database objects and writing SQL programs is tedious and time-consuming, and the day-to-day management of the database requires a lot of SQL scripts to complete. Quest software provides an
Usually in the large database system, in order to ensure the consistency of the data, when the data in the database operation, the system will be the corresponding lock on the data.
These locks have "read-only lock", "exclusive lock", "shared
when an Oracle database is installed successfully, related database information is displayed:
Global Database name: Oracle
System identifier (SID): Oracle
Server parameter filename: C:\oracle\product\10.2.0\db_1/dbs/spfileoracle.ora
The Database
Machine A:
Select instance_name from V$instance;
Select name from V$database;
Select name from V$datafile;
Query log mode:
Archive log list;
Shutdown immediate;
startup Mount;
Change Log to archive mode:
ALTER DATABASE Archivelog;
ALTER DATABASE
One, query a field repeat
Copy Code code as follows:
SELECT *
From User u
where U.user_name in (select U.user_name
From User u
GROUP BY U.user_name has count (*) > 1)
Two, delete the duplicate of a few fields in the
LOB types are divided into BLOBs and CLOB two: BLOBs-binary large pair images (Binary Large Object), which are used to store text-throttling data (such as programs, images, audio, video, and so on). CLOB, a character-type large pair (Character Large
Import java.sql.*;
Several problems needing attention in JBuilder correctly connecting Oracle ArrayiOracle8 above should all use the Classes12.jar file as JDBC driver;Correctly set up the enterprise Setup, configure libraries in Windows Classpath
Before using compression, we can estimate how much the effect of using compression can be.
11GR2 can use dbms_comp_advisor before, the specific code has been given in the attachment. You only need to execute two files Dbmscomp.sql and PRVTCOMP.PLB,
1, ASCII (C)
Description: Returns the first character of C in the ASCII code corresponding to the decimal
Example:
Sql>select ASCII (' a ') a,ascii (' A ') b,ascii (' 0 ') c,ascii (') D from DUAL;
A B C D
-------------------- ---------- --------
Oracle has actually introduced this feature in 11.1.0.6, but there are bugs in 11.1.0.6. Here is a brief introduction to the Remap_table feature in 11.2.
Look at a simple example:
Sql> select * from V$version;
BANNER
-----------------------------
Oracle can save an online log file to a number of different locations, and the process of converting an online log to an archive log is called archiving. The corresponding log is called an archive log.
One, archive log
is a copy of the online redo
Database version: 11GR2First, IntroductionIn Oracle, there is no concept of databases in other database systems, and objects are created under the user. The current user has all the permissions for all objects under the current user, regardless of
Https://blogs.oracle.com/wim/entry/mysql_5_6_20_4?utm_source=tuicool&utm_medium=referralBy Wimcoekaerts-oracle on Jul, 2014The MySQL team just released MySQL 5.6.20. One of the cool new things for Oracle Linux users is the addition of MySQL DTrace
27 Using the SchedulerOracle database provides database job capabilities through Oracle Scheduler (the Scheduler). This chapter explains the various Scheduler, and discusses the following topics:Dispatcher objects and their namingUsing jobsUsing
Pre-query Trigger in Oracle d2k/oracle FormsDescriptionFires during Execute query or Count Query processing, just before Form Builder constructs and issuesThe SELECT statement to identify rows that match the query criteria.Definition Level form or
On the Windows system > If you do not want the user through the operating system authentication mode login, you can modify the Sqlnet.ora file, put sqlnet. Authentication_services=nts the front plus # comment out.On Linux Systems > If you do not
Some friends feedback database startup run after a little time, then automatic crash, let us help find the reason, through analysis is because the smon process triggers ORA-600 13013 caused database exceptionsAlert Log error messageThu Aug 4 18:39:44
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service