1、服务器超管登录
echo $ORACLE_SID
export ORACLE_SID=orcl ##设置环境,当前会话有效
sqlplus / as sysdba
2、设置行宽
show linesize
set linesize
3、解锁用户
alter user tiger account unlock
4、密码过期,修改密码
select username,profile from dba_users
alter user tiger identified by tiger
## 设置密码不过期
Alter PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED
5、查询db_links
select * from dba_db_links
select * from user_sys_privs where privilege like upper('%DATABASE LINK%') AND USERNAME='tiger'
6、查询控制文件路径
show parameter control_files
7、实例启动
export ORACLE_SID=orcl
sqlplus / as sysdba
SQL> startup ##启动
##打开监听
lsnrctl start(指定监听使用命令:lsnrctl start TIGER(监听名字))