Shulou(Shulou.com)06/01 Report--

Linux system

Oracle11.2.0.3 version

Question:

When sqlplus / as sysdba executes starup, an error is reported:

Answer: check whether this parameter is set in sqlnet.ora. If SQLNET.AUTHENTICATION_SERVICES has it, set it to ALL. If not, it doesn't matter.

If the above settings are set, check your environment variables under Oracle users, and check the information of Oracle users.

Id oracle to see if the user group to which Oracle belongs is correct

After that, if there is still a problem after checking the above two, then your parameter file has not been created correctly or has been deleted, create a new one:

Orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=, your password, entries=5 force=y.

The startup startup database appears as follows:

Answer:

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

Modify kernel parameters:

1. Modify / dev/shm size

[oracle@rtest] $df-h

Filesystem Size Used Avail Use% Mounted on

/ dev/sda3 140G 57G 76G 43% /

/ dev/sda1 99m 12m 82m 13% / boot

Tmpfs 3.9G 995m 3.0G 25% / dev/shm

[oracle@rtest] $mount-o size=8G-o nr_inodes=1000000-o noatime,nodiratime-o remount / dev/shm

Mount: only root can do that

[oracle@rtest ~] $su-

Password:

[root@rtest] # mount-o size=8G-o nr_inodes=1000000-o noatime,nodiratime-o remount / dev/shm

[root@rtest] # df-h

Filesystem Size Used Avail Use% Mounted on

/ dev/sda3 140G 57G 76G 43% /

/ dev/sda1 99m 12m 82m 13% / boot

Tmpfs 8.0g 995m 7.1g 13% / dev/shm

2 、 vi / etc/fstab

LABEL=/ / ext3 defaults 1 1

LABEL=/boot / boot ext3 defaults 1 2

Tmpfs / dev/shm tmpfs defaults,size=8G 0 0

Devpts / dev/pts devpts gid=5,mode=620 0 0

Sysfs / sys sysfs defaults 0 0

Proc / proc proc defaults 0 0

LABEL=SWAP-sda2 swap swap defaults 0 0

3. Start database verification:

[oracle@rtest ~] $export ORACLE_SID=test0924

[oracle@rtest ~] $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Oct 28 14:41:13 2013

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

Connected to an idle instance.

Idle > idle >

Idle > conn / as sysdba

Connected to an idle instance.

Idle > startup

ORACLE instance started.

Total System Global Area 3340451840 bytes

Fixed Size 2232960 bytes

Variable Size 3204451712 bytes

Database Buffers 117440512 bytes

Redo Buffers 16326656 bytes

Database mounted.

Database opened.

Idle > conn / as sysdba

Connected.

Sys@TEST0924 > show parameter mem

NAME TYPE VALUE

-

Hi_shared_memory_address integer 0

Memory_max_target big integer 3200M

Memory_target big integer 0

Shared_memory_address integer 0

The main reason for this is the lack of a solid grasp of the foundation of the database.

Not familiar with the cause, learning oracle must have a solid grasp of the foundation in order to avoid mistakes in the work.

For more Oracle learning, click:

Http://dwz.cn/3h3L5U

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.