OracleServiceORCL11和ORacleOraDB11g_home1TNSListener在服务中以显示启动了,但是当plsql连接时还是 报找不到监听的错误,而且我用sqlplus连接时还报ora-01034和ora-27101的两个错误,这两个错误时不时说oracle服务程序没有启动啊?。,
解决方案 »
- sql server 2005 数据 导入 oracle
- 数据处理中突然断网,会造成部分数据被更新,部分数据没被更新的情况吗?
- 视图奇慢,如何解决??
- 将图片批量导入Oracle中
- 日志文件自动丢失ERROR: ORA-01033: ORACLE initialization or shutdown in progress。
- 安装oracle9204, 在安装compat-gcc-7.3-2.96.122.i386.rpm软件包的时候,出错,请问这是怎么回事啊
- long,blob类型的数据在C++中用string存可以么?
- 哪一个存储过程更好一些,为什么?(高手请进)
- 字符串“拼接”
- 问两个标准概念:游标、存储过程
- 拜师
- 如何将Excel / Access 数据导出到Oracle数据库的已有表中去?
~~~~~~~~~~Database has been configured to start automatically whenever the server
is rebooted. But the database does not start and any query to the database
fails with Ora-27101 and Ora-1034 errors. Same errors are reported in
the Oradim.log.ORA-01034 ORACLE not available
ORA-27101 "Shared Memory Realm Does Not Exist"
Change(s)
~~~~~~~~~~DBAs are trying to automate the startup of the database when
server reboots. The Registry key ORA_<SID>_AUTOSTART is set to
TRUE and ORA_<SID>_PFILE is pointing to correct location. The "startmode"
of Oracle service ORACLESERVICE<SID> has been set to AUTOMATIC.
Cause
~~~~~~~The Oracle service ORACLESERVICE<SID> get corrupted for some unknown
reasons and does not start the database successfully
Fix
~~~~recreate the Oracle service using ORADIM utilitya) delete the current service -
c:\> oradim -delete -sid <sid_name>b) make sure the service has status DISABLED in Service Windows and it
does not appear after refreshing the Service Windows. If the service
still appears, reboot the server.c) create the service
c:\> oradim -new -sid <sid> -startmode auto -pfile <absolute path of init.ora>