DATABASE MACHINE ABC

[orasam@abc ~]$ sqlplus /nolog

SQL*Plus: Release 9.2.0.5.0 - Production on Wed Oct 1 14:34:38 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> conn sys/1234@sam
ERROR:
ORA-28009: connection to sys should be as sysdba or sysoper


SQL> conn sys/1234@sam as sysdba
Connected.
SQL> show parameter remote_login_passwordfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile            string      EXCLUSIVE

SQL> select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP
------------------------------ ----- -----
SYS                            TRUE  TRUE

REMOTE MACHINE XYZ

SQL> !tnsping sam

TNS Ping Utility for Linux: Version 8.0.6.3.0 - Production on 01-OCT-2008 22:47:08

(c) Copyright 1997 Oracle Corporation.  All rights reserved.

Attempting to contact (ADDRESS=(PROTOCOL=tcp)(HOST=abc.panaji.com)(PORT=1531))
OK (220 msec)

SQL> conn sys/1234@sam
ERROR:
ORA-28009: connection to sys should be as sysdba or sysoper


SQL> conn sys/1234@sam as sysdba
ERROR:
ORA-01031: insufficient privileges