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

The failure of oracle user connection makes us a headache. The following describes how to solve the failure of oracle user connection and hopes to help you learn about oracle user connection. After installing Oracle11g, I want to enable the

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

1. What is the initial password after Oracle is installed?   Internal/oracleSys/change_on_installSystem/managerScott/tigerSysman/oem_temp  2. What is the initial Default User and password of ORACLE9I as web cache?Administrator/administrator   3. How

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

3.10 common scripts 3.10.1. Delete preference: Begin Ctx_ddl.drop_preference (my_lexer ); End;   3.10.2. Index reconstruction: Alter index newsindex rebuild parameters (replace lexer my_lexer );   3.10.3 synchronize Indexes Begin Ctx_ddl.sync_index (

Oracle redo corruption handling if only INACTIVE redo is damaged, there are three ways to restore: 1. clear logfile commands: alter database clear logfile '/database/oradata/skyread/redo04.log '; -- the archived operation alter database clear

Primary Key constraints automatic index creation constraints are used to ensure the integrity of database data. In oracle databases, you can use constraints, triggers, and application code (processes, functions) to achieve data integrity, among the

There are many articles such as Oracle Data lock quick detection and removal on the Internet. I hope to quickly find all row-level locks in a table and remove them together. So I improved it: if you want to use the kill-9 sessionPid method, the view

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

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

Memory of oracle-Spur (2) pga is not shared in the Process of the operating system or a memory area specific to the thread. Because pga is specified by a process, it is not allocated in sga. Pga is a memory heap that contains session variable

Add, delete, modify, and query this table in the oracle trigger (1) only the before insert trigger can query or update this table. Create or replace trigger tri_test_ins before inserton testfor each rowdeclare v_cnt integer; begin select count (*)

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

Oracle-full recovery of user management (iv) I. the role of resetlogs 1. reset the current log serial number to 1, discard all previous log information, you can delete them on the operating system; 2. in non-archive mode, if online redo logs are