Oracle

Oracle Sys users cannot log on with the default password change_on_install (error code: ORA-28009) When you log on to the database using the default Oracle SQL Plus, you can use the system user's default password manager to log on to the

1. How to configure EM to support SSL protocol OMS, DBConsole, and Agent in 10g em all support the SSL protocol. Specific operations: ◆ 1. if there is no environment variable ORACLE_SID, configure it first, or directly input set ORACLE_SID = xxx (in

Data sharing is one of the most basic features of a database. However, data sharing brings convenience to employees, but it also has some negative effects. For example, the damage to Data Consistency caused by concurrent user access, the damage to

Oracle provides a tool for manual query of ASM disk information-kfod. First, let's look at the help information: Db1-> kfod-help_ Asm_a/llow_only_raw_disks KFOD allow only raw devices [_ asm_allow_only_raw_disks = TRUE/(FALSE)]_ Asm_l/ibraries ASM

Here is a question about csdn. Correct the error. The image function requires statistics on the data in a table.Table definition (Omitted fields not used)LB01_PURRECEIVEBOOK(Purreceivedate date, -- format: 2009/11/01RECEIVEAMT NUMBER)① In annual

Tax initiation: 3000 SQL codeCreate or replace function tax (v_salary in number) return number isV_expense number;-- Deduction for quick calculation at this level = maximum income at the upper level × (current tax rate-higher tax rate) + deduction

Because there are many ODU commands, especially the key unload commands, this article will briefly introduce the command sequence used for data recovery using ODU in several scenarios.Scenario 1: The database cannot be started, but the data

1. oracle internal process during select executionAnalysis: Includes syntax analysis, semantic analysis, view conversion, expression conversion, optimizer selection, connection method selection, connection sequence selection, and data search path,

8.1 what is an archive log fileOracle databases allow you to store full redo log files to offline directories, which are called archive log files.Archive the process of saving the redo log file to the archive log file. This process can only run in

A script for enabling the Oracle service and changing the host name does not know what to start with. This is a question raised by the database teacher yesterday. Because the recovery card is installed on all the machines in the lab, the system will

Oracle 10g installation does not find a prerequisite error solution when installing oracle 10g (Version: 10.2.0.1, haha, 10201) error: In oraparam. the prerequisite check is not found in ini, and the system prerequisite check is not executed. Start

Oracle 11g default profile default Enable Password Expiration 180 days ORA-28001 error handling Problem description: the customer reported that the client could not connect when logging on to the application. Environment: AIX 5.3 + Oracle 11gR2

PLSQL garbled & TNS-12557: protocol adapter not loadable solves 1. garbled is a character set problem. Set NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK  Or Set NLS_LANG = AMERICAN_AMERICA.UTF8  Yes. 2. I encountered a link to TNS-12557: protocol

In Oracle 11g, if you want to obtain the ip address or hostname of the server, run the following statement: SELECT utl_inaddr.get_host_address FROM dual; // obtain IPSELECT utl_inaddr.get_host_name FROM dual; // obtain the host Name  If it works

Oracle knowledge point Summary 3 (subquery) 1. Use of subquery 1. insert use of subquery when inserting data in insert, be sure not to add the Vaules keyword. SQL> create table copy_dep as select * from departments;Table created.SQL> truncate

Introduction to Oracle services in Windows: The Oracle service list of one node of RAC in 11gr2. Oracle does not need to start all services in the background when processing general transactions. Because the oracle service occupies a large amount of

[Oracle]-[architecture-LGWR]-some understandings of LGWR: LGWR, short for Log Writer, is also a background process. It is mainly responsible for writing the log buffer content to online redo log files or groups on the disk. Before DBWn writes the

The difference between a dedicated Oracle server and a shared server is that when you create an Oracle database, you should see this option in the database creation assistant wizard, that is, the connection mode of the database. There are two

The process of a shutdown operation cannot be normally executed: the database version is 10.2.0.4. After the shutdown normal operation is executed, the database has not stopped for a long time, at this time, the database is no longer able to log on

Complete the steps for Oracle to change the tablespace file location: // Create a temporary tablespace [SQL] create temporary tablespace test_temp tempfile 'd: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ test_temp01.dbf 'size 32 m autoextend on