1.用有dba权限的用户登录:sys用户
2.创建一个新用户:create user EXCHANGE identified by EXCHANGE;
create user U_FRONT2GPS identified by FRONT2GPS;
3.授予DBA权限: grant connect,resource,dba to EXCHANGE; grant connect,resource,dba to U_FRONT2GPS;
ok,创建好了,就可以用abc这个用户登录了,abc用户拥有dba权限。
--以指定用户登录
sqlplus EXCHANGE/EXCHANGE@orcl as sysdba
--修改Oracle账号密码
alter user EXCHANGE identified by EXCHANGE;
alter user U_FRONT2GPS identified by FRONT2GPS;
--删除用户
drop user EXCHANGE cascade;
--解锁数据库
select username,lock_date from dba_users where username='EXCHANGE';
alter user EXCHANGE account unlock;
--查看当前数据库实例
show parameter instance_name;
--启动数据库监听
lsnrctl start
--新创建的实例启动方法 (相关的两个文件tnsnames.ora 和 listener.ora localhost要改成数据库的连接地址)
1.设置监听alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=IP地址)(PORT=1521))))' scope=spfile;
2.启动监听 lsnrctl start
3.关闭数据库 shutdown immediate
4.重启数据 startup