Unlock Oracle

Ulock oracle after note shutdown during backup   xhost:/dev/diskgroup # ll total 0 lrwxrwxrwx 1 root root 54 2015-12-14 14:50 dg_data -> /dev/disk/by-id/scsi-360022a11000e1c4c21965a9300000006 lrwxrwxrwx 1 root root 54 2015-12-14 14:50 dg_index -> /dev/disk/by-id/scsi-360022a11000e1c4c2196629300000007 lrwxrwxrwx 1 root root 8 2015-12-14 14:50 dg_ora -> /dev/sdb xhost:/dev/diskgroup # su – grid grid@xhost:~> crsctl stat res -t ——————————————————————————– NAME… Read More Unlock Oracle

Oracle AWS report

oracle@xxxx01a:/oracle/app/product/11g/db/rdbms/admin> sqlplus / as sysdba SQL*Plus: Release 11.1.0.7.0 – Production on Thu Sep 5 14:36:04 2013 Copyright (c) 1982, 2008, Oracle.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit Production With the Partitioning, Oracle Label Security, OLAP, Data Mining, Oracle Database Vault and Real Application Testing options SQL> @awrrpt.sql… Read More Oracle AWS report