公司产品的部署经常使用到oracle数据库，在与oracle不断打交道的过程中，总结了以下几点常见错误，希望能对有这方面需要的朋友有所帮助。 1，oracle启动数据库时报错： SQL> startup; ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/home/oracle/oracle/product/10.2.0/db_1/dbs/initbdczra.bdcz.cbpm.ora' 解决办法： [oracle@bdczra dbs]$ cp /home/...
oracle 报8007错误，具体描述为： 08007, 00000, "Further changes to this block by this transaction not allowed" // *Cause: Max locks have been reached for this transaction in this block // *Action: Commit changes 请问如何处理啊？谢谢
最近在研究oracle dataguard 在设置备库时出现了一些问题一直困扰着我： SQL> startup oracle instance started. Total System Global Area 264241152 bytes Fixed Size 1218868 bytes Variable Size 92276428 bytes Database Buffers 167772160 bytes Redo Buffers 2973696 bytes Database mounted. ORA-01157: cannot identify/lock data file 1 - see DBWR trace fi...
Spawned Process 4693 Xlib: connection to "shideerp:0.0" refused by server Xlib: Client is not authorized to connect to Server Xlib: connection to "shideerp:0.0" refused by server Xlib: Client is not authorized to connect to Server REP-3000: 启动 oracle Toolkit 时发生内部错误. REP-3000: 启动 oracle Toolkit 时发生内部错误. 请问哪位高人遇到过，我在网上看到一些关于这个问题的解决方法，是说在环境变量里...
今天发现服务器出现问题php连接oracle出现错误， ORA-12705: invalid or unknown NLS parameter value specified in xxxx on line 20 无法连接到数据库服务器。 bash_profile文件内容如下： JAVA_HOME=/usr/java/jdk1.5.0_11 export JAVA_HOME CLASSPATH=.:$JAVA_HOME/lib:$JAVA_HOME/jre/lib export CLASSPATH LD_LIBRARY_PATH=/usr/local/lib:$JAVA_HOME/lib:$JAVA_HOME/jre/lib export LD_LIBRARY_PATH PATH=$JAVA_HOME/bin...
bash-2.05$ sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 11月 12 15:31:31 2007 Copyright (c) 1982, 2005, oracle. All rights reserved. SQL> connect /as sysdba; 已连接到空闲例程。 SQL> startup; ORA-27154: post/wait create failed ORA-27300: OS system dependent operation:semget failed with status: 28 ORA-27301: OS failure message: No space left on device ORA-27302: failure occ...
