. When the system shuts down, the instance is erased from memory, and the entire memory structure and background processes disappear, but the database remains on disk, just in the closed state.1. DatabaseA database is a collection of data.When installing the Oracle database, let's choose to install the startup
It takes a day and a half to resolve the client connection to the Oracle database on the server side, unable to connect the problem. Ora-01034:oracle Not available (ORACLE does not exist), ora-27101:shared memory realm does not exist analysis:A few days ago you can also connect to the
For more information, see
-------------- Note: The following operations are performed in rhel vnc, not in secureCRT. -------------------------- Cause: If it is executed in secureCRT, m Lu will be shown as: m Lu. See the following. Why? I haven't studied it yet --
The experiment process is as follows:
[oracle@lei1 ~]$ export NLS_LANG=AMERICAN_AMERICA.AL32UTF8[oracle@lei1 ~]$ sqlplus scott/aaaaaaSQL*Plus:
Conclusion
Now that your database has been started and running, you can start to use ORACLE 10G. It is best to start using Oracle Enterprise Manager because it is completely rewritten and uses a Web-based interface. If you are not sure where to start,OracleConcept GuideAndD
Oracle Database multi-Table query instance and Oracle database instanceFlute product: the number of columns is added, and the number of rows is multiplied.
SQL> -- equivalent connection SQL> -- Query employee information: employee ID name monthly salary Department name SQL> set linesize 80SQL> desc dept name is blank?
will be reported.[Root @ centos ~] # Df-hFilesystem Size Used Avail Use % Mounted on/Dev/mapper/VolGroup-lv_root25G 11G 14G 45%/Tmpfs 2.0G 751 M 1.3G 37%/dev/shm/Dev/sda1 485 M 30 M 430 M 7%/boot/Dev/sr0 3.6G 3.6G 0 100%/media/CentOS_6.4_Final[Root @ centos ~] #
Test:
2. An error occurred while starting the oem control interface.[Oracle @ centos ~] $ Emctl stop dbconsoleOracle Enterprise
automatically. You can use DBCA to select from a list of predefined database templates, or you can use an existing database as a sample to create a template.(4) Network Configuration Assistant (onca,oracle net config Assistant) and network Manager (onm,oracle Net
The ORACLE tutorial is: a deep understanding of Oracle Database startup and shutdown.
The Oracle database provides several different methods for starting and disabling databases. This article describes the differences between these methods and their respective functions.
1.
are too simple or users with the default password), and so on.
Other issues
Ora2html is still in the process of development, has the potential to become a very convenient database information collection tool (the last update is actually Oct 22 2004, developers YCL still very diligent:-)). The problem now is that CSS does not have full and HTML page stripping (as the author is aware); Platform support is not broad enough; there is no support for XML.
As an Oracle administrator, you will learn database management tools from the beginning. The following describes some basic concepts of database management tools for Oracle administrators.
1. What is Oracle Enterprise
The Oracle database provides several different methods for starting and disabling databases. This article describes the differences between these methods and their respective functions. 1. Start and close the Oracle database For most Oracle DBAs, the most common method to
enhances Oracle's backup utilities, such as CommVault's Simpana and IBM's Tivoli Storage Manager.
Matthew Staver, the manager of the Information Technology Department at Pentel Inc. in atosans, California, uses a series of tools. Staver said, "When we handle some special transactions, we will use the HP (Hewlett-Packard's) Storage Service EVA commercial copy software for snapshot processing, if we need to
variables are set incorrectly. Confirm the correctness and click Next to proceed to the Next step:
Three installation options are available in this step:
Oracle9i Database 9.0.1.0.0: Install the Database server version, Administrative Tools, network services, and basic client software of oracle9i;
Oracle9i Client 9.0.1.0.0, enterprise Client software, network
From:Information on installed Database components and Schemas (document ID 472937.1)Note: This article is a lot of content, do not do all the translation, only listed the following directory and the Oracle database comes with the user:1. Jserver JAVA Virtual Machine2. OLAP Catalog, OLAP Analytic Workspace, Oracle OLAP
information only when the client is started.
The new Oracle VM Templates combines the advantages of Oracle VM for x86 and real Oracle Application Clusters to provide a high-availability database cloud solution, this solution has all the advantages of a fully virtualized environment. The new
1. Enable the Scott user and specify the password.
2. To enable SQL developer, you must configure the Java Virtual Machine. If it is oracle32bit, you can directly use oracle java.exe. If it is oracle64-bit, you can download the "java7 64bit plugin" from the official website, and then install and define its own java.exe path, because the "SQL developer" for oracle64-bit is 32-bit. Alternatively, install the 64-bit "SQL developer ".
3. Change "Scott
database before continuing,
>
Check the system requirements. If no error occurs during the check, continue. If an error occurs, adjust it according to the error prompt and try again until it passes.
After check is installed, if all requirements are met, click Next to continue the installation,Check whether there is a problem in the Summary information. If there is no problem, click the Inastall button to start installation.After the installation is
immediate.RECOVER DATABASE USING BACKUP CONTROLFILE-- Database can now be opened zeroing the online logs.ALTER DATABASE OPEN RESETLOGS;-- Commands to add tempfiles to temporary tablespaces.-- Online tempfiles have complete space information.-- Other tempfiles may require adjustment.ALTER TABLESPACE TEMP ADD TEMPFILE '/oradata/easy/temp01.dbf' SIZE 20971520
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.