昨天重装了ORACLE,安装时有个设置口令的地方我填写的密码是sys,然后,我改了下TNS,现在用PLSQL连接,显示TNS无法解析指定连接标识符。我用的账号是:sysdba,密码:sa。
TNS文件内容为:
# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools.bizz = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.102.2)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.102.3)(PORT = 1521)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 180) (DELAY = 5) ) ))
请教下,怎么回事,如何解决,谢谢。(我装完后把PLSQL里面的一个设置oracle home给成现在的了,还有用sysdba/sys也不行)
TNS文件内容为:
# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools.bizz = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.102.2)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.102.3)(PORT = 1521)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 180) (DELAY = 5) ) ))
请教下,怎么回事,如何解决,谢谢。(我装完后把PLSQL里面的一个设置oracle home给成现在的了,还有用sysdba/sys也不行)
你本机有几个OracleHome?
你PLSQL连接的时候,选择的数据库是啥:是orcl还是bizz?
服务开了么?