Hi guys,
I am facing issues while triggering sqlplus with "/" option
I can connect to database with USER ID and password. but, if i just specify "/" option since it is "externally identiifed user" it doesn't work
Any suggestions?
mail me @ Removed.
Regards, Giri
Please read our rules. In particular:
(10) Don't post your email address and ask for an email reply. The forums are for the benefit of all, so all Q&A should take place in the forums.
Ok.. finally found the solution.. with lots of (re)search..
here is the solution
1) user (say ops$usr1 should be externally identiifed user is Oracle)
2) Define the OS_AUTHENT_PREFIX parameter in the init.ora to define the prefix used in the Oracle usernames:
OS_AUTHENT_PREFIX=OPS$
3) set ORACLE_HOME and ORACLE_SID while calling sqlplus
This should work