Home » All posts
ORA-28000 - Desbloqueando usuário
Problema
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;
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-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:
http://help.sap.com/saphelp_nw04/helpdata/en/c4/3a615d505211d189550000e829fbbd/frameset.htm
Abraços
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
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.
-
Link para download http://www.microsoft.com/en-us/download/details.aspx?id=1944.
-
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