`

ORACLE not available

阅读更多

大周一的就出问题,用了一个小时解决了。记录下作为参考:

 

启动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!呵呵。。。记录下方便日后用,有什么不对的地方还请高手们拍砖!

分享到:
评论

相关推荐

    oracle10g提示oracle not available的一些个人总结

    自己通过网上整理总结了一些oracle not available的解决方法,包含了一些输入startup命令后出现的n多问号的错误解决。

    oracle 10g提示oracle not available

    oracle 10g提示oracle not available

    用Oracle DBCA 工具创建新数据库

    用Oracle DBCA 工具创建新数据库

    oracle连接错误处理

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

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

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

    SQL21日自学通

    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

    21天学习SQL V1.0.pdf 66 SQL 21 日自学通(V1.0) 翻译人笨猪 ...日期/时间函数............................................................................................................ADD_MONTHS..................

    ubuntu qt提示QMYSQL driver not loaded 的解决方法不用重新编译

    qt编译连接MYSQL出现QMYSQL driver not loaded 基本成为普遍现象,网络上大多数解决方案是重新编译驱动,亲身证实是可行方案之一。这里给出更简单的办法,适用于ubuntu,直接安装该deb包,就可以了。ubuntu16.04和...

    presto-oracle

    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.

    delphi下最佳oracle控件:Oracle Data Access Components

    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

    Beginning Oracle SQL 3rd

    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).

    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 $...

    Oracle PL/SQL Best Practices

    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 ...

    Apress.Beginning.Oracle.SQL.Dec.2009

    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

    oracle-j2sdk1.8-1.8.0+update181-1.x86_64.rpm

    大数据组件,官方版本:CDH5.9.0 操作系统:CentOS7/RHEL7 完整系列: oracle-j2sdk1.8-1.8.0+update181-1.x86_64.rpm

    Oracle Database 10g:New Features for Administrators Vol 1

    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 ...

    Oracle APEX Cookbook, 2nd Edition

    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

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

    Oracle sqldeveloper without jdk (win+linux)

    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 ...

    Expert Oracle Database Architecture 2nd Edition

    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: ...

Global site tag (gtag.js) - Google Analytics