windows 启动
cmd --> sqlplus /nolog
cmd --> set ORACLE_SID=RESTAURANT
sql --> connect / as sysdba
sql --> startup
启动
startup pfile=C:\app\Administrator\admin\RESTAURANT\pfile\init.ora.1012201865419
# C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN
登录
cmd --> sqlplus /nolog
cmd --> set ORACLE_SID=RESTAURANT
#连接
sql --> connect / as sysdba
#连接
connect sys/123456@192.168.5.232/RESTAURANT as sysdba
创建用户并授权
create user testdb identified by testdb;
#授权登录
grant create session to testdb;
#授权创建表权限
grant create table to testdb;
#授权表空间
grant unlimited tablespace to testdb;
---------------------------------------------------------
# 或全部权限
grant all privileges to testdb
---------------------------------------------------------
sqlplus sys/admin as sysdba删除用户
# 删除用户 ${user} 指具体的账号
drop user ${user};
# 在用户名字后面加个cascade 删除用户的同时删除用户的数据
drop user ${user} cascade;
oracle监听配置
192.168.5.232_restaurant=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.5.232)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RESTAURANT)
)
)
