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
Oracle Database 11g Release 2 Standard Edition and Enterprise Edition software DownloadsOracle Database 11g 2nd edition Standard Edition,Software download for Enterprise EditionOracle download also requires a user name I registered a convenience for everyone to use the downl
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\
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
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
Guidance:Oracle announced at its U.S. headquarters that,Oracle Database 11 GBInTPC-HA new world record was created in the MB benchmark. This achievement marks another milestone in Oracle Database development and marks the rapid development of Oracle databases. This is the fa
With the upgrade of the Oracle version, RMAN is also enhanced. RMAN in Oracle11g supports the use of different operating systems and different databases. For the compatibility of RMAN, refer:
Oracle RMAN compatibility and FAQs between different versions and different platforms
This article demonstrates an example of restoring 10 Gb to 11 GB in linux.
Target end:
OS: Ora
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
search the web for PL/SQL Deleloper 64-bit version. However the Discovery PL/SQL Deleloper does not differentiate between 64-bit and 32-bit. It seems that we can only start with Oci.dll. According to the above error message, it appears that just install a 32-bit version of Oracle Client.2. Install Oracle ClinetFirst download an Oracle
:
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
does not differentiate between 64-bit and 32-bit. It seems that we can only start with Oci.dll. According to the above error message, it appears that just install a 32-bit version of Oracle Client.2. Install Oracle ClinetFirst download an Oracle 11g Client to the Oracle web
does not differentiate between 64-bit and 32-bit. It seems that we can only start with Oci.dll. According to the above error message, it appears that just install a 32-bit version of Oracle Client.2. Install Oracle ClinetFirst download an Oracle 11g Client to the Oracle web
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
Event Viewer, delete the Oracle-related logs DescriptionIf there are cases where individual DLL files cannot be deleted, do not bother, restart, start a new installation,When installing, select a new directory, then, after installation and restart, the old directory and files can be deleted
If the article is wrong, welcome to correct, we communicate with each other. Accustomed to look at technical articles, want to get more Java resources o
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_
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.