[admin@localhost ~]$ sqlplus
-bash: sqlplus: 未找到命令
[admin@localhost ~]$ su root
密码:
[root@localhost admin]# su oracle
[oracle@localhost admin]$ ll
ls: 无法打开目录.: 权限不够
[oracle@localhost admin]$ cd ~
[oracle@localhost ~]$ ll
总用量 74696
-rw-r--r-- 1 oracle oinstall 76488704 9月 6 13:03 expdat.dmp
[oracle@localhost ~]$ source .bash_profile //转成Oracle用户后用 .bash_profile
[oracle@localhost ~]$ sqlplus //这样sqlplus就能用了
SQL*Plus: Release 11.2.0.4.0 Production on Tue Mar 3 10:03:29 2020
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter user-name:
Enter password:
ERROR:
ORA-28002: the password will expire within 7 days
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning option
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED ; //设置用户密码永不过期
Profile altered.
SQL> alter user 用户名 identified by 用户密码;
User altered.
SQL>