Oracle

First, describeDB version: 12.1.0.2System version: 7.0Second, the processing process1, error, the database starts on the instance will be abnormally terminatedORA-00312: online log 3 thread 1: ‘+DATADG/ORCLDG/ONLINELOG/group_3.403.962961193‘ORA-00312

How to retrieve lost passwords for all Oracle users:Method One:1. Log in as an operating system verifiedSql>conn/as Sysdba;2. View the user name in the system.Sql>select USERNAME from Dba_users;3. Find the user name you need to change4. Modify the

Enter Sqlplus (as Administrator)Sqlplus/as Sysdba;Create user user1 identified by User1; Create a user name and specify a passwordGrant the appropriate permissionsGrant create session to User1;Grant CREATE table to User1;Grant unlimited tablespace

First, the Environment configuration1. Execution Environment:Exp/imp can be executed either on the client or on the server side,Clients that need to have Oracle installed on the client,If it is a Linux system, it is logged in as an Oracle user and

1 --Scenario 1:2 SelectPT, Greatest (WM), least (WM)3 from(SelectS.producttype PT, Wm_concat (S.productid) WM4 fromsys_product S5 Group byS.producttype)6 wherePt= 1;7 /*8 --Results:9 1 | 1 17,19,16,15,9,4,3,2,1,14,13,18Ten 2

Function:CREATE OR REPLACE FUNCTION count_weekend (start_date in date, end_date in date)RETURN number is V_count INT;BEGINSELECT COUNT (*) into V_countFrom (SELECT start_date + num-1,To_char (end_date + num-1, ' Day ') as T_date2From (SELECT rownum

1.Installing the Multipath tool# yum–y Install Device-mapper Device-mapper-multipath2. Set boot from boot# Chkconfig MULTIPATHD on3. Open Multipath# mpathconf--enableor use the full command: mpathconf--enable--find_multipaths y--with_multipathd

Oracle 11G, the database default is the audit function, so sometimes we forget to turn off this feature caused the system table space is full, but because the shutdown audit function needs to restart the database, such operations are not allowed in

--table name, table space Size (MB), number of rowsSelect table_name, round (num_rows * avg_row_len/1024/1024, 8) as Total_len, num_rowsFrom User_tablesWHERE table_name = ' table name 'ORDER BY TABLE_NAME;--table name, column name, column space Size

The previous knowledge of the database was mostly focused on MySQL, which has been using Oracle for the most recent work, although in the Internet industry MySQL is a big line, but some traditional industries or the financial sector are more

First, error messageA few days ago the website suddenly can't access, and reported the following error:Ora-27101:shared Memory realm does not existOra-01034:oracle Not Available 11gOra-24324:service Handle not initializedCause: Because the database

The Main library parameters are detailed:?Keep all the same db_name in the same data guarddb_name=ora11g?? #为一个数据库指定一个唯一的名称, the parameter will not change once it is specified, unless the DBA actively changes it so that

The six main steps of JDBC: Registration driver Get connections Gets the Execute SQL statement object Execute SQL statement Working with result sets Close Resource Oracle URL:jdbc:oracle:thin:@localhost:1521:SIDjdbc:

OracleColdIt looks like you need DBCA create a consistent Oracle Instance server configuration version as much as possible, with the same installation path.Turn off Oracle ServicesCopy the Oradata in the Oracle app directory and the control file in

Oracle outer JOIN (OUTER join) Left OUTER join (the table on the left is unrestricted) Right outer join (the table on the right is unrestricted) All-out connection (both the left and right tables are unrestricted) Corresponds

At present, many production databases are two node RAC, application connected database will usually connect scan IP or VIP, here do a small experiment, if we use VIP connection,How to configure our clients, load balancing is a strict rotation

The most significant relationship with the date operation is two conversion functions: To_date (), To_char ()The To_date () function converts a character type to a date type in a certain format:Specific usage: to_date (' 2004-11-27 ', ' yyyy-mm-dd ')

Based on the solution of ORA-19815 flash back space explosion problem, ora-19815 flash back The problem that the flash back area is full is also frequently encountered. The most important thing is that the flash back setting size and archive are

Oracle Contains function usage, oraclecontains 1. query student addresses in Beijing SELECT student_id,student_nameFROM studentsWHERE CONTAINS( address, 'beijing' ) Remark: beijing is a word that must be enclosed in single quotes. 2. query student

Instance analysis ORACLE database performance optimization, instance analysis oracle ORACLE Database optimization methods differ greatly from those of MYSQL. Today, an ORACLE database instance is used to analyze how to optimize ORACLE databases from