Re: "/ as sysdba" Failes But "sys/password@service_name" Works ???

idogan_tech_at_yahoo.com (Ibrahim DOGAN) wrote in message news:<6bf58828.0402251154.bfd587b_at_posting.google.com>...
> I'm trying to connect to a remote Oracle database from a Unix box.
>
> Unix : AIX 4.3.3.
> Oracle: 8.1.7
>
> $> sqlplus sys/syspassword_at_my_db_name
> Connected.
>
> perfectly works
>
> but, the following commands generate ORA-12545: error, any idea why ? :
>
> $> export ORACLE_SID=my_db_name
> $> sqlplus "/ as sysdba"
> ERROR:
> ORA-12545: Connect failed because target host or object does not exist
>
> i.d.

Because when you are connecting from a remote machine, you have to do so via the Listener, which means use a tnsnames alias (or its centralised names resolution equivalent) which is what your first example does. When you fail to suppl an alias, Oracle expects to find an instance named the same as your ORACLE_SID *running on that machine*, not on a remote one.

Your second example's error message, when roughly translated into ordinary English, actually reads "'Ere mate: there's no instance called "my_db_name" running on your PC".

Regards
HJR Received on Wed Feb 25 2004 - 17:39:21 CST