Search This Blog

Total Pageviews

Thursday 19 May 2011

ORA-00600: internal error code, arguments: [kzsviver:1], [], [], [], [], [],

in Oracle 11g

ORA-00600: internal error code, arguments: [kzsviver:1], [], [], [], [], [],

alter user xyz identified by values is null in pl sql block <<<<<<<<

example .....

my_text :=
'Alter user '
|| pwd.username
|| ' identified by values '
|| ''''
|| l_old_password
|| '''';
-- dbms_output.put_line(my_text);
EXECUTE IMMEDIATE (my_text);

Validate corruption via RMAN 11g

oracle@apt-amd-02:~> rman

Recovery Manager: Release 11.2.0.1.0 - Production on Thu May 19 09:31:35 2011

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

RMAN> connect target /

connected to target database: ORCL (DBID=1267852645)

RMAN> validate database check logical;

Starting validate at 19-MAY-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=58 device type=DISK
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00002 name=/opt/app/oracle/oradata/orcl/sysaux01.dbf
input datafile file number=00001 name=/opt/app/oracle/oradata/orcl/system01.dbf
input datafile file number=00003 name=/opt/app/oracle/oradata/orcl/undotbs01.dbf
input datafile file number=00004 name=/opt/app/oracle/oradata/orcl/users01.dbf
input datafile file number=00005 name=/opt/app/oracle/oradata/orcl/example01.dbf
input datafile file number=00008 name=/opt/app/oracle/oradata/orcl/tsapexu01.dbf
input datafile file number=00007 name=/opt/app/oracle/oradata/orcl/tsapexf01.dbf
input datafile file number=00006 name=/opt/app/oracle/oradata/orcl/anujtest.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:02:06
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
1 OK 0 14032 101125 9202958
File Name: /opt/app/oracle/oradata/orcl/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 69631
Index 0 13990
Other 0 3467

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
2 OK 0 22319 106254 9202956
File Name: /opt/app/oracle/oradata/orcl/sysaux01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 27420
Index 0 25986
Other 0 30515

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
3 OK 0 1 28800 9202958
File Name: /opt/app/oracle/oradata/orcl/undotbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 28799

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
4 OK 0 1710 27200 9178356
File Name: /opt/app/oracle/oradata/orcl/users01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 23370
Index 0 1357
Other 0 763

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
5 OK 0 1689 12804 9089116
File Name: /opt/app/oracle/oradata/orcl/example01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6607
Index 0 1261
Other 0 3243

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
6 OK 0 328 1280 7522828
File Name: /opt/app/oracle/oradata/orcl/anujtest.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 803
Index 0 0
Other 0 149

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
7 OK 0 6273 6400 8527760
File Name: /opt/app/oracle/oradata/orcl/tsapexf01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 127

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
8 OK 0 2648 12800 8826300
File Name: /opt/app/oracle/oradata/orcl/tsapexu01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 4606
Index 0 2615
Other 0 2931

channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
including current control file for validation
including current SPFILE in backup set
channel ORA_DISK_1: validation complete, elapsed time: 00:00:02
List of Control File and SPFILE
===============================
File Type Status Blocks Failing Blocks Examined
------------ ------ -------------- ---------------
SPFILE OK 0 2
Control File OK 0 600
Finished validate at 19-MAY-11

RMAN>


Recovery Manager complete.
oracle@apt-amd-02:~> !sql
sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu May 19 09:38:41 2011

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> SELECT * FROM v$database_block_corruption;

no rows selected

Oracle DBA

anuj blog Archive