Oracle 10 Gb manual database creation method generally, the tool that is more convenient to create a database is to use the dbca tool that comes with oracle, which is really very convenient. However, production databases in some industries (such as telecommunications and finance) have the requirement for manual
Oracle OEM database creation instances and oracleoem database creation
OEM is a graphical database administrator tool. It provides a centralized system management tool for database administrators. It is also a tool for managing, diagnosing, and debugging multiple databases,
The simulated server suddenly loses power, the database is lost, and the transaction cannot be recovered from the rollback failure.The database status is as follows:SQL> select instance_name, status from v $ instance;INSTANCE_NAME STATUS----------------------------Marven OPENNon-archive mode:SQL> archive log listDatabase log mode No Archive ModeAutomatic archival DisabledArchive destination/u01/app/
-- Connection recovery ManagerC: \ Documents ents and Settings \ mengzhaoliang> rman target/-- Archive log listRMAN> list archivelog all;-- Delete archive logs that do not exist in the physical fileRMAN> delete expired archivelog all;-- Delete archived logs 7 days agoRMAN> delete archivelog all completed before 'sysdate-7 ';Oracle archiving Mode I. Check whether the oracle
, Alter table Your_table_name cathe.
Oracle Query Optimization The second aspect: Optimization of multi-table query
The database may take a mergejoins, NESTED LOOP, HASH JOIN when making a multiple-table federated query. In this case, the hash join is less expensive than the other two connections.
We can use hash joins instead of Mergejoins, NESTED Loop joins, so in applications, you can add settings tha
1. Use SQL * PLUS to stop a databaseCopy codeThe Code is as follows:$ Sqlplus/nolog
SQL> connect/as sysdba
SQL> shutdown [immediate]
SQL> exit
2. Stop ListenerCopy codeThe Code is as follows:$ Lsnrctl stop
3. Stop the HTTP serviceCopy codeThe Code is as follows:# Service httpd stop
4. Use su or log on to the root again (if you want to reinstall it, You can retain the oracle user, saving you the need to enter environment variables)
5. Delete the instal
Unmount the Oracle database on Linux and the linuxoracle Database
See the article Red Hat5 installing Oracle 11gR2 (http://blog.csdn.net/johnnysun2015/article/details/45022119.
1. Stop the Oracle database
SQL> showdown immediate
How to migrate a MySQL database to an Oracle database bitsCN.com:
Tools to be prepared:
1. jdbc driver mysql-connector-java-5.0.4-bin.jar connecting to Mysql
2. SQL Developer 1.2 developed by Oracle Company
The following is how to configure SQL Developer 1.2
Configuration environment:
Select Tools-Preferences-
Oracle Database error ORACLE not available solution the following Error occurs when running commands such as exp, imp, or sqlplus: EXP-00056: ORACLE error 1034 encounteredORA-01034: ORACLE not availableORA-27101: shared memory realm does not existLinux-x86_64 Error: 2: No su
The following articles mainly introduce the example of Oracle Database DBA interview questions. This article describes the basic mode of Oracle Database DBA interview questions in a one-Answer manner, the following is an introduction to the related interview questions. I hope you will get some
Oracle (1) --> detailed description of database objects (Text explanation, first of all a small understanding ~), Oracle details---- Database object: a set of logical structures ----1. Synonym: alias of an existing object/*Purpose:Simplify SQL statementsHide the Object Name and ownerProvide public access to objectsCate
Oracle Database File Corruption has been solved. The problem is "error: ORA-01033: Oracle initialization or shutdown in progress", and later from the Internet to find some information, and finally add their own practice finally solved, but there is a problem, it seems that the database files are useless.
SolutionIn a
Oracle Performance Diagnosis art (milestone book on Oracle Database optimization)
[Original book name] troubleshooting Oracle Performance[Original Publishing House] apress[Author] (Swiss) Christian antognini [same as the author's work] [Translator's introduction][Translated by] Tong Jiawang; Hu Yiwen; Feng dahui [same
Tags: IP address server directory. COM class sign Ted cat remote serverFirst, the development environment requirements:
The premise is that the computer must have an Oracle client installed.
Installed the Pl-sql software
Second, configure PL-SQ and connect Oracle
Configuration method:
1. Locate the installation directory for Oracle.
Recover Database Report ORA-600 3020
The code is as follows
Copy Code
Recovery of Online Redo log:thread 1 Group 2 Seq 5729 Reading mem 0mem# 0:e:\oracle\oradata\yygdb\redo02.logTue Aug 19 19:37:29 2014Errors in File D:\oracle\diag\rdbms\yygdb\yygdb\trace\yygdb_pr0s_4296.trc (incident=39403):Ora-00600:internal error code, arguments: [30
information for the Oracle database is registered.4. Delete the registered Oracle Event log and open the registryHkey_local_machine\system\currentcontrolset\services\eventlog\applicationDelete all entries in the registry that begin with Oracle.5. Delete the environment variables for
. Users of fromuser and touser can be different)
Rows = y
Indexes = y
Grants = y
Constraints = y
Buffer= 409600
File =/backup/ctgpc_20030623.dmp
Log =/backup/import_20030623.log
Supplement: adding feedback = 1000 in the Import/Export command can display an increasing number of "..." in the process to change the blinking cursor.
In short, Oracle Database Export (exp)/import (IMP)
Exp
The
---restore content starts---1. Download 11g on the Oracle website firstOracle Database 11g 2nd edition (11.2.0.1.0) Standard Edition, Standard Edition 1, and Enterprise Edition, Oracle Database 11g 2nd edition for Microsoft Windows (x64) (11.2.0.1.0 ), (sign-in required):Http://download.oracle.com/otn/nt/oracle11g/1120
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.