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

I. description of the environment

System: rhel 7.3

Database: Oracle 12.2.0.1

Second, use AMM

$export ORACLE_SID=orcl

$sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Thu Aug 16 11:17:25 2018

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

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0-64bit Production

SQL > show parameter target

NAME TYPE VALUE

Archive_lag_target integer 0

Db_big_table_cache_percent_target string 0

Db_flashback_retention_target integer 1440

Fast_start_io_target integer 0

Fast_start_mttr_target integer 0

Memory_max_target big integer 0

Memory_target big integer 0

Parallel_servers_target integer 16

Pga_aggregate_target big integer 782M

Sga_target big integer 2352M

Target_pdbs integer 0

SQL >

SQL > alter system set memory_target=5g scope=spfile

System altered.

SQL > startup force

ORA-00845: MEMORY_TARGET not supported on this system

SQL > exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0-64bit Production

$df-h

Filesystem Size Used Avail Use% Mounted on

/ dev/mapper/rhel-root 30G 28G 1.5G 96% /

Devtmpfs 3.9G 0 3.9G 0% / dev

Tmpfs 3.9G 84K 3.9G 1% / dev/shm

Tmpfs 3.9G 8.8m 3.9G 1% / run

Tmpfs 3.9G 0 3.9G 0% / sys/fs/cgroup

/ dev/mapper/vgdata-lvdata01 8.0G 33m 8.0G 1% / oracle

/ dev/sda1 197M 150M 48m 77% / boot

Tmpfs 783M 16K 783M 1% / run/user/42

Tmpfs 783M 0 783M 0% / run/user/0

$exit

Logout

[root@roidb01 ~] #

[root@roidb01 ~] #

[root@roidb01 ~] # vi / etc/fstab

[root@roidb01 ~] # more / etc/fstab

/ dev/mapper/rhel-root / xfs defaults 0 0

UUID=e991f183-78ab-43cf-ba5a-2c0598867972 / boot xfs defaults 0 0

/ dev/mapper/rhel-swap swap swap defaults 0 0

/ dev/vgdata/lvdata01 / oracle xfs defaults 0 0

Tmpfs / dev/shm tmpfs defaults,size=6G 0 0 # # add a line

[root@roidb01] # mount-o remount / dev/shm

[root@roidb01] # df-h

Filesystem Size Used Avail Use% Mounted on

/ dev/mapper/rhel-root 30G 28G 1.5G 96% /

Devtmpfs 3.9G 0 3.9G 0% / dev

Tmpfs 6.0G 84K 6.0G 1% / dev/shm

Tmpfs 3.9G 8.8m 3.9G 1% / run

Tmpfs 3.9G 0 3.9G 0% / sys/fs/cgroup

/ dev/mapper/vgdata-lvdata01 8.0G 33m 8.0G 1% / oracle

/ dev/sda1 197M 150M 48m 77% / boot

Tmpfs 783M 16K 783M 1% / run/user/42

Tmpfs 783M 0 783M 0% / run/user/0

[root@roidb01 ~] # su-oracle

Last login: Thu Aug 16 08:34:52 CST 2018 on pts/0

$sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Thu Aug 16 12:19:20 2018

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

Connected to an idle instance.

SQL > exit

Disconnected

$export ORACLE_SID=orcl

$sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Thu Aug 16 12:19:39 2018

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

Connected to an idle instance.

SQL > startup

ORACLE instance started.

Total System Global Area 5368709120 bytes

Fixed Size 8632016 bytes

Variable Size 4211083568 bytes

Database Buffers 1140850688 bytes

Redo Buffers 8142848 bytes

Database mounted.

Database opened.

SQL > show parameter target

NAME TYPE VALUE

Archive_lag_target integer 0

Db_big_table_cache_percent_target string 0

Db_flashback_retention_target integer 1440

Fast_start_io_target integer 0

Fast_start_mttr_target integer 0

Memory_max_target big integer 5G

Memory_target big integer 5G

Parallel_servers_target integer 16

Pga_aggregate_target big integer 782M

Sga_target big integer 2352M

Target_pdbs integer 0

SQL > alter system set sga_target=0 scope=both

System altered.

SQL > alter system set pga_aggregate_target=0 scope=both

System altered.

SQL > show parameter target

NAME TYPE VALUE

Archive_lag_target integer 0

Db_big_table_cache_percent_target string 0

Db_flashback_retention_target integer 1440

Fast_start_io_target integer 0

Fast_start_mttr_target integer 0

Memory_max_target big integer 5G

Memory_target big integer 5G

Parallel_servers_target integer 16

Pga_aggregate_target big integer 0

Sga_target big integer 0

Target_pdbs integer 0

SQL >

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.