0516-787 extendlv: Maximum allocation for logical volume

Cenário
- É necessário realizar um extend no logical volume.

Problema
maq1@root:/:#chfs -a size=+54G /oracle/TST/data1
0516-787 extendlv: Maximum allocation for logical volume tstdata1lv is 512.

Oracle x Sql Server

Comparativo Oracle vs Sql Server
  
 Para quem procura um documento interessante sobre a comparação entre o Oracle e o Sql Server, pode encontrar muitas respostas neste documento da Oracle.

Identificando o nome do message server


Solução
- Acesse a SMMS.

Instalação do iFix - APAR

AIX

Referencia
- IBM

Solução
- Enviar o arquivo *.epkg.Z no formato binário via FTP para o diretório /tmp.

- Simulando a aplicação do ifix.
#emgr -pXe IV11188s01.111212.epkg.Z

maq01@root:/tmp:#emgr -pXe IV11188s01.111212.epkg.Z
*******************************************************************************
EFIX MANAGER PREVIEW START
*******************************************************************************
+-----------------------------------------------------------------------------+
Efix Manager Initialization
+-----------------------------------------------------------------------------+
Initializing log /var/adm/ras/emgr.log ...
Efix package file is: /tmp/IV11188s01.111212.epkg.Z
MD5 generating command is /usr/bin/csum
MD5 checksum is 024181fff901192c9be25518f1209519
Accessing efix metadata ...
Processing efix label "IV11188s01" ...
Verifying efix control file ...

+-----------------------------------------------------------------------------+
Installp Prerequisite Verification
+-----------------------------------------------------------------------------+
Verifying prerequisite file ...
Checking prerequisites ...

Prerequisite Number: 1
   Fileset: bos.rte.printers
   Minimal Level: 6.1.7.0
   Maximum Level: 6.1.7.0
   Actual Level: 6.1.7.0
   Type: PREREQ
   Requisite Met: yes

All prerequisites have been met.

+-----------------------------------------------------------------------------+
Processing APAR reference file
+-----------------------------------------------------------------------------+
ATTENTION: Interim fix is enabled for automatic removal by installp.

+-----------------------------------------------------------------------------+
Efix Attributes
+-----------------------------------------------------------------------------+
LABEL:            IV11188s01
PACKAGING DATE:   Mon Dec 12 05:58:30 CST 2011
ABSTRACT:         efix for IV11188.
PACKAGER VERSION: 7
VUID:             00CCCC5B4C00121205123011
REBOOT REQUIRED:  no
BUILD BOOT IMAGE: no
PRE-REQUISITES:   yes
SUPERSEDE:        no
PACKAGE LOCKS:    no
E2E PREREQS:      no
FIX TESTED:       no
ALTERNATE PATH:   None
EFIX FILES:       2

Install Scripts:
   PRE_INSTALL:   yes
   POST_INSTALL:  no
   PRE_REMOVE:    yes
   POST_REMOVE:   no

File Number:      1
   LOCATION:      /usr/lib/lpd/pio/etc/piomisc_ext
   FILE TYPE:     Standard (file or executable)
   INSTALLER:     installp
   SIZE:          32
   ACL:           DEFAULT
   CKSUM:         15016
   PACKAGE:       printers.rte
   MOUNT INST:    no

File Number:      2
   LOCATION:      /usr/lib/lpd/pio/etc/piorlfb
   FILE TYPE:     Standard (file or executable)
   INSTALLER:     installp
   SIZE:          16
   ACL:           DEFAULT
   CKSUM:         61547
   PACKAGE:       printers.rte
   MOUNT INST:    no

+-----------------------------------------------------------------------------+
Efix Description
+-----------------------------------------------------------------------------+
========================== EFIX DESCRIPTION =============================
Enter the EFIX description. Please include the symptoms that are fixed by
this EFIX, all additional install details, and any other information that
would be useful to the USER. Save and exit the editor to return to epkg.
=========================================================================
IV11188         - Add a Remote queue with local filter fails with 6100-07.
Symptoms        - Adding a remote queue with local filter gives error.
Cause           - In smit -p option is already used in case of local filter to specify the printer type.
                With code change in 61Q -p is used twice in case of local filter.
Workaround      - Change -p(small) to -P(capital) in smit screen. Modify the piorlfb file to accept -p option.

Note : Stop the qdaemon before installing the efix.

+-----------------------------------------------------------------------------+
Efix Lock Management
+-----------------------------------------------------------------------------+
Checking locks for file /usr/lib/lpd/pio/etc/piomisc_ext ...
Checking locks for file /usr/lib/lpd/pio/etc/piorlfb ...

All files have passed lock checks.

+-----------------------------------------------------------------------------+
Space Requirements
+-----------------------------------------------------------------------------+
Checking space requirements ...

Space statistics (in 512 byte-blocks):
File system: /usr, Free: 6231656, Required: 1306, Deficit: 0.
File system: /tmp, Free: 11513592, Required: 2567, Deficit: 0.

+-----------------------------------------------------------------------------+
Reboot Processing
+-----------------------------------------------------------------------------+
Reboot is not required by this efix package.

*******************************************************************************
EFIX MANAGER PREVIEW END
*******************************************************************************

+-----------------------------------------------------------------------------+
Operation Summary
+-----------------------------------------------------------------------------+
Log file is /var/adm/ras/emgr.log

EPKG NUMBER       LABEL               OPERATION              RESULT
===========       ==============      =================      ==============
1                 IV11188s01          INSTALL PREVIEW        SUCCESS

Return Status = SUCCESS

- Para instalar o ifix, execute o comando emgr. Não é necessário reiniciar o sistema operacional.

Ex:
#emgr -Xe IV11188s01.111212.epkg.Z

maq01@root:/tmp:#emgr -Xe IV11188s01.111212.epkg.Z
+-----------------------------------------------------------------------------+
Efix Manager Initialization
+-----------------------------------------------------------------------------+
Initializing log /var/adm/ras/emgr.log ...
Efix package file is: /tmp/IV11188s01.111212.epkg.Z
MD5 generating command is /usr/bin/csum
MD5 checksum is 024181fff901192c9be25518f1209519
Accessing efix metadata ...
Processing efix label "IV11188s01" ...
Verifying efix control file ...

+-----------------------------------------------------------------------------+
Installp Prerequisite Verification
+-----------------------------------------------------------------------------+
Verifying prerequisite file ...
Checking prerequisites ...

Prerequisite Number: 1
   Fileset: bos.rte.printers
   Minimal Level: 6.1.7.0
   Maximum Level: 6.1.7.0
   Actual Level: 6.1.7.0
   Type: PREREQ
   Requisite Met: yes

All prerequisites have been met.

+-----------------------------------------------------------------------------+
Processing APAR reference file
+-----------------------------------------------------------------------------+
ATTENTION: Interim fix is enabled for automatic removal by installp.

+-----------------------------------------------------------------------------+
Efix Attributes
+-----------------------------------------------------------------------------+
LABEL:            IV11188s01
PACKAGING DATE:   Mon Dec 12 05:58:30 CST 2011
ABSTRACT:         efix for IV11188.
PACKAGER VERSION: 7
VUID:             00CCCC5B4C00121205123011
REBOOT REQUIRED:  no
BUILD BOOT IMAGE: no
PRE-REQUISITES:   yes
SUPERSEDE:        no
PACKAGE LOCKS:    no
E2E PREREQS:      no
FIX TESTED:       no
ALTERNATE PATH:   None
EFIX FILES:       2

Install Scripts:
   PRE_INSTALL:   yes
   POST_INSTALL:  no
   PRE_REMOVE:    yes
   POST_REMOVE:   no

File Number:      1
   LOCATION:      /usr/lib/lpd/pio/etc/piomisc_ext
   FILE TYPE:     Standard (file or executable)
   INSTALLER:     installp
   SIZE:          32
   ACL:           DEFAULT
   CKSUM:         15016
   PACKAGE:       printers.rte
   MOUNT INST:    no

File Number:      2
   LOCATION:      /usr/lib/lpd/pio/etc/piorlfb
   FILE TYPE:     Standard (file or executable)
   INSTALLER:     installp
   SIZE:          16
   ACL:           DEFAULT
   CKSUM:         61547
   PACKAGE:       printers.rte
   MOUNT INST:    no

+-----------------------------------------------------------------------------+
Efix Description
+-----------------------------------------------------------------------------+
========================== EFIX DESCRIPTION =============================
Enter the EFIX description. Please include the symptoms that are fixed by
this EFIX, all additional install details, and any other information that
would be useful to the USER. Save and exit the editor to return to epkg.
=========================================================================
IV11188         - Add a Remote queue with local filter fails with 6100-07.
Symptoms        - Adding a remote queue with local filter gives error.
Cause           - In smit -p option is already used in case of local filter to specify the printer type.
                With code change in 61Q -p is used twice in case of local filter.
Workaround      - Change -p(small) to -P(capital) in smit screen. Modify the piorlfb file to accept -p option.

Note : Stop the qdaemon before installing the efix.

+-----------------------------------------------------------------------------+
Efix Lock Management
+-----------------------------------------------------------------------------+
Checking locks for file /usr/lib/lpd/pio/etc/piomisc_ext ...
Checking locks for file /usr/lib/lpd/pio/etc/piorlfb ...

All files have passed lock checks.

+-----------------------------------------------------------------------------+
Space Requirements
+-----------------------------------------------------------------------------+
Checking space requirements ...

Space statistics (in 512 byte-blocks):
File system: /usr, Free: 6231656, Required: 1306, Deficit: 0.
File system: /tmp, Free: 11513592, Required: 2567, Deficit: 0.

+-----------------------------------------------------------------------------+
Efix Installation Setup
+-----------------------------------------------------------------------------+
Unpacking efix package file ...
Initializing efix installation ...

+-----------------------------------------------------------------------------+
Pre-Install Script
+-----------------------------------------------------------------------------+
Executing pre-install script ...
ODM data changed sucessfully
Return code from pre-install script is: 0

+-----------------------------------------------------------------------------+
Efix State
+-----------------------------------------------------------------------------+
Setting efix state to: INSTALLING

+-----------------------------------------------------------------------------+
File Archiving
+-----------------------------------------------------------------------------+
Saving all files that will be replaced ...
Save directory is: /usr/emgrdata/efixdata/IV11188s01/save
File 1: Saving /usr/lib/lpd/pio/etc/piomisc_ext as EFSAVE1 ...
File 2: Saving /usr/lib/lpd/pio/etc/piorlfb as EFSAVE2 ...

+-----------------------------------------------------------------------------+
Efix File Installation
+-----------------------------------------------------------------------------+
Installing all efix files:
Installing efix file #1 (File: /usr/lib/lpd/pio/etc/piomisc_ext) ...
Installing efix file #2 (File: /usr/lib/lpd/pio/etc/piorlfb) ...

Total number of efix files installed is 2.
All efix files installed successfully.

+-----------------------------------------------------------------------------+
Package Locking
+-----------------------------------------------------------------------------+
Processing package locking for all files.
File 1: locking installp fileset printers.rte.
File 2: installp fileset printers.rte is already locked by emgr.

All package locks processed successfully.

+-----------------------------------------------------------------------------+
Reboot Processing
+-----------------------------------------------------------------------------+
Reboot is not required by this efix package.

+-----------------------------------------------------------------------------+
Efix State
+-----------------------------------------------------------------------------+
Setting efix state to: STABLE

+-----------------------------------------------------------------------------+
Operation Summary
+-----------------------------------------------------------------------------+
Log file is /var/adm/ras/emgr.log

EPKG NUMBER       LABEL               OPERATION              RESULT
===========       ==============      =================      ==============
1                 IV11188s01          INSTALL                SUCCESS

Return Status = SUCCESS

- Para remover um ifix.

Ex:
#emgr -rL IV11188s01

Abraços

Localizando versão SAP Netweaver

Para encontrar qual a versão do SAP Netweaver utilizada, siga os passos abaixo.

1- Abra o menu System -> Status.


Desmontando fita no TSM

TSM
Problema
- Fita no drive com status de Idle.

Solução
- Para desmontar a fita e automaticamente ela retornar ao seu slot de origem, basta executar o comando dismount.

Abrindo conexão HTTP Connect - URLAccess


Referencia
Note 592085 - Installing HTTP Connect service
Solução
- Acesse o SAP MarketPlace.
- Entre no menu Help & Support -> Connect to SAP.
- Clique em Maintain Connections.

Erro durante EHP - Upgrade still running: Logon not possible

Problema:
- Durante a aplicação de EHP a aplicação SAP não permite o logon, retornando a seguinte mensagem:

Upgrade still running: Logon not possible

Webinar - Oracle SPARC e Solaris


Oracle SPARC e Solaris
Performance Máxima para Aplicações de Missão Crítica
Os servidores Oracle SPARC rodando Solaris são a solução ideal para as aplicações de missão crítica que exigem as melhores tecnologias em confiabilidade, disponibilidade, escalabilidade e gerenciabilidade.

A família de servidores SPARC inclui sistemas projetados para performance maxima em todas as camadas de aplicações, desde aplicações web concomitantes até aplicações corporativas complexas e data warehouses

WebCast VMWare - Introdução rápida ao VMware vCenter Operations Manager 5

Pessoal,
  Para se inscrever no Webcast basta clicar aqui e realizar o cadastro.

Detalhes
Parte 2 de um curso de duas partes que usa demonstrações ao vivo do produto para ensinar aos administradores como usar a interface de usuário personalizada do vCOps Enterprise.

Abraços

DR_DMA_MIGRATE_FAIL

Aix

Problema
LABEL:          DR_DMA_MIGRATE_FAIL
IDENTIFIER:     4DA8FE60

Date/Time:       Mon Aug 20 22:44:51 BRT 2012
Sequence Number: 11662
Machine Id:      000ACB9AD400
Node Id:         unbru02
Class:           S
Type:            TEMP
WPAR:            Global
Resource Name:   DR_KER_MEM

Description
Memory related DR operation failed

Probable Causes
DMA activity to memory being removed

RCP - 0826-813 Permission is denied.


Problema
0826-813 Permission is denied.

Solução
- Ajuste os arquivos .rhosts e o /etc/hosts.equiv

Abraços

RCP - 3004-330 Your encrypted password is invalid

AIX

Problema 
[files]: 3004-330 Your encrypted password is invalid.

Solução 
- Execute o comando para corrigir 

# pwdck -y ALL

- Continue normalmente ajustando a senha do usuário desejado.

# passwd root 

# passwd username 

Abraços

Entrevista com Mauro Peres: Futuro dos negócios e evolução de TI

Quer saber como preparar sua empresa para o futuro e sobre a evolução no setor de TI?

Então confira a entrevista com Mauro Peres no SAP Mobile Experience 2012, presidente da IDC



Abraços

Commit Update Aix

- Entre no gerenciador do Aix.

# smit
->  Software Installation and Maintenance 
- > Software Maintenance and Utilities 
-> Commit Applied Software Updates (Remove Saved Files)

- Selecione a opção PREVIEW only? com YES e execute.

Erro: 0403-006 Execute permission denied

Problema
ksh[24]: /usr/lib/instl/sm_inst: 0403-006 Execute permission denied.

Solução
- Faça login com o usuário root e execute novamente.

Abraços

ORA-28000 - Desbloqueando usuário


Problema
SYS@TST> conn system/teste;
ERROR:
ORA-28000: the account is locked

Solução

- Alterando a senha do usuário system.
SYS@TST>alter user system identified by "teste@2012";

User altered.

- Desbloqueando o usuário

Erro ORA-03113


Problema
- Depois de um shutdown abort.

ORA-03113: end-of-file on communication channel
Process ID: 6750302
Session ID: 85 Serial number: 3


Restart serviço IBM TSM Client


- Verificamos qual o UID do processo em execução.



maq01@root:/:#ps -ef | grep dsmc
    root  4849864        1   0   Aug 03      -  0:03 /usr/tivoli/tsm/client/ba/bin/dsmcad

- Finalizamos este processo.


Exibir histórico de atualizações

Para exibir o histórico de atualizações no Oracle, execute a consulta a seguir.


SELECT TO_CHAR(registry$history.action_time, 'DD/MM/YYYY') "DATE", comments 
 FROM registry$history;



Abraços

Error Errpt 0315-132,0315-180,0315-171,0315-141


Problema:
Quando nós verificamos os erros do sistema operacional AIX, obtemos o erro:

# errpt
0315-132 The supplied error
log is not valid: /var/adm/ras/errlog.
0315-180 logread: UNEXPECTED EOF
0315-171 Unable to process the error log file /var/adm/ras/errlog.
0315-141 errpt: invalid error log entry length: 538976288 at offset: 49209


# ls -l  /var/adm/ras/errlog
-rw-rw-r--   1 root     system            0 Mar 09 13:40 /var/adm/ras/errlog


Profile Parameters - Default Profile e Instance Profile

Os parâmetros podem estar na default profile ou na instance profile. Estes arquivos estão configurados como a figura abaixo:


Antes de um processo SAP ler o parâmetro da profile, realiza a seguinte verificação:
  • Verifica se o parâmetro existe na instance profile
  • Caso não exista, o processo verifica se o parâmetro está configurado na default profile.
Se o parâmetro não for encontrado em ambos profiles, o valor padrão para o parâmetro será usado para a inicialização do ERP.

Se possível, tenha certeza de que o parâmetro esteja configurado apenas na default ou na instance profile.

Fonte

http://help.sap.com/saphelp_nw04/helpdata/en/c4/3a615d505211d189550000e829fbbd/frameset.htm

Abraços

Error reading BR*Tools profile

Problema


maq01:oratst 8> brtools
BR0651I BRTOOLS 7.20 (23)
BR0252E Function fopen() failed for '/oracle/TST/102_64/dbs/initTST.sap' at location BrInitSapRead-1
BR0253E errno 2: No such file or directory
BR0159E Error reading BR*Tools profile /oracle/TSA/102_64/dbs/initTST.sap

BR0280I BRTOOLS time stamp: 2012-08-24 16.09.02
BR0654I BRTOOLS terminated with errors



Solução

Verifique se o arquivo init<SID>.sap esta com o SID correto, caso não esteja altere-o.

maq01:oratst 18> mv initPPP.sap initTST.sap


maq01:oratst 19> brtools
BR0651I BRTOOLS 7.20 (23)

BR0280I BRTOOLS time stamp: 2012-08-24 16.11.22
BR0656I Choice menu 1 - please make a selection
-------------------------------------------------------------------------------
BR*Tools main menu

 1 = Instance management
 2 - Space management
 3 - Segment management
 4 - Backup and database copy
 5 - Restore and recovery
 6 - Check and verification
 7 - Database statistics
 8 - Additional functions
 9 - Exit program

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:


Abraços

Instalando pacote de idiomas no IE


Problema



Solução

- Para resolver o problema do Internet Explorer (IE) em inglês, basta instalar o pacote de idioma em português.


- Faça download do pacote IE9-Windows6.1-LanguagePack-x64-ptb.msu.



OPatch failed with error code 73

Problema

maq01:oratst 18> $ORACLE_HOME/OPatch/opatch lsinventory
Invoking OPatch 10.2.0.4.3

Oracle Interim Patch Installer version 10.2.0.4.3
Copyright (c) 2007, Oracle Corporation.  All rights reserved.


Oracle Home       : /oracle/TST/102_64
Central Inventory : /oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.4.3
OUI version       : 10.2.0.4.0
OUI location      : /oracle/TST/102_64/oui
Log file location : /oracle/TST/102_64/cfgtoollogs/opatch/opatch2012-08-22_10-35-42AM.log

List of Homes on this system:

  Home name= TSB_102_64, Location= "/oracle/TSB/102_64"
  Home name= OraDb11g_home1, Location= "/oracle/TST/112_64"
Inventory load failed... OPatch cannot load inventory for the given Oracle Home.
Possible causes are:
   Oracle Home dir. path does not exist in Central Inventory
   Oracle Home is a symbolic link
   Oracle Home inventory is corrupted
LsInventorySession failed: OracleHomeInventory gets null oracleHomeInfo

OPatch failed with error code 73

Solução

maq01:oratsa 32> cd $ORACLE_HOME/oui/bin
maq01:oratsa 33> ./attachHome.sh
Starting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /oracle/oraInventory
'AttachHome' was successful.


Obs: Se a instalação for originada de um restore, edite o script attachHome.sh e altere os SID dos diretórios.


Abraços