转载于:http://yinyongliang.iteye.com/blog/34091
当遇到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后再连接数据库应该没有问题了。
分享到:
相关推荐
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 工具创建新数据库
ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist 进程 ID: 0 会话 ID: 0 序列号: 0
Oracle报错ORA-12516 TNS:listener could not find available handler with matching protocol stack
Oracle数据库因断电导致异常的解决方案,如:数据库服务开着,监听正常,但是连接数据库不成功,或者连接上无法查询数据,报错:ORA-01034: ORACLE not available
- 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. ...
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 $...
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@...
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/...
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 ...
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 ...