Search Results

Hi All,

I have written a new script to check for DB space and size of dump log file before it can be imported into a Oracle DB.
I'm relatively new to shell scripting.
Please help me optimize...

Oracle Solaris and am using korn shell

Thanks for your inputs.

ksh tester
tester[4]: syntax error at line 1 : `<' unexpected

I still get an error

I'm using korn shell.

sh tester
tester: syntax error at line 4: `(' unexpected

Please advise

Hi,

I have a file which has a date extension to it.
Like <filename>_01012014.

I need to rename the file as 12152013 , that is i need to be able to subtract 15 days from the date of the file...

Hi,
I'm a newbie to shell programming and have just written a small program to transfer files.

# job variables
RunMode=$1

export DATETIME=`date +%Y%m%d%H%M%S`
export STARTTIME=`date...

I have a shell script which calls a sql script.
But in the output file I'm getting an additional '^L' character.
Please advise how this is to be handled.
spool...

So will it be ln -s /p11/prod/stagein01/ stagein01.

Regards,
VN

We have a NFS mount p11/prod/stagein01/ on one of the servers.
We need to have a softlink 'stagein01' pointing to this Filesystem.

Regards,
VN

Hi,
I need to create a link as stagein01 for the /p11/prod/stagein01/.
Please let me know the procedure for the same.

Regards,
VN

Hi,

This file is loaded using sql loader.
There is a bad record created and i need to delete this record.

Regards,
VN

Hi,
I need to delete one row from a .dat file.
error processing column PCT_USED in row 1053295 for datafile /exp/stats/ts_stats.dat
ORA-01722: invalid number

This is used to load records using...

Hi ,

On one of my solaris server I getan error whenever I use df -h as below.

df: unknown option: h
Usage: df [-F FSType] [-abegklntVv] [-o FSType-specific_options] [directory | block_device |...

Hi,

We have a new server which has 2.7 TB RAW Disk.Outof this we want to convery 1.2 TB to filesystem and nfs mount it on one of the servers.
After our activity we need to convert this back to...

We are facing an issue setting up Display on our server.

Thu Jan 5 17:09:01 2012
vncext: VNC extension running!
vncext: Listening for VNC connections on port 5905
vncext: ...

Hi,

We have a requirement wherein we do not want to share the Oracle DB sys and system passwords to be shared with the support desk.
But they will be responsible for starting/shuting down the...

Hi,

I need to install Oracle on HP-UX 11.23.But I'm unable to start xclock to check if x-server is working fine or not.
Have tried connecting using reflection but no luck.
Have also set the...

Hi,

Is there a way to clear the temp files from /var/tmp?
Is root access required to delete the files?

Thanks,
Narayan

Hi,
I need to take a tar backup of a dir on AIX.
Pls let me know the command for the same.

Thanks,
Narayan

Thanks a lot.

Regards,
Narayan

Thanks for the reply.But is it possible that I can get the output and run it?As I'm working as a dba this may not be always feasible.

Hi,

Is there a way to kill all processes belonging to one user in one shot?

Thanks,
Narayan

Hi,

I am creating two shell scripts for Database backup and the output has to be routed to nohup.out file.

We will also be running the scripts in the background as
nohup.out <script_name> &...

Hi,

The size of the backup file is 0 bytes.
Its not copying any files for backup.

-rw-r--r-- 1 appldev1 dba 0 Jun 29 08:34 oraInventory_062909.tgz

This is on AIX.
...

Hi,

I need to modify a script wherein need to use gzip instead of compress.
The script is
# cat dly_appsfiles_bkp.ksh
#
# dly_appsfiles_bkp.ksh
#
date_stamp=`date +%m%d%y`...