Database Administration (MOSC)

MOSC Banner

oracle scripting issue

edited Sep 19, 2014 5:01AM in Database Administration (MOSC) 1 commentAnswered

Hello,

The script runs fine as below:

#!/bin/ksh

for i in `cat cataloglist1.dat`

do

set echo on

sqlplus RCAT_CMORET/rcat @rman_catalog.sql

done

However,when I use $i in sqlplus $i/pwd then it hangs

#!/bin/ksh

for i in `cat cataloglist1.dat`

do

set echo on

sqlplus $i/rcat @rman_catalog.sql

done

Please assist.I need to execute rman_catalog.sql in 124 user schemas which are listed in a file.How should I use the script?

Best regards,

Vishal

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center