The following error occurred while starting the Oracle 11g RAC database, only one of the nodes could be started, and the other node could not start, possibly due to a previous modification of the Cluster_database parameter. This parameter must be set to true in the Oralc RAC schema.
Error message:
ora-01102:cannot Mount
Oracle 11g RAC remote database login time and OS time difference 16 hours solution
Help colleagues install the RAC database of Oracle 11.2.0.4 for project stress testing. The operating system is red flag server 3.
Today, my colleague suddenly called to say that the
modifications, it became the following (I executed the ALTER DATABASE DataFile ' sql> ALTER DATABASE open;ALTER DATABASE Open*An error occurred on line 1th:ORA-01113: file 1 requires media recoveryORA-01110: data file 1: ' C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM. DBF ' sql> recover DataFile ' C:\ORACLEXE\APP\
end of the installation, you will be prompted to execute two scripts: Execute the two scripts again with the root user.Note: When the second script executes, it depends on the information returned. [[emailprotected] ~]#/u01/app/11.2.0/grid/root.sh Running Oracle 11g root.sh script ... The following environment variables is set as:oracle_owner= ORACLE oracle_ho
ORACLE 11g R2 database installation hardware environment requirements, 11gr2
Physical memory requirements: Minimum 1 GB, minimum 2 GB for windows7, windows8, and windows8.1.
Virtual Memory (or paging space) capacity requirements:
Available RAM
Swap Space Required
Between 2 GB and 16 GB
Equal to the size of RAM
More than 16 GB
then press ENTER. As soon as the installation is complete, you will be prompted to execute 2 shell scripts with root privileges. Perform/home/oracle/app/oracle/product/11.2.0/dbhome_1/root.sh and/home/oracle/orainventory/as indicated by their pathOrainstroot.sh, there will be a message when the installation is complete. Execute command: CD /home/
It's sometimes said that the true job of an Oracle database administrator can be summed up in one, essential skill: to be able to recover your database. there's much wisdom in that statement. of all the things you are responsible for as a database administrator, nothing is more important than the data itself. like it o
Connect to the oracle (11g) database using python, python11gPreparation: 1. Download the corresponding version of oracle-instantclient (I am here 11.2.0.1.0)
http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html2. Installation
rpm -ivh
Channel:prmy2Released Channel:prmy3Released Channel:prmy4The repository environment has been fully initialized, eliminating the need for us to manually configure the Pfile parameter file, manually copy the password file to the repository, create the standby control and copy to the standby, copy the data file backup to the repository and so on. But see here, there is a puzzled Oracle How to directly copy those password files, parameter files, control
)
ORACLE ENTERPRISE LINUX 5.7 under Database 11G RAC cluster installation (vii)
ORACLE ENTERPRISE LINUX 5.7 Databases 11G RAC database installation (eight)
Basic test and use of da
:
Database version is 11g
Operation user must have SYSDBA permission
Database parameter timed_statistics must be true
IO must be allowed asynchronously, but with the file system, you can set the Filesystemio_options parameter to SetAll
Ensure that the data file allows asynchronous IO, which can be confirmed by the following SQL statement
Oracle 11g database security reinforcement considerations, oracle11g
In database security configuration, security reinforcement is required. To ensure database security, however, sometimes, after improper operations or database bu
is: Span style= "COLOR: #ff0000" > " | | Mnttime); -- set serveroutput on/off on or off display Dbms_output.put_line ( " ok, im fine " end / You can save the statement to a file and then call it with the "@/path/filename.sql".Substitution variables:SELECT empno, ename from EMP WHERE deptno= Department number;If the replacement variable provides data for a numeric column, you can drink it directly, or if you provide data for a character type or a date type, you need to enclose the
=xxg;# #rac operate one setStart the database:ALTER DATABASE Open # #rac above 2 machines to doAfter that, you can connect to the database, but what needs to be done now is to clear the archive log of the database, because now only increases the db_recovery space, we need to clean up the unnecessary archive log, to obtain space.Clear the Archive log script:#!/bin
Tags: Oracle Linux Centos system operationsTroubleshooting remote inability to invoke graphics installationThe remote installation of the ORACLE-11G database cannot invoke a graphical workaround, as in the following error:WORKAROUND: Switch to the root user and execute the command:#xdpyinfo | grep Local//results as fil
Oracle language, add the environment variable Nls_lang, and the value is simplified Chinese_china. Zhs16gbkIf you do not know the Oracle language of the remote database, you can ssh or telnet to the remote machine, enter it at the command interface, and connect to the database using the command line.SELECT * from Nls_
advance). This is a dynamic parameter that can be changed in the database run:ALTER SYSTEM SET log_archive_max_processes=10;ASM-related processes: You must create an ASM instance (rebalance (Rbal), ASM rebalance (ARBN), ASM background) when using ASMManageability Monitor (Mmon): Collects centralized statistics, such as awr snapshot information, and warns you about the various dimensions of a database that
Tags: WinForm style blog http tar extBecause like new things, so basically computer development tools are the latest, Oracle also installed 11g R2, but colleague classmate is not 11g R1 is 10G, from here I exported the DMP file in their direction in, all show:IMP-00010: Not a valid export file, header validation failedFor this problem has been distressed, almost
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.