Oracle

Today, I encountered a problem. Suddenly, Oracle failed to log in with the System user in the normal state, but sysdba was able to log in. The reasons are as follows: 1. Oracle DBA groups are related to the operating system, and ora_dba is a DBA

The following error is reported when running sqlplus in cmd in win7. SP2-1503: Unable to initialize Oracle call interface SP2-1503: Unable to initialize Oracle tuning SP2-0152 Solution: Right-click sqlplus.exe In the oracle \ product \ 10.2.0

Arcsde9.2 and Oracle distributed Installation Environment: Oracle10gr2 is installed on two servers, but it only performs dual-machine hot backup. The operating system is Windows Server 2003 sp2. ArcSDE is installed on the third server, and the

You can modify it on the database server: In the init file: nls_date_format is set to YYYY-MM-DD You can also modify the registry or environment variables on the client. Name: nls_date_format Values: yyyy-mm-dd The explicit display of the

Learning how to use the nbu backup file system is just the beginning for a data administrator. For most enterprises, nbu is mainly used to back up the data of enterprise databases, protect the data security of databases, and thus ensure the safe

Guidance: Several project teams have begun to use the full-text index of oracle. Oracle's lexical analyzer is not smart enough for the lexical analysis of the zhs16gbk character set. It can only be mechanically matched in words. The utf8 character

The default naming conventions for this file are:Init $ oracle_sid.ora (in UNIX environment)Init % oracle_sid %. ora (in Windows) By default, it is placed in the following directory$ ORACLE_HOME/DBS (UNIX)% ORACLE_HOME %/Database (Windows) This

/*There are four functions that support regular expressions in Oracle:1. regexp_like: similar to like2. regexp_instr: similar to instr3, regexp_substr: similar to substr4. regexp_replace: similar to replaceThey are used in the same way as Oracle SQL

Oracle Data Pump details Oracle Database uses Data Pump Technology in 10 Gb, allowing DBAs or developers to quickly move database metadata (object definition) and data to another Oracle database.I,Role of Data Pump Export Import (expdp and impdp:1.

Steps for upgrading oracle from 10 Gb to 11 GB Database Old Version: 10.2.0.4New database version: 11.2.0.2OS: Solaris 10Reference:Complete checklist for manual upgrades to 11gr2 [ID 837570.1]Part 1-install 11gr2 SoftwareHere Software Of Install For

On the Internet, you can see an article about partition tables and local indexes written by eygle.Article, I think the summary is quite good. OracleOfPartitioning technologyIt can be greatly improved under some conditions.QuerySo it is widely used.

Oracle cluster (RAC) Startup and Shutdown Pay attention to the following points when starting and disabling Oracle RAC: 1. Check shared devices Ii. Automatically Start RAC and check related processes Iii. manually start RAC 4. Check the

A database version used to change the password of an Oracle user: 9.2.0.5) Sometimes we may not know the password of a user, but we need to perform some operations with this user, and we cannot modify the password of this user. At this time, we

Oracle paging query statements can be applied in the format given in this article. Paging statement:Select * from(Select a. *, rownum RnFrom (select * From table_name)Where rownum )Where rn> = 21 [/color] Where the innermost query select * From

In my project, we use SSIS to import data between two oralce instances. Because of the large data volume, An error is reported when more than 0.7 million of the data is exported to more than 80 thousand.CodeIs Row-00060, which is the same for a

  Modify the port 8080 of Oracle Use sys to log on to Oracle and use dbms_xdb to modify port settingsSQL> call dbms_xdb.cfg_update (updatexml (2 dbms_xdb.mongo_get ()3, '/xdbconfig/sysconfig/protocolconfig/httpconfig/HTTP-Port/text ()'(4

The control file is a very important file. Only when the instance reads the control file can it be mounted. One principle of DBA is multi-channel control files. Today I did an experiment and learned this. CodeAs follows:

Scenario Description:Control File Corruption (control file content unchanged) 1. Backup 1 SQL> alter database backup controlfile to trace as '/u01/admin/sun/udump/c.trc';2 3 Database altered.4 5 SQL> 2. Delete the backup file 1 -bash-3.00$ ls -l 2

1. Check the locked table. Select lpad ('', decode (L. xidusn, 0, 3, 0) | L. oracle_username user_name, O. owner, O. object_name, O. object_type, S. sid, S. serial # from V $ locked_object L, dba_objects o, V $ session s where L. object_id = O.

Select E. employee_id, E. last_name, D. department_id, D. department_nameFrom HR. Employees e left Outer Join HR. Orders ments dOn E. department_id = D. department_idSelect E. employee_id, E. last_name, D. department_id, D. department_nameFrom HR.