Re: RE: sys account

hi,Sinardy Xing

  SQL> show parameters remote_login_passwordfile 

NAME                                 TYPE        VALUE
------------------------------------ -----------=
 ------------------------------
remote_login_passwordfile            string      EXCLUSIVE
SQL> 

if the remote_login_passwordfile is set to  NONE ,you can  not =
 use password file . 
add the os user to DBA group (windows is ora_dba group) , if use=
 windows  or  nt ,plz modify the the  file sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES=3D (NTS)

  

Best regards

yahoo id: feng_chunpei
msn: biti_rainy@xxxxxxxxxxx

=3D=3D=3D=3D=3D=3D from the  mail=3D=3D=3D=3D=3D=3D=3D=3D=3D
>use orapwd to recreate your password file
>
>-----Original Message-----
>From: oracle-l-bounce@xxxxxxxxxxxxx
>[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Fahd Mirza
>Sent: 19 April 2004 16:33
>To: oracle-l@xxxxxxxxxxxxx
>Subject: sys account
>
>
>Hi experts,
>    I have got a problem. The problem is that when I connect to=
 my =3D
>database (8.1.6) from sys
>like this
>  svrmgrl> connect sys/syspassword@test
>I get connected.
>But when i try to connect as sysdba like this
>  svrmgrl> connect sys/syspassword@test as sysdba
>I get the following error.
>ORA-01017: invalid username/password; logon denied
>Please help me, as I have to restart the instance urgently.
>Thanks
>regards,
>Fahd
>----------------------------------------------------------------=

>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------=

>To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>----------------------------------------------------------------=
-
>
>----------------------------------------------------------------=

>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------=

>To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>----------------------------------------------------------------=
-
>
>.


=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1



----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: