Re: RE: sys account

From: biti_rainy <biti_rainy_at_itpub.net>
Date: Mon, 19 Apr 2004 17:43:49 +0800
Message-Id: <20040419093133.758A172CBC4@turing.freelists.org>

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

=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_at_freelists.org
>[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Fahd Mirza
>Sent: 19 April 2004 16:33
>To: oracle-l_at_freelists.org
>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_at_test
>I get connected.
>But when i try to connect as sysdba like this
> svrmgrl> connect sys/syspassword_at_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_at_freelists.org
>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
>----------------------------------------------------------------=

=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_at_freelists.org 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
-----------------------------------------------------------------

Received on Mon Apr 19 2004 - 04:39:08 CDT