Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus login without password
You must connect as a ops$ user:
take a look as your parameter os_authent_prefix (svrmgrl; connect internal; show parameter os_auth) you should get a result as:
os_authent_prefix string ops$
now create a user in the database with the same name as your unix user but with a leading string OPS$
now you can connect to the database with sqlplus /
(Sorry for my bas english)
Steve wrote:
>
> Hi,
>
> I would like to do some cron job from unix server which needs to login to
> sqlplus first. I export anything necessary, e.g. oracle home, path,
> ora_env, ... But sqlplus still requests a password before excuting the
> batch process. I have no problem working on sqldba with the same
> setting.
>
> Anyone, please help!
>
> Thanks.
>
> Steve
Received on Tue Dec 01 1998 - 01:57:10 CST