Friday, August 25, 2017

How to get DB ID when database in nomount state?

Issue below command in nomount state.
alter session set tracefile_identifier = DBID_TRACE;

alter system dump datafile 'C:\APP\ORACLE\ORADATA\TESTDB\SYSTEM01.DBF' block min 1 block max 10;

check the trace file

Start dump data block from file C:\APP\ORACLE\ORADATA\TESTDB\SYSTEM01.DBF minblk 1 maxblk 10
 V10 STYLE FILE HEADER:
Compatibility Vsn = 202375680=0xc100200
Db ID=2736190072=0xa316f278, Db Name='TESTDB'
Activation ID=0=0x0

Tuesday, August 15, 2017

ORA-27069: attempt to do I/O beyond the range of the file

Error:

[oracle@cloud1 rdbms]$ sqlplus "/as sysdba"


SQL*Plus: Release 12.1.0.2.0 Production on Mon Aug 14 19:23:07 2017

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

ORA-27069: attempt to do I/O beyond the range of the file
Additional information: 479
Additional information: 1
Additional information: 472
ORA-27069: attempt to do I/O beyond the range of the file
Additional information: 479
Additional information: 1
Additional information: 472


Workaround:

trace sqlplus session

strace -o /tmp/problem_strace_sysdba.out -fTtt sqlplus / as sysdba

18885 19:20:43.797919 stat("/u01/app/oracle/audit/test12/", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0 .000011="">
18885 19:20:43.798632 stat("/u01/app/oracle/audit/test12/ora_audit_00.bin", {st_mode=S_IFREG|0640, st_size=241664, ...}) = 0 <0 .000010="">
18885 19:20:43.798682 open("/u01/app/oracle/audit/test12/ora_audit_00.bin", O_RDONLY) = 14 <0 .000010="">
18885 19:20:43.799524 stat("/u01/app/oracle/audit/test12/ora_audit_00.bin", {st_mode=S_IFREG|0640, st_size=241664, ...}) = 0 <0 .000009="">
18885 19:20:43.799578 stat("/u01/app/oracle/audit/test12/ora_audit_00.bin", {st_mode=S_IFREG|0640, st_size=241664, ...}) = 0 <0 .000008="">
18885 19:20:43.799622 open("/u01/app/oracle/audit/test12/ora_audit_00.bin", O_RDONLY) = 14 <0 .000009="">
18885 19:20:43.799758 stat("/u01/app/oracle/audit/test12/ora_audit_00.bin", {st_mode=S_IFREG|0640, st_size=241664, ...}) = 0 <0 .000008="">
18885 19:20:43.799803 open("/u01/app/oracle/audit/test12/ora_audit_00.bin", O_RDONLY) = 14 <0 .000009="">
18885 19:20:43.799967 statfs("/u01/app/oracle/audit/test12/ora_audit_00.bin", {f_type="EXT2_SUPER_MAGIC", f_bsize=4096, f_blocks=15173137, f_bfree=2119411, f_bavail=1350712, f_files=3858432, f_ffree=3546627, f_fsid={-11706456, 1069661174}, f_namelen=255, f_frsize=4096}) = 0 <0 .000010="">
18885 19:20:43.800015 open("/u01/app/oracle/audit/test12/ora_audit_00.bin", O_RDONLY) = 14 <0 .000009="">
18885 19:20:43.800150 open("/u01/app/oracle/audit/test12/ora_audit_00.bin", O_RDWR|O_DSYNC) = 14 <0 .000010="">
18885 19:20:43.803933 stat("/u01/app/oracle/audit/test12/", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0 .000011="">
18885 19:20:43.804003 stat("/u01/app/oracle/audit/test12/ora_audit_00.bin", {st_mode=S_IFREG|0640, st_size=241664, ...}) = 0 <0 .000012="">
18885 19:20:43.804062 open("/u01/app/oracle/audit/test12/ora_audit_00.bin", O_RDONLY) = 15 <0 .000016="">
18885 19:20:43.805632 stat("/u01/app/oracle/audit/test12/ora_audit_00.bin", {st_mode=S_IFREG|0640, st_size=241664, ...}) = 0 <0 .000011="">
18885 19:20:43.805691 stat("/u01/app/oracle/audit/test12/ora_audit_00.bin", {st_mode=S_IFREG|0640, st_size=241664, ...}) = 0 <0 .000008="">
18885 19:20:43.805735 open("/u01/app/oracle/audit/test12/ora_audit_00.bin", O_RDONLY) = 15 <0 .000012="">
18885 19:20:43.805945 stat("/u01/app/oracle/audit/test12/ora_audit_00.bin", {st_mode=S_IFREG|0640, st_size=241664, ...}) = 0 <0 .000009="">
18885 19:20:43.805992 open("/u01/app/oracle/audit/test12/ora_audit_00.bin", O_RDONLY) = 15 <0 .000009="">
18885 19:20:43.806076 statfs("/u01/app/oracle/audit/test12/ora_audit_00.bin", {f_type="EXT2_SUPER_MAGIC", f_bsize=4096, f_blocks=15173137, f_bfree=2119406, f_bavail=1350707, f_files=3858432, f_ffree=3546626, f_fsid={-11706456, 1069661174}, f_namelen=255, f_frsize=4096}) = 0 <0 .000009="">
18885 19:20:43.806123 open("/u01/app/oracle/audit/test12/ora_audit_00.bin", O_RDONLY) = 15 <0 .000009="">
18885 19:20:43.806241 open("/u01/app/oracle/audit/test12/ora_audit_00.bin", O_RDWR|O_DSYNC) = 15 <0 .000009="">


remove or rename ora_audit_00.bin


Tuesday, August 8, 2017

Oracle Support Matrix

Release Schedule of Current Database Releases (Doc ID 742060.1)