sys account 2004-04-19 - By biti_rainy
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= (NTS)
Best regards
yahoo id: feng_chunpei
msn: biti_rainy@(protected)
====== from the mail=========
>use orapwd to recreate your password file
>
>-- --Original Message-- --
>From: oracle-l-bounce@(protected)
>[mailto:oracle-l-bounce@(protected)]On Behalf Of Fahd Mirza
>Sent: 19 April 2004 16:33
>To: oracle-l@(protected)
>Subject: sys account
>
>
>Hi experts,
> I have got a problem. The problem is that when I connect to my =
>database (8.1.6) from sys
>like this
> svrmgrl > connect sys/syspassword@(protected)
>I get connected.
>But when i try to connect as sysdba like this
> svrmgrl > connect sys/syspassword@(protected) as sysdba
>I get the following error.
>ORA-01017 (See ORA-01017.ora-code.com): 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@(protected)
>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@(protected)
>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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
