![]() |
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| oracle connection from shell script | DILEEP410 | Shell Programming and Scripting | 4 | 07-01-2009 03:19 AM |
| Command/script to find size of Unix Box ? | sakthifire | Shell Programming and Scripting | 6 | 06-18-2008 03:07 AM |
| unix script to check whether particular file exists and to find its size | Balachandar | Shell Programming and Scripting | 9 | 02-05-2008 03:56 AM |
| shell script to find files by date and size | dadadc | UNIX for Dummies Questions & Answers | 1 | 10-20-2007 06:18 AM |
| Shell script to Find file size | ragsnovel | Shell Programming and Scripting | 1 | 08-10-2007 11:01 AM |
![]() |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
||||
|
Hi,
I need to execute a script to find the tablespace size in oracle.But i get an error. ![]() Script Executed:- #!/bin/ksh ORACLE_SID= oracelinstance ORACLE_HOME= oracle path PATH=$ORACLE_HOME/bin export ORACLE_SID ORACLE_HOME PATH sqlplus username/password@oracle_instance <<-EOF set serveroutput on whenever sqlerror exit 1; spool /tmp/tab_tmp.log connect sys/standard as sysdba; select tablespace_name, round((sum(bytes)/1024/1024),2) size_in_mb, sum(greatest(maxbytes,bytes))/1024/1024 total_available, round(((sum(bytes)/1024/1024)/(sum(greatest(maxbytes,bytes))/1024/1024)),2) pct_used from DBA_DATA_FILES group by tablespace_name order by 1; spool off EOF exit 0 Error : SQL> SQL> connect sys/standard as sysdba; Connected to an idle instance. SQL> SQL> select tablespace_name, round((sum(bytes)/1024/1024),2) size_in_mb,sum(greatest(maxbytes,bytes))/1024/1024 total_available, round(((sum(bytes)/1024/1024)/(sum(greatest(maxbytes,bytes))/1024/1024)),2) pct_used from DBA_DATA_FILES group by tablespace_name order by 1; select tablespace_name, round((sum(bytes)/1024/1024),2) size_in_mb, sum(greatest(maxbytes,bytes))/1024/1024 total_available, round(((sum(bytes)/1024/1024)/(sum(greatest(maxbytes,bytes))/1024/1024)),2) pct_used from DBA_DATA_FILES group by tablespace_name order by 1 * ERROR at line 1: ORA-01034: ORACLE not available |
![]() |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|