自己的机器上装有oracle 服务
tnsnames.ora文件如下
BJFUSION =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = BJFUSION)
)
)ITE308 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ITE308)
)
)INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
lisntener.ora文件如下
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ITE308)
(ORACLE_HOME = c:\oracle\ora92)
(SID_NAME = ITE308)
)
(SID_DESC =
(GLOBAL_DBNAME = BJFUSION)
(ORACLE_HOME = c:\oracle\ora92)
(SID_NAME = BJFUSION)
)
)
sql plus 连接总出现
ora-12514监听进程不能解析连接串中的servicename .怎么解决啊? 捆饶我一上午了```` 郁闷啊``
tnsnames.ora文件如下
BJFUSION =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = BJFUSION)
)
)ITE308 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ITE308)
)
)INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
lisntener.ora文件如下
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ITE308)
(ORACLE_HOME = c:\oracle\ora92)
(SID_NAME = ITE308)
)
(SID_DESC =
(GLOBAL_DBNAME = BJFUSION)
(ORACLE_HOME = c:\oracle\ora92)
(SID_NAME = BJFUSION)
)
)
sql plus 连接总出现
ora-12514监听进程不能解析连接串中的servicename .怎么解决啊? 捆饶我一上午了```` 郁闷啊``
(SID_DESC =
(GLOBAL_DBNAME = ITE308)
(ORACLE_HOME = c:\oracle\ora92)
(SID_NAME = ITE308)
)
(SID_DESC =
(GLOBAL_DBNAME = BJFUSION)
(ORACLE_HOME = c:\oracle\ora92)
(SID_NAME = BJFUSION)
)
本机有两个数据库
一个是ITE308 一个是BJFUSION
sqlplus sys/manager@BJFUSION
另:参考一下我的解决过程,或许对你有帮助:http://blog.sina.com.cn/s/blog_3f2ef1180100aikc.html