winxp下 oracle10.1 安装完毕
怎么连接测试老是不成功啊
net configuration 与 net manager 是不是有冲突啊 我想
让这台电脑同时做服务器和客户端
让本机和局域网的电脑都能登陆本机 操作数据库
该怎样配置?正在尝试使用以下用户 ID 连接:zl
测试没有成功。
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor在输入的字段中可能有错误,
或者服务器连接未就绪。 # listener.ora Network Configuration File: F:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(SID_NAME = ZA)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = C7E4FAF308F643A)(PORT = 1522))
)
)
)# tnsnames.ora Network Configuration File: F:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ZL192.168.2.10 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.10)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCA)
)
)# sqlnet.ora Network Configuration File: F:\oracle\product\10.1.0\Db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
data source name odbc 我也配置了
description 192.168.2.10
TNS service name cracle数据库
zl
user system
怎么连接测试老是不成功啊
net configuration 与 net manager 是不是有冲突啊 我想
让这台电脑同时做服务器和客户端
让本机和局域网的电脑都能登陆本机 操作数据库
该怎样配置?正在尝试使用以下用户 ID 连接:zl
测试没有成功。
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor在输入的字段中可能有错误,
或者服务器连接未就绪。 # listener.ora Network Configuration File: F:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(SID_NAME = ZA)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = C7E4FAF308F643A)(PORT = 1522))
)
)
)# tnsnames.ora Network Configuration File: F:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ZL192.168.2.10 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.10)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCA)
)
)# sqlnet.ora Network Configuration File: F:\oracle\product\10.1.0\Db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
data source name odbc 我也配置了
description 192.168.2.10
TNS service name cracle数据库
zl
user system
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(SID_NAME = ZA)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = C7E4FAF308F643A)(PORT = 1522))
)
)
)
# tnsnames.ora Network Configuration File: F:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ZL192.168.2.10 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.10)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCA)
)
)1. 192.168.2.10 是你机器的IP么,还是其他机器的IP
2. C7E4FAF308F643A 是机器名么?
3. 到底要用1521,还是1522端口,确定了么
4. 到底SID叫什么名字,ORCA,ORCL,ZA???
2. C7E4FAF308F643A 是机器名么? C7E4FAF308F643A是我的机器名
3. 到底要用1521,还是1522端口,确定了么 net manager 用了1521 net configuration 用 1521 时提示端口有冲突 就改 1522了(1521好像也不行)
4. 到底SID叫什么名字,ORCA,ORCL,ZA??? SID 我也不知道叫什麽好这3个文件改怎样配置呢
我把这3个文件改了改你看哪还有问题
还是不成功
# listener.ora Network Configuration File: F:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = SID)
(SID_NAME = SID)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.10)(PORT = 1521))
)
)
)# tnsnames.ora Network Configuration File: F:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ZL192.168.2.10 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.10)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = SID)
)
)
# sqlnet.ora Network Configuration File: F:\oracle\product\10.1.0\Db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
如果要同时做客户端 就要再 netmanager 输入新的监听端口 和对方的ip 和服务器名
如果要同时做客户端 就要再 netmanager 输入新的监听端口 和对方的ip 和服务器名