Oracle

There are customers QQ to find me, said a friend recommended, let me help them restore the database. The database does not start properly because of a forced shutdown.Database Recover DB FailedMon Mar 28 10:20:33 2016ALTER Database RECOVER

Date functionDate functions manipulate Date values (fields of date type), timestamp values (TIMESTAMP, TIMESTAMP with time ZONE, and TIMESTAMP with the fields of the local time ZONE type), and interval values (INTERVAL day to SECOND and INTERVAL

Database initial failureThu Sep 25 09:27:26 2014Mmon started with pid=15, OS id=1968Starting up 1 Dispatcher (s) to network address ' (Address= (Partial=yes) (protocol=tcp)) ' ...Starting up 1 Shared server (s) ...Oracle_base from environment =

To fix the reason for the security audit, found that there is a xs$null user in the database, try to modify the password for it, found an error. Even the SYS user cannot modify the password of the Xs$null User: Sql>--11.2.0.4sql> alter user xs$null

For example: There are nearly 11 million data in the  t table, many times we want to do string matching, in SQL statements, we usually use like to achieve our search goals. However, the actual test found that the efficiency of like differs

Navicat PREMIUM11 Connection Oracle appears ora-28547:connection to server failed Environment Description:Local Oracle is installed normally, and no exception occurs halfway through.Ensure that Oracle's primary services are started.1,

Most of the reasons for the lack of access are due to changes in the configuration of TNS in Oracle. The cause of TNS configuration problems may be: 1. Computer Name 2 was modified. Modified the IP The default Oraclexe launches

Scenario: Create a table space in Oracle, assuming the space name is tbsp_1, the file location is d:\app\administrator\oradata\orcl/, and the space size is 10M. Steps: To create SQL:CREATE tablespace tbsp_1 datafile '

Brief: When querying database data, prompt temporary table space exception, error ORA-01157 ORA-01110, after the data file processing, has resolved this fault.Environment: Oracle 11g RAC for Linux 6, library for Dataguard1. Query the data times

a long time ago, OGG only supports deployment on the database host, which is called a localized deployment. And now OGG supports remote deployment, that is , OGG software is not installed on the database host, but installed on a separate machine,

Some of the understanding of Oracle instance recovery, has been a misunderstanding, today by looking at relevant information and discussion with students, found their own mistakes, the results are as follows:Instance recovery: When the database is

Note 1:TYPICALLYDBWR have to free up some buffers when you want to read something from the disk. During This process there is chances that you'll be a waiting for your local buffer (i.e blocks dirtied/invalidated by R session) to is written to disk.

ORA-100501 is the error returned if you trap a Raise form_trigger_failure in an exception handler.Somewhere in your program unit, you have codedException ... when others then ...Coding "Exception When others" was a bad idea. I have never coded,

One. DB file Parallel Write wait eventQuote from the following blog:Http://oradbpedia.com/wiki/Wait_Events_-_db_file_parallel_writeDB file Parallel writeThe db file parallel write wait event belongs to the Oracle database writer (DBWR) process

In real-world development applications, about Oracle databases, it is often heard that a database is created, a instance is created, and a instance is started.Actually ask them what is the database, what is instance, most likely they give the answer

Create a new database in Oracle, delete it today and then log on to Sql*plus, and there is a ORA-12560:TNS: Protocol adapter error.Ora-12560:tns: Resolution of protocol Adapter errorsThere are three reasons why the Ora-12560:tns: Protocol adapter

ORA-00904: "***" invalid identifier The possible cause of this error is that a field name in your SQL statement is incorrect, Or the table name is wrong. In short, this type of error occurs basically because in SQL statements, The field name does

I. Preparation knowledge Constraints are placed in tables. There are five constraints: Not null the column specified by the non-NULL constraint C cannot be NULL. UNIQUE has no duplicate values in the column specified by the UNIQUE constraint U, or

O & m dba reflects production Oracle database storage offline Oracle database faults cannot start error: ORA-00600 [2131] ORA-07445 [kdxlin] Errors1. Startup reports ORA-00600 [2131] errorFri Nov 06 14:50:59 2015ALTER DATABASE MOUNTThis instance was

We already know that/etc/init. d/init. ohasd in 11.2 and 12c RAC is the daemon process for starting all other processes of RAC.So what if someone accidentally deleted the file or modified it by mistake?This solution is not difficult, because in the