问题现象:

alter user scott account unlock;

ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0

[oracle@rhel ~]$ echo $ORACLE_SID
xxxx
[oracle@rhel ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4. Production on Tue Sep :: Copyright (c) , , Oracle. All rights reserved. Connected to an idle instance. SQL> select userenv('language') from udal;
select userenv('language') from udal
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0

问题解决:

确认当前实例对不

export ORACLE_SID=xxxx     --设置

echo $ORACLE_SID=xxxx     --查看

查看监听状态

lsnrctl status

 sqlplus sys/123123@sznfpt as sysdba  #明确登录的用户及实例,就OK了

[oracle@rhel ~]$ sqlplus sys/@sznfpt as sysdba

SQL*Plus: Release 11.2.0.4. Production on Tue Sep  :: 

Copyright (c) , , Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4. - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL>
SQL>
SQL> alter user scott account unlock; User altered. SQL>
SQL>
SQL> alter user scott identified by ; User altered. SQL>

最新文章

  1. 跌倒了,再爬起来:ASP.NET 5 Identity
  2. js用8421码实现10进制转2进制
  3. HMAC-MD5算法原理及实现
  4. .Net MVC中访问PC网页时,自动切换到移动端对应页面
  5. UVa12726 one Friend at a Time (位 广搜)
  6. Docs list
  7. javascript深入理解闭包
  8. 使用c3p0与DBCP连接池,造成的MySql 8小时问题解决方案
  9. BZOJ-1045-[HAOI2008] 糖果传递(中位数原理)
  10. tee 命令详解
  11. Java代码输出是“father”还是“child”(一)
  12. Spark:reduceByKey函数的用法
  13. PAT1090:Highest Price in Supply Chain
  14. Windows环境安装运行:Angular.js
  15. Fabric 1.0交易流程
  16. Delphi中Json格式读写
  17. Android被忽略的tools
  18. SQL SERVER 快捷键收录
  19. Path Sum II leetcode java
  20. Linux 修改文件和文件夹权限

热门文章

  1. Understanding Linux CPU stats
  2. 数学图形(1.47)贝塞尔(Bézier)曲线
  3. CSS只是进化的一部分
  4. Ios开发之协议protocol
  5. Laravel 5 中使用 JWT(Json Web Token) 实现基于API的用户认证
  6. 【架构】ServiceMesh初步了解
  7. Trie树分词
  8. Mahout源码目录说明
  9. 利用NATAPP隧道解决微信公众号开发之本地调试难题
  10. Cognos11第三方权限认证之OpenDJ