SQLplus必须先以sysdba身份登录,才能用其他用户登录么?
SQLplus必须先以sysdba身份登录,才能用其他用户登录么?
直接用 SCOTT 登录不上,提示让输入用户名,按提示输入用户名和密码还是不能登录,如下:
$ sqlplus SCOTT/TIGER
SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 27 10:45:26 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
Enter user-name:
但先用sys登录,然后再用SCOTT登录就可以,为什么? 如下:
$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 27 10:47:33 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1202556928 bytes
Fixed Size 2212816 bytes
Variable Size 335547440 bytes
Database Buffers 855638016 bytes
Redo Buffers 9158656 bytes
Database mounted.
SQL> show user
USER is "SYS"
SQL> alter database open;
Database altered.
SQL> !sqlplus SCOTT/TIGER
SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 27 10:48:55 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show user
USER is "SCOTT"
SQL>