Rodrigo Silva e Silva – Página: 11

Adicionando novo DATAFILE

Publicado em 1 de novembro de 2018 by rodrigosilvaesilva

Verificando tamanho total datafile

select tablespace_name, sum(bytes)/1024/1024 as "TAMANHO(MB)"
from dba_data_files
group by tablespace_name
order by sum(bytes);

TABLESPACE_NAME                TAMANHO(MB)
------------------------------ -----------
USERS                                    5
INTRANET                               100
NFELOB                                 200
RHMETA_INDEX                           600
NFEINDICES                             900
SYSAUX                                1450
NFEDADOS                              1600
SYSTEM                                2010
ORCLINDICES                           2700
REORG_LOB                             7400
TOOLS                                 8300
UNDOTBS1                              8405
REORG_DADOS                          12800
RHMETA                          32767.9844
REORG_INDICES                        42600
ORCLDADOS                           141300

16 rows selected.

select tablespace_name, sum(bytes)/1024/1024 as "TAMANHO(MB)"

from dba_data_files

group by tablespace_name

order by sum(bytes);

TABLESPACE_NAME TAMANHO(MB)

------------------------------ -----------

USERS 5

INTRANET 100

NFELOB 200

RHMETA_INDEX 600

NFEINDICES 900

SYSAUX 1450

NFEDADOS 1600

SYSTEM 2010

ORCLINDICES 2700

REORG_LOB 7400

TOOLS 8300

UNDOTBS1 8405

REORG_DADOS 12800

RHMETA 32767.9844

REORG_INDICES 42600

ORCLDADOS 141300

16 rows selected.

Verificando espaço disponível DATAFILES

select tablespace_name, sum(bytes)/1024/1024 as "TAMANHO(MB)"
from dba_free_space
group by tablespace_name
order by sum(bytes);

TABLESPACE_NAME                TAMANHO(MB)
------------------------------ -----------
SYSTEM                               .1875
USERS                               3.0625
NFEINDICES                              56
RHMETA                             60.0625
SYSAUX                             76.4375
RHMETA_INDEX                       77.3125
NFEDADOS                           86.0625
NFELOB                              88.375
INTRANET                            94.875
ORCLINDICES                         220.75
REORG_LOB                            403.5
TOOLS                               419.25
REORG_DADOS                        669.125
REORG_INDICES                    2053.6875
ORCLDADOS                         3503.375
UNDOTBS1                           8043.25

16 rows selected.

select tablespace_name, sum(bytes)/1024/1024 as "TAMANHO(MB)"

from dba_free_space

group by tablespace_name

order by sum(bytes);

TABLESPACE_NAME TAMANHO(MB)

------------------------------ -----------

SYSTEM .1875

USERS 3.0625

NFEINDICES 56

RHMETA 60.0625

SYSAUX 76.4375

RHMETA_INDEX 77.3125

NFEDADOS 86.0625

NFELOB 88.375

INTRANET 94.875

ORCLINDICES 220.75

REORG_LOB 403.5

TOOLS 419.25

REORG_DADOS 669.125

REORG_INDICES 2053.6875

ORCLDADOS 3503.375

UNDOTBS1 8043.25

16 rows selected.

Adicionando DATAFILE

SYS@ORCL > ALTER TABLESPACE RHMETA ADD DATAFILE '/u01/oracle/oradata/ORCL/tbs_rhmeta_02.dbf' size 100m AUTOEXTEND ON;

Tablespace altered.

SYS@ORCL > ALTER TABLESPACE RHMETA ADD DATAFILE '/u01/oracle/oradata/ORCL/tbs_rhmeta_02.dbf' size 100m AUTOEXTEND ON;

Tablespace altered.

Verificando novamente espaço disponível DATAFILES

SYS@ORCL >
select tablespace_name, sum(bytes)/1024/1024 as "TAMANHO(MB)"
from dba_free_space
group by tablespace_name
order by sum(bytes);

TABLESPACE_NAME                TAMANHO(MB)
------------------------------ -----------
SYSTEM                               .1875
USERS                               3.0625
NFEINDICES                              56
SYSAUX                             76.4375
RHMETA_INDEX                       77.3125
NFEDADOS                           86.0625
NFELOB                              88.375
INTRANET                            94.875
ORCLINDICES                         220.75
REORG_LOB                            403.5
TOOLS                               419.25
REORG_DADOS                        669.125
RHMETA                           1695.0625
REORG_INDICES                    1989.6875
ORCLDADOS                         3503.375
UNDOTBS1                           8113.25

16 rows selected.

SYS@ORCL >

select tablespace_name, sum(bytes)/1024/1024 as "TAMANHO(MB)"

from dba_free_space

group by tablespace_name

order by sum(bytes);

TABLESPACE_NAME TAMANHO(MB)

------------------------------ -----------

SYSTEM .1875

USERS 3.0625

NFEINDICES 56

SYSAUX 76.4375

RHMETA_INDEX 77.3125

NFEDADOS 86.0625

NFELOB 88.375

INTRANET 94.875

ORCLINDICES 220.75

REORG_LOB 403.5

TOOLS 419.25

REORG_DADOS 669.125

RHMETA 1695.0625

REORG_INDICES 1989.6875

ORCLDADOS 3503.375

UNDOTBS1 8113.25

16 rows selected.

Alterar local ARCHIVELOG

Publicado em 1 de novembro de 2018 by rodrigosilvaesilva

Verificando local archivelog

SYS@ORCL > show parameter log_archive_dest_1

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1                   string

SYS@ORCL > show parameter log_archive_dest_1

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_1 string

Alterando local archivelog

SYS@ORCL > ALTER SYSTEM SET log_archive_dest_1='LOCATION=/u02/fra/ORCL/archivelog' scope=both;

System altered.

Elapsed: 00:00:00.04

SYS@ORCL > ALTER SYSTEM SET log_archive_dest_1='LOCATION=/u02/fra/ORCL/archivelog' scope=both;

System altered.

Elapsed: 00:00:00.04

Verificando local archivelog

SYS@ORCL > show parameter log_archive_dest_1

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1                   string      LOCATION=/u02/fra/ORCL/archivelog

SYS@ORCL > show parameter log_archive_dest_1

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_1 string LOCATION=/u02/fra/ORCL/archivelog

Alterando senha usuário root MySQL

Publicado em 29 de outubro de 2018 by rodrigosilvaesilva

mysql> alter user 'root'@'localhost' IDENTIFIED BY 'nova_senha_complexa';
Query OK, 0 rows affected (0.00 sec)

1 2	mysql> alter user 'root'@'localhost' IDENTIFIED BY 'nova_senha_complexa'; Query OK, 0 rows affected (0.00 sec)

Resetar senha root Oracle Linux 6.9

Publicado em 22 de outubro de 2018 by rodrigosilvaesilva

Resetar senha root Oracle Linux 6.9 Pressione Enter Selecione a opção de Kernel “Oracle Linux Server Unbreakable Enterprise Kernerl e pressione E para editar Selecione a Opção kernel /vmlinuz.. e pressione E para editar Ao final da linha quiet adicione 1, conforme imagem abaixo e Pressione Enter para salvar. Nessa tela, aperte b no Kernel…

Script hugepages

Publicado em 12 de outubro de 2018 by rodrigosilvaesilva

Download Segue o script hugepages

#!/bin/bash
#
# hugepages_settings.sh
#
# Linux bash script to compute values for the
# recommended HugePages/HugeTLB configuration
# on Oracle Linux
#
# Note: This script does calculation for all shared memory
# segments available when the script is run, no matter it
# is an Oracle RDBMS shared memory segment or not.
#
# This script is provided by Doc ID 401749.1 from My Oracle Support 
# http://support.oracle.com

# Welcome text
echo "
This script is provided by Doc ID 401749.1 from My Oracle Support 
(http://support.oracle.com) where it is intended to compute values for 
the recommended HugePages/HugeTLB configuration for the current shared 
memory segments on Oracle Linux. Before proceeding with the execution please note following:
 * For ASM instance, it needs to configure ASMM instead of AMM.
 * The 'pga_aggregate_target' is outside the SGA and 
   you should accommodate this while calculating SGA size.
 * In case you changes the DB SGA size, 
   as the new SGA will not fit in the previous HugePages configuration, 
   it had better disable the whole HugePages, 
   start the DB with new SGA size and run the script again.
And make sure that:
 * Oracle Database instance(s) are up and running
 * Oracle Database 11g Automatic Memory Management (AMM) is not setup 
   (See Doc ID 749851.1)
 * The shared memory segments can be listed by command:
     # ipcs -m


Press Enter to proceed..."

read

# Check for the kernel version
KERN=`uname -r | awk -F. '{ printf("%d.%d\n",$1,$2); }'`

# Find out the HugePage size
HPG_SZ=`grep Hugepagesize /proc/meminfo | awk '{print $2}'`
if [ -z "$HPG_SZ" ];then
    echo "The hugepages may not be supported in the system where the script is being executed."
    exit 1
fi

# Initialize the counter
NUM_PG=0

# Cumulative number of pages required to handle the running shared memory segments
for SEG_BYTES in `ipcs -m | cut -c44-300 | awk '{print $1}' | grep "[0-9][0-9]*"`
do
    MIN_PG=`echo "$SEG_BYTES/($HPG_SZ*1024)" | bc -q`
    if [ $MIN_PG -gt 0 ]; then
        NUM_PG=`echo "$NUM_PG+$MIN_PG+1" | bc -q`
    fi
done

RES_BYTES=`echo "$NUM_PG * $HPG_SZ * 1024" | bc -q`

# An SGA less than 100MB does not make sense
# Bail out if that is the case
if [ $RES_BYTES -lt 100000000 ]; then
    echo "***********"
    echo "** ERROR **"
    echo "***********"
    echo "Sorry! There are not enough total of shared memory segments allocated for 
HugePages configuration. HugePages can only be used for shared memory segments 
that you can list by command:

    # ipcs -m

of a size that can match an Oracle Database SGA. Please make sure that:
 * Oracle Database instance is up and running 
 * Oracle Database 11g Automatic Memory Management (AMM) is not configured"
    exit 1
fi

# Finish with results
case $KERN in
    '2.2') echo "Kernel version $KERN is not supported. Exiting." ;;
    '2.4') HUGETLB_POOL=`echo "$NUM_PG*$HPG_SZ/1024" | bc -q`;
           echo "Recommended setting: vm.hugetlb_pool = $HUGETLB_POOL" ;;
    '2.6') echo "Recommended setting: vm.nr_hugepages = $NUM_PG" ;;
    '3.8') echo "Recommended setting: vm.nr_hugepages = $NUM_PG" ;;
    '3.10') echo "Recommended setting: vm.nr_hugepages = $NUM_PG" ;;
    '4.1') echo "Recommended setting: vm.nr_hugepages = $NUM_PG" ;;
esac

# En

#!/bin/bash

# hugepages_settings.sh

# Linux bash script to compute values for the

# recommended HugePages/HugeTLB configuration

# on Oracle Linux

# Note: This script does calculation for all shared memory

# segments available when the script is run, no matter it

# is an Oracle RDBMS shared memory segment or not.

# This script is provided by Doc ID 401749.1 from My Oracle Support

# http://support.oracle.com

# Welcome text

echo "

This script is provided by Doc ID 401749.1 from My Oracle Support

(http://support.oracle.com) where it is intended to compute values for

the recommended HugePages/HugeTLB configuration for the current shared

memory segments on Oracle Linux. Before proceeding with the execution please note following:

* For ASM instance, it needs to configure ASMM instead of AMM.

* The 'pga_aggregate_target' is outside the SGA and

you should accommodate this while calculating SGA size.

* In case you changes the DB SGA size,

as the new SGA will not fit in the previous HugePages configuration,

it had better disable the whole HugePages,

start the DB with new SGA size and run the script again.

And make sure that:

* Oracle Database instance(s) are up and running

* Oracle Database 11g Automatic Memory Management (AMM) is not setup

(See Doc ID 749851.1)

* The shared memory segments can be listed by command:

# ipcs -m

Press Enter to proceed..."

read

# Check for the kernel version

KERN=`uname -r | awk -F. '{ printf("%d.%d\n",$1,$2); }'`

# Find out the HugePage size

HPG_SZ=`grep Hugepagesize /proc/meminfo | awk '{print $2}'`

if [ -z "$HPG_SZ" ];then

echo "The hugepages may not be supported in the system where the script is being executed."

exit 1

# Initialize the counter

NUM_PG=0

# Cumulative number of pages required to handle the running shared memory segments

for SEG_BYTES in `ipcs -m | cut -c44-300 | awk '{print $1}' | grep "[0-9][0-9]*"`

MIN_PG=`echo "$SEG_BYTES/($HPG_SZ*1024)" | bc -q`

if [ $MIN_PG -gt 0 ]; then

NUM_PG=`echo "$NUM_PG+$MIN_PG+1" | bc -q`

done

RES_BYTES=`echo "$NUM_PG * $HPG_SZ * 1024" | bc -q`

# An SGA less than 100MB does not make sense

# Bail out if that is the case

if [ $RES_BYTES -lt 100000000 ]; then

echo "***********"

echo "** ERROR **"

echo "***********"

echo "Sorry! There are not enough total of shared memory segments allocated for

HugePages configuration. HugePages can only be used for shared memory segments

that you can list by command:

# ipcs -m

of a size that can match an Oracle Database SGA. Please make sure that:

* Oracle Database instance is up and running

* Oracle Database 11g Automatic Memory Management (AMM) is not configured"

exit 1

# Finish with results

case $KERN in

'2.2') echo "Kernel version $KERN is not supported. Exiting." ;;

'2.4') HUGETLB_POOL=`echo "$NUM_PG*$HPG_SZ/1024" | bc -q`;

echo "Recommended setting: vm.hugetlb_pool = $HUGETLB_POOL" ;;

'2.6') echo "Recommended setting: vm.nr_hugepages = $NUM_PG" ;;

'3.8') echo "Recommended setting: vm.nr_hugepages = $NUM_PG" ;;

'3.10') echo "Recommended setting: vm.nr_hugepages = $NUM_PG" ;;

'4.1') echo "Recommended setting: vm.nr_hugepages = $NUM_PG" ;;

esac

# En

Fonte Oracle Support

← Posts recentes Posts antigos →