OracleStudy case -- OracleSqlplus Error

OracleStudy case -- OracleSqlplus error system environment: Operating System: AIX5.3 Database: Oracle10gR2 case analysis: 1. View space information [oracle @ aix220 ~] $ Df-mFilesystemMB & nbs ..

OracleStudy case -- OracleSqlplus error system environment: Operating System: AIX5.3 Database: Oracle10gR2 case analysis: 1. View space information [oracle @ aix220 ~] $ Df-mFilesystemMB & nbs ..

Oracle Study case -- Oracle Sqlplus Error

System Environment:

Operating System: AIX5.3

Database: Oracle 10gR2

Case Analysis:

1. View spatial information [oracle @ aix220 ~] $ Df-mFilesystem MB blocks Free % Used Iused % Iused Mounted on/dev/hd4 17408.00 1238.15 93% 37699 12%/dev/hd2 8192.00 6310.39 23% 46534/usr/dev/hd9var 4% 1725.55 16% 1704 1%/var/dev/hd3 2048.00 1902.58 8% 420 1%/tmp/dev/fwdump 3072.00 3071.21 1% 1% 4 2048.00/var/adm/ras/platform/dev/hd1 1821.98 12% 74 1%/home/proc--/proc/dev/hd10opt 2048.00 1374.77 33% 8934 3%/opt/dev/lv00 1 024.00 991.80 4% 18 1%/var/adm/csd/dev/arch 10240.00 8347.63 19% 15360.00/dev/lv02 10097.80 35% 123693 4%/u012, View File Permissions [oracle @ aix220 ~] $ Ls-ld/u01/app/oracle/admin/master/drwxr-x --- 8 oracle dba 512 Feb 17/u01/app/oracle/admin/master/[oracle @ aix220 ~] $ Ls-ld/u01/app/oracle/admin/master/adump/drwxr-x --- 2 oracle dba 1536 Feb 17/u01/app/oracle/admin/master/adump /3. view the file system information [oracle @ aix220 dbs] $ cat/etc/filesystems/u01: dev =/dev/lv02 vfs = jfs log =/dev/loglv00 mount = true options = rw account = false [root @ aix220/] # lsvg-l limit levg1_levg: lv name type LPs PPs PVs lv state mount POINTloglv00 jfslog 1 1 1 closed/syncd N/Alv02 jfs 120 120 1 closed/syncd/u01 [root @ aix220/] # df-mFilesystem MB blocks Free % Used Iused % Iused Mounted on/dev/hd4 17408.00 1238.18 93% 37700 12% // dev/hd2 8192.00 6310.39 23% 46534 4%/usr/dev/hd9var 2048.00 1725.56 16% 1704 1%/var/dev/hd3 2048.00 1902.58 8% 420 1%/tmp/dev/fwdump 3072.00 3071.21 1% 4 1%/var /adm/ras/platform/dev/hd1 2048.00 1821.98 12% 74 1%/home/proc--/proc/dev/hd10opt 2048.00 1374.77 33% 8934 3%/opt/dev/lv00 1024.00 991.80 4% 18 1%/var/adm/csd/dev/arch 10240.00 8347.63 19% 1%/arch/dev/lv01 5120.00 4959.25 4% 16 1%/flash/dev/lv03 25600.00 24796.43 4% 17 1%/home/oracle/arch_masterrhel152: /backup/cuug15/storage30 14111.05 13052.23 8% 31 1%/backupmount file system failure: [root @ aix220/] # mount/u01Replaying log for/dev/lv02.mount: /dev/lv02 on/u01: Unformatted or incompatibl E mediaThe superblock on/dev/lv02 is dirty. run a full fsck to fix. file System Repair: [root @ aix220/] # fsck-y/dev/lv02 ...... ** Phase 5-Check Inode Map ** Phase 6-Check Block MapBad Block Map (SALVAGED) ** Phase 6b-Salvage Block MapSuperblock is marked dirty (FIXED) 123665 files 10749336 blocks 20707944 free ****** Filesystem was modified ****** mount the file system successfully: [root @ aix220/] # mount/u01 [root @ aix220/] # df-mFile System MB blocks Free % Used Iused % Iused Mounted on/dev/hd4 17408.00 1238.16 93% 37699 12% 8192.00 // dev/hd2 6310.39 23% 46534 4% 2048.00/usr/dev/hd9var 1725.55 16% 1704 1%/var/dev/hd3 2048.00 1902.58 8% 420 1%/tmp/dev/fwdump 3072.00 3071.21 1% 1% 4 2048.00/var/adm/ras/platform/dev/hd1 1821.98 12% 1% 74 /home/proc---/proc/dev/hd10opt 2048.00 1374.77 33% 8934/opt/dev/lv00 3% 99 1.80 4% 18 1%/var/adm/csd/dev/lv02 15360.00 10111.30 35% 123674 4%/u01 run the sqlplus command successfully: [root @ aix220/] # su-oracle [oracle @ aix220 ~] $ Sqlplus '/as sysdba' SQL * Plus: Release 10.2.0.1.0-Production on Tue Feb 17 19:46:03 2015 Copyright (c) 1982,200 5, Oracle. all rights reserved. connected to an idle instance. SQL>