在PL/SQL试图连接数据库的时候,Oracle报告下列错误:
ERROR:
ORA-27101 Shared memory realm does not exist
ORA-01034 ORACLE not available 环境 oracle10g windowsxp 按照网上的解决办法:
1.C:\>set ORACLE_SID= ORCL --我的数据库唯一实例 为 ORCL
--重启服务后 问题依旧
2.将sqlnet.ora文件中的
SQLNET.AUTHENTICATION_SERVICES = (NTS) NTS换为NONE.
--重启服务后问题依旧
问题依旧
问题依旧
问题依旧
问题依旧问题依旧问题依旧问题依旧
问题依旧
问题依旧问题依旧
问题依旧问题依旧
问题依旧
问题依旧
ERROR:
ORA-27101 Shared memory realm does not exist
ORA-01034 ORACLE not available 环境 oracle10g windowsxp 按照网上的解决办法:
1.C:\>set ORACLE_SID= ORCL --我的数据库唯一实例 为 ORCL
--重启服务后 问题依旧
2.将sqlnet.ora文件中的
SQLNET.AUTHENTICATION_SERVICES = (NTS) NTS换为NONE.
--重启服务后问题依旧
问题依旧
问题依旧
问题依旧
问题依旧问题依旧问题依旧问题依旧
问题依旧
问题依旧问题依旧
问题依旧问题依旧
问题依旧
问题依旧
sqlplus /nolog
conn / as sydba
startup force再试你的东西.
在windows 的开始-》运行输入 sqlplus /nolog SQL*Plus: Release 10.1.0.2.0 - Production on Fri Jul 18 11:08:43 2008Copyright (c) 1982, 2004, Oracle. All rights reserved.SQL> conn / as sydba
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon> ::= <username>[/<password>][@<connect_identifier>] | /
SQL> connection / as sysdba
SP2-0734: unknown command beginning "connection..." - rest of line ignored.
SQL> connect /as sysdba
ERROR:
ORA-01031: insufficient privileges
SQL>
conn / as sysdba
startup force 再试你的东西.
conn / as sysdba
startup force 再试你的东西.
当前的登陆用户在ORA_DBA组里面
SQL> startup force
ORA-01261: Parameter db_recovery_file_dest destination string cannot be translat
ed
ORA-01263: Name given for file destination directory is invalid
OSD-04018: Unable to access the specified directory or device.
O/S-Error: (OS 2) 系统找不到指定的文件。
SQL>
恢复文件没有了
*.db_recovery_file_dest='F:\flash_recovery_area'
没有这个文件
THANKS A LOT!
THANKS A LOT!THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!THANKS A LOT!
THANKS A LOT!THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!
THANKS A LOT!