Oracle Operation Problems

Oracle Operation Problems

Linux

Oracle11.2.0.3

Problem:
When sqlplus/assysdba executes starup, an error is returned:

A: Check whether this parameter is set in sqlnet. ora. If SQLNET. AUTHENTICATION_SERVICES exists, it is set to ALL. If not, it does not matter.

If the preceding settings are complete, check the environment variables of the Oracle user and the information of the Oracle user.
Check whether the Oracle user group is correct in idoracle


After the preceding two checks, the problem persists, that is, your parameter file is not correctly created or deleted, and you can recreate it:
Orapwdfile = $ ORACLE_HOME/dbs/orapw $ ORACLE_SIDpassword = your password entries = 5 force = y

The following error occurs when startup starts the database:



Answer:
If AMM memory management is used in Oracle 11g, when the MEMORY_TARGET value is greater than/dev/shm, The ORA-00845: MEMORY_TARGET not supported on this system error will be reported, solution: increase the size of/dev/shm. In the redhat system, the default value of/dev/shm is half of the total memory of the system.

Modify kernel parameters:
1. Modify the size of/dev/shm.
[Oracle @ rtest ~] $ Df-h
FilesystemSizeUsedAvailUse % Mountedon
/Dev/sda3140G57G76G43 %/
/Dev/sda199M12M82M13 %/boot
Tmpfs3.9G995M3.0G25 %/dev/shm
[Oracle @ rtest ~] $ Mount-osize = 8G-onr_inodes = 000000-onoatime, nodiratime-oremount/dev/shm
Mount: onlyrootcandothat
[Oracle @ rtest ~] $ Su-
Password:
[Root @ rtest ~] # Mount-osize = 8G-onr_inodes = 000000-onoatime, nodiratime-oremount/dev/shm
[Root @ rtest ~] # Df-h
FilesystemSizeUsedAvailUse % Mountedon
/Dev/sda3140G57G76G43 %/
/Dev/sda199M12M82M13 %/boot
Tmpfs8.0G995M7.1G13 %/dev/shm

2. vi/etc/fstab

LABEL = // ext3defaults11
LABEL =/boot/bootext3defaults12
Tmpfs/dev/shmtmpfsdefaults, size = 8G00
Devpts/dev/ptsdevptsgid = 5, mode = 62000
Sysfs/syssysfsdefaults00
Proc/procprocdefaults00
LABEL = SWAP-sda2swapswapdefaults00


3. Start database Verification:
[Oracle @ rtest ~] $ ExportORACLE_SID = test0924
[Oracle @ rtest ~] $ Sqlplus/assysdba

SQL * Plus: Release11.2.0.3.0ProductiononMonOct2814: 41: 132013

Copyright (c) 1982,2011, Oracle. Allrightsreserved.


Connectedtoanidleinstance.

Idle>
Idle> conn/assysdba
Connectedtoanidleinstance.
Idle> startup
ORACLEinstancestarted.

TotalSystemGlobalArea3340451840bytes
FixedSize2232960bytes
VariableSize3204451712bytes
DatabaseBuffers117440512bytes
RedoBuffers16326656bytes
Databasemounted.
Databaseopened.
Idle> conn/assysdba
Connected.
Sys @ TEST0924> showparametermem

NAMETYPEVALUE
-----------------------------------------------------------------------------
Hi_shared_memory_addressinteger0
Memory_max_targetbiginteger3200M
Memory_targetbiginteger0
Shared_memory_addressinteger0



The main reason for this is that the database foundation is not reliable,
If you are not familiar with oracle, you must have a solid understanding of the basics to avoid errors at work.


For more information about Oracle, click:
Http://tg.wyzc.com/index.php? A = generalize & m = Index & c = tongji & tg = 3006123630