original

 Hello Sir,
       we are using Linux AS 2.1 and oracle 9.2.0

I want to connect as sysdba from client machine running on window.
I have setup my tnsnames.ora and able to connect with any other user
except SYS ...



db_name = db1
sid     = siddb1


[oracle@localhost dbs]$ orapwd file=orapwsiddb1 password=test
[oracle@localhost dbs]$ ll
total 12
-rw-r--r--    1 oracle   dba           417 Apr  6 11:46 initsiddb1.ora
-rw-r--r--    1 oracle   dba           543 Apr  7 12:26 initsiddb2.ora
-rwSr-----    1 oracle   dba          1536 Apr 12 17:06 orapwsiddb1

path change. ..

[oracle@localhost admin]$ cat sqlnet.ora

sqlnet.authentication_services(ALL)

ON SERVER 
-----------
ORACLE instance started.

Total System Global Area  269553824 bytes
Fixed Size                   450720 bytes
Variable Size             184549376 bytes
Database Buffers           83886080 bytes
Redo Buffers                 667648 bytes
Database mounted.
Database opened.
SQL>
SQL> show parameter remote

NAME                                 TYPE        VALUE
------------------------------------ ----------- 
---------------------remote_archive_enable                string      true
remote_dependencies_mode             string      TIMESTAMP
remote_listener                      string
remote_login_passwordfile            string      EXCLUSIVE
remote_os_authent                    boolean     FALSE
remote_os_roles                      boolean     FALSE
SQL>

FROM CLIENT
----------------

SQL> conn test/test@db1
Connected.


SQL> conn sys/test@db1 as sysdba
ERROR:
ORA-01031: insufficient privileges


Warning: You are no longer connected to ORACLE.
SQL> 
SQL> 
SQL> conn sys@db1 as sysdba
Enter password: ****
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> conn "sys@db1 as sysdba"
Enter password: ****
ERROR:
ORA-12560: TNS:protocol adapter error




I got three differ. errors. . 

Could you pls. tell me .. how can we setup this ... 

Thanks,
Abhi .. 



 

 
and we said...

I cannot reproduce.  Please make sure your password file did not change AFTER 
database startup.  bounce your database and if it doesn't persist, the password 
file was changed after startup.

Consider:


C:\Documents and Settings\Administrator>sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Mon Apr 12 09:55:48 2004

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

SQL> connect sys/test@ora9ir2.us.oracle.com as sysdba;
Connected.
SQL> connect sys@ora9ir2.us.oracle.com as sysdba
Enter password:
Connected.
SQL> connect "sys@ora9ir2.us.oracle.com as sysdba"
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error


Warning: You are no longer connected to ORACLE.
SQL>


the third should fail, it is "wrong".  The first two should succeed.  If I 
simply recreate my password file:


[ora9ir2@tkyte-pc dbs]$ rm orapw$ORACLE_SID
[ora9ir2@tkyte-pc dbs]$ orapwd file=orapw$ORACLE_SID password=test

I immediately get:

SQL> connect sys@ora9ir2.us.oracle.com as sysdba
Enter password:
ERROR:
ORA-01031: insufficient privileges


on the windows client.  so, i think you did things in a different order than 
you say above perhaps...