ansaurus

Question

Answer 1

A:

When running CONNECT inside SQL*Plus, remove the quotes:

CONNECT myuser/mypass@mydb

They double quotes are required if you are passing the credentials as an argument to sqlplus:

sqlplus "myuser/mypass@mydb"

, for the shell to parse myuser/mypass@mydb as a single argument if you have spaces in your connection identifier or use additional options like AS SYSDBA.

Quassnoi 2010-01-28 16:59:08

Tried that. No effect.

Wade Williams 2010-01-28 17:31:52

@Wade: Does it connect from a command line with the same credentials?

Quassnoi 2010-01-28 17:39:25

Yes. sqlplus myuser/mypass@mydb works fine.

Wade Williams 2010-01-28 17:55:14

@Wade: does you script fail only when run under `cron`? Could you please put `CONNECT myuser/mypass@mydb` into a `file.sql` and run `sqlplus /nolog @file.sql`?

Quassnoi 2010-01-28 18:04:06

I'm not running it under cron yet. What you describe is what I was doing. However, the key difference is that I wasn't using the /nolog option. With that option, it works. Thanks for the help.

Wade Williams 2010-01-28 18:32:42

Answer 2

A:

Use the /NOLOG option.

sqlplus /nolog @myscript

Jeffrey Kemp 2010-01-29 02:23:07

oh, I see you've already got that... :)

Jeffrey Kemp 2010-01-29 02:23:57

ansaurus

tags:

views:

answers:

Should CONNECT work in SQL*PLUS script?

related questions