- 博客(16)
- 资源 (17)
- 问答 (1)
- 收藏
- 关注
转载 ORA-28001: the password has expired
Oracle提示错误消息ORA-28001: the password has expired发表于:2011年09月19日 15:38 0首先,以SYS DBA身份进入sqlpuls 打开sqlpuls SQL->请输入用户名:sys as sysdba SQL->密码: 登录成功以后查询DBA用户状态 SQL->selec
2012-05-30 17:51:41 7264
转载 ORA-24324: service handle not initialized
ORALCE启动不了报错ORA-24324: service handle not initialized 源文档 http://bbs.chinaunix.net/thread-1104660-1-1.html>SQL> startupORA-27126: unable to lock shared memory segment in coreHPUX-ia64 Erro
2012-05-30 17:51:16 16735
转载 ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 87.41% used
查看文章 ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 87.41% used2010-08-04 21:271.错误提示:ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 87.41% used
2012-05-30 17:50:42 1112
转载 ORA-12519
ORA-12519: TNS:no appropriate service handler found 解决 2011-09-14 16:20:02| 分类:默认分类 |字号 订阅ORA-12519: TNS:no appropriate service handler found 解决有时候连得上数据库,有时候又连不上.可能是数据库上当前的连接数目已经超过了它能够
2012-05-30 17:50:06 1244
转载 ORA-03113: end-of-file on communication channel
查看文章 一次 ORA-03113: end-of-file on communication channel 错误定位过程2010-01-30 01:44手动关闭Oracle之后打算再次启动Oracle:$sqlplus ‘/as sysdba’SQL> startupORA-03113: end-of-file on communication channel结
2012-05-30 17:49:31 3775
转载 Ora-01116
ORA-01116: error in opening database file 89分类: DataBase 2011-02-06 17:50 118人阅读评论(0)收藏举报语法:DROP TABLESPACE tablespace[ INCLUDING CONTENTS [ {AND | KEEP} DATAFILES ][ CASCADE C
2012-05-30 17:49:05 4539
转载 ORA-01109:数据库无法启动问题
数据库无法启动问题登录数据库时提示:ORA-12514: TNS: 监听程序当前无法识别连接描述符中解决办法:然后远程登录数据库服务器(aix5 unix),转到oracle用户下(unix转用户命令:su - oracle),输入sqlplus /nolog 回车 conn /as sysdba回车进入sql界面,作如下操作:1、关闭实例SQL> shutdown
2012-05-30 17:48:43 1025
转载 ORA-01102/ORA-01507
ORA-01102: cannot mount database in EXCLUSIVE mode ORA-01507: database not mounted 源文档 http://hi.baidu.com/super__senior/blog/item/140fe6360dba611c90ef3982.html>今天在STARTUP一数据库时,发生如下错误:SQL
2012-05-30 17:48:15 2798
转载 ORA-01090
ORA-01090: shutdown in progress - connection is not permitted2009-08-07 16:03 494人阅读评论(0)收藏举报 本人在sql&plus中用shutdown normal命令关闭数据库时,觉得关闭时间太长,所以就将sql&plus窗口关闭了。重新启动时,报如下错误:
2012-05-30 17:47:10 4997
转载 ORA-01078: failure in processing system parameters_flying
解决oracle 11g 问题之ORA-01078: failure in processing system parameters(2011-08-22 23:21:02) 转载标签:杂谈昨天刚刚将oracle 11G安装完成,今天想通过sqlplus来连接数据库,在启动oracle时,突然报错:ORA-01078: failure in proces
2012-05-30 17:46:47 1828
转载 ora-01034:oracle not available ora-27101:shared memory realm does not exist
1 先看oracle的监听和oracle的服务是否都启动了。启动oracle监听:cmd的命令行窗口下,输入lsnrctl start,回车即启动监听。2 查看oracle的sid叫什么,比如创建数据库的时候,实例名叫“abc”,那么先手工设置一下oralce的sid,cmd命令窗口中,set ORACLE_SID=abc3 再输入sqlplus /nolog,回车再输入 con
2012-05-30 17:46:15 3819
转载 ORA-01012: not logged on
conn / as sysdba 报错ORA-01012: not logged on(2010-12-01 15:52:54) 转载▼标签: 转载原文地址:conn / as sysdba 报错ORA-01012: not logged on作者:tooperw发生原因:关闭数据库是shutdown 后面没有接关闭参数中的任何一个。[nomal
2012-05-30 17:45:45 1451
原创 ORA-00845: MEMORY_TARGET not supported on this system
今天晚上新装一台Oracle 11g的数据库,打算将SGA设大一点,知道 11g 中有一个新特新 MEMORY_TARGET,于是尝一下鲜,谁知报了个 ORA-00845,报错比较容易迷惑人,不借助Google真得想半天:SQL> alter system set memory_max_target=3G scope=spfile ;System altered.SQL> alter
2012-05-30 17:44:09 771
原创 Ora-00376
Sql>select file#,name,status,enabled from v$datafile;在线的状态为:NAME--------------------------------------------------------------------------------STATUS ENABLED------- ----------/u01/
2012-05-30 17:43:22 672
原创 ORA-00257错误(归档空间不够)
先说一下我的实际操作:1、sqlplus /nolog2、sqlplus sys/password@ORCL as sysdba3、SQL> select * from V$FLASH_RECOVERY_AREA_USAGE;可以查看日志占用的记录4、SQL> show parameter recover;NAME
2012-05-30 17:41:28 1046
转载 ORA-00059 oracle
ORA-00059: maximum number of DB_FILES exceeded 处理 =========================================================== 今天添加数据文件,结果报错,ORA-00059: maximum number of DB_FILES exceeded 。 ---------------
2012-05-30 17:38:56 2662
2020年中国区块链人才发展研究报告-猎聘+互链脉搏-2020.3-29页-20200327.pdf
2020-05-29
新基建下区块链的发展状况.pdf
2020-05-27
区块链教学系统2.0.pdf
2020-05-27
linux中oracle的日常维护命令
2011-10-10
缓存机制(Jive缓存机制的实现)
2010-12-13
扩解.NET中的XML编程技术
2010-12-13
Java正则表达式详解
2010-05-20
模拟面试题及答案 Java
2010-01-14
TA创建的收藏夹 TA关注的收藏夹
TA关注的人