Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ ORA-00824: can not set sga_target due to existing problem-solving     - Try the command ip, ifconfig is obsolete under Linux (Linux)

- CentOS x86 64bit upgrade to 2.7 Python2.6 (Linux)

- Linux LVM Logical Volume Management to resize partitions (Linux)

- Machine Learning: Classification of the curse of dimensionality (Programming)

- Oracle first Automated Installation Packages (Database)

- Linux argument references and command substitution (Linux)

- Java heap (Heap) and stack difference (Programming)

- How to use the TF / SD card making Exynos 4412 u-boot boot disk in Ubuntu (Linux)

- How to install GIMP 2.8.16 in Ubuntu 16.04,15.10,14.04 (Linux)

- To install and configure the Jetty server and JDK under Ubuntu 14.04.2 (Server)

- About Samba certification process and permissions (Linux)

- Linux Network Programming - raw socket Example: sending a UDP packet (Programming)

- Android recyclerview cardview (Programming)

- Java development specifications summary (Programming)

- CentOS permanently banned from running in the background PackageKit (Linux)

- Using the Linux folder wc statistics number of lines of code for all files (including subdirectories) (Linux)

- Linux operating system Study Notes (Linux)

- Android Scroller call mechanism and the relationship of computeScroll (Programming)

- Making Linux root file system problems on-link library (Programming)

- MySQL 5.5 on master-slave copy filter (Database)

  ORA-00824: can not set sga_target due to existing problem-solving
  Add Date : 2018-11-21      
  Said that after using Oracle9i client connections Oracle10g, modify some parameters, resulting in Oracle10 not start normally, small machine will not restart several times.

After the remote connection, the user when using Oracle sqlplus following startup, the system prompts as follows:

ORA-00824: can not set sga_target due to existing internal settings, see alert log for more information

It appears to be sga_target this parameter in question. Check in online information search sga_target parameters (specific I can see another one reprint article: ORACLE10 - SGA_MAX_SIZE and SGA_TARGET), it is learned that in oracle10 new memory parameters for each component of the dynamic adjustment of SGA memory . Its content is also stored in the spfile.

Prior to this, after another piece of paper ORACLE9i-- optimization SGA exceeds the maximum result 1.7G instance can not be started by the relationship between spfile and pfile to solve the problem can not be started due to the adjustment SGA_MAX_SIZE instance, the use of this same relationship sga_target can solve today's problems.

Moreover, after practice I found that the process used last too cumbersome, today through practice to find an easy way.

But the idea is the same: to find ways to modify the value of sga_target to the normal threshold, and then start the database instance

According to this idea:

1, we can start the first instance with the database of configuration parameters pfile

2, through reconstruction pfile spfile file (create spfile from pfile)

3, close the database instance

4, the normal start the database instance

Specific operations are as follows:

[Oracle @ RedHat pfile] $ sqlplus / nolog

SQL * Plus: Release - Production on Tue Oct 20 00:20:19 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup pfile = '/ home / oracle / admin / zgz / pfile / init.ora.82220096537'

- "Start oracle instance via pfile file"
ORACLE instance started.

Total System Global Area 285212672 bytes
Fixed Size 1218968 bytes
Variable Size 88082024 bytes
Database Buffers 188743680 bytes
Redo Buffers 7168000 bytes
Database mounted.
Database opened.
SQL> create spfile from pfile = '/ home / oracle / admin / zgz / pfile / init.ora.82220096537'; - "by rebuilding the spfile pfile"

File created.

SQL> shutdown immediate - "Shut down the database instance."
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup - "through the normal startup spfile file oracle instance"
ORACLE instance started.

Total System Global Area 285212672 bytes
Fixed Size 1218968 bytes
Variable Size 88082024 bytes
Database Buffers 188743680 bytes
Redo Buffers 7168000 bytes
Database mounted.
Database opened.

Look! It is not very easy to approach than the last and up entirely on the command line can be completed.

Such learning is also a problem, you want to keep abreast easier way, is progress!

However, in the specific resolution process, when I use shutdown immediate to close the database, the system suddenly reported the following error: ORA-03113: end-of-file on communication channel

Not previously encountered in the online search found, the cause of this error for many reasons, most of which are caused by a bad network connection, turn off the results of my current SSH window to re-establish a SSH connection, the problem is solved.
- Xshell upload files to achieve Windows host Linux (Linux)
- MySQL thread cache thread_cache_size parameter optimization (Database)
- Red Hat Enterprise Linux 6.4 Configuring VNC Remote Desktop login access (Linux)
- Shilpa Nair interview experience sharing RedHat Linux package management (Linux)
- OpenSUSE 13.1 OpenSUSE 12.3 and how to install Cinnamon 2.2 Desktop (Linux)
- Linux Systemd-- To start / stop / restart services in RHEL / CentOS 7 (Linux)
- Binary tree traversal recursive and non-recursive (cyclic) traversal achieve (Programming)
- Ten SCP transfer command example (Linux)
- Questions about Linux compiler u-boot (Programming)
- Bash How to read a file line by line (Programming)
- SecureCRT in Python scripting study guide (Programming)
- Open Ubuntu system updates (Linux)
- The Java utility, JavaMail (Programming)
- Android realize RippleEffect water (Programming)
- CentOS7 management of systemd (Linux)
- Configure shared library PCRE (Linux)
- How to upgrade the kernel to 3.13.7 on Ubuntu / Linux Mint (Linux)
- Chromium Install Flash Official Guide (Linux)
- Create the container and run the application Docker (Server)
- System-level alias vs Oracle ADR functionality (Database)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.