sqlplus -s

Hi Everyone,

Quick Question. I am running a ksh script and trying to login to sqlplus.
When I put

SQLPLUS=${ORACLE_HOME}/bin/sqlplus
$SQLPLUS -s/ <
It keeps bombing, asking for a password.

when I run it without the -s, it works. Does anyone have an answer for this.

Thanks,
Kathy

of course, you have a space between the -s and /, right? Post the block of code that doesn't work...

It means that your OS authnetication had not been setin your init.ora parameter. Verify the docs on how to set that up.

Sam

No I do not have a space between the -s/. Now this works on another box, alright.

I checked the init file and here are the settings I have.

remote_os_authent = true # enable remote ops$ logins
os_authent_prefix=ops$

After this hot backup runs I will put the -s back in and see if I am still getting the same errors. I don't get it because i thought the -s just means running in silent mode.

Anymore thoughts,

update here is the code that doesn't work

SQLPLUS=${ORACLE_HOME}/bin/sqlplus
$SQLPLUS -s/ <

here is the code that does:
SQLPLUS=${ORACLE_HOME}/bin/sqlplus
$SQLPLUS / <
Thx,

Yes, -s is just silent mode. No output from SQLPLUS will be sent to the screen.

To check to make sure OS authentication is active, try sqlplus without the -s flag. It sounds like you have tried that and it works...

This works for me:

sqlplus -s /@dbname << EOF
select count(*) from user_objects;
exit
EOF


This also works fine for me:


export SQLPLUS=$ORACLE_HOME/bin/sqlplus
$SQLPLUS -s /@dbname << EOF
select count(*) from user_objects;
exit
EOF


Check your

sqlnet.ora: sqlnet.authentication_services = (NTS)


Sam

Quote:

---

Originally posted by kburrows
update here is the code that doesn't work

SQLPLUS=${ORACLE_HOME}/bin/sqlplus
$SQLPLUS -s/ <

here is the code that does:
SQLPLUS=${ORACLE_HOME}/bin/sqlplus
$SQLPLUS / <
Thx,

---

I might be repeating the obvious, but Jeff has allready pointed at the source of your trubles (it just might be that you missunderstood his point): you *need* a space between -s parameter and your slash.

Instead of

$SQLPLUS -s/ << EOF

use

$SQLPLUS -s / << EOF


As for Sam's suggestion: isnt the sqlnet.authentication_services = (NTS) relevant only for NT environment?

[Edited by jmodic on 06-14-2001 at 03:31 PM]

I will try it with the space.

And Yes, I think the sqlnet is for NT, I am running unix box 4.

Jurij, point well said.

Yes, I'm not present in this world, when I was posting that message. You are correct, it is for NT.

Too much of thinking for today !!!

http://www.plauder-smilies.de/nut.gif
Sam