Oracle database Express Edition 11g Release 2 (11.2) Error resolution Highlights

Preface: The First contact database, want to download an Oracle demo (although I heard that the general large enterprises only use), to the official website to download a simple version of the XE version, installation should be careful to remember the database password you entered (password)

There is also an installation path that cannot contain spaces (does not select a directory, which has spaces in its name),

Nothing happens after installation, the only Help is the Start menu->oracle Database Express Edition Get help

Click to read the document to see the basic instructions for use on the website.

Basic operational issues can be solved in the reading document, but it is difficult to learn from other problems directly, only to get help, go to the online forum for help, or search the engine by yourself.

Here is a list of the problems I have encountered, for my own backup, and I would like to provide reference for those who need it.

What is the basic operation?

Resolution: ( according to the official website and some search, I know the following (specific should be detailed crossing Web documents))

1. First open "Start menu->oracle database Express Edition" or "Run SQL command line"

2, if "Run SQL command line" run Sqlplus directly, if "Start the database" will just go to the command line, you need to open Sqlplus, enter the Sqlplus/nolog (or help Sqlplus to view assistance)

3. After startup, connect the database: Connect sys/password as Sysdba

4. Open the database with ALTER DATABASE (if it is already open)

5, then should be able to build a table or something.

Errors that may be encountered:

Error:12560-TNS protocol Adapter error

Resolution:https://community.oracle.com/message/10223124#10223124 by Lubiez jean-valentin 2012-3-20 am 5 : 12

Error:ORA-01109: database is not open

The following three links to I did not get the final help, can be used as a reference

Solution:http://www.cnblogs.com/sprinng/p/4616399.html

[Reprint]oracle database is not open, only allow query in fixed table/view

ORA-01109: database is not open

corruption of non-current online logs and current online logs :

After a series of confusing and nonsensical modifications, it became the following (I executed the ALTER DATABASE DataFile ' < path. \.\name. def> ' offline drop;

sql> ALTER DATABASE open;
ALTER DATABASE Open
*
An error occurred on line 1th:
ORA-01113: file 1 requires media recovery
ORA-01110: data file 1: ' C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM. DBF '

sql> recover DataFile ' C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM. DBF ';
ORA-00283: recovery session canceled due to an error
ORA-00333: redo Log Read block 1674 Count 374 error

Sql> select Group#,sequence#,archived,status from V$log;

group# sequence# Archiv STATUS
---------- ---------- ------ --------------------------------
2 0 NO UNUSED
1 NO Current

Sql> ALTER DATABASE Clear unarchived logfile Group 1;
ALTER DATABASE Clear unarchived logfile Group 1
*
An error occurred on line 1th:
ORA-01624: log 1 is required for emergency Recovery instance XE (thread 1)
ORA-00312: online log 1 thread 1: ' C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_C6NPXN
5l_. LOG '

Solution:http://www.itpub.net/thread-175996-1-1.html Posted in 2003-11-25 16:43:04 | author:rchsh

[I am damaged the current online log, and is a "No backup, requires mandatory recovery" case, one step need to add parameters in the Init<sid>.ora file
"_allow_resetlogs_corruption=true", I can not find the specific name, so in the database storage directory search for the init Word file,

Add this sentence to the previous 4 files containing init,

, the results seem to pass!

Specific steps must be described above link]

Oracle database Express Edition 11g Release 2 (11.2) Error resolution Highlights