大周一的就出问题,用了一个小时解决了。记录下作为参考:
启动Oracle数据出现oralce not available错误。
google了下大多如下修改方法:
当遇到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后再连接数据库应该没有问题了。
按照上面的执行不成功,我晕。。。。
接着找,找到一片文章让删除电脑中的日志。(具体地址忘了)死马当活马医把。我也是刚刚学习Oracle瞎弄把!
结果用系统管理员的身份可以登录了。在用普通用户登录,靠。不可以。。这下怎么办啊。
对了,重启Oracle服务。重启了登录ok!呵呵。。。记录下方便日后用,有什么不对的地方还请高手们拍砖!
分享到:
相关推荐
自己通过网上整理总结了一些oracle not available的解决方法,包含了一些输入startup命令后出现的n多问号的错误解决。
oracle 10g提示oracle not available
用Oracle DBCA 工具创建新数据库
ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist 进程 ID: 0 会话 ID: 0 序列号: 0
Oracle数据库因断电导致异常的解决方案,如:数据库服务开着,监听正常,但是连接数据库不成功,或者连接上无法查询数据,报错:ORA-01034: ORACLE not available
Oracle Not Available 483 Inserted Value Too Large for Column 483 TNS:listener Could Not Resolve SID Given in Connect Descriptor 484 Insufficient Privileges During Grants484 Escape Character in Your ...
21天学习SQL V1.0.pdf 66 SQL 21 日自学通(V1.0) 翻译人笨猪 ...日期/时间函数............................................................................................................ADD_MONTHS..................
qt编译连接MYSQL出现QMYSQL driver not loaded 基本成为普遍现象,网络上大多数解决方案是重新编译驱动,亲身证实是可行方案之一。这里给出更简单的办法,适用于ubuntu,直接安装该deb包,就可以了。ubuntu16.04和...
Presto OraclePlugin This is a plugin for Presto that allow ...Oracle Driver is not available in common repositories, so you will need to download it from Oracle and install manually in your repository.
Oracle compatibility ODAC supports Oracle servers 11g, 10g, 9i, 8i, 8.0, and 7.3, including Oracle 10g Express. ODAC supports x86 versions of the following Oracle clients: ...Direct Mode is not available
This is not a book about ...software that you need to install Oracle Database on either Windows or Linux for learning purposes is available free of charge from the Oracle Technology Network (OTN).
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 $...
I hope you will not be offended by this repetition. It's simply impossible to offer in a single book everything that can and should be written about the Oracle PL/SQL language. While I plan to ...
learning purposes is available free of charge from the Oracle Technology Network (OTN). Begin your journey with a visit to the OTN website at: http://www.oracle.com/technology/index.html
大数据组件,官方版本:CDH5.9.0 操作系统:CentOS7/RHEL7 完整系列: oracle-j2sdk1.8-1.8.0+update181-1.x86_64.rpm
were available in previous releases (except when defining the context for a new feature or comparing past behavior with current behavior). Consequently, the course is most useful to you if you have ...
As a Cookbook this book enables you to create APEX web applications and to implement features with immediately usable recipes that unleash the powerful functionality of Oracle APEX 4 2 Each recipe is ...
Oracle报错ORA-12516 TNS:listener could not find available handler with matching protocol stack
If the locale of the operating system is not English, a few UI elements, like default wizard buttons and Oracle error messages, may show up in the language of this locale. If the locale of the ...
by a mountain of information that is nice to have, but not critical to getting started. The answer is simple. Step 1: Read the concepts manual so you have an idea of what it’s all about. Step 2: ...