![](https://img-blog.csdnimg.cn/20201014180756754.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle报错
safe_sound
这个作者很懒,什么都没留下…
展开
-
11g安装报错ORA-01078,LRM-00109: couldnot open parameter;ORA-00845,MEMORY_TARGET not.ORA-01102cannot moun
SQL> conn / as sysdbaConnected to an idle instance.SQL> startupORA-01078: failure in processing system parametersLRM-00109: could not open parameter file '/opt/oracle/product/11.2/db_1/dbs/inito...原创 2018-06-04 16:59:12 · 616 阅读 · 0 评论 -
oracle安装报错:ORA-00119invalid specification for system+ORA-00130: invalid listener address
在图形化创建数据库时,dbca到安装过程,安装到2%时,报错ORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=dcsopen2Node)(PORT=1521))'百度到的知识说是需要...原创 2018-06-04 17:01:35 · 807 阅读 · 0 评论 -
oracle报错:ORA-00972: identifier is too long
今天数据库巡检时,查询dba_data_files的字段出现报错:ORA-00972: identifier is too long网上查询获知为:字面的意思是标识符(你备注的名称)过长,有的说标识符不可超过30。附:我的查询语句select file_name 文件名,tablespace_name 表空间,bytes/1048576 使用,user_bytes/1048676 可用,maxby...原创 2018-05-30 13:36:00 · 12141 阅读 · 2 评论