Oracle

Ora-01548:active rollback segment ' _syssmu1$ ' found in OracleConnect to the above Oracle Undo tablespace Recovery (no backup) http://tiany.blog.51cto.com/513694/14312871. After creating a new undo Tablesapce "Undotbs2", delete the old undo

Today upgrade a 10g cluster environment to 10.2.0.5, download the patch package P8202632_10205_linux-x86-64.zip online, after decompression installation execution, midway error:I/O ERROR cannt reading or opening file in/tmp/...../temp52The online

In the management of the Oracle database or in the development activities often using the Plsql developer tool to manage our database, of course, to let our operations on the Plsql developer in the remote database system, we first need to install

1, first go to Oracle official website Download the following installation package

How to open Oracle rac--archive log 2011-10-07 15:53:04Category: OracleOracle rac--Archive Logging Method ================================== 10g R1 To modify the cluster_database parameters, 10G R2 and later versions will not be required1. Example (1

A recent use of statspack on a customer's 8i production library found an error in alert:Mon June 16 13:17:52 2014Errors in FILE/ORACLE/8.1.7/ADMIN/PROD/BDUMP/SNP0_96626_PROD.TRC:Ora-12012:error on Auto execute of Job 304Ora-01631:max # Extents (505)

Create or Replace functionMy_test (p_strvarchar2)return Number as--Common VariablesV_varvarchar2( +);--fixed-length arraysType V_ar isVarray (Ten) of varchar2( -); My_ar V_ar:=V_ar ('g','m','D','Gong','Handsome');--variable Length valueType

Here is an example to illustrate:Connect to Oracle first with Oracle System user (SYSDBA identity)Then create two users of "Lisi" and "Zhangsan"Then grant the Lisi permission to create the table .Lisi connect to the database and create a table

Overview:1.Oracle Memory Management2.Oracle Database startup shutdown3.Oracle parameter file4.Oracle Control files5.Oracle Redo log File6.Oracle Undo Table Space Management7.Oracle normal tablespace and data file8.Oracle Temp Table Space9.Oracle

Problem description: On February 10, 00600, the Ora-9835218 error occurred while checking the database warning file, and the Rman L1 backup failed. query the relevant information and find that the error was a Bug. Therefore, we asked SR for official

This problem has recently been plagued by the fact that the Oracle listening service is not automatically started after the server is powered off and restarted (the listening service has been set to self-started ). Specifically, the listening

Recently, due to the upgrade of Mac OS x 10.10 Yosemite, one night just a few days ago, I found that I was stuck on the boot page. It seems that BETA is unreliable, then I thought that I had just backed up my backup a few days ago. It's okay. What

Before Oracle 11g, when there is a problem with the database, it is often the first time you need to read the alert Log to see what errors are recorded in it, you can prompt us. Alert file name Alert _ . log. The file storage path is determined by

For Oracle beginners and even Oracle DBAs who have some experience, Oracle account logon problems are often very difficult. Even if you log on to oracle successfully, you still know it. After systematic study and repeated practices, The author

Oracle 11g RAC construction in linux (10)9. Use DBCA to create a database [Root @ node1 ~] # Su-oracle // switch to an oracle user [Oracle @ node1 ~] $Dbca// Dbca creates a database Select oracle RACdatabase to install RAC Database We recommend

Background: A table suddenly experienced slow queries, with a cost of more than 100 seconds, seriously affecting production. Original SQL: explain plan for select * from (select ID id,RET_NO retNo, FROM_SYS fromSy, TO_SYS toSys, COMMAND_CODE

An example is provided below: First, connect to Oracle as a guest (sysdba) Then create two users, "lisi" and "zhangsan" Then authorize lisi and grantCreate a tablePermissions Lisi connects to the database and creates a table named

After the data in the table is deleted, it does not actually delete the data. Instead, it is marked with a delete mark and can be restored as long as it is not overwritten. The experiment process is as follows: SYS @ ORCL> create table bbed_test (x

Select a. FILE_NAME, a. AUTOEXTENSIBLE, a. MAXBYTES, a. INCREMENT_BY from dba_data_files; -- AUTOEXTENSIBLE auto Scaling-- MAXBYTES maximum -- INCREMENT_BY: automatically scales the number of blocks. SQL> show parameter db_blockNAME TYPE VALUE ------

1. Oracle built-in role connect and resource PermissionsGrant connect, resource to user;CONNECT role: -- is the most basic and typical right granted to end users.Alter session -- modify a SESSIONCreate cluster -- CREATE a CLUSTERCreate database link