Have you created a password file? Cheers Harshan -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of dba1 mcc Sent: Wednesday, December 31, 2008 7:40 AM To: oracle-l@xxxxxxxxxxxxx Subject: how to login as "SYS" on sqlplus I tried to login as "sys" and test "sys" password. I can NOT make it work. Any ideal? ========================================================== %sqlplus sys/passwd@T102 as sysdba SQL*Plus: Release 10.2.0.4.0 - Production on Tue Dec 30 21:01:39 2008 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. ERROR: ORA-01031: insufficient privileges Enter user-name: -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l