[oracle@localhost ~]$ sqlplus /nolog SQL*Plus: Release 9.2.0.1.0 - Production on Mon Oct 24 11:14:29 2005 Copyright (c) 1982, 2002, oracle Corporation. All rights reserved. SQL>; connect / as sysdba Connected to an idle instance. SQL>; startup mount ora-01078: failure in processing system parameters LRM-00109: could not open parameter file '/u01/app/oracle/product/9.2.0.4/dbs/in ...
by mjlinux - Oracle - 2009-06-17 17:45:44 阅读(15269) 回复(8)
SQL>sqlplus sys/(passwd)@oraCLE_SID as sysdba 已连接。 SQL> startup ora-01078: failure in processing system parameters LRM-00109: could not open parameter file ’/opt/oracle/app/oracle/product/10.1.0/Db_1/dbs/initoracle.ora’ 这是因为在oracle9i和oracle10g中,数据库默认将使用spfile启动数据库,如果spfile不存在,则就会出现上述错误。 解决方法: 将$oraCLE_BASE/admin/数据库名称/spfile目录下的init.ora....
现象装完oraCLE 9 在DBCA建库时总是失败详见log 运行环境 linux redhat 9 /mnt/diskc/oracle/product/9.0.1/rdbms/log/ora_2861.trc oracle9i Enterprise Edition Release 9.0.1.0.0 - Production With the Partitioning option JServer Release 9.0.1.0.0 - Production oraCLE_HOME = /mnt/diskc/oracle/product/9.0.1 System name: Linux Node name: zn Release: 2.4.20-8bigmem Version: #1 SMP Thu Mar 13 17:32:29 EST 2003 ...
到数据时出错 打开游标时出错!错误代码为-1555ora-015 55: snapshot too old: rollback segment number 12 with name "RBS
http://blog.chinaunix.net/u/20078/article_31545.html http://www.puschitz.com/Installingoracle9i.shtml http://www.oracle-db.com/oracle_cn/news-list-10001 http://www.oracle.com/technology/global/cn/pub/articles/smiley_10gdb_install.html http://www.puschitz.com/Installingoracle9i.shtml http://www.ixdba.net/article/JiQunJiShu/ http://www.dbanotes.net/ http://www.eygle.com/ http://w...
ora-01026 multiple buffers of size >; 4000 in the bind list Cause More than one long buffer in the bind list. Action Change the buffer size to be less than 4000 for the bind variable bound to a normal column. 但是不直达要在哪里改这个缓存 哪位知道的告知一下啊
今天检查部门对外业务的数据库,发现在日志里报错,但是不影响对外业务。数据库是ora9201,系统是windows 2000 ADV。两台机器加exp400,做的是2000的集群加oracle failsafe。数据库开启了自动归档,每天用rman备份。alert日志如下:
ora-01157 ora-01110 ora-27037 版本:(aix5.2+rac) ---------------------------------------------------------------- oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bi PL/SQL Release 10.1.0.5.0 - Production CORE 10.1.0.5.0 Production TNS for IBM/AIX RISC System/6000: Version 10.1.0.5.0 - Productio NLSRTL Version 10.1.0.5.0 - Production 报错信息: Fri Jan 19 20:36:18 2007 Errors in f...
:em17: 本人在AIX4.3.3 HA4.4 上面安装oraCLE817 OPS 在建库时报ora-27300 ora-27301 ora-27302 还望高手赐教 谁能说明一下oraCLE 与RAW DEVICE 的关系? 谢谢