Re: Scheduled batch process fail to connect to Oracle

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Tue, 21 Dec 2004 22:52:52 +0100
Message-ID: <ul6hs059066djpe59uu7rm0kcmhdck6hse@4ax.com>

On 21 Dec 2004 12:28:15 -0800, uzlanerv_at_yahoo.com (Vladimir Uzlaner) wrote:

>Suppose user login is user/password. Then MKS connect to Oracle using
>OPS$USER/password login. I think problem is in '$' sign, because for
>Korn shell it is special character. And if we put:

check out the os_authent_prefix init.ora parameter. It's current default is an empty string.
Also if you did set up OS authentication properly the connect string is simply
sqlplus /@<service>
NOT
sqlplus ops$user/password_at_service

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Dec 21 2004 - 15:52:52 CST