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