`
yinyongliang
  • 浏览: 171449 次
社区版块
存档分类
最新评论

解决ora-01034:oracle not available 的方法

阅读更多
当遇到ORACLE出现下面提示时:
ora-01034:oracle   not   available  
ora-27101:shared   mermory   realm   does   not   exist  
可以这样解决;
方法1:
1.输入:connect/as sysdba;
2.重起计算机就OK了;

方法2:
在命令行中输入  
  C:\>svrmgrl  
  Oracle   Server   Manager   Release   3.1.7.0.0   -   Production  
  Copyright   (c)   2000,   Oracle   Corporation.     All   Rights   Reserved.   
  Oracle8i   Enterprise   Edition   Release   8.1.7.0.0   -   Production  
  With   the   Partitioning   option  
  JServer   Release   8.1.7.0.0   -   Production  
  SVRMGR>   connect   internal/oracle  
  连接成功。  
  SVRMGR>   startup   
  startup后再连接数据库应该没有问题了。

分享到:
评论
1 楼 shanxmxj 2011-11-02  
在9i以后就没有这个命令了 请问还有其他什么办法可以解决么?

相关推荐

    p7331323_10204_AIX5L

    ORA-00603: ORACLE server session terminated by fatal error ORA-27504: IPC error creating OSD context ORA-27300: OS system dependent operation:sskgxp_select failed with status: 3 ORA-27301: OS ...

    用Oracle DBCA 工具创建新数据库

    用Oracle DBCA 工具创建新数据库

    oracle连接错误处理

    ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist 进程 ID: 0 会话 ID: 0 序列号: 0

    Oracle报错ORA-12516

    Oracle报错ORA-12516 TNS:listener could not find available handler with matching protocol stack

    处理Oracle数据库因断电异常关闭.txt

    Oracle数据库因断电导致异常的解决方案,如:数据库服务开着,监听正常,但是连接数据库不成功,或者连接上无法查询数据,报错:ORA-01034: ORACLE not available

    Oracle sqldeveloper without jdk (win+linux)

    - Bug # 4918539: ORA-ORA-06502 or ORA-01460 may occurs if a procedure is executed through the Run PL/SQL dialog box and a string with multibyte characters is assigned to one of the parameters. ...

    oracle11g for linuxx64编译bbed需要的三个文件

    BBED is not available in 11g but you can still link it after getting the following files from any previous version like 10gR2. Copy $ORA10g_HOME/rdbms/lib/ssbbded.o to $ORA11g_HOME/rdbms/lib Copy $...

    linux命令快速执行

    8_____vi /home/oracle/ora/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora 9_____/opt/lampp/lampp start 10_____/opt/lampp/lampp restart 11_____/opt/lampp/lampp stop 帮助 [root@...

    PLSQL.Developer v11.0.4.1774 主程序+ v11中文包+keygen

    Viewing job classes on Oracle12c could lead to "ORA-01036: illegal variable name/number" PL/SQL Beautifier did not format FORALL/MERGE loop correctly Test Window now processes trailing slash of a PL/...

    plsqldev14.0.1.1965x64多语言版+sn.rar

    Fixes for multiple monitors with different display scaling (file selector, print dialogs, MDI window title bars, scrollbar width) were not available in the 64 bit version The “Close unused ...

    plsqldev14.0.1.1965x32多语言版+sn.rar

    Fixes for multiple monitors with different display scaling (file selector, print dialogs, MDI window title bars, scrollbar width) were not available in the 64 bit version The “Close unused ...

Global site tag (gtag.js) - Google Analytics