Oracle 10g 学习笔记

Oracle 启动
      昨天刚安装上Oracle 10g 用sqlplus 命令登陆数据库,输入系统默认的用户名和密码(system/manager)不能登录,出现以下提示:
Enter user-name: system
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
应该是数据库未启动的原因.

启动数据库:
[oracle@localhost ~]$ sqlplus /nolog
 SQL> connect /as sysdba
 SQL> startup
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                   778776 bytes
Variable Size              95165928 bytes
Database Buffers          188743680 bytes
Redo Buffers                 524288 bytes
Database mounted.
Database opened.
此时,数据库成功启动.

Oracle 用户添加:
SQL>create user aklus identified by aklus;
SQL>grant connect,resource,dba to aklus;
SQL>commit ;
用户aklus成功添加,并设置权限.