The ORA-00845 is prompted when the database is started: MEMORY_TARGETnotsupportedonthissystem (the parameter MEMORY_TARGE for Automatic Memory Management added in oracle11g
The ORA-00845 is prompted when you start the database: MEMORY_TARGET not supported on this system (the parameter MEMORY_TARGE for Automatic Memory Management added in oracle 11g
1. The ORA-00845: MEMORY_TARGET not supported on this
How to handle EM key garbled characters in Oracle 11g
Today, I used a Mac to connect to the VMware Fusion virtual machine database. I suddenly wanted to use EM and suddenly found that the buttons were garbled. For example:
Analysis: To solve the problem, find the correct font.
Solution:
1. Find a font file such as simsun. ttc on Windows machine c: \ windows \ fonts.
2. Create a folder named fallback in the
Oracle 11g update PSU detailed steps
Oracle releases the latest patches every quarter. For production O M personnel, regular system upgrade and patching are indispensable in daily work.
Compared with the previous versions, Oracle patching has become relatively simple, and the method for processing PSU has also changed
Tags: OracleThis blog post focuses on installing Oracle 11g in a CentOS environment. The system environment is CentOS7.2.Pre-installation Environment preparationTo install the required packages:Yum install binutils compat-libcap1 compat-libstdc++ gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel LIBGCC Libs tdc++ libstdc++-devel libxi libxtst make Sysstat unixodbc-devel-yYum install binutils* compat-lib
configuration are the most critical parts. Iv. Unloading of the database Go to the installation directory and go to product-->11.2.0-->dbhome_1-->deinstall-->deinsytall.bat Continue through the carriage return to achieve the next step, come here follow the prompts to enter Y Go back in and enter Y here Continue to enter the database after the cleanup operation, a few minutes (in fact, a long time), the database is uninstalled, the process may fail, restart the computer or shut down the
Installing Oracle 11g R2 in LinuxI. installation environment
Linux Server: CentOS 6.4 64-bit
Oracle Server: Oracle 11gR2 64-bitIi. System Requirements
Requirements for installing Oracle in Linux
System Requirements
Description
Memory
Physical memor
Oracle 11g R2 rac rman backup script example
1. Switch RAC to archive Mode
1. Modify the archive mode of the database. Generally, archive is configured and the flash back area is used when RAC is installed. you can skip the steps below if you have configured archive.
SQL> alter system set cluster_database = false scope = spfile sid = '*';
2. Shut down all instances (shutdown on both sides)
SQL> shutdown imm
Prior to 11.1, many people might have known that Oracle database history passwords could be restored through alter user identified by values password, but several problems occurred in 11g:1. Dba_users no password record (null value), this problem can be directly queried User$.password still have recordsSql> Select password from dba_users where username= ' SYS ';PASSWORD------------------------------Sql> Sel
Oracle 11G 64-bit automatic restart and shutdown commands in RHEL (Red Hat Enterprise Linux, the same below) 5.5 64-bit:
Log On As an oracle user and enter:
VI/etc/init. d/Oracle
On the Edit page, add the following content: (assume that the Oracle main directory is/u01
Running Oracle 11g root.sh script ... The following environment variables isSet as: Oracle_owner=Oracle Oracle_home=/opt/oracle/product/Orahomeenter the full pathname of the Local bin directory: [/usr/local/bin]: Here enter Copying Dbhome to/usr/local/bin ... Copying oraenv to/usr/local/bin ... Copying coraenv to/usr
New Features of Oracle 11g: User rename
Oracle Data is constantly changing during project development. Therefore, we need to regularly import the development database to the test database. The common practice is "trilogy :"
1. Export data from exp in the Development Library
2. Delete the Test Database User
3. Use imp to import exported data to the Test Database
T
Install Oracle 11g in RedHat Linux 6.0
Steps for installing Oracle in Linux
Preparations before installation
Transmit oracle to the root directory through ssh (this installation is under VMware)
Installation Package for Linux for Oracle
The source of this article, in order to facilitate direct copy over. If there is infringement, please inform, thank youhttp://blog.csdn.net/chiclewu/article/details/14646687An Oracle 11g 64-bit version was installed in the virtual machine today, and when connected with PL/SQL developer, it was found that there was no database connection to TNS.It is considered that the PL/SQL developer does not recognize th
is completecan use Sqlplus to test, the new Open a command window, enter the Sqlplus, and then enter the user name and password, you can test, here do not do too much introduction.Configuring monitoring and local network services1) in Oracle User's graphical interface Oracle user, the new terminal is opened, the input command NETCA will pop up the following interface.2) Create a listening service (acting a
It is very easy to uninstall Oracle on Linux, that is, to delete all files and folders under the Oracle installation directory.
It is very easy to uninstall Oracle on Linux, that is, to delete all files and folders under the Oracle
Common Oracle Database colleagues know that Oracle often encounters some inexplicable errors, resulting in the database cannot be started or used properly.
After solving these problems, we found the root cause of the problem, that is, when we re-installed the Oracle database, we did not thoroughly uninstall the previou
, Oracle. All rights reserved.Connect:Oracle Database 11g Enterprise Edition Release 11.1.0.6.0-64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data MiningAnd Real Application Testing optionsSQL> shutdown the immediate database has been disabled. The database has been detached.The ORACLE routine has been disabled.SQL> startupThe
New Features of Oracle 11g
(36 in total)
I. Database Management
·1. Database Replay)
This feature can capture the load of the entire data and pass it to a test database created from the backup or standby database, and then repeat the load to test the system tuning effect.
·2. SQL replay (sqlreplay)
Similar to the previous feature. However, it only captures the SQL load, rather than all the load.
"rolling upgrade" for ORACLE11g and later versions. In other words, you cannot use this function to upgrade ORACLE10g databases to 11G.
Before performing a rolling upgrade, make sure your environment is ready. For example, if you use the ORACLE Clusterware software, you must complete the upgrade to the next version that meets the requirements before rolling the upgrade. Of course, you should also use the r
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.