oracle9i登录数据库,Oracle 10G 以normal身份登陆数据库无法登陆

Microsoft Windows XP [版本 5.1.2600]

(C) 版权所有 1985-2001 Microsoft Corp.

C

ocuments and Settingsuser>sqlplus sys/admin@cjec as sysdba

SQL*Plus: Release 10.1.0.2.0 - Production on 星期五 6月 6 10:29:35 2008

Copyright (c) 1982, 2004, Oracle.  All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production

With the Partitioning, OLAP and Data Mining options

SQL> drop user "ship" cascade;

drop user "ship" cascade

*

ERROR at line 1:

ORA-01918: user 'ship' does not exist

SQL> CREATE USER "ship"  PROFILE "DEFAULT"

2      IDENTIFIED BY "ship0987" DEFAULT TABLESPACE "CJEC"

3      ACCOUNT UNLOCK;

User created.

SQL> GRANT "CONNECT" TO "ship" WITH ADMIN OPTION;

Grant succeeded.

SQL> GRANT "DBA" TO "ship" WITH ADMIN OPTION;

Grant succeeded.

SQL> GRANT "CREATE SESSION" TO "SHIP" WITH ADMIN OPTION;

GRANT "CREATE SESSION" TO "SHIP" WITH ADMIN OPTION

*

ERROR at line 1:

ORA-01917: user or role 'SHIP' does not exist

SQL> CONN SHIP AS SYSDAB

SP2-0306: Invalid option.

Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]

where   ::= [/][@] | /

SQL> CONN SHIP AS SYSDBA

Enter password:

Connected.

SQL> ALTER USER "SHIP" IDENTIFIED SHIP0987;

ALTER USER "SHIP" IDENTIFIED SHIP0987

*

ERROR at line 1:

ORA-00924: missing BY keyword

SQL> ALTER USER "SHIP" IDENTIFIED BY SHIP0987;

ALTER USER "SHIP" IDENTIFIED BY SHIP0987

*

ERROR at line 1:

ORA-01918: user 'SHIP' does not exist

SQL> CONN SHIP

Enter password:

ERROR:

ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.

SQL> CONN SHIP AS SYSDBA

Enter password:

Connected.

SQL> ALTER USER SHIP IDENTIFIED BY SHIP0987;

ALTER USER SHIP IDENTIFIED BY SHIP0987

*

ERROR at line 1:

ORA-01918: user 'SHIP' does not exist

SQL> Alter user "ship" identified by ship0987;

User altered.

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area  171966464 bytes

Fixed Size                   787988 bytes

Variable Size             145488364 bytes

Database Buffers           25165824 bytes

Redo Buffers                 524288 bytes

Database mounted.

Database opened.

SQL> conn ship

Enter password:

ERROR:

ORA-01017: invalid username/password; logon denied