Password file failure

[hamhey]

$ sqlplus hamhey/hamhey@soldb.dpi.net.ir

SQL*Plus: Release 8.1.5.0.0 - Production on Sun Jun 15 11:07:33 2003

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production

SQL> connect hamhey/hamhey as sysdba
Connected.

SQL> SQL> select * from v$pwfile_users order by 1;

USERNAME SYSDB SYSOP
------------------------------ ----- -----
HAMHEY TRUE TRUE
INTERNAL TRUE TRUE
ORACLE TRUE TRUE
SYS TRUE TRUE

SQL>

II) Logon as sys
$ sqlplus sys/sysdba8i@soldb.dpi.net.ir

SQL*Plus: Release 8.1.5.0.0 - Production on Sun Jun 15 11:12:42 2003

(c) Copyright 1999 Oracle Corporation. All rights reserved.

SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] | [INTERNAL]
where ::= [/][@] | /
Enter user-name:


Can any see the difference between logon I) and II) and why I get the error message as sys and not as user hamhey defined as sysdba in the password file.

Regards
Hamhey

[akhadar]

Try
$ sqlplus sys/sysdba8i@soldb.dpi.net.ir as sysdba
instead of $ sqlplus sys/sysdba8i@soldb.dpi.net.ir

[hamhey]

Hi,
It dosen't work either
here is the error message:
$ sqlplus sys/sysdba8i@soldb.dpi.net.ir as sysdba
Usage: SQLPLUS [] [logon] [@[.ext] [ ...]]
where ::= { - | -? | -s }
::= [/][@] | / | /nolog
- to display the usage syntax, -? to display version number, -s for silent mode

any idea

//hamhey

[akhadar]

Clearly there is difference in the error message after givng sysdba.
Can u do one thing try connecting
$ sqlplus sys/sysdba8i as sysdba or

After successfully entering into SQL prompt with hamhey user then try to connect with SYS user.

PS:As i don't have much experience in unix environment

[davey23uk]

put some quotes round the connect string

[abhaysk]

Change the pswd of the user SYS, since SYSDBA is key word.

Conn with internal or hamey as sysdba & change the pswd of the user SYS.

Abhay.

[davey23uk]

his password is sysdba81, which isnt a reserved word and anyway there is no restriction on using a reserved word as a password in 8i