oracle 学习笔记

关闭数据库：shutdonw immediate
启动：startup

sqlplus username/password[@connect_id][as sysdba]

sqlplus sys/oracle as sysdba

解锁scott用户：

[oracle@localhost ~]$ sqlplus sys/oracle as sysdba;

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jan 21 22:21:07 2011

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> alter user scott account unlock;

User altered.

切换用户：
SQL> connect sys/oracle as sysdba

SQL> select * from emp

SQL> select * from emp


创建数据库实例：dbca

创建监听：netca或netmgr

启动监听：lsnrctl start

指定编辑器
SQL> define _editor
DEFINE _EDITOR	       = "vim" (CHAR)
SQL> define _editor=vim

查看服务名：

SQL>show parameter service_names

动态注册服务名：
SQL>alter system set service_names='aaaa,bbb,ccc';


1、查看企业管理控制的状态命令 emctl status dbconsole
 
[oracle@localhost ~]$ emctl status dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0  
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
http://localhost.localdomain:1158/em/console/aboutApplication
Oracle Enterprise Manager 10g is not running. 
------------------------------------------------------------------
Logs are generated in directory /u/app/oracle/product/10.2.0/db_1/localhost.localdomain_orcl/sysman/log 

2、启动企业管理控制的状态命令 emctl start dbconsole

3、启动企业管理控制的状态命令 emctl stopdbconsole

sql

 Struture query language

dml
	insert update select merge delete
	不隐含commit
ddl    
	create alter drop
dcl
	grant revoke

crud 
select update delete insert


emp
dept


[原创]linux下oracle开机自动启动的设置
1、创建启动数据库的shell文件，例如/oradata/s.sh，赋予可执行权限：

lsnrctl start
SQLDBA="sqlplus /nolog"
$SQLDBA <<EOF
connect / as sysdba
startup
quit
EOF
2、修改/etc/rc.local,启动时调用s.sh，增加：

su - oracle -c "/oradata/s.sh"
这样linux启动后，就自动执行s.sh文件，把数据库启动了。


linux下oracle启动和关闭脚本


 
自己写的，很简单，可以看看：
1）启动脚本（dbstart.sh）
   lsnrctl start
   sqlplus /nolog <<EOF
   connect / as sysdba
   startup;
   exit
   EOF
  $sh dbstart.sh 即可
2）关闭脚本（dbstop.sh）
   lsnrctl stop 
   sqlplus /nolog <<EOF
   connect / as sysdba
   shutdown immediate;
   exit
   EOF
  $sh dbstop.sh 即可