问题一:*****连接
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.