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
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
Recently, the company has changed the computer, and the 10 Gb memory is still quite powerful. First, the Oralce runtime environment is installed on the local machine. I thought it would be very smooth, but there were still some minor problems, record it and help you sort it out. It is also the beginning of the blog. I remember the first time I installed Oracle on Linux, I did not know how many days I had to
Install oracle 11g and oracle11g in linux
Oracle 11g Installation
I. Environment preparation
/15000 M
/Tmp 4096 M
/Boot 100 M
Swap 4096 M
/U01 remaining space
2. Change the Host Name and IP address
3. install the software package
The environment for
Initorcl.oraStartup NomountGenerate SPFileCreate SPFile from Pfile;Reboot to Nomount stateStartup Force NomountAdd Repository LogALTER DATABASE add standby logfile Group 10;alter database add standby logfile Group 11;alter database add standby logfile Group 12;alter Database Add standby logfile Group 13;Cloning a repo
registry key, all the keys that contain Oracle.11. My Computer----high-level----environment variables, delete environment variables classpath and path for Oracle settings.12. Remove all Oracle-related groups and icons from the desktop, startup Group, and Programs menu.13. Delete all Oracle-related directories (if not
Background:The physical memory of the master and slave machines is doubled. After the memory is expanded, You need to modify the memory parameters related to the database, including the database and operating system. After doubling the memory size of the backup machine, modify the relevant memory parameters and start the database to the backup machine for two day
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_
small. To revert it back to storage just run following command and REBOOT machine to be effective.Systemctl Mask Tmp.mountInstall database SoftwareLet's start with database software installation as Oracle user.Su-oracle--unzip Software 11.2.0.4unzip p13390677_112040_linux-x86-64_1of7.zipunzip p13390677_112040_linux-x8
decompress the file.2) After the decompression is complete, the CD enters its unzipped directory.Enter the command:CD database (database in your extracted directory, according to your own situation, into the database)Use the LS command to view the files that the database contains after decompression3) Perform the inst
> list datafilecopy all; rman> Delete Expired backupcopy; Rman> crosscheck datafilecopy All; rman> Delete Expired backupcopy;If this is due to the Flash recovery area capacity limit, you can modify the path and capacity of the flash recovery area:Sql> alter system set db_recovery_file_dest= '/data/app/oracle/test ';Sql> alter system set db_recovery_file_dest_size=10g;Rman Incremental BackupWhen you use Backup data
The following problems are frequently encountered during data migration:
1. If the exported file is not valid, the header verification fails;
2. EXP-00056: Oracle error 6550ORA-06550: Line 1, column 41:PLS-00302: component 'set _ no_outlines 'must be declaredORA-06550: Line 1, column 15:PL/SQL: Statement ignoredEXP-00000: Export termination failed
About import and export:
1. The exp command on the client must be consistent with the
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
. Configuring Oracle User Environment variablesVI. bash_profileExport Oracle_base=/u01/app/oracleExport Oracle_home=/u01/app/oracle/product/11.2.0/dbhome_1Export ORACLE_SID=ORCLExport path= $ORACLE _home/bin: $PATH 8. Open Xmanager Passive, execute in system[Email protected] ~]# export display=192.168.1.100:0.0(IP for machines that need to receive
.dbf' size 20 M reuse
Undo tablespace UNDOTBS1
Datafile '/u01/app/oradata/hsj/undotbs01.dbf'
Size 200 M reuse autoextend on maxsize unlimited;
Spool off
6. Go to sqlplus and execute the database creation script.
@ Createdb. SQL
7. If an error is reported, check the createdb. log alert log and trace log.
8. Go to the $ ORACLE_HOME/rdbms/admin directory and run the SQL statement used to create the data dictionary and system package.
@ Catalog. SQL
@ Cat
Tags: OracleOracle Database 11g Some important initialization parameters (i)Initialize parameter file locationD:\app\Administrator\admin\orcl1\pfile\init.oraInit.ora1, Diagnostic_destIn 11g, there is a new structure for storing diagnostic information called the Automated Diagnostics repository (AUTOMATICD Diagnostic Repository ADR).Specify the directory location
\ System-application.xml F:\app\Administrator\product\11.2.0\dbhome_2\oc4j\j2ee\OC4J_DBConsole\config\ System-jazn-data.xml F:\app\Administrator\product\11.2.0\dbhome_2\oc4j_applications\applications\em.ear F:\app\ Administrator\product\11.2.0\dbhome_2\oc4j_applications\applications\em\em.war [NS-20802]Oracle Net Configuration Assistant failure
Workaround: After downloading, there are 2 installation packages.
After decompression, the second package
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.