-
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...
Jeff Hunter
-
It means that your OS authnetication had not been setin your init.ora parameter. Verify the docs on how to set that up.
Sam
Thanx
Sam
Life is a journey, not a destination!
-
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
Jeff Hunter
-
This also works fine for me:
export SQLPLUS=$ORACLE_HOME/bin/sqlplus
$SQLPLUS -s /@dbname << EOF
select count(*) from user_objects;
exit
EOF
Jeff Hunter
-
Check your
sqlnet.ora: sqlnet.authentication_services = (NTS)
Sam
Thanx
Sam
Life is a journey, not a destination!
-
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]
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
I will try it with the space.
And Yes, I think the sqlnet is for NT, I am running unix box 4.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|