Oracle database INSERT into aud$ causes high version problem ora-600[17059]

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\

Oracle in ora-3136,ora-609

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

Oracle client version and number of bits (Windows System) View method _oracle

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

Oracle uses the Toad implementation to import and export Excel data _oracle

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

Fast detection of lock-waiting in Oracle database _oracle

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

Oracle installation and Sqlplus simple usage _oracle

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

ORACLE Database Rman Backup Recovery _oracle

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

Oracle Query duplicate data and delete duplicate records sample sharing _oracle

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

Problem resolution for read-write BLOB fields in Oracle _oracle

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

JDBC Connection Oracle Database method

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

How to estimate the effect of table compression in Oracle

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,

Oracle Single-line character function parsing

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 -------------------- ---------- --------

remap_table function of Oracle 11g R2 data Pump

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's archive logs

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

Oracle permissions (Grant, REVOKE)

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

MySQL 5.6.20-4 and Oracle Linux DTrace

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

Oracle 10.2 Database Administrator Guide-Chapter 27

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 Forms

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

How to block Oracle's operating system authentication on different operating systems

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

How to handle mon_mod $ Table ORA-600 13013 errors in oracle

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

Total Pages: 2147 1 .... 183 184 185 186 187 .... 2147 Go to: GO

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.