Oracle

After the IP address of the oracle server is changed, the following error is reported when the listener is started after the IP address of the oracle server is changed: TNS-12542: TNS: address already in use TNS-12560: TNS: protocol adapter error

The cold backup data must be that the database is not in the open state. The detailed process is shown in the following steps: ◆ (1): Shut down the database: shutdown immediate; ◆ (2): copy all files under the oradata directory, including data

The Oracle parameter query command show parameter is a small trick. You can use fuzzy query. For example, if you want to query parameters that contain db _, you can use: SQL> show parameter db _; NAME TYPE VALUE --------------------------------------

When I read the Oracle performance optimization book, I talked about replacing in with exists and using table links to replace exists. About the former, the effect is generally obvious, and the exists efficiency is much higher than in, however, if

3.6 Wordlist attributes The wordlist attribute of Oracle full-text search is used to set fuzzy queries and root queries. The wordlist attribute also supports For subqueries and prefix queries, the oracle wordlist attribute is only basic_wordlist

I encountered a problem a few days ago. It took more than eight hours to recreate the index of a table. Later, I checked carefully to create a slow index and found that the index was basically a global index and was rebuilt ONLINE. The

-- Create permanent tablespaceCreate tablespace "58 SPACE"LOGGINGDATAFILE 'd: \ ORACLE \ ORADATA \ MYDB \ 57SPACE. ora 'size 5 M EXTENTMANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO-- Create temporary tablespaceCREATETemporary tablespace "58

Oracle control file recovery case 1: the solution to the loss of a single control file is very simple. Just copy the Multiplexing Control file to the corresponding path. Case 2: All control files are lost (created using SQL in trace) Before this

All about login Ming User-Managed Database Recovery Issuing set autorecovery on before issuing the RECOVER command. if you recovery with set autorecovery off, which is the default, then you must enter filenames manually or accept the suggested

Oracle POLICY learning 01 -- 1. create test table 02 create table TEST_POLICY03 (04 USERNAME VARCHAR2 (10), 05 password number (10) 06); 07 insert into t_policy values ('A', 30 ); 08 insert into t_policy values ('B', 20); 09 insert into t_policy

Oracle USER management, authorization and backup I. USER Creation for authorization: the USER just created does not have any permissions to CREATE USER username indentife BY password authorization: GRANT permission 1, permission 2... TO User

Oracle 10046 event tracking is generally not recommended for 10046 events, because if the performance of the instance to be processed in front of you is poor, 10046 event tracking, it may make your instance performance worse. In general, we can

The oracle Stored Procedure exception is caught in oracle. [SQL] // SQL Execution exception when others then dbms_output.putline ('exception ');  Others indicates that an unnamed exception is caught. Other exceptions include Access_into_null: the

Run the following statement to view the deadlock: Select/* + rule */lpad ('', decode (l. xidusn, 0, 3, 0) | l. oracle_username User_name, o. owner, o. object_name, o. object_type, s. sid, s. serial #, p. spidfrom v $ locked_object l, dba_objects o,

A colleague from the analysis and optimization team of a node "downtime" of a RAC database received a notification that a set of RAC databases in Beijing had "crashed" at on January 1, July 1 ", it is unknown whether all the machines are down or if

The performance problem of querying the maximum and minimum values of a column in a single table is that in oracle 10 Gb, there is an SQL statement for querying a single table. It does not have a where clause, but simply calculates the maximum and

ORACLE Control File Management 1. Control File: a binary file that records the physical structure of the database. 2. The control file mainly includes the Database Name (DB_NAME) data file name and location, REDOLOG file name and location database

Oracle AWR conducts in-depth research and analysis on how to use AWR, formerly known as statspack. Of course, AWR is still in use, but everyone is using it because it is convenient, simple, intuitive, and visual. AWR is a built-in oracle tool. It

For the left, right, and inner keywords, pay attention to the details. The details are very important! For example, remember to add comments when writing code! 1. Typographical editing-when writing SQL statements, especially writing batches, be sure

How Does Oracle create an index for the big data database in a hundred million-level record table? 1. in the previous phase, a project was created, and a data in the production system needs to be exported to the backup machine. This table contains