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...