Search Results

Hi experts,

I have the below details with me.How to calculate the tablespace growth between two dates.

sample data(have data upto 1 year):


INSTANCE_NAME DATE TABLESPACE_NAME ...

Hi Experts,

I am trying to write a shell script to change DB user password.
Requirement:
login to multiple DBs as multiple users and change their respective passwords.
ex :users:T1,T2,T3...

Hi Experts,

I am trying to write script to find the FS usage.

My requirement is first i need to gather all the mountpoint details.like below.
df -k 2> /dev/null | awk '{print "FS=" $1 "\tMP="...

Hi Anbu,

NR < 5 Worked!!! Thanks.

I need to display the output into HTML table.I tried <table> tags and but i need to convert the output using script.Could you help me with this.

Still the same :confused:

awk 'NR<3 ; /^-/{getline; print}' part.log


DB1 XYZ BILLED 820 2014_06_30 109
DB2 XYZ DATA ...

Hi Anbu/Scrutinizer
Thanks for the commands.
But your command returns data without headers

awk 'NR<3 ||/^-/{getline; print}' part.log

DB1 XYZ BILLED 820 ...

Hi Gurus,

I have a shell script which connects to mulitple DBs and run some queries and output will be written to log file.I need the consolidated output (html format will be better)from the...

Hi Experts,

I have a list of Dbs.In that DBs i need to execute some sql scripts.
each sql script is unique and it should run on particular DB only.
For example. i have DBs like...

Hi Experts,

I have a log file like this.I need to filter the Index name and elapsed time(only created ).

06:36:39 SQL> create index XYZ_F75 on XYZ
06:36:39 2 ("GRP_ID", "_ID") parallel...

Actually i am running the script from different location
say /app/test...

the oratab file is the exactly same as the mentioned

blank :(

what u want to know
host $ sh -x test.ksh
+ awk -F[#:*] NF==3&&$1~/./{print $1} /var/opt/oracle/oratab

awk -F[#:*] NF==3&&$1~/./{print $1} /var/opt/oracle/oratab

thanks for the script
when i execute this i am getting nothing,
can u please explain the awk part?

for line in `awk -F"[#:*]" 'NF==3&&$1~/./{print $1}' /var/opt/oracle/oratab` ; do
ps -ef|grep...

the problem is all of the below mentioned DBs will run on that server.if any one of DB goes down,i need to start up that particular DB.

ya there are multiple entries..
the problem is all of the below mentioned DBs will run on that server.if any one of DB goes down,i need to start up that particular DB.
...

check_stat=`ps -ef|grep ${ORACLE_SID}|grep pmon|wc -l`;
oracle_num=`expr $check_stat`
if [ $oracle_num -lt 1 ]
then
exit 0
fi


i tried this.. but the problem is ORACLE_SID is not set. the...

EXPERTS,
I need a UNIX shell script to check the DBs status (Running/Shutdown) in the server.If its Running then no issue but if it is in shutdown state ,it should prompt like " DB is shut down you...

EXPERTS,
I need a shell script to check the DBs status (Running/Shutdown) in the server.If its Running then no issue but if it is in shutdown state ,it should prompt like " DB is shut down you want...

this is the code .the content of output.log is in (refer to my 1st post)$dir=file('D:/test/');
$lines=array();
$temp=array();
$result=array();

$fp=fopen('output.log', 'r');
while (!feof($fp))...

thanks Space.
for your information i am using array that will read from that log file.is this possible to done using array indexes??

Hi All,

i have a log file .i want to cut and filter using some conditions in PHP
condition 1:first i want to filter the datas having "P12345"
condition 2:cut the session ID and time stamp(i.e...

i have a text file
15728710[01/03/2013 18:16:35]
15728710[01/03/2013 18:16:35]
15728710[01/03/2013 18:16:35]
15728710[01/03/2013 18:16:35]
15728710[01/03/2013 18:16:35]
15728710[01/03/2013...

Also a small additional modifiaction ..in the below output



15728710[01/03/2013 18:16:35]
15728710[01/03/2013 18:16:35]
15728710[01/03/2013 18:48:35]
15729310[01/03/2013 18:48:35]...

Hi i have a log file
P12345_15728710[01/03/2013 18:16:35]:DEBUG:Begin
P12345_15728710[01/03/2013 18:16:35]:DEBUG:Being
P12345_15729310[01/03/2013 18:48:35]:DEBUG:GetAgen...