topic Re: problrm running script in Operating System - HP-UX

problrm running script

Cathy Arora — Fri, 07 Nov 2003 11:35:19 GMT

Thanks all,
I already had changed the permissions
(apologize for incomplete info)
However i added the location of my script with in the script and still I get the same error
and script looks like this
name of the script whoami

cd /home/kchinsky/scripts
show user
select * from global_name
exit

I logon to sqlplus
user/pasword
@whoami
and I get
SP2-0310: unable to open file "whoami.sql"
any help is appreciated

Re: problrm running script

Mark Greene_1 — Fri, 07 Nov 2003 12:05:35 GMT

If I am reading what you wrote correctly, it appears that you need to rename the script from whoami to whoami.sql

mark

Re: problrm running script

Umapathy S — Fri, 07 Nov 2003 12:06:51 GMT

By the way why are you naming a script on the lines of a unix command. It may confuse sometimes :-).

HTH,
Umapathy

Re: problrm running script

Jean-Luc Oudart — Fri, 07 Nov 2003 12:14:51 GMT

If your file is not whoami.sql but whoami.xxx you can also call :
sqlplus user/ @whoami.xxx

if no ext. is given .sql is assumed, hence the error message.

Rgds,
JL

Re: problrm running script

Michael Schulte zur Sur — Fri, 07 Nov 2003 12:53:35 GMT

Hi Cathy,

why is there a unix command in the sql script? Otherwise the others are correct. Without extension .sql ia assumed.

greetings,

Michael

Re: problrm running script

Alberto Ochoa — Fri, 07 Nov 2003 13:45:02 GMT

Cathy,

When in sqlplus, try running your script writing all the path (e.g. @/home/kchinsky/scripts/whoami.sql)
Also comment the cd /home/kchinsky/scripts line.

If you still have problems, if you have permissions, try running your script loging as oracle user and changing your scripts owner and group to match those of unix oracle user and try,just to be sure your script is running fine.

Alberto.

Re: problrm running script

Cathy Arora — Fri, 07 Nov 2003 15:35:48 GMT

HI all after a long break.
I took the unix code out of the script.
reason I had it to locate path for script but that was wrong. any how I tried to give a path as i was suggested but i still have a same error.
I did not quite undesrtand oracle user login etc.
I am logged on unix box with unix id/password, then I logged in sqlplus with oracle id and password.
and here I tried to run the script @/home/kchinsky/scripts/whoami.sql
and I have same error.
thanks again for your help.
any sugessions are welcome.
Regards,

Re: problrm running script

Cathy Arora — Fri, 07 Nov 2003 16:07:53 GMT

THnaks all. Problem fixed.

Re: problrm running script

Michael Schulte zur Sur — Sat, 08 Nov 2003 07:26:33 GMT

Hi Cathy,

would you please be so kine to award some points for the ones, who helped to solve the problem?

thanks,

Michael

Re: problrm running script

Michael Schulte zur Sur — Wed, 19 Nov 2003 12:23:00 GMT

Hi Cathy,

would you please be so kine to award some points for the ones, who helped to solve the problem?

thanks,

Michael

Re: problrm running script

Dave La Mar — Wed, 19 Nov 2003 13:21:27 GMT

Cathy -
Forget the points. Could you post the solution?

Regards,
dl