数据库: Oracle 10g 10.1.0.2.0 sid= wmdev
系统:win2kserver.
装好数据库后,然后在此系统上装了as服务器. sqlnet.ora的内容如下:
(*第一个sqlnet.ora ,即安装Oracle 10g 后产生的)
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
和此文件相同目录的tnsname.ora 内容:
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
WMDEV11 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.11)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = wmdev)
)
)
(*第二个sqlnet.ora ,即安装as后产生的)
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT, ONAMES, HOSTNAME)
和此文件相同目录的tnsname.ora 内容:
REP_HORIZONWM_FRHOME1. =
(ADDRESS = (PROTOCOL = tcp)(HOST = horizonwm)(PORT = 1950))
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = horizonwm)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)
WMDEV11 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.11)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = wmdev)
)
)
想修改数据库为归档模式,步骤如下:
SQL> shutdown immediate
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORA-12560: TNS: 协议适配器错误
SQL>
在dos下运行tnspingwmdev11,结果如下:
C:\Documents and Settings\Administrator>tnsping wmdev11
TNS Ping Utility for 32-bit Windows: Version 10.1.0.4.2 - Production on 04-7月 -2006 17:04:01
Copyright (c) 1997, 2003, Oracle.All rights reserved.
已使用的参数文件:
D:\oracle\FRHome_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.11)(PORT = 1521)
DEDICATED) (SERVICE_NAME = wmdev)))
OK (20 毫秒)
为什么会出现这种错误呢,要怎么解决呢
|