Oracle 命令行操作
39
1、切换到oracle用户
[root@oracledb ~]# su - oracle
Last login: Tue Jun 1 01:48:10 PDT 2021 on pts/5
2、以dba身份进入sql语句
[oracle@oracledb ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 1 01:49:31 2021
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
3、修改用户名
ALTER USER 用户名 IDENTIFIED BY 新密码;
SQL> alter user hmf identified by lianshi;
User altered.
4、查询所有用户
SQL> select * from all_users;
5、给用户授权
SQL> grant connect,resource,dba to HMF;
Grant succeeded.
6、查询用户所有角色权限
select * from dba_role_privs;
7、创建一个新用户:
create user aaa identified by 123456;
8、授予DBA权限:
grant connect,resource,dba to aaa;
可以用aaa这个用户登录了,abc用户拥有dba权限。
select * from dba_users; 查看数据库里面所有用户,前提是你是有dba权限的帐号,如sys,system
select * from all_users; 查看你能管理的所有用户!
select * from user_users; 查看当前用户信息 !
9、退出
SQL> quit;
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
-----------
1、切换oracle用户 su - oracle
2、进入数据库 sqlplus / as sysdba
3、新建用户 create user hmf identified by lianshi;
4、用户授权 grant dba to hmf;
------------
参考:
oracle 查看数据库和表命令_he_jian1的专栏-CSDN博客_oracle 查看数据库
https://blog.csdn.net/liyu1059915776/article/details/84643893
遇到问题:
新建用户 create user hmf identified by lianshi;遇到下面问题:
ORA-65096: invalid common user or role 解决方法
解决办法:
create user c##hmf identified by lianshi;
grant dba to c##hmf;
参考:https://blog.csdn.net/Ruishine/article/details/113744137
重启Oracle服务
以oracle身份登录数据库,命令:su – oracle ,然后输入密码
进入Sqlplus控制台,命令:sqlplus /nolog
以系统管理员登录,命令:connect /as sysdba
如果是关闭数据库,命令:shutdown immediate
如果是启动数据库,命令:startup
退出sqlplus控制台,命令:exit
进入监听器控制台,输入命令:lsnrctl
停止监听器,命令:stop
启动监听器,命令:start
退出监听器控制台,命令:exit
oracle监听器操作
lsnrctl status #查看监听状态
lsnrctl start #启动监听器