terça-feira, 13 de fevereiro de 2018

RMAN - Simulando backup para fita

Se você não possui drive de fita mas quer simular um backup para fita ou mesmo realizar testes quando dizem que o problema está no RMAN e não no produto de terceiros como NetBackup, NetWorker, Data Protector e TSM, por exemplo, utilize a API oracle.disksbt que a Oracle fornece para simular o uso da MML (Media Management Library) fazendo com o que um diretório do servidor seja tratado igual a uma unidade de fita.

A API pode ser especificada na alocação do canal ou configurada nas parametrizações do RMAN onde será atribuída automaticamente ao canal quando um backup SBT_TAPE for executado inibindo a necessidade de alocar o canal com os parâmetros manualmente.

SBT_LIBRARY  : recebe a API que simula o uso da MML;
BACKUP_DIR   : recebe o diretório que serão gerados os arquivos de backup.

Na Alocação do canal:


[oracle@db3 ~]$ mkdir -p /orabackup/sbt
[oracle@db3 ~]$ rman target /

Recovery Manager: Release 12.2.0.1.0 - Production on Tue Feb 13 18:32:40 2018

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

connected to target database: CDB1 (DBID=913632474)

RMAN> RUN {
2> ALLOCATE CHANNEL CH01 DEVICE TYPE 'SBT_TAPE' PARMS="SBT_LIBRARY=oracle.disksbt, ENV=(BACKUP_DIR=/orabackup/sbt)";
3> BACKUP CURRENT CONTROLFILE;
4> }

using target database control file instead of recovery catalog
allocated channel: CH01
channel CH01: SID=56 device type=SBT_TAPE
channel CH01: WARNING: Oracle Test Disk API

Starting backup at 13-FEB-18
channel CH01: starting full datafile backup set
channel CH01: specifying datafile(s) in backup set
including current control file in backup set
channel CH01: starting piece 1 at 13-FEB-18
channel CH01: finished piece 1 at 13-FEB-18
piece handle=2jsr52rc_1_1 tag=TAG20180213T173331 comment=API Version 2.0,MMS Version 8.1.3.0
channel CH01: backup set complete, elapsed time: 00:00:01
Finished backup at 13-FEB-18

Starting Control File and SPFILE Autobackup at 13-FEB-18
piece handle=c-913632474-20180213-00 comment=API Version 2.0,MMS Version 8.1.3.0
Finished Control File and SPFILE Autobackup at 13-FEB-18
released channel: CH01

RMAN> exit


Recovery Manager complete.
[oracle@db3 ~]$ ls -lrt /orabackup/sbt/
total 49164
-rw-r--r--. 1 oracle oinstall 25165840 Feb 13 18:33 2jsr52rc_1_1
-rw-r--r--. 1 oracle oinstall 25165840 Feb 13 18:33 c-913632474-20180213-00
-rw-r--r--. 1 oracle oinstall     3360 Feb 13 18:33 Oracle_Disk_SBT_Catalog

 Nas parametrizações do RMAN:

[oracle@db3 ~]$ rman target /

Recovery Manager: Release 12.2.0.1.0 - Production on Tue Feb 13 18:43:04 2018

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

connected to target database: CDB1 (DBID=913632474)

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name CDB1 are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/orabin/app/oracle/product/12.2.0.1/dbhome_1/dbs/snapcf_cdb1.f'; # default

RMAN> CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS="SBT_LIBRARY=oracle.disksbt, ENV=(BACKUP_DIR=/orabackup/sbt)";

new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  "SBT_LIBRARY=oracle.disksbt, ENV=(BACKUP_DIR=/orabackup/sbt)";
new RMAN configuration parameters are successfully stored

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';

new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
new RMAN configuration parameters are successfully stored

RMAN> backup current controlfile format 'exemplo2.bkp';

Starting backup at 13-FEB-18
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=59 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: WARNING: Oracle Test Disk API
channel ORA_SBT_TAPE_1: starting full datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_SBT_TAPE_1: starting piece 1 at 13-FEB-18
channel ORA_SBT_TAPE_1: finished piece 1 at 13-FEB-18
piece handle=exemplo2.bkp tag=TAG20180213T174719 comment=API Version 2.0,MMS Version 8.1.3.0
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:01
Finished backup at 13-FEB-18

Starting Control File and SPFILE Autobackup at 13-FEB-18
piece handle=c-913632474-20180213-01 comment=API Version 2.0,MMS Version 8.1.3.0
Finished Control File and SPFILE Autobackup at 13-FEB-18

RMAN> exit


Recovery Manager complete.
[oracle@db3 ~]$ ls -lrt /orabackup/sbt/
total 98328
-rw-r--r--. 1 oracle oinstall 25165840 Feb 13 18:33 2jsr52rc_1_1
-rw-r--r--. 1 oracle oinstall 25165840 Feb 13 18:33 c-913632474-20180213-00
-rw-r--r--. 1 oracle oinstall 25165840 Feb 13 18:47 exemplo2.bkp
-rw-r--r--. 1 oracle oinstall 25165840 Feb 13 18:47 c-913632474-20180213-01
-rw-r--r--. 1 oracle oinstall     5600 Feb 13 18:47 Oracle_Disk_SBT_Catalog

 A nível de curiosidade, a API existe desde a versão 9i do Oracle database ¹.

Referências:

https://docs.oracle.com/cd/A84870_01/doc/server.816/a76990.pdf
https://docs.oracle.com/cd/B10500_01/server.920/a96566/wnrcmug.htm¹
https://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmconfg.htm#BRADV006
Mais informações →

terça-feira, 6 de fevereiro de 2018

ORA-19909: datafile 1 belongs to an orphan incarnation

Durante a realização de um duplicate from active database, fui notificado que o processo havia falhado durante o recover da base de dados apresentando o erro ORA-19909 conforme detalhamento (case de exemplo) a seguir.


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 01/10/2017 16:42:19
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
 start until change 226605 using backup controlfile
ORA-00283: recovery session canceled due to errors
ORA-19909: datafile 1 belongs to an orphan incarnation
ORA-01110: data file 1: '/u01/app/oracle/oradata/dbtst/system.dbf'

Como a liberação da base era importante para a continuidade dos negócios, verifiquei o incarnation do ambiente produtivo e realizei o reset do incarnation do ambiente auxiliary para a mesma incarnação do produção, conclui o recover e demais etapas necessárias.

DBPROD:

RMAN> list incarnation;


List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       DBPRD    3274873056       CURRENT 1          30-OCT-17

DBTST:
RMAN> list incarnation;

using target database control file instead of recovery catalog

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       DBPRD    3274873056       PARENT  1          30-OCT-17
2       2       DBPRD    3274873056       ORPHAN  221767     05-NOV-17
4       4       DBPRD    3274873056       ORPHAN  222025     05-NOV-17
3       3       DBPRD    3274873056       CURRENT 222452     05-NOV-17

RMAN> reset database to incarnation 1;

database reset to incarnation 1

RMAN> list incarnation of database;


List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       DBPRD    3274873056       CURRENT 1          30-OCT-17
2       2       DBPRD    3274873056       ORPHAN  221767     05-NOV-17
4       4       DBPRD    3274873056       ORPHAN  222025     05-NOV-17
3       3       DBPRD    3274873056       ORPHAN  222452     05-NOV-17



<.. recover e demais processos ..>

Na semana seguinte fui notificado da mesma ocorrência, fiz o mesmo procedimento para liberação do ambiente mas também fui analisar o motivo que gerava o erro para resolvê-lo de modo que não fosse necessário uma nova ação manual durante o próximo processo de duplicate.

Examinando o log de alertas do banco (alertlog), podemos constatar a ocorrência de vários "Setting recovery target incarnation to N" as 16:42:14 que represetam as mudanças de incarnation durante o processo de recover. 


[oracle@tst1 /]$ vi $ORACLE_BASE/diag/rdbms/dbtst/dbtst/trace/alert_dbtst.log
..
..
Tue Jan 10 16:41:29 2017
alter database mount
Set as converted control file due to db_unique_name mismatch
Changing di2dbun from DBPRD to DBTST
Successful mount of redo thread 1, with mount id 3249055801
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount
RMAN DUPLICATE: Errors in krbm_getDupCopy
Errors in file /u01/app/oracle/diag/rdbms/dbtst/dbtst/trace/dbtst_ora_14094.trc:
ORA-19625: error identifying file /u01/app/oracle/oradata/dbtst/system.dbf
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
RMAN DUPLICATE: Errors in krbm_getDupCopy
Errors in file /u01/app/oracle/diag/rdbms/dbtst/dbtst/trace/dbtst_ora_14094.trc:
ORA-19625: error identifying file /u01/app/oracle/oradata/dbtst/sysaux.dbf
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
RMAN DUPLICATE: Errors in krbm_getDupCopy
Errors in file /u01/app/oracle/diag/rdbms/dbtst/dbtst/trace/dbtst_ora_14094.trc:
ORA-19625: error identifying file /u01/app/oracle/oradata/dbtst/undotbs1.dbf
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Tue Jan 10 16:42:14 2017
Setting recovery target incarnation to 2 <========
Setting recovery target incarnation to 2 <========
Setting recovery target incarnation to 3 <========
Setting recovery target incarnation to 3 <========
Tue Jan 10 16:42:14 2017
Switch of datafile 1 complete to datafile copy
  checkpoint is 226585
Switch of datafile 2 complete to datafile copy
  checkpoint is 226597
Switch of datafile 3 complete to datafile copy
  checkpoint is 226594
alter database recover datafile list clear
Completed: alter database recover datafile list clear
alter database recover datafile list
 1 , 2 , 3
Completed: alter database recover datafile list
 1 , 2 , 3
alter database recover if needed
 start until change 226605 using backup controlfile
Media Recovery Start
Serial Media Recovery started
Warning: Recovery target destination is in a sibling branch
of the controlfile checkpoint. Recovery will only recover
changes to datafiles.
Datafile 1 (ckpscn 226585) is orphaned on incarnation#=1
Media Recovery failed with error 19909
ORA-283 signalled during: alter database recover if needed
 start until change 226605 using backup controlfile

Um pouco antes destas mensagens de mudança de incarnation podemos ver a ocorrência de outros erros juntamente com o nome de um arquivo de rastreamento (.trc). Abrindo o arquivo e pesquisando por incarnation podemos ver que eles ocorreram logo após a leitura de alguns archives pois neles foram identificados mudanças no incarnation deste database em decorrência de outras cargas com open resetlogs (sempre que ocorrer um RESETLOGS uma nova incarnation será gerada).

[oracle@tst1 /]$ vi /u01/app/oracle/diag/rdbms/dbtst/dbtst/trace/dbtst_ora_14094.trc
..
..
*** 2017-01-10 16:42:14.546
*** ACTION NAME:(0000023 STARTED124) 2017-01-10 16:42:14.546

New incarnation branch detected in ArchiveLog, filename /oraarchive/DBTST/archivelog/2017_11_05/dbtst_1_1_959263858.arc
Inspection of file changed rdi from 1 to 2
New incarnation branch detected in ArchiveLog, filename /oraarchive/DBTST/archivelog/2017_11_05/dbtst_1_1_959265418.arc
Inspection of file changed rdi from 2 to 3
New incarnation branch detected in ArchiveLog, filename /oraarchive/DBTST/archivelog/2017_11_05/dbtst_1_1_959264815.arc

Para solucionar o "problema" basta mover/remover os archives indicados (possivelmente já desnecessários) ou apontar a FRA (Fast Recovery Area) para outro destino onde não exitam archives com o mesmo dbid, caso não esteja sendo utilizado a recovery area basta mudar o apontamento do log_archive_dest_1, por exemplo.

Mas por que o processo de recover lê estes archives com outras incarnações?

A partir da versão 11.2.0.3 o comando foi alterado para catalogar todos os arquivos(archives) abaixo do local onde foi configurado a recovery area ou log_archive_dest_N do banco auxiliary, desta forma o "catalog clone start with +DISKGROUP" lê e cataloga todos os arquivos abaixo do diretório que contenham o mesmo DBID da base que está sendo clonada.

Este cenário ocorre normalmente nos casos em que:

FRA está configurada:

*.db_recovery_file_dest='+RECO1'


log_archive_dest_N utilizando LOCATION=+DISKGROUP:

*.log_archive_dest_1='LOCATION=+RECO1'


Para evitar o erro reaponte para outro destino conforme supracitado:

*.db_recovery_file_dest='+RECOC4'
*.log_archive_dest_1='LOCATION=+RECOC4/newdb'

contents of Memory Script:
{
  backup as copy reuse
  archivelog like  "+RECOC4/luz/archivelog/2014_07_18/thread_1_seq_1742.2339.853243229" auxiliary format "+RECOC4/newdb/1_1742_847627148.dbf"   ;
  catalog clone archivelog  "+RECOC4/newdb/1_1742_847627148.dbf";   <======== é catalogado apenas o archive copiado
  switch clone datafile all;


NOTA:
No cenário de exemplo acima copiei os archives com novas incarnações para dentro do diretório da base DBTST para simular o problema.

[oracle@tst1 /]$ cp /oraarchive/DBPRD/archivelog/2017_11_05/* /oraarchive/DBTST/archivelog/2017_11_05/

e durante o recover:

contents of Memory Script:
{
   backup as copy reuse
   archivelog like  "/oraarchive/DBPRD/archivelog/2017_01_10/o1_mf_1_14_d7bbr54c_.arc" auxiliary format
 "/oraarchive/DBTST/archivelog/2017_01_10/o1_mf_1_14_%u_.arc"   ;
   catalog clone recovery area; <======== catalogando todos os arquivos abaixo da FRA
   switch clone datafile all;
}

Referências:

RMAN-11003 ORA-283 ORA-19909 during duplicate database (Doc ID 1913573.1)
Manual Completion of a Failed RMAN Backup based Duplicate (Doc ID 360962.1)
Mais informações →

quarta-feira, 31 de janeiro de 2018

Pass! Certificação 1Z0-338

Após algum tempo de estudo fiz a prova 1Z0-338 Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials e consegui passar com o score de 86% dos 63% requeridos. =)


Aos que tiverem interesse:

Link da certificação na Oracle University: https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-338


Tópicos do exame:

Oracle Database Software
  • Configure and administer a basic database using Oracle features and functions
  • Tune the Oracle database for performance in common use case scenarios
Oracle Exadata Architecture
  • Describe offloading processing
  • Describe the architecture used by Oracle Exadata software
  • Use Smart Flash Cache
  • Enable Flash Cache Write Back
  • Enable Advanced Compression and Hybrid Columnar Compression on Exadata tables
  • Describe storage indexes
  • Describe Oracle recommended configurations for High Availability configurations
  • Enable parallelism for Data Warehouse workloads
  • Describe database and Automatic Storage Management-Scoped Security Cconcepts
  • Describe the Power Distribution Unit
  • Describe memory capabilities of different models
  • Describe the importance and use of In-Memory Fault Tolerance in the Exadata Database Machine
  • Explain the differences between the types of storage servers available on the Exadata Database Machine
Administration and Configuration 
  • Compress data using Advanced Compression and Hybrid Columnar Compression
  • Use network configuration options
  • Create and configure Automatic Storage Management disk groups using Exadata
  • Explain the impact of various diskgroup failure group choices
  • Install software onto the Exadata Database Machine
  • Describe various tasks that can be done with the Integrated Lights Out Management (ILOM) console
  • Reconfigure a 1/8th rack into a 1/4 rack
  • Describe network components in Exadata
  • Create a database snapshot on Exadata for testing purposes

Backup and Recovery
  • Create a backup plan for Exadata
  • Implement recovery procedures on different failure scenarios
  • Describe troubleshooting tasks for backup and recovery processes
  • Describe how the Exadata Storage Servers are backed up internally

High Availability
  • Describe Oracle's recommended guidelines for high availability configurations on Exadata
  • Identify failure scenarios and implement recovery procedures
  • Install high availability software onto the Exadata Database Machine
Monitoring
  • Install an Enterprise Manager Exadata Monitoring plug-in
  • Set up an agent, plugin, and Exadata target for Enterprise Manager Cloud Control
  • Monitor the storage cell using Cell Command Line Interface and Distributed Command Line Interface
  • Describe the purpose and uses for Simple Network Management Protocol (SNMP), Intelligent Platform Management Interface (IPMI) and Integrated Lights Out Management for a DB machine
  • Use osWatcher and iostat to monitor the Database Machine operating system
  • Use exacli and dbcli to monitor storage cells
Software Maintenance
  • Describe software components
  • Locate patches for Exadata
  • Apply Oracle recommendations to the patching process for Exadata
  • Describe the Oracle Configuration Manager
  • Explain how to perform planned maintenance of the Exadata machine
  • Describe how to use the Oracle Exadata Deployment Assistant to create virtual machines on Exadata
Bulk Loading and Migration
  • Use Database File System (DBFS) to perform bulk loading operations
  • Use the ASM Cluster File System (ACFS) to perform bulk data loading operations
  • Configure a Database for staging input data files
  • Use external tables for data loads
  • Describe migration strategies for Exadata
  • Explain Oracle recommendations on how to choose a migration strategy
Resource Management
  • Set up instance caging
  • Manage I/O on Exadata
Support
  • Set up an Automatic Service Request (ASR) on the Database Machine
  • Explain the ASR configuration process
  • Describe implementation requirements for Platinum Support
Exadata in the Cloud
  • Describe the Oracle Exadata Cloud Service provisioning process
  • Configure backup and recovery on the Exadata Cloud Service
  • Administer the Oracle Database on the Exadata Cloud Service
  • Administer the Oracle Database on the Exadata Cloud Machine
Mais informações →

quarta-feira, 17 de janeiro de 2018

Capturar variáveis de SO com dbms_system.get_env

Através do pacote DBMS_SYSTEM do Oracle RDBMS podemos fazer várias coisas, como:



SQL> var VAR varchar2(255)
SQL> exec dbms_system.get_env('ORACLE_HOME',:VAR);

PL/SQL procedure successfully completed.

SQL> print :VAR

VAR
--------------------------------------------------------------------------------
/orabin/app/oracle/product/12.2.0.1/dbhome_1

Exportando uma variável de teste:

Banco=cdb1-> export TESTE="variavel de teste"
Banco=cdb1-> sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Mon Apr 3 03:47:54 2017

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


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

SQL> var VAR varchar2(255)
SQL> exec dbms_system.get_env('TESTE',:VAR);

PL/SQL procedure successfully completed.

SQL> print :VAR

VAR
--------------------------------------------------------------------------------
variavel de teste

Exemplo criando uma function para retorno da variável:

SQL> create or replace function getvar (envvar varchar2) return varchar2 as
output varchar2(4000);
begin
dbms_system.get_env(envvar, output);
return output;
end;
/

Function created.

SQL> select getvar('ORACLE_HOME') from dual;

GETVAR('ORACLE_HOME')
--------------------------------------------------------------------------------
/orabin/app/oracle/product/12.2.0.1/dbhome_1

Exemplo criando uma procedure para retorno da variável:

SQL> create or replace procedure getvar2 (envvar varchar2) as
output varchar2(4000);
begin
dbms_system.get_env(envvar, output);
dbms_output.put_line(output);
end;
/

Procedure created.

SQL> set serveroutpu on
SQL> exec getvar2('TESTE');
variavel de teste

PL/SQL procedure successfully completed.

SQL> exec getvar2('ORACLE_HOME');
/orabin/app/oracle/product/12.2.0.1/dbhome_1

PL/SQL procedure successfully completed.
Mais informações →

segunda-feira, 15 de janeiro de 2018

Movendo AWR Snapshots para outro database


As tabelas do AWR (Automatic Workload Repository) contém uma grande quantidade de dados de desempenho extremamente úteis para análises de performance e detecção de problemas. Os dados do AWR são armazenados em tabelas WRH$ e DBA_HIST alimentadas através de snapshots regulares e armazenados por um período de tempo definido na SYSAUX tablespace.

Algumas vezes é necessário que estes dados sejam salvos para utilizações futuras ou mesmo importados em outras bases de dados para comparações, maior tempo de armazenamento em relação ao definido na base origem, etc. A Oracle fornece dois scripts para realizar o export e import dos dados do AWR, são eles: awrextr.sql e awrload.sql, ambos localizados em $ORACLE_HOME/rdbms/admin


O export dos dados é realizado através do script awrextr.sql que gera um arquivo data pump contendo o intervalo de snapshots desejado e que posteriormente pode ser importado em outra base de dados.


1 – Criando o diretório que será gerado o arquivo de dump:

SQL> create directory awr_directory as '/orabackup';
 
Directory created.

2 - Executando o script de export:

SQL> @?/rdbms/admin/awrextr.sql
~~~~~~~~~~~~~
AWR EXTRACT
~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~  This script will extract the AWR data for a range of snapshots  ~
~  into a dump file.  The script will prompt users for the         ~
~  following information:                                          ~
~     (1) database id                                              ~
~     (2) snapshot range to extract                                ~
~     (3) name of directory object                                 ~
~     (4) name of dump file                                        ~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


Databases in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

   DB Id     DB Name      Host
------------ ------------ ------------
* 3274873056 DBPRD        tst1

The default database id is the local one: '3274873056'.  To use this
database id, press  to continue, otherwise enter an alternative.

Quando executado o script precisa de 4 interações para gerar o export dos snapshots.

2.A - Informar o DBID da base de dados desejada. O script irá listar todos os dbids disponíveis, se o dbid desejado for o default(*) basta pressionar ENTER ou então primeiramente informar o dbid necessário.

Enter value for dbid: 3274873056

Using 3274873056 for Database ID

2.B - O segundo passo é especificar a quantidade de dias para que a listagem dos snapshots (snap_ids) seja retornada e o período (begin_snap/end_snap) da extração de dados definida.

Specify the number of days of snapshots to choose from
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Entering the number of days (n) will result in the most recent
(n) days of snapshots being listed.  Pressing  without
specifying a number lists all completed snapshots.


Enter value for num_days: 1

Listing the last day's Completed Snapshots

DB Name        Snap Id    Snap Started
------------ --------- ------------------
DBPRD                1 05 Nov 2017 09:50
                     2 05 Nov 2017 11:00
                     3 05 Nov 2017 12:00
                     4 05 Nov 2017 13:00
                     5 05 Nov 2017 14:00
                     6 05 Nov 2017 15:00
                     7 05 Nov 2017 16:00


Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 2
Begin Snapshot Id specified: 2

Enter value for end_snap: 6
End   Snapshot Id specified: 6

2.C - Especificar o diretório que será utilizado para gerar o arquivo de dump (expdp).

Specify the Directory Name
~~~~~~~~~~~~~~~~~~~~~~~~~~

Directory Name                 Directory Path
------------------------------ -------------------------------------------------
AWR_DIRECTORY                  /orabackup
DATA_PUMP_DIR                  /u01/app/oracle/product/11.2.0.4/dbhome1/rdbms/lo
                               g/

ORACLE_OCM_CONFIG_DIR          /u01/app/oracle/product/11.2.0.4/dbhome1/ccr/host
                               s/tst1/state

ORACLE_OCM_CONFIG_DIR2         /u01/app/oracle/product/11.2.0.4/dbhome1/ccr/stat
                               e


Choose a Directory Name from the above list (case-sensitive).

Enter value for directory_name: AWR_DIRECTORY

Using the dump directory: AWR_DIRECTORY

2.D - Por fim, informar o nome do arquivo data pump que será gerado. O nome não deve conter a extensão .dmp, ele será acrescentado automaticamente pelo script.

Specify the Name of the Extract Dump File
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The prefix for the default dump file name is awrdat_2_6.
To use this name, press  to continue, otherwise enter
an alternative.

Enter value for file_name: awrdata_dbprd_2_6

Using the dump file prefix: awrdata_dbprd_2_6
|
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|  The AWR extract dump file will be located
|  in the following directory/file:
|   /orabackup
|   awrdata_dbprd_2_6.dmp
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
|  *** AWR Extract Started ...
|
|  This operation will take a few moments. The
|  progress of the AWR extract operation can be
|  monitored in the following directory/file:
|   /orabackup
|   awrdata_dbprd_2_6.log
|

End of AWR Extract

Dependendo da quantidade de dados AWR que precisa ser extraído a operação de extração pode demorar um pouco para ser concluída. Uma vez concluída você pode levar o arquivo para o local ou servidor desejado.

O import de dados é realizado através do script awrload.sql utilizando o dump gerado anteriormente pelo script awrextr.sql, conforme demonstrado abaixo:

1 - Criando o diretório em outra base de dados com o caminho onde se encontra o arquivo de dump:

SQL> create directory awr_directory as '/orabackup';

Directory created.

2 - Executando o script de import:

SQL> @?/rdbms/admin/awrload.sql
~~~~~~~~~~
AWR LOAD
~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~  This script will load the AWR data from a dump file. The   ~
~  script will prompt users for the following information:    ~
~     (1) name of directory object                            ~
~     (2) name of dump file                                   ~
~     (3) staging schema name to load AWR data into           ~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Da mesma forma que no script de export, o script de import também requer algumas interações.

2.A - Informar o nome do diretório que contem o arquivo.

Specify the Directory Name
~~~~~~~~~~~~~~~~~~~~~~~~~~

Directory Name                 Directory Path
------------------------------ -------------------------------------------------
AWR_DIRECTORY                  /orabackup
DATA_PUMP_DIR                  /u01/app/oracle/product/11.2.0.4/dbhome1/rdbms/lo
                               g/

ORACLE_OCM_CONFIG_DIR          /u01/app/oracle/product/11.2.0.4/dbhome1/ccr/host
                               s/tst1/state

ORACLE_OCM_CONFIG_DIR2         /u01/app/oracle/product/11.2.0.4/dbhome1/ccr/stat
                               e


Choose a Directory Name from the list above (case-sensitive).

Enter value for directory_name: AWR_DIRECTORY

Using the dump directory: AWR_DIRECTORY

2.B - Informar o nome do arquivo contendo os dados AWR extraídos anteriormente. Não é preciso incluir junto ao nome do arquivo sua extensão (.dmp), ela será adicionada automaticamente pelo script.

Specify the Name of the Dump File to Load
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Please specify the prefix of the dump file (.dmp) to load:

Enter value for file_name: awrdata_dbprd_2_6

Loading from the file name: awrdata_dbprd_2_6.dmp

2.C - Nesta etapa deve ser informado o nome de um schema temporário para que os dados sejam importados e posteriormente transferidos para as tabelas do AWR. Após a transferencia dos dados para as tabelas do AWR o schema é automaticamente removido.

Informações como a tablespace permanente e temporária do schema também serão solicitadas nesta etapa e ao fim os dados serão finalmente importados.

Staging Schema to Load AWR Snapshot Data
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The next step is to create the staging schema
where the AWR snapshot data will be loaded.
After loading the data into the staging schema,
the data will be transferred into the AWR tables
in the SYS schema.


The default staging schema name is AWR_STAGE.
To use this name, press  to continue, otherwise enter
an alternative.

Enter value for schema_name: AWR_STAGE

Using the staging schema name: AWR_STAGE

Choose the Default tablespace for the AWR_STAGE user
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Choose the AWR_STAGE users's default tablespace.  This is the
tablespace in which the AWR data will be staged.

TABLESPACE_NAME                CONTENTS  DEFAULT TABLESPACE
------------------------------ --------- ------------------
SYSAUX                         PERMANENT *

Pressing  will result in the recommended default
tablespace (identified by *) being used.

Enter value for default_tablespace: SYSAUX

Using tablespace SYSAUX as the default tablespace for the AWR_STAGE


Choose the Temporary tablespace for the AWR_STAGE user
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Choose the AWR_STAGE user's temporary tablespace.

TABLESPACE_NAME                CONTENTS  DEFAULT TEMP TABLESPACE
------------------------------ --------- -----------------------
TEMP                           TEMPORARY *

Pressing  will result in the database's default temporary
tablespace (identified by *) being used.

Enter value for temporary_tablespace: TEMP

Using tablespace TEMP as the temporary tablespace for AWR_STAGE


... Creating AWR_STAGE user

|
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|  Loading the AWR data from the following
|  directory/file:
|   /orabackup
|   awrdata_dbprd_2_6.dmp
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
|  *** AWR Load Started ...
|
|  This operation will take a few moments. The
|  progress of the AWR load operation can be
|  monitored in the following directory/file:
|   /orabackup
|   awrdata_dbprd_2_6.log
|
... Dropping AWR_STAGE user

End of AWR Load

Dependendo da quantidade de dados AWR que serão importadas a operação pode demorar um pouco para ser concluída.

3 - Verificando se os snapshots do DBID desejado foram importados:

SQL> select distinct dbid from DBA_HIST_SNAPSHOT;

      DBID
----------
3274873056
3149615557

Referências:

How to Export and Import the AWR Repository From One Database to Another (Doc ID 785730.1)
Mais informações →

segunda-feira, 8 de janeiro de 2018

ACFS sobre Oracle Restart (autostart)

Para quem não conhece, o Oracle ACFS (Automatic Storage Management Cluster File System) é uma tecnologia de gerenciamento de armazenamento de dados que estende a funcionalidade do ASM (Automatic Storage Management) para suportar arquivos de clientes mantidos fora do Oracle database, pode ser acessado e gerenciado usando ferramentas nativas do sistema operacional e interfaces de programação de aplicativos (APIs) e permite o compartilhamento de dados através de NAS (Network Attached Storage), NFS (Network File System) e CIFS (Common Internet File System).

O funcionamento do ACFS passa pela camada do ADVM (ASM Dinamyc Volume Manager) que é responsável por entregar e gerenciar os volumes criados.


Tentando criar um destes volumes acabei recebendo o erro ORA-15477:


ASMCMD> volcreate -G DGDATA -s 500G acfstst
ORA-15032: not all alterations performed
ORA-15477: cannot communicate with the volume driver (DBD ERROR: OCIStmtExecute)

Fazendo algumas buscas no MOS (My Oracle Support) encontrei as Docs ID 1609452.1 e 886407.1 informando que o erro ocorre em função dos drivers de ACFS não terem sido carregados após o reboot do servidor.

Detalhe, sobre o Grid Infrastruture eles são carregados com sucesso porem sobre o Oracle Restart (standalone setup) não, comportamento este esperado pela Oracle.

Abaixo vemos que ele é suportado, esta instalado porem não foi carregado após o restart do servidor.


[root@dbtst ~]# $GRID_HOME/bin/acfsdriverstate supported
ACFS-9200: Supported
[root@dbtst ~]# $GRID_HOME/bin/acfsdriverstate installed
ACFS-9203: true
[root@dbtst ~]# $GRID_HOME/bin/acfsdriverstate loaded
ACFS-9204: false

Subindo o driver manualmente:

[root@dbtst ~]# $GRID_HOME/bin/acfsload start -s
[root@dbtst ~]#
[root@dbtst ~]# $GRID_HOME/bin/acfsdriverstate loaded
ACFS-9203: true

Agora basta tentar criar o volume novamente que já vai ser possível.

Workaround para que o driver suba automaticamente no Oracle Restart após o reboot do servidor e monte os ACFS:

Adicionar ao final do arquivo /etc/rc.d/rc.local

# Add the command to start ACFS file system automatically after server reboot
#
/orabin/app/11.2.0.4/grid/bin/acfsload start -s
sleep 150
/sbin/mount.acfs -o all


Referências:

https://docs.oracle.com/cd/E11882_01/server.112/e18951/asmfilesystem.htm#OSTMG31000
ACFS-9371: Starting ACFS Registry Resource Failed Upon Server Reboot in a Standalone Setup. (Doc ID 1609452.1)
ACFS/ADVM is NOT started automatically after node reboot or after CRS is restarted in non-RAC environment (Doc ID 886407.1)
Mais informações →

quinta-feira, 14 de dezembro de 2017

Instalando o Oracle Management Agent (OMA) em Silent Mode - agentDeploy

Além da instalação do Management Agent via GUI (Graphical User Interface) utilizando o "Add Host Targets Wizard" é possivel também instalá-lo em silent mode.

A instalação em silent mode é útil quando é preciso instalar o agent a partir do próprio servidor destino, ou seja, sem utilizar o assistente(Add Host Targets Wizard).

Aqui utilizei a instalação em silent mode pois o acesso ao servidor destino não poderia ser realizado diretamente como root (sshd_config > PermitRootLogin no) e o usuário para acesso não possuía sudo configurado, informações estas que precisam ser definidas e funcionais utilizando o Wizard.

Em silent mode três métodos podem ser utilizados:

AgentPull Script:

Quando não se tem acesso ao EM CLI no servidor do OMS (Oracle Management Server) para geração da imagem do agent e tranferência para o servidor destino. O Management Agent Software/script será adquirido através do acesso a uma URL ao OMS_HOST (exemplo, https://<OMS_HOST>:<OMS_PORT>/em/install/getAgentImage). Este método proporciona uma instalação básica pois permite poucos parâmetros adicionais.

agentDeploy Script:

Deve-se usar o EM CLI para gerar a imagem do agent software. O EM CLI pode ser utilizado tanto no servidor do OMS (onde é preciso posteriormente transferir o arquivo para o servidor destino) ou diretamente no servidor destino (onde uma instalação prévia do EM CLI deve ser realizada). Este método permite uma instalação totalmente customizavel pois muitos parâmetros podem ser adicionados na instalação.

RPM File:

Disponível apenas para Linux x86 e x86-64, onde é gerado um arquivo .rpm utilizando o EM CLI no servidor do OMS, após tranferido para o servidor destino pode ser instalado da mesma forma que os demais pacotes do sistema operacional (rpm -ivh).

Neste exemplo estarei utilizando o método agentDeploy e optei em gerar a imagem do agent software no EM CLI do servidor OMS.

Logando no EM CLI (OMS_HOST):


srv=oms-> $OMS_HOME/bin/emcli login -username=sysman -password=senha
Login successful

Sincronizando:

srv=oms-> $OMS_HOME/bin/emcli sync
Synchronized successfully

Identificando as plataformas que está disponível a imagem do Agent na biblioteca de software (Software Library):


srv=oms-> $OMS_HOME/bin/emcli get_supported_platforms
-----------------------------------------------
Version = 13.2.0.0.0
 Platform = Linux x86-64
-----------------------------------------------
Platforms list displayed successfully.

Download da imagem do Management Agent Software:

srv=oms-> $OMS_HOME/bin/emcli get_agentimage -destination=/orabackup/agent_img -platform="Linux x86-64" -version=13.2.0.0.0
 === Partition Detail ===
Space free : 134 GB
Space required : 1 GB
Check the logs at /orabin/app/oracle/product/13.2.0.0/EM/gc_inst/em/EMGC_OMS1/sysman/emcli/setup/.emcli/get_agentimage_2017-12-06_10-43-50-AM.log
Downloading /orabackup/agent_img/13.2.0.0.0_AgentCore_226.zip
File saved as /orabackup/agent_img/13.2.0.0.0_AgentCore_226.zip
Downloading /orabackup/agent_img/13.2.0.0.0_Plugins_226.zip
File saved as /orabackup/agent_img/13.2.0.0.0_Plugins_226.zip
Downloading /orabackup/agent_img/unzip
File saved as /orabackup/agent_img/unzip
Executing command: /orabackup/agent_img/unzip /orabackup/agent_img/13.2.0.0.0_Plugins_226.zip -d /orabackup/agent_img
Exit status is:0
Agent Image Download completed successfully.

Copiando a imagem para o servidor destino e removendo a imagem gerada no servidor do OMS:

srv=oms-> scp /orabackup/agent_img/13.2.0.0.0_AgentCore_226.zip oracle@srvagent:/oracle/EM/agent_img/
Acesso restrito a usuarios autorizados.
oracle@srvagent's password:
13.2.0.0.0_AgentCore_226.zip    
srv=oms-> rm -rf /orabackup/agent_img

Listando algumas informações do OMS que serão utilizadas na configuração do response file no servidor destino:


srv=oms-> $OMS_HOME/bin/emctl status oms -details
Oracle Enterprise Manager Cloud Control 13c Release 2
Copyright (c) 1996, 2016 Oracle Corporation.  All rights reserved.
Enter Enterprise Manager Root (SYSMAN) Password :
Console Server Host        : srvoms
HTTP Console Port          : 7788
HTTPS Console Port         : 7803
HTTP Upload Port           : 4889
HTTPS Upload Port          : 4903
EM Instance Home           : /orabin/app/oracle/product/13.2.0.0/EM/gc_inst/em/EMGC_OMS1
OMS Log Directory Location : /orabin/app/oracle/product/13.2.0.0/EM/gc_inst/em/EMGC_OMS1/sysman/log
OMS is not configured with SLB or virtual hostname
Agent Upload is locked.
OMS Console is locked.
Active CA ID: 1
Console URL: https://srvoms:7803/em
Upload URL: https://srvoms:4903/empbs/upload

WLS Domain Information
Domain Name            : GCDomain
Admin Server Host      : srvoms
Admin Server HTTPS Port: 7102
Admin Server is RUNNING

Oracle Management Server Information
Managed Server Instance Name: EMGC_OMS1
Oracle Management Server Instance Host: srvoms
WebTier is Up
Oracle Management Server is Up
JVMD Engine is Up

BI Publisher Server Information
BI Publisher Managed Server Name: BIP
BI Publisher Server is Up

BI Publisher HTTP Managed Server Port   : 9701
BI Publisher HTTPS Managed Server Port  : 9803
BI Publisher HTTP OHS Port              : 9788
BI Publisher HTTPS OHS Port             : 9851
BI Publisher is locked.
BI Publisher Server named 'BIP' running at URL: https://srvoms:9851/xmlpserver
BI Publisher Server Logs: /orabin/app/oracle/product/13.2.0.0/EM/gc_inst/user_projects/domains/GCDomain/servers/BIP/logs/
BI Publisher Log        : /orabin/app/oracle/product/13.2.0.0/EM/gc_inst/user_projects/domains/GCDomain/servers/BIP/logs/bipublisher/bipublisher.log

Descompactado a imagem do agent no servidor destino:

srv=agent-> cd /oracle/EM/agent_img

srv=agent-> ls
13.2.0.0.0_AgentCore_226.zip

srv=agent-> unzip 13.2.0.0.0_AgentCore_226.zip
Archive:  13.2.0.0.0_AgentCore_226.zip
  inflating: agentcore.bin
  inflating: agent.rsp
  inflating: agentDeploy.sh
  inflating: agentimage.properties
  inflating: unzip
  inflating: zip
   creating: plugins/
  inflating: plugins/oracle.sysman.oh.agent.plugin-13.2.0.0.0.farb
  inflating: plugins/oracle.sysman.db.discovery.plugin-13.2.2.0.0.farb
  inflating: plugins/oracle.sysman.si.discovery.plugin-13.2.2.0.0.farb
  inflating: plugins/oracle.sysman.xa.discovery.plugin-13.2.2.0.0.farb
  inflating: plugins/oracle.sysman.oh.discovery.plugin-13.2.0.0.0.farb
  inflating: plugins/oracle.sysman.emas.discovery.plugin-13.2.2.0.0.farb
  inflating: plugins.txt

srv=agent-> ls
13.2.0.0.0_AgentCore_226.zip  agentcore.bin  agentDeploy.sh  agentimage.properties  agent.rsp  plugins  plugins.txt  unzip  zip

No mesmo diretório da imagem temos agora o arquivo "agent.rsp" que é nosso response file e que deve ser ajustado com alguns parâmetros do ambiente.


srv=agent-> vi agent.rsp

srv=agent-> cat agent.rsp | grep -v '^#'


OMS_HOST=srvoms
EM_UPLOAD_PORT=4903
AGENT_REGISTRATION_PASSWORD=senha
AGENT_INSTANCE_HOME=/oracle/EM/agent/agent_inst
ORACLE_HOSTNAME=srvagent.dominio
EM_INSTALL_TYPE="AGENT"

A maioria dos parâmetros acima estarão comentados no arquivo agent.rsp, basta remover o "#" do inicio da linha em que o parâmetro se encontra e ajustá-lo conforme o ambiente. Informações como OMS_HOST e EM_UPLOAD_PORT podemos pegar no retorno do comando "emctl status oms -details" executado anteriormente no EM CLI do servidor OMS.

O AGENT_INSTANCE_HOME é o local que será instalado o agent e ORACLE_HOSTNAME é o nome do servidor local que estamos instalando o agent (importante incluir o domínio da mesma forma que está configurado no /etc/hosts)

Ajustando a permissão do arquivo reponse file e criando diretório que será instalado o Management Agent Software:


srv=agent-> chmod 777 agent.rsp
srv=agent-> mkdir -p /oracle/EM/agent/agent_inst

Executando a instalação utilizando o agentDeploy.sh. Observe que foi passado o AGENT_BASE_DIR que é a diretório base da instalação (diretório antes do agent_inst) e RESPONSE_FILE que é o arquivo contendo os parâmetros configurados.


srv=agent-> ./agentDeploy.sh AGENT_BASE_DIR=/oracle/EM/agent RESPONSE_FILE=/oracle/EM/agent_img/agent.rsp

The space available is ....  9712 MB

 Validating the OMS_HOST & EM_UPLOAD_PORT
Executing command : /oracle/EM/agent/agent_13.2.0.0.0/jdk/jre/bin/java -classpath /oracle/EM/agent/agent_13.2.0.0.0/jlib/agentInstaller.jar:/oracle/EM/agent/agent_13.2.0.0.0/oui/modules/OraInstaller.jar oracle.sysman.agent.installer.AgentInstaller /oracle/EM/agent/agent_13.2.0.0.0 /oracle/EM/agent_img /oracle/EM/agent $args -prereq
AGENT_ins home is:AGENT_BASE_DIR=/oracle/EM/agentoraclehome is:/oracle/EM/agent/agent_13.2.0.0.0
The oraclehome /oracle/EM/agent/agent_13.2.0.0.0

Validating oms host & port with url: https://srvoms:4903/empbs/genwallet
Validating oms host & port with url: http://srvoms:4903/empbs/genwallet
Return status:0-oms http port is passed
Validating the OMS Host and Port completed.
/oracle/EM/agent_img/agentcore.bin -ignoreSysPrereqs -prereqChecker -entryPoint oracle.sysman.top.agent_Complete -silent -ignoreSysPrereqs -detailedExitCodes -responseFile /oracle/EM/agent/agentInstall.rsp  -J-DORACLE_HOSTNAME=srvagent.dominio  -J-Djava.io.tmpdir=/oracle/EM/agent/agent_13.2.0.0.0/cfgtoollogs/prereqlogs -J-DAGENT_BASE_DIR=/oracle/EM/agent
0%...................................................................................................100%
Launcher log file is /oracle/EM/agent/agent_13.2.0.0.0/cfgtoollogs/prereqlogs/OraInstall2017-12-06_11-59-03AM/launcher2017-12-06_11-59-03AM.log.
Starting Oracle Prerequisite Checker

Checking if CPU speed is above 300 MHz.   Actual 1064.000 MHz    Passed
Checking swap space: must be greater than 512 MB.   Actual 44990 MB    Passed
Checking if this platform requires a 64-bit JVM.   Actual 64    Passed (64-bit not required)
Checking temp space: must be greater than 300 MB.   Actual 8274 MB    Passed


Preparing to launch the Oracle Universal Installer from /oracle/EM/agent/agent_13.2.0.0.0/cfgtoollogs/prereqlogs/OraInstall2017-12-06_11-59-03AM
Oracle Prerequisite Checker Version 13.8.0.0.0 Production
Copyright (C) 1999, 2015, Oracle. All rights reserved.

Starting execution of prerequisite checks...
Total No of checks: 10

Performing check for CertifiedVersions_agent
Is the software certified on the current operating system?
Expected result: One of enterprise-6,oracle-8,oracle-7,SuSE-11,SuSE-12,redhat-6,redhat-7
Actual Result: redhat-6
Check complete. The overall result of this check is: Passed


Check complete: Passed
========================================================
Performing check for Packages_agent
Are the required packages installed on the current operating system?
Checking for make-3.81; found make-1:3.81-20.el6-x86_64.        Passed
Checking for binutils-2.20; found binutils-2.20.51.0.2-5.43.el6-x86_64. Passed
Checking for gcc-4.1.1; found gcc-4.4.7-16.el6-x86_64.  Passed
Checking for libaio-0.3.106; found libaio-0.3.107-10.el6-x86_64.        Passed
Checking for glibc-common-2.3.4; found glibc-common-2.12-1.166.el6_7.3-x86_64.  Passed
Checking for libstdc++-4.1.1; found libstdc++-4.4.7-16.el6-x86_64.      Passed
Checking for sysstat-5.0.5; found sysstat-9.0.4-27.el6-x86_64.  Passed
Check complete. The overall result of this check is: Passed


Check complete: Passed
========================================================
Performing check for CompatibilityCheck
Is the software compatible with the current operating system?
sourceLoc is :/oracle/EM/agent/agent_13.2.0.0.0/cfgtoollogs/prereqlogs/OraInstall2017-12-06_11-59-03AM/stage/shiphomeproperties.xml
ARU ID is:226
Platform is :x86_64
Check complete. The overall result of this check is: Passed


Check complete: Passed
========================================================
Performing check for AvailableInventorySpace
Checking for sufficient disk space in the Inventory Location
Expected result: 100.0MB
Actual Result: 8229MB
Check complete. The overall result of this check is: Passed


Check complete: Passed
========================================================
Performing check for InventoryWritableCheck
Checking for write permissions on the inventory.
Check complete. The overall result of this check is: Passed


Check complete: Passed
========================================================
Performing check for TZRegionCheck
Checking TimeZone settings...
Check complete. The overall result of this check is: Passed


Check complete: Passed
========================================================
Performing check for AgentBaseDirCheck
Is the ownership of the agent base directory valid?
Check complete. The overall result of this check is: Passed


Check complete: Passed
========================================================
Performing check for PortCheck
Checking for port availability and hostname validity...
Host name to check srvagent.dominio
PORT 3872
Getting Inet Addresses for host srvagent.dominio
Trying for host : srvagent.dominio/10.20.5.176 and port : 3872
Trying for host : /127.0.0.1 and port : 3872
** Agent Port Check completed successfully.**
Agent port to use 3872
===Expected Result final Either port 3872 must be available or a port in the range of 1830 to 1849 must be available on host srvagent.dominio.
Expected result: Either port 3872 must be available or a port in the range of 1830 to 1849 must be available on host srvagent.dominio.
Actual Result: 3872
Check complete. The overall result of this check is: Passed


Check complete: Passed
========================================================
Performing check for OracleHomeCheck
Checking whether the old oracle home entry is present in the central inventory ...
Check complete. The overall result of this check is: Passed


Check complete: Passed
========================================================
Performing check for CheckHostName
Is the host name valid?
value of oracle_hostname:srvagent.dominio
value of hostname is:srvagent
Expected result: Fully qualified domain name, for example foo.mydomain.com
Actual Result: srvagent.dominio. Ensure that you provide a fully qualified domain name.
Check complete. The overall result of this check is: Passed


Check complete: Passed
========================================================
PrereqChecks complete


The log(s) can be found here: /oracle/EM/agent/agent_13.2.0.0.0/cfgtoollogs/prereqlogs/OraInstall2017-12-06_11-59-03AM.

 Agent Prereqs Completed


 Starting Install Phase .....
/oracle/EM/agent_img/agentcore.bin -ignoreSysPrereqs -silent -responseFile /oracle/EM/agent/agentInstall.rsp
0%...................................................................................................100%
Launcher log file is /tmp/OraInstall2017-12-06_11-59-24AM/launcher2017-12-06_11-59-24AM.log.
Starting Oracle Universal Installer

Checking if CPU speed is above 300 MHz.   Actual 2262.000 MHz    Passed
Checking swap space: must be greater than 512 MB.   Actual 44990 MB    Passed
Checking if this platform requires a 64-bit JVM.   Actual 64    Passed (64-bit not required)
Checking temp space: must be greater than 300 MB.   Actual 2278 MB    Passed


Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2017-12-06_11-59-24AM
Dec 06, 2017 11:59:27 AM oracle.sysman.oii.oiio.oiioz.OiiozResponseFile getValue
INFO: This installation is being performed using response file /oracle/EM/agent/agentInstall.rsp.
..................................................................................................
Installation Summary


Disk Space : Required 1,323 MB, Available 9,504 MB
Feature Sets to Install:
        Oracle JDK 12.1.3.0.1
        Perl 5.14.4.0.0 5.14.4.0.0
        Next Generation Install Core 13.8.0.0.0
        OPatch 13.8.0.0.0
        Oracle HTTP Client 12.1.3.0.0
        Oracle XDK 12.1.3.0.0
        DMS Full 12.1.3.0.0
        Wallet Functionality 12.1.3.0.0
        Remote Diagnostic Assistant 8.09.0.1.0
..................................................................................................
Session log file is /tmp/OraInstall2017-12-06_11-59-24AM/install2017-12-06_11-59-24AM.log

Loading products list. Please wait.
.................. 1%
.................. 2%
.................. 40%

Loading products. Please wait.
.................. 41%
.................. 42%
.................. 43%
.................. 44%
.................. 45%
.................. 46%
.................. 47%
.................. 48%
.................. 49%
.................. 50%
.................. 51%
.................. 52%
.................. 53%
.................. 54%
.................. 55%
.................. 56%
.................. 57%
.................. 58%
.................. 59%
.................. 60%
.................. 61%
.................. 62%
.................. 63%
.................. 64%
.................. 65%
.................. 66%
.................. 67%
.................. 68%
.................. 69%
.................. 70%
.................. 71%
.................. 72%
.................. 72%
.................. 73%
.................. 74%
.................. 75%
.................. 76%
.................. 77%
.................. 78%
.................. 79%
.................. 80%
.................. 81%
.................. 82%
.................. 83%
.................. 84%
.................. 85%
.................. 86%
.................. 87%
.................. 88%
.................. 89%
.................. 90%
.................. 91%
.................. 92%
.................. 93%
.................. 94%
.................. 95%
.................. 96%
.................. 97%
.................. 98%
.................. 99%

Updating Libraries



Starting Installations
.................. 1%
.................. 2%
.................. 3%
.................. 4%
.................. 5%
.................. 6%
.................. 7%
.................. 8%
.................. 9%
.................. 10%
.................. 11%
.................. 12%
.................. 13%
.................. 14%
.................. 15%
.................. 16%
.................. 17%
.................. 18%
.................. 19%
.................. 20%
.................. 21%
.................. 22%
.................. 23%
.................. 24%
.................. 25%
.................. 26%
.................. 27%
.................. 28%
.................. 29%
.................. 30%
.................. 31%
.................. 32%
.................. 33%
.................. 34%
.................. 35%
.................. 36%
.................. 37%
.................. 38%
.................. 39%
.................. 40%
.................. 41%
.................. 42%
.................. 43%
.................. 44%
.................. 45%
.................. 46%
.................. 47%
.................. 48%
.................. 49%
.................. 50%
.................. 51%
.................. 52%
.................. 53%
.................. 54%
.................. 55%
.................. 56%
.................. 57%
.................. 58%
.................. 59%
.................. 60%
.................. 61%
.................. 62%
.................. 63%
.................. 64%
.................. 65%
.................. 66%
.................. 67%
.................. 68%
.................. 69%
.................. 70%
.................. 71%
.................. 72%
.................. 73%
.................. 74%
.................. 75%
.................. 76%
.................. 77%
.................. 78%
.................. 79%
.................. 80%
.................. 81%
.................. 82%
.................. 83%
.................. 84%
.................. 85%
.................. 86%
.................. 87%
.................. 88%

Install pending...

Installation in progress

 Component : oracle.osdt.core 12.1.3.0.0

Copying files for 'oracle.osdt.core 12.1.3.0.0 '

 Component : oracle.pki 12.1.3.0.0

Copying files for 'oracle.pki 12.1.3.0.0 '

 Component : oracle.rsa.crypto 12.1.3.0.0

Copying files for 'oracle.rsa.crypto 12.1.3.0.0 '

 Component : oracle.glcm.logging 1.4.0.0.0

Copying files for 'oracle.glcm.logging 1.4.0.0.0 '

 Component : oracle.glcm.comdev 7.6.0.0.0

Copying files for 'oracle.glcm.comdev 7.6.0.0.0 '

 Component : oracle.glcm.dependency 1.6.0.0.0

Copying files for 'oracle.glcm.dependency 1.6.0.0.0 '

 Component : oracle.glcm.xmldh 3.2.0.0.0

Copying files for 'oracle.glcm.xmldh 3.2.0.0.0 '

 Component : oracle.glcm.wizard 7.6.0.0.0

Copying files for 'oracle.glcm.wizard 7.6.0.0.0 '

 Component : oracle.glcm.encryption 2.5.0.0.0

Copying files for 'oracle.glcm.encryption 2.5.0.0.0 '

 Component : oracle.bali.share 12.1.3.0.0

Copying files for 'oracle.bali.share 12.1.3.0.0 '

 Component : oracle.bali.jewt 12.1.3.0.0

Copying files for 'oracle.bali.jewt 12.1.3.0.0 '

 Component : oracle.bali.ice 6.1.3.2.1

Copying files for 'oracle.bali.ice 6.1.3.2.1 '

 Component : oracle.help.share 12.1.3.0.0

Copying files for 'oracle.help.share 12.1.3.0.0 '

 Component : oracle.help.ohj 12.1.3.0.0

Copying files for 'oracle.help.ohj 12.1.3.0.0 '

 Component : oracle.nginst.common 13.8.0.0.0

Copying files for 'oracle.nginst.common 13.8.0.0.0 '

 Component : oracle.nginst.osp.compstager 13.8.0.0.0

Copying files for 'oracle.nginst.osp.compstager 13.8.0.0.0 '

 Component : oracle.jcraft.jsch 0.1.53.0.0

Copying files for 'oracle.jcraft.jsch 0.1.53.0.0 '

 Component : oracle.glcm.opatch.common.api 13.8.0.0.0

Copying files for 'oracle.glcm.opatch.common.api 13.8.0.0.0 '

 Component : oracle.nginst.core 13.8.0.0.0

Copying files for 'oracle.nginst.core 13.8.0.0.0 '

 Component : oracle.nginst.thirdparty 13.8.0.0.0

Copying files for 'oracle.nginst.thirdparty 13.8.0.0.0 '

 Component : oracle.swd.opatch 13.8.0.0.0

Copying files for 'oracle.swd.opatch 13.8.0.0.0 '

 Component : oracle.apache.commons.cli 1.2.0.0.1

Copying files for 'oracle.apache.commons.cli 1.2.0.0.1 '

 Component : oracle.apache.commons.compress 1.4.0.0.1

Copying files for 'oracle.apache.commons.compress 1.4.0.0.1 '

 Component : oracle.glcm.osys.core 13.8.0.0.0

Copying files for 'oracle.glcm.osys.core 13.8.0.0.0 '

 Component : oracle.glcm.oplan.core 13.8.0.0.0

Copying files for 'oracle.glcm.oplan.core 13.8.0.0.0 '

 Component : oracle.glcm.opatchauto.core 13.8.0.0.0

Copying files for 'oracle.glcm.opatchauto.core 13.8.0.0.0 '

 Component : oracle.jse.dms 12.1.3.0.0

Copying files for 'oracle.jse.dms 12.1.3.0.0 '

 Component : oracle.jrf.dms.common 12.1.3.0.0

Copying files for 'oracle.jrf.dms.common 12.1.3.0.0 '

 Component : oracle.jrf.dms 12.1.3.0.0

Copying files for 'oracle.jrf.dms 12.1.3.0.0 '

 Component : oracle.xdk.jrf.jaxp 12.1.3.0.0

Copying files for 'oracle.xdk.jrf.jaxp 12.1.3.0.0 '

 Component : oracle.xdk.jrf 12.1.3.0.0

Copying files for 'oracle.xdk.jrf 12.1.3.0.0 '

 Component : oracle.xdk.jrf.fmw 12.1.3.0.0

Copying files for 'oracle.xdk.jrf.fmw 12.1.3.0.0 '

 Component : oracle.xdk.jrf.xmlparserv2 12.1.3.0.0

Copying files for 'oracle.xdk.jrf.xmlparserv2 12.1.3.0.0 '

 Component : oracle.sysman.top.agent 13.2.0.0.0

Copying files for 'oracle.sysman.top.agent 13.2.0.0.0 '

 Component : oracle.sysman.common 13.2.0.0.0

Copying files for 'oracle.sysman.common 13.2.0.0.0 '

 Component : oracle.sysman.sbin 13.2.0.0.0

Copying files for 'oracle.sysman.sbin 13.2.0.0.0 '

 Component : oracle.sysman.emagent.installer 13.2.0.0.0

Copying files for 'oracle.sysman.emagent.installer 13.2.0.0.0 '

 Component : oracle.sysman.darda 8.09.0.1.0

Copying files for 'oracle.sysman.darda 8.09.0.1.0 '

 Component : oracle.jre 1.7.0.111.0

Copying files for 'oracle.jre 1.7.0.111.0 '

 Component : oracle.jdk 1.7.0.111.0

Copying files for 'oracle.jdk 1.7.0.111.0 '

 Component : oracle.ldap.rsf 12.1.3.0.0

Copying files for 'oracle.ldap.rsf 12.1.3.0.0 '

 Component : oracle.buildtools.rsf 11.2.0.3.0

Copying files for 'oracle.buildtools.rsf 11.2.0.3.0 '

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/install/utl/rootmacro.sbs'.

 Component : oracle.wsm.common 12.1.3.0.0

Copying files for 'oracle.wsm.common 12.1.3.0.0 '

 Component : oracle.jrf.j2ee 12.1.3.0.0

Copying files for 'oracle.jrf.j2ee 12.1.3.0.0 '

 Component : oracle.opss.core 12.1.3.0.0

Copying files for 'oracle.opss.core 12.1.3.0.0 '

 Component : oracle.sysman.agent.ic 13.2.0.0.0

Copying files for 'oracle.sysman.agent.ic 13.2.0.0.0 '

 Component : oracle.ons 12.1.3.0.0

Copying files for 'oracle.ons 12.1.3.0.0 '

 Component : oracle.http_client 12.1.3.0.0

Copying files for 'oracle.http_client 12.1.3.0.0 '

 Component : oracle.perlint 5.14.4.0.0

Copying files for 'oracle.perlint 5.14.4.0.0 '

 Component : oracle.perlint.expat 2.0.1.0.1

Copying files for 'oracle.perlint.expat 2.0.1.0.1 '

 Component : oracle.perlint.modules 5.14.4.0.1

Copying files for 'oracle.perlint.modules 5.14.4.0.1 '

Install successful

Post feature install pending...

Post Feature installing

 Feature Set : com.oracle.orapki

 Feature Set : glcm_encryption_lib

 Feature Set : glcm_common_lib

 Feature Set : jsch.lib

 Feature Set : orapki.lib

Post Feature installing 'jsch.lib'

Post Feature installing 'glcm_common_lib'

Post Feature installing 'glcm_encryption_lib'

Post Feature installing 'com.oracle.orapki'

Post Feature installing 'orapki.lib'

 Feature Set : oracle.glcm.opatch.common.api.classpath

Post Feature installing 'oracle.glcm.opatch.common.api.classpath'

 Feature Set : apache_commons_compress_lib

Post Feature installing 'apache_commons_compress_lib'

 Feature Set : apache_commons_cli_lib

Post Feature installing 'apache_commons_cli_lib'

 Feature Set : oracle.glcm.osys.core.classpath

Post Feature installing 'oracle.glcm.osys.core.classpath'

 Feature Set : com.oracle.db.xdk-no-jaxp

Post Feature installing 'com.oracle.db.xdk-no-jaxp'

 Feature Set : oracle.glcm.oplan.core.classpath

 Feature Set : oracle.glcm.opatchauto.core.actions.classpath

Post Feature installing 'oracle.glcm.oplan.core.classpath'

Post Feature installing 'oracle.glcm.opatchauto.core.actions.classpath'

 Feature Set : oracle.glcm.opatchauto.core.classpath

 Feature Set : oracle.glcm.opatchauto.core.wallet.classpath

Post Feature installing 'oracle.glcm.opatchauto.core.classpath'

Post Feature installing 'oracle.glcm.opatchauto.core.wallet.classpath'

Post feature install complete

String substitutions pending...

String substituting

 Component : oracle.osdt.core 12.1.3.0.0

String substituting 'oracle.osdt.core 12.1.3.0.0 '

 Component : oracle.pki 12.1.3.0.0

String substituting 'oracle.pki 12.1.3.0.0 '

 Component : oracle.rsa.crypto 12.1.3.0.0

String substituting 'oracle.rsa.crypto 12.1.3.0.0 '

 Component : oracle.glcm.logging 1.4.0.0.0

String substituting 'oracle.glcm.logging 1.4.0.0.0 '

 Component : oracle.glcm.comdev 7.6.0.0.0

String substituting 'oracle.glcm.comdev 7.6.0.0.0 '

 Component : oracle.glcm.dependency 1.6.0.0.0

String substituting 'oracle.glcm.dependency 1.6.0.0.0 '

 Component : oracle.glcm.xmldh 3.2.0.0.0

String substituting 'oracle.glcm.xmldh 3.2.0.0.0 '

 Component : oracle.glcm.wizard 7.6.0.0.0

String substituting 'oracle.glcm.wizard 7.6.0.0.0 '

 Component : oracle.glcm.encryption 2.5.0.0.0

String substituting 'oracle.glcm.encryption 2.5.0.0.0 '

 Component : oracle.bali.share 12.1.3.0.0

String substituting 'oracle.bali.share 12.1.3.0.0 '

 Component : oracle.bali.jewt 12.1.3.0.0

String substituting 'oracle.bali.jewt 12.1.3.0.0 '

 Component : oracle.bali.ice 6.1.3.2.1

String substituting 'oracle.bali.ice 6.1.3.2.1 '

 Component : oracle.help.share 12.1.3.0.0

String substituting 'oracle.help.share 12.1.3.0.0 '

 Component : oracle.help.ohj 12.1.3.0.0

String substituting 'oracle.help.ohj 12.1.3.0.0 '

 Component : oracle.nginst.common 13.8.0.0.0

String substituting 'oracle.nginst.common 13.8.0.0.0 '

 Component : oracle.nginst.osp.compstager 13.8.0.0.0

String substituting 'oracle.nginst.osp.compstager 13.8.0.0.0 '

 Component : oracle.jcraft.jsch 0.1.53.0.0

String substituting 'oracle.jcraft.jsch 0.1.53.0.0 '

 Component : oracle.glcm.opatch.common.api 13.8.0.0.0

String substituting 'oracle.glcm.opatch.common.api 13.8.0.0.0 '

 Component : oracle.nginst.core 13.8.0.0.0

String substituting 'oracle.nginst.core 13.8.0.0.0 '

 Component : oracle.nginst.thirdparty 13.8.0.0.0

String substituting 'oracle.nginst.thirdparty 13.8.0.0.0 '

 Component : oracle.swd.opatch 13.8.0.0.0

String substituting 'oracle.swd.opatch 13.8.0.0.0 '

 Component : oracle.apache.commons.cli 1.2.0.0.1

String substituting 'oracle.apache.commons.cli 1.2.0.0.1 '

 Component : oracle.apache.commons.compress 1.4.0.0.1

String substituting 'oracle.apache.commons.compress 1.4.0.0.1 '

 Component : oracle.glcm.osys.core 13.8.0.0.0

String substituting 'oracle.glcm.osys.core 13.8.0.0.0 '

 Component : oracle.glcm.oplan.core 13.8.0.0.0

String substituting 'oracle.glcm.oplan.core 13.8.0.0.0 '

 Component : oracle.glcm.opatchauto.core 13.8.0.0.0

String substituting 'oracle.glcm.opatchauto.core 13.8.0.0.0 '

 Component : oracle.jse.dms 12.1.3.0.0

String substituting 'oracle.jse.dms 12.1.3.0.0 '

 Component : oracle.jrf.dms.common 12.1.3.0.0

String substituting 'oracle.jrf.dms.common 12.1.3.0.0 '

 Component : oracle.jrf.dms 12.1.3.0.0

String substituting 'oracle.jrf.dms 12.1.3.0.0 '

 Component : oracle.xdk.jrf.jaxp 12.1.3.0.0

String substituting 'oracle.xdk.jrf.jaxp 12.1.3.0.0 '

 Component : oracle.xdk.jrf 12.1.3.0.0

String substituting 'oracle.xdk.jrf 12.1.3.0.0 '

 Component : oracle.xdk.jrf.fmw 12.1.3.0.0

String substituting 'oracle.xdk.jrf.fmw 12.1.3.0.0 '

 Component : oracle.xdk.jrf.xmlparserv2 12.1.3.0.0

String substituting 'oracle.xdk.jrf.xmlparserv2 12.1.3.0.0 '

 Component : oracle.sysman.top.agent 13.2.0.0.0

String substituting 'oracle.sysman.top.agent 13.2.0.0.0 '

 Component : oracle.sysman.common 13.2.0.0.0

String substituting 'oracle.sysman.common 13.2.0.0.0 '

 Component : oracle.sysman.sbin 13.2.0.0.0

String substituting 'oracle.sysman.sbin 13.2.0.0.0 '

 Component : oracle.sysman.emagent.installer 13.2.0.0.0

String substituting 'oracle.sysman.emagent.installer 13.2.0.0.0 '

 Component : oracle.sysman.darda 8.09.0.1.0

String substituting 'oracle.sysman.darda 8.09.0.1.0 '

 Component : oracle.jre 1.7.0.111.0

String substituting 'oracle.jre 1.7.0.111.0 '

 Component : oracle.jdk 1.7.0.111.0

String substituting 'oracle.jdk 1.7.0.111.0 '

 Component : oracle.ldap.rsf 12.1.3.0.0

String substituting 'oracle.ldap.rsf 12.1.3.0.0 '

 Component : oracle.buildtools.rsf 11.2.0.3.0

String substituting 'oracle.buildtools.rsf 11.2.0.3.0 '

 Component : oracle.wsm.common 12.1.3.0.0

String substituting 'oracle.wsm.common 12.1.3.0.0 '

 Component : oracle.jrf.j2ee 12.1.3.0.0

String substituting 'oracle.jrf.j2ee 12.1.3.0.0 '

 Component : oracle.opss.core 12.1.3.0.0

String substituting 'oracle.opss.core 12.1.3.0.0 '

 Component : oracle.sysman.agent.ic 13.2.0.0.0

String substituting 'oracle.sysman.agent.ic 13.2.0.0.0 '

 Component : oracle.ons 12.1.3.0.0

String substituting 'oracle.ons 12.1.3.0.0 '

 Component : oracle.http_client 12.1.3.0.0

String substituting 'oracle.http_client 12.1.3.0.0 '

 Component : oracle.perlint 5.14.4.0.0

String substituting 'oracle.perlint 5.14.4.0.0 '

 Component : oracle.perlint.expat 2.0.1.0.1

String substituting 'oracle.perlint.expat 2.0.1.0.1 '

 Component : oracle.perlint.modules 5.14.4.0.1

String substituting 'oracle.perlint.modules 5.14.4.0.1 '

String substitutions complete

Link pending...

Linking in progress

 Component : oracle.osdt.core 12.1.3.0.0

Linking 'oracle.osdt.core 12.1.3.0.0 '

 Component : oracle.pki 12.1.3.0.0

Linking 'oracle.pki 12.1.3.0.0 '

 Component : oracle.rsa.crypto 12.1.3.0.0

Linking 'oracle.rsa.crypto 12.1.3.0.0 '

 Component : oracle.glcm.logging 1.4.0.0.0

Linking 'oracle.glcm.logging 1.4.0.0.0 '

 Component : oracle.glcm.comdev 7.6.0.0.0

Linking 'oracle.glcm.comdev 7.6.0.0.0 '

 Component : oracle.glcm.dependency 1.6.0.0.0

Linking 'oracle.glcm.dependency 1.6.0.0.0 '

 Component : oracle.glcm.xmldh 3.2.0.0.0

Linking 'oracle.glcm.xmldh 3.2.0.0.0 '

 Component : oracle.glcm.wizard 7.6.0.0.0

Linking 'oracle.glcm.wizard 7.6.0.0.0 '

 Component : oracle.glcm.encryption 2.5.0.0.0

Linking 'oracle.glcm.encryption 2.5.0.0.0 '

 Component : oracle.bali.share 12.1.3.0.0

Linking 'oracle.bali.share 12.1.3.0.0 '

 Component : oracle.bali.jewt 12.1.3.0.0

Linking 'oracle.bali.jewt 12.1.3.0.0 '

 Component : oracle.bali.ice 6.1.3.2.1

Linking 'oracle.bali.ice 6.1.3.2.1 '

 Component : oracle.help.share 12.1.3.0.0

Linking 'oracle.help.share 12.1.3.0.0 '

 Component : oracle.help.ohj 12.1.3.0.0

Linking 'oracle.help.ohj 12.1.3.0.0 '

 Component : oracle.nginst.common 13.8.0.0.0

Linking 'oracle.nginst.common 13.8.0.0.0 '

 Component : oracle.nginst.osp.compstager 13.8.0.0.0

Linking 'oracle.nginst.osp.compstager 13.8.0.0.0 '

 Component : oracle.jcraft.jsch 0.1.53.0.0

Linking 'oracle.jcraft.jsch 0.1.53.0.0 '

 Component : oracle.glcm.opatch.common.api 13.8.0.0.0

Linking 'oracle.glcm.opatch.common.api 13.8.0.0.0 '

 Component : oracle.nginst.core 13.8.0.0.0

Linking 'oracle.nginst.core 13.8.0.0.0 '

 Component : oracle.nginst.thirdparty 13.8.0.0.0

Linking 'oracle.nginst.thirdparty 13.8.0.0.0 '

 Component : oracle.swd.opatch 13.8.0.0.0

Linking 'oracle.swd.opatch 13.8.0.0.0 '

 Component : oracle.apache.commons.cli 1.2.0.0.1

Linking 'oracle.apache.commons.cli 1.2.0.0.1 '

 Component : oracle.apache.commons.compress 1.4.0.0.1

Linking 'oracle.apache.commons.compress 1.4.0.0.1 '

 Component : oracle.glcm.osys.core 13.8.0.0.0

Linking 'oracle.glcm.osys.core 13.8.0.0.0 '

 Component : oracle.glcm.oplan.core 13.8.0.0.0

Linking 'oracle.glcm.oplan.core 13.8.0.0.0 '

 Component : oracle.glcm.opatchauto.core 13.8.0.0.0

Linking 'oracle.glcm.opatchauto.core 13.8.0.0.0 '

 Component : oracle.jse.dms 12.1.3.0.0

Linking 'oracle.jse.dms 12.1.3.0.0 '

 Component : oracle.jrf.dms.common 12.1.3.0.0

Linking 'oracle.jrf.dms.common 12.1.3.0.0 '

 Component : oracle.jrf.dms 12.1.3.0.0

Linking 'oracle.jrf.dms 12.1.3.0.0 '

 Component : oracle.xdk.jrf.jaxp 12.1.3.0.0

Linking 'oracle.xdk.jrf.jaxp 12.1.3.0.0 '

 Component : oracle.xdk.jrf 12.1.3.0.0

Linking 'oracle.xdk.jrf 12.1.3.0.0 '

 Component : oracle.xdk.jrf.fmw 12.1.3.0.0

Linking 'oracle.xdk.jrf.fmw 12.1.3.0.0 '

 Component : oracle.xdk.jrf.xmlparserv2 12.1.3.0.0

Linking 'oracle.xdk.jrf.xmlparserv2 12.1.3.0.0 '

 Component : oracle.sysman.top.agent 13.2.0.0.0

Linking 'oracle.sysman.top.agent 13.2.0.0.0 '

 Component : oracle.sysman.common 13.2.0.0.0

Linking 'oracle.sysman.common 13.2.0.0.0 '

 Component : oracle.sysman.sbin 13.2.0.0.0

Linking 'oracle.sysman.sbin 13.2.0.0.0 '

 Component : oracle.sysman.emagent.installer 13.2.0.0.0

Linking 'oracle.sysman.emagent.installer 13.2.0.0.0 '

 Component : oracle.sysman.darda 8.09.0.1.0

Linking 'oracle.sysman.darda 8.09.0.1.0 '

 Component : oracle.jre 1.7.0.111.0

Linking 'oracle.jre 1.7.0.111.0 '

 Component : oracle.jdk 1.7.0.111.0

Linking 'oracle.jdk 1.7.0.111.0 '

 Component : oracle.ldap.rsf 12.1.3.0.0

Linking 'oracle.ldap.rsf 12.1.3.0.0 '

 Component : oracle.buildtools.rsf 11.2.0.3.0

Linking 'oracle.buildtools.rsf 11.2.0.3.0 '

 Component : oracle.wsm.common 12.1.3.0.0

Linking 'oracle.wsm.common 12.1.3.0.0 '

 Component : oracle.jrf.j2ee 12.1.3.0.0

Linking 'oracle.jrf.j2ee 12.1.3.0.0 '

 Component : oracle.opss.core 12.1.3.0.0

Linking 'oracle.opss.core 12.1.3.0.0 '

 Component : oracle.sysman.agent.ic 13.2.0.0.0

Linking 'oracle.sysman.agent.ic 13.2.0.0.0 '

 Component : oracle.ons 12.1.3.0.0

Linking 'oracle.ons 12.1.3.0.0 '

 Component : oracle.http_client 12.1.3.0.0

Linking 'oracle.http_client 12.1.3.0.0 '

 Component : oracle.perlint 5.14.4.0.0

Linking 'oracle.perlint 5.14.4.0.0 '

 Component : oracle.perlint.expat 2.0.1.0.1

Linking 'oracle.perlint.expat 2.0.1.0.1 '

 Component : oracle.perlint.modules 5.14.4.0.1

Linking 'oracle.perlint.modules 5.14.4.0.1 '

Linking in progress

Link successful

Setup pending...

Setup in progress

 Component : oracle.osdt.core 12.1.3.0.0

Setting up 'oracle.osdt.core 12.1.3.0.0 '

 Component : oracle.pki 12.1.3.0.0

Setting up 'oracle.pki 12.1.3.0.0 '

 Component : oracle.rsa.crypto 12.1.3.0.0

Setting up 'oracle.rsa.crypto 12.1.3.0.0 '

 Component : oracle.glcm.logging 1.4.0.0.0

Setting up 'oracle.glcm.logging 1.4.0.0.0 '

 Component : oracle.glcm.comdev 7.6.0.0.0

Setting up 'oracle.glcm.comdev 7.6.0.0.0 '

 Component : oracle.glcm.dependency 1.6.0.0.0

Setting up 'oracle.glcm.dependency 1.6.0.0.0 '

 Component : oracle.glcm.xmldh 3.2.0.0.0

Setting up 'oracle.glcm.xmldh 3.2.0.0.0 '

 Component : oracle.glcm.wizard 7.6.0.0.0

Setting up 'oracle.glcm.wizard 7.6.0.0.0 '

 Component : oracle.glcm.encryption 2.5.0.0.0

Setting up 'oracle.glcm.encryption 2.5.0.0.0 '

 Component : oracle.bali.share 12.1.3.0.0

Setting up 'oracle.bali.share 12.1.3.0.0 '

 Component : oracle.bali.jewt 12.1.3.0.0

Setting up 'oracle.bali.jewt 12.1.3.0.0 '

 Component : oracle.bali.ice 6.1.3.2.1

Setting up 'oracle.bali.ice 6.1.3.2.1 '

 Component : oracle.help.share 12.1.3.0.0

Setting up 'oracle.help.share 12.1.3.0.0 '

 Component : oracle.help.ohj 12.1.3.0.0

Setting up 'oracle.help.ohj 12.1.3.0.0 '

 Component : oracle.nginst.common 13.8.0.0.0

Setting up 'oracle.nginst.common 13.8.0.0.0 '

 Component : oracle.nginst.osp.compstager 13.8.0.0.0

Setting up 'oracle.nginst.osp.compstager 13.8.0.0.0 '

 Component : oracle.jcraft.jsch 0.1.53.0.0

Setting up 'oracle.jcraft.jsch 0.1.53.0.0 '

 Component : oracle.glcm.opatch.common.api 13.8.0.0.0

Setting up 'oracle.glcm.opatch.common.api 13.8.0.0.0 '

 Component : oracle.nginst.core 13.8.0.0.0

Setting up 'oracle.nginst.core 13.8.0.0.0 '

registering file(s) under /oui/.globalEnv.properties in deinstall-info.xml

 Component : oracle.nginst.thirdparty 13.8.0.0.0

Setting up 'oracle.nginst.thirdparty 13.8.0.0.0 '

 Component : oracle.swd.opatch 13.8.0.0.0

Setting up 'oracle.swd.opatch 13.8.0.0.0 '

 Component : oracle.apache.commons.cli 1.2.0.0.1

Setting up 'oracle.apache.commons.cli 1.2.0.0.1 '

 Component : oracle.apache.commons.compress 1.4.0.0.1

Setting up 'oracle.apache.commons.compress 1.4.0.0.1 '

 Component : oracle.glcm.osys.core 13.8.0.0.0

Setting up 'oracle.glcm.osys.core 13.8.0.0.0 '

 Component : oracle.glcm.oplan.core 13.8.0.0.0

Setting up 'oracle.glcm.oplan.core 13.8.0.0.0 '

 Component : oracle.glcm.opatchauto.core 13.8.0.0.0

Setting up 'oracle.glcm.opatchauto.core 13.8.0.0.0 '

 Component : oracle.jse.dms 12.1.3.0.0

Setting up 'oracle.jse.dms 12.1.3.0.0 '

 Component : oracle.jrf.dms.common 12.1.3.0.0

Setting up 'oracle.jrf.dms.common 12.1.3.0.0 '

 Component : oracle.jrf.dms 12.1.3.0.0

Setting up 'oracle.jrf.dms 12.1.3.0.0 '

 Component : oracle.xdk.jrf.jaxp 12.1.3.0.0

Setting up 'oracle.xdk.jrf.jaxp 12.1.3.0.0 '

 Component : oracle.xdk.jrf 12.1.3.0.0

Setting up 'oracle.xdk.jrf 12.1.3.0.0 '

 Component : oracle.xdk.jrf.fmw 12.1.3.0.0

Setting up 'oracle.xdk.jrf.fmw 12.1.3.0.0 '

 Component : oracle.xdk.jrf.xmlparserv2 12.1.3.0.0

Setting up 'oracle.xdk.jrf.xmlparserv2 12.1.3.0.0 '

 Component : oracle.sysman.top.agent 13.2.0.0.0

Setting up 'oracle.sysman.top.agent 13.2.0.0.0 '

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/install/unix/scripts/agentstup.template'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/install/unix/scripts/agentstup.template'.

changing permission for '/oracle/EM/agent/agent_13.2.0.0.0'

spawning 'chmod -R a+rX /oracle/EM/agent/agent_13.2.0.0.0/perl'

changing permission for '/oracle/EM/agent/agent_13.2.0.0.0/EMStage'

updating '/oracle/EM/agent/agent_13.2.0.0.0/root.sh.template.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/root.sh.template'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/replacebins.sh.template'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/stage/bin/forwarderProxy.template'.

changing permissions for '/oracle/EM/agent/agent_13.2.0.0.0/stage/bin/forwarderProxy.template'

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/bin/emtgtctl'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/stage/sysman/config/emd.properties.template'.

updating '/oracle/EM/agent/agent_13.2.0.0.0/install/eminstall.info.

spawning '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin/perl /oracle/EM/agent/agent_13.2.0.0.0/sysman/admin/scripts/patchUploadTriggers.pl /oracle/EM/agent/agent_13.2.0.0.0'

 Component : oracle.sysman.common 13.2.0.0.0

Setting up 'oracle.sysman.common 13.2.0.0.0 '

instantiating '/oracle/EM/agent/agent_13.2.0.0.0//bin/emctl.pl.template'.

deleting '/oracle/EM/agent/agent_13.2.0.0.0//bin/emctl.pl.template'

instantiating '/oracle/EM/agent/agent_13.2.0.0.0//bin/emctl.template'.

changing permissions for '/oracle/EM/agent/agent_13.2.0.0.0/bin/emctl'

instantiating '/oracle/EM/agent/agent_13.2.0.0.0//bin/commonenv.template'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0//install/unix/scripts/gcroot.sh.template'.

changing permissions for '/oracle/EM/agent/agent_13.2.0.0.0//install/unix/scripts/gcroot.sh'

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/oui/bin/runConfig.sh'.

 Component : oracle.sysman.sbin 13.2.0.0.0

Setting up 'oracle.sysman.sbin 13.2.0.0.0 '

 Component : oracle.sysman.emagent.installer 13.2.0.0.0

Setting up 'oracle.sysman.emagent.installer 13.2.0.0.0 '

 Component : oracle.sysman.darda 8.09.0.1.0

Setting up 'oracle.sysman.darda 8.09.0.1.0 '

 Component : oracle.jre 1.7.0.111.0

Setting up 'oracle.jre 1.7.0.111.0 '

 Component : oracle.jdk 1.7.0.111.0

Setting up 'oracle.jdk 1.7.0.111.0 '

 Component : oracle.ldap.rsf 12.1.3.0.0

Setting up 'oracle.ldap.rsf 12.1.3.0.0 '

 Component : oracle.buildtools.rsf 11.2.0.3.0

Setting up 'oracle.buildtools.rsf 11.2.0.3.0 '

 Component : oracle.wsm.common 12.1.3.0.0

Setting up 'oracle.wsm.common 12.1.3.0.0 '

 Component : oracle.jrf.j2ee 12.1.3.0.0

Setting up 'oracle.jrf.j2ee 12.1.3.0.0 '

 Component : oracle.opss.core 12.1.3.0.0

Setting up 'oracle.opss.core 12.1.3.0.0 '

 Component : oracle.sysman.agent.ic 13.2.0.0.0

Setting up 'oracle.sysman.agent.ic 13.2.0.0.0 '

 Component : oracle.ons 12.1.3.0.0

Setting up 'oracle.ons 12.1.3.0.0 '

 Component : oracle.http_client 12.1.3.0.0

Setting up 'oracle.http_client 12.1.3.0.0 '

 Component : oracle.perlint 5.14.4.0.0

Setting up 'oracle.perlint 5.14.4.0.0 '

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/c2ph'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/config_data'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/corelist'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/cpan'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/cpan2dist'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/cpanp'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/cpanp-run-perl'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/dbilogstrip'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/dbiprof'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/dbiproxy'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/dprofpp'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/enc2xs'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/find2perl'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/h2ph'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/h2xs'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/instmodsh'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/libnetcfg'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/ora_explain'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/perlbug'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/perldoc'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/perlivp'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/piconv'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/pl2pm'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/pod2html'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/pod2latex'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/pod2man'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/pod2text'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/pod2usage'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/podchecker'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/podselect'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/prove'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/psed'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/pstruct'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/ptar'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/ptardiff'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/s2p'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/shasum'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/splain'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp/xsubpp'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/lib_tmp/Config.pm'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/lib_tmp/Config_heavy.pl'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/lib_tmp/config.h'.

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/lib_tmp/perllocal.pod'.

spawning 'rm -rf  /oracle/EM/agent/agent_13.2.0.0.0/perl/bin_tmp'

spawning 'rm -rf /oracle/EM/agent/agent_13.2.0.0.0/perl/lib_tmp'

 Component : oracle.perlint.expat 2.0.1.0.1

Setting up 'oracle.perlint.expat 2.0.1.0.1 '

 Component : oracle.perlint.modules 5.14.4.0.1

Setting up 'oracle.perlint.modules 5.14.4.0.1 '

instantiating '/oracle/EM/agent/agent_13.2.0.0.0/perl/modules_lib_tmp/mk.pm'.

spawning 'rm -rf /oracle/EM/agent/agent_13.2.0.0.0/perl/modules_lib_tmp'

Setup successful

Save inventory pending...

Saving inventory
.................. 89%

Saving inventory complete
.................. 90%

Configuration complete
Logs successfully copied to /oracle/oraInventory/logs.
 Agent Software install completed

Creating symlink /oracle/EM/agent/agent_13.2.0.0.0/oracle_common/jdk/bin /oracle/EM/agent/agent_13.2.0.0.0/jdk/bin
Executing command to check/apply patches if exist in agenthome.....
/oracle/EM/agent/agent_13.2.0.0.0/perl/bin/perl /oracle/EM/agent/agent_13.2.0.0.0/install/oneoffs/apply_NewOneoffs.pl /oracle/EM/agent/agent_13.2.0.0.0 true
The ORACLE HOME is /oracle/EM/agent/agent_13.2.0.0.0The install isLocal is trueThe command is opatch napply -invPtrLoc /oracle/EM/agent/agent_13.2.0.0.0/oraInst.loc -silent   -local

 Unjarring the oneoff 24470104.zip ...
 /oracle/EM/agent/agent_13.2.0.0.0/oracle_common/jdk/bin/jar xvf /oracle/EM/agent/agent_13.2.0.0.0/install/oneoffs/agent/24470104.zip
  created: 24470104/
 inflated: 24470104/README.txt
  created: 24470104/files/
  created: 24470104/files/oracle.sysman.agent.ic/
  created: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/
  created: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/
  created: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/
  created: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/
  created: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/
  created: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/
  created: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/net/
  created: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/net/ns/
 inflated: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/net/ns/NSProtocol.class
  created: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/net/nt/
 inflated: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/net/nt/TcpsNTAdapter.class
 inflated: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/net/nt/SSLSocketChannel.class
 inflated: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/net/nt/TcpsConfigure.class
 inflated: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/net/nt/CustomSSLSocketFactory.class
  created: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/net/resolver/
 inflated: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/net/resolver/AddrResolution.class
  created: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/jdbc/
 inflated: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/jdbc/OracleConnection$DatabaseShutdownMode.class
 inflated: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/jdbc/OracleConnection.class
  created: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/jdbc/driver/
 inflated: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/jdbc/driver/T4CConnection$1.class
 inflated: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/jdbc/driver/NTFListener.class
 inflated: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/jdbc/driver/PhysicalConnection.class
 inflated: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/jdbc/driver/NTFAQRegistration.class
 inflated: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/jdbc/driver/PhysicalConnection$1.class
 inflated: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/jdbc/driver/T4CConnection$ReplayMode.class
 inflated: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/jdbc/driver/PhysicalConnection$DrcpState.class
 inflated: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/jdbc/driver/T4CConnection$3.class
 inflated: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/jdbc/driver/PhysicalConnection$2.class
 inflated: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/jdbc/driver/PhysicalConnection$3.class
 inflated: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/jdbc/driver/NTFConnection.class
 inflated: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/jdbc/driver/T4CConnection$2.class
 inflated: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/jdbc/driver/T4CConnection.class
 inflated: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/jdbc/driver/PhysicalConnection$BufferCacheStore.class
 inflated: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/jdbc/driver/PhysicalConnection$4.class
 inflated: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/jdbc/driver/NTFManager.class
 inflated: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/jdbc/OracleConnection$CommitOption.class
 inflated: 24470104/files/oracle.sysman.agent.ic/13.2.0.0.0/oracle.sysman.agent.ic.symbol/jdbc/lib/ojdbc7.jar/oracle/jdbc/OracleConnection$DatabaseStartupMode.class
  created: 24470104/etc/
  created: 24470104/etc/config/
 inflated: 24470104/etc/config/actions.xml
 inflated: 24470104/etc/config/inventory.xml
patches exist in /oracle/EM/agent/agent_13.2.0.0.0

 Applying opatch for the oneoffs 24470104 ...
 /oracle/EM/agent/agent_13.2.0.0.0/OPatch/opatch napply -invPtrLoc /oracle/EM/agent/agent_13.2.0.0.0/oraInst.loc -silent   -local  -oh /oracle/EM/agent/agent_13.2.0.0.0 -phBaseFile /oracle/EM/agent/agent_13.2.0.0.0/patch.txt
Oracle Interim Patch Installer version 13.8.0.0.0
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


Oracle Home       : /oracle/EM/agent/agent_13.2.0.0.0
Central Inventory : /oracle/oraInventory
   from           : /oracle/EM/agent/agent_13.2.0.0.0/oraInst.loc
OPatch version    : 13.8.0.0.0
OUI version       : 13.8.0.0.0
Log file location : /oracle/EM/agent/agent_13.2.0.0.0/cfgtoollogs/opatch/opatch2017-12-06_12-00-09PM_1.log


OPatch detects the Middleware Home as "/oracle/EM/agent"

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   24470104

Do you want to proceed? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
All checks passed.
Backing up files...
Applying interim patch '24470104' to OH '/oracle/EM/agent/agent_13.2.0.0.0'

Patching component oracle.sysman.agent.ic, 13.2.0.0.0...
Patch 24470104 successfully applied.
Log file location: /oracle/EM/agent/agent_13.2.0.0.0/cfgtoollogs/opatch/opatch2017-12-06_12-00-09PM_1.log

OPatch succeeded.

 Finished one-offs apply...

 Deleting the files...

 Finished deleting the above files...
Copying Install logs to /oracle/EM/agent/agent_13.2.0.0.0/cfgtoollogs/agentDeploy .....
Entered Post Install...

Relaxing execute  permission for other users  on /oracle/EM/agent/agent_13.2.0.0.0/install for bug#20005612
/bin/chmod: cannot access `/oracle/EM/agent/agent_13.2.0.0.0/plugins': No such file or directory
Finished post install
Plugin txt:
Inside if ,  is empty
oracle.sysman.oh|13.2.0.0.0| |agentPlugin
oracle.sysman.oh|13.2.0.0.0| |discoveryPlugin
/oracle/EM/agent/agent_13.2.0.0.0/oracle_common/jdk/jre/bin/java -classpath /oracle/EM/agent/agent_13.2.0.0.0/jlib/agentInstaller.jar:/oracle/EM/agent/agent_13.2.0.0.0/oui/modules/OraInstaller.jar:/oracle/EM/agent/agent_13.2.0.0.0/oui/modules/installer-launch.jar oracle.sysman.agent.installer.AgentPluginInstaller /oracle/EM/agent/agent_13.2.0.0.0 /oracle/EM/agent_img/plugins
/oracle/EM/agent/agent_13.2.0.0.0/oracle_common/jdk/jre/bin/java -classpath /oracle/EM/agent/agent_13.2.0.0.0/oui/modules/OraInstaller.jar:/oracle/EM/agent/agent_13.2.0.0.0/oui/modules/emCfg.jar:/oracle/EM/agent/agent_13.2.0.0.0/jlib/agentInstaller.jar oracle.sysman.agent.installer.AgentFreshInstaller /oracle/EM/agent/agent_13.2.0.0.0 /oracle/EM/agent/agent_inst /oracle/EM/agent RESPONSE_FILE=/oracle/EM/agent/agentInstall.rsp  $args
The AgentFreshInstaller is starting now
Oraclehome : ../oracle/EM/agent/agent_13.2.0.0.0
InstanceHome : /oracle/EM/agent/agent_inst
Agent Base Directory : /oracle/EM/agent
The oraclehome /oracle/EM/agent/agent_13.2.0.0.0
Dec 06, 2017 12:00:44 PM oracle.sysman.agent.installer.AgentInstaller parseResponseFile
INFO: /oracle/EM/agent/agent_13.2.0.0.0
Dec 06, 2017 12:00:44 PM oracle.sysman.agent.installer.AgentInstaller parseResponseFile
INFO: /oracle/EM/agent/agent_inst
Dec 06, 2017 12:00:44 PM oracle.sysman.agent.installer.AgentInstaller parseResponseFile
INFO: /oracle/EM/agent
Dec 06, 2017 12:00:44 PM oracle.sysman.agent.installer.AgentInstaller parseResponseFile
INFO: RESPONSE_FILE=/oracle/EM/agent/agentInstall.rsp
Dec 06, 2017 12:00:44 PM oracle.sysman.agent.installer.AgentInstaller parseResponseFile
INFO: AGENT_BASE_DIR=/oracle/EM/agent
Dec 06, 2017 12:00:44 PM oracle.sysman.agent.installer.AgentInstaller parseResponseFile
INFO: RESPONSE_FILE=/oracle/EM/agent_img/agent.rsp
Dec 06, 2017 12:00:44 PM oracle.sysman.agent.installer.AgentInstaller parseResponseFile
INFO: OMS_HOST=srvoms
Dec 06, 2017 12:00:44 PM oracle.sysman.agent.installer.AgentInstaller parseResponseFile
INFO: EM_UPLOAD_PORT=4903
Dec 06, 2017 12:00:44 PM oracle.sysman.agent.installer.AgentInstaller parseResponseFile
INFO: AGENT_INSTANCE_HOME=/oracle/EM/agent/agent_inst
Dec 06, 2017 12:00:44 PM oracle.sysman.agent.installer.AgentInstaller parseResponseFile
INFO: ORACLE_HOSTNAME=srvagent.dominio
Dec 06, 2017 12:00:44 PM oracle.sysman.agent.installer.AgentInstaller parseResponseFile
INFO: EM_INSTALL_TYPE="AGENT"
Dec 06, 2017 12:00:44 PM oracle.sysman.agent.installer.AgentInstaller parseResponseFile
INFO: ORACLE_HOME=/oracle/EM/agent/agent_13.2.0.0.0
Dec 06, 2017 12:00:44 PM oracle.sysman.agent.installer.AgentInstaller parseResponseFile
INFO: OMS_HOST=srvoms
Dec 06, 2017 12:00:44 PM oracle.sysman.agent.installer.AgentInstaller parseResponseFile
INFO: EM_UPLOAD_PORT=4903
Dec 06, 2017 12:00:44 PM oracle.sysman.agent.installer.AgentInstaller parseResponseFile
INFO: AGENT_INSTANCE_HOME=/oracle/EM/agent/agent_inst
Dec 06, 2017 12:00:44 PM oracle.sysman.agent.installer.AgentInstaller parseResponseFile
INFO: ORACLE_HOSTNAME=srvagent.dominio
Dec 06, 2017 12:00:44 PM oracle.sysman.agent.installer.AgentInstaller parseResponseFile
INFO: EM_INSTALL_TYPE="AGENT"
Dec 06, 2017 12:00:44 PM oracle.sysman.agent.installer.AgentInstaller parseResponseFile
INFO: ORACLE_HOME=/oracle/EM/agent/agent_13.2.0.0.0
Dec 06, 2017 12:00:44 PM oracle.sysman.agent.installer.AgentInstaller parseResponseFile
INFO: EMCTLCFG_MODE=NONE
Dec 06, 2017 12:00:44 PM oracle.sysman.agent.installer.AgentInstaller parseResponseFile
INFO: OMS_HOST=srvoms
Dec 06, 2017 12:00:44 PM oracle.sysman.agent.installer.AgentInstaller parseResponseFile
INFO: EM_UPLOAD_PORT=4903
Dec 06, 2017 12:00:44 PM oracle.sysman.agent.installer.AgentInstaller parseResponseFile
INFO: AGENT_INSTANCE_HOME=/oracle/EM/agent/agent_inst
Dec 06, 2017 12:00:44 PM oracle.sysman.agent.installer.AgentInstaller parseResponseFile
INFO: ORACLE_HOSTNAME=srvagent.dominio
Dec 06, 2017 12:00:44 PM oracle.sysman.agent.installer.AgentInstaller parseResponseFile
INFO: EM_INSTALL_TYPE="AGENT"
Dec 06, 2017 12:00:44 PM oracle.sysman.agent.installer.AgentInstaller parseResponseFile
INFO: ORACLE_HOME=/oracle/EM/agent/agent_13.2.0.0.0
Writing the following contents into /oracle/EM/agent/agent_13.2.0.0.0/install/oragchomelist
/oracle/EM/agent/agent_13.2.0.0.0:/oracle/EM/agent/agent_inst
Both /etc/oragchomelist and /var/opt/oracle/oragchomelist does not exist.
The value of chainInstall : false forceConfigure : false skipValidation : false
Validating oms host & port with url: https://srvoms:4903/empbs/genwallet
Validating oms host & port with url: http://srvoms:4903/empbs/genwallet
The status is 0
Validated the oms host and port :- srvoms----4903
Getting Inet Addresses for host srvagent
** Agent Port Check completed successfully.**
Validated the agent port :- ----3872
shared agent value is :false
Agent Mode is None
Agent Configuration completed successfully
The following configuration scripts need to be executed as the "root" user. Root script to run : /oracle/EM/agent/agent_13.2.0.0.0/root.sh
Waiting for agent targets to get promoted...
Successfully Promoted agent and its related targets to Management Agent

Executando o script solicitado como root:

[root@srv=agent agent]# /oracle/EM/agent/agent_13.2.0.0.0/root.sh
Finished product-specific root actions.
/etc exist

Creating /etc/oragchomelist file...

Verificando o status do agent instalado:


srv=agent-> $AGENT_HOME/bin/emctl status agent
Oracle Enterprise Manager Cloud Control 13c Release 2
Copyright (c) 1996, 2016 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version          : 13.2.0.0.0
OMS Version            : 13.2.0.0.0
Protocol Version       : 12.1.0.1.0
Agent Home             : /oracle/EM/agent/agent_inst
Agent Log Directory    : /oracle/EM/agent/agent_inst/sysman/log
Agent Binaries         : /oracle/EM/agent/agent_13.2.0.0.0
Core JAR Location      : /oracle/EM/agent/agent_13.2.0.0.0/jlib
Agent Process ID       : 34568
Parent Process ID      : 34395
Agent URL              : https://srvagent.dominio:3872/emd/main/
Local Agent URL in NAT : https://srvagent.dominio:3872/emd/main/
Repository URL         : https://srvoms:4903/empbs/upload
Started at             : 2017-12-06 12:01:36
Started by user        : oracle
Operating System       : Linux version 2.6.32-573.7.1.el6.x86_64 (amd64)
Number of Targets      : 4
Last Reload            : (none)
Last successful upload                       : 2017-12-06 12:09:35
Last attempted upload                        : 2017-12-06 12:09:35
Total Megabytes of XML files uploaded so far : 0.58
Number of XML files pending upload           : 0
Size of XML files pending upload(MB)         : 0
Available disk space on upload filesystem    : 21.86%
Collection Status                            : Collections enabled
Heartbeat Status                             : Ok
Last attempted heartbeat to OMS              : 2017-12-06 12:09:48
Last successful heartbeat to OMS             : 2017-12-06 12:09:48
Next scheduled heartbeat to OMS              : 2017-12-06 12:10:48

---------------------------------------------------------------
Agent is Running and Ready

Referência:
https://docs.oracle.com/cd/E63000_01/EMADV/install_agent_usng_rsp.htm#EMADV145
Mais informações →
Postagens mais antigas Página inicial

Translate

# ACE Program

#Oracle

#Oracle
Disclaimer: The views expressed on this blog are my own and do not necessarily reflect the views of Oracle.

#Blog reconhecido

#ARTICULISTA

Marcadores

Postagens populares