Re: Not able to connect from another unix account

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 26 Dec 2005 20:07:01 +0100
Message-ID: <2lf0r1hbhm07g70jtndr9difs1i8br4h1r@4ax.com>

On 26 Dec 2005 06:48:50 -0800, "News" <Contact_404_at_hotmail.com> wrote:

>It seems that the problem is different cause I could connect using
>
>sqlplus system/manager_at_orcl.world
>
>where orcl.world is defined in tsnames.ora
>
>I remember it's so only in 10g (and not in 9i) and from account other
>the oracle.
>any explanation ?

Normal behavior in *all* versions.
You are using two different protocols.
Likely orcl.world uses TCP/IP
The method using ORACLE_SID uses BEQ.
The comments with respect to not running root.sh and incorrect privileges still stand.
If you don't want to *solve* the problem, then by all means change all your scripts. They will get *slower* because of this, and use more network traffic.

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Dec 26 2005 - 13:07:01 CST