Oracle 10g遇到的问题及查找的解决方法

上一篇 / 下一篇  2009-07-03 14:34:59 / 个人分类:Oracle

问题一:*****连接Oracle 10g时ORA-12514: TNS: 监听进程不能解析在连接描述符中给出的 SERVICE_NAME 错误的解决

解决方法:
1. 打开<OracleHome>/network/admin/listener.ora文件,找到:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
2. 添加:
(SID_DESC =
(GLOBAL_DBNAME = ORACLE)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(SID_NAME = ORACLE)
)
3. 最后变成:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORACLE)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(SID_NAME = ORACLE)
)------------因为数据库上创建了多个实例,为了使监听能够访问到每个实例,所以此处要进行添加。
)
4. 保存文件,重启服务中的TNSListener,OK!

参考文档:http://www.blogjava.net/usherlight/archive/2007/02/12/99566.html

问题二:ORA-01078 与 LRM-00109 could not open parameter file initxxx.ora
错误信息:

  SQL> startup

-------------initrawdb.ora该文件找不到,所以无法启动。
  ORA-01078: failure in processing system parameters

  LRM-00109: could not open parameter file '/opt/oracle/products/10.1.0.3/db_1/dbs/initrawdb.ora'

  解决办法:
-------------直接把$ORACLE_BASE/admin/$ORACLE_SID/pfile/init.ora复制到上面启动时需要读取的配置文件的文件夹下。
  cp $ORACLE_BASE/admin/$ORACLE_SID/pfile/init.ora /opt/oracle/products/10.1.0.3/db_1/dbs/initrawdb.ora

  >sqlplus /nolog

  SQL*Plus: Release 10.1.0.3.0 - Production on Thu Jun 8 13:16:00 2006

  Copyright (c) 1982, 2004, Oracle. All rights reserved.

  SQL> conn / as sysdba

  Connected to an idle instance.

  SQL> startup

  ORACLE instance started.

  Total System Global Area 167772160 bytes

  Fixed Size 778212 bytes

  Variable Size 57679900 bytes

  Database Buffers 109051904 bytes

  Redo Buffers 262144 bytes

  Database mounted.

  Database opened.

  SQL>

  问题解决!
参考文档:http://www.cnscn.org/htm_data/585/0812/19230.html

三、创建pfile
SQL> create pfile='/oracle/product/dbs/pfileora10g.ora' from spfile='/oracle/product/dbs/spfileora10g.ora';
SQL> startup pfile='/oracle/product/dbs/pfileora10g.ora';
ORACLE instance started.

Total System Global Area 603979776 bytes
Fixed Size 1268872 bytes
Variable Size 163578744 bytes
Database Buffers 432013312 bytes
Redo Buffers 7118848 bytes
Database mounted.
Database opened.

TAG:

 

评分:0

我来说两句

Open Toolbar