[oracle@pub19-node2 ~]$ sqlplus sys@czhprimaryas sysdba SQL*Plus: Release19.0.0.0.0- Production on Sun May308:08:532020Version19.5.1.0.0Copyright (c)1982,2019, Oracle. All rights reserved. Enterpassword:ERROR: ORA-12154:TNS:couldnotresolve the connect identifier specified Enteruser-name: AI...
(1)在oracle安装路径的tns配置文件里添加如下代码 # tnsnames.ora Network Configuration File: d:\Oracle\product\10.2.0\client_1\NETWORK\ADMIN\tnsnames.ora # Generated by Oracle configuration tools. ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 152...
ORA-12154: TNS: 无法解析指定的连接标识符 C:\oracle\product\10.2.0\client_2\NETWORK\ADMIN\tnsnames.ora C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN # tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\client_2\NETWORK\ADMIN\tnsnames.ora # Generated by Oracle configuration t...
但在用户的客户端测试连接时,报错ORA-12154,TNS-03505 sqlplus system/oracle@192.168.10.10/xxsid 代码语言:javascript 复制 C:\Documents and Settings\Administrator>sqlplus system/oracle@192.168.10.10/xxsid SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 7月16 16:53:58 2015 Copyright (c) 1982...
ORA-12154: TNS: 无法解析指定的连接标识符 C:\oracle\product\10.2.0\client_2\NETWORK\ADMIN\tnsnames.ora C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN tnsnames.ora ORA-12154: TNS: 无法解析指定的连接标识符 可以搜索关键字: 关于win7 x64 连接oracle 客户端 VS2010调试 提示“ORA-12154: TNS: ...
ORA-12154: TNS:could not resolve the connect identifier specified It appeared that the cause was bad password for sys containing '@' character. For example when you connect as below: $sqlplus sys as sysdba The response is SQL*Plus: Release 11.2.0.4.0 Production on Wed May 27 08:24:19...
错误提示信息, 是 TNS: 无法解析指定的连接标识符 你需要先尝试一下 tnsping orcl 看看, 能不能访问到那个数据库先。当前的数据库正在使用的情况下, 是可以 exp 的。
\oracle\product\10.1.0\Db_1\dbs\initorcl.ora下我也试过了还是不行,天快亮了想想怎么要是重新装数据库怕是来不了,我平静下来想了想可不可以把init.ora.4292012235036文件改为init.ora把它放到C:\oracle\product\10.1.0\Db_1\database\目录下,我带着疑惑试了下,改完cp后在运行startup提示ORACLE ...
你是要导出整个数据库?使用exp命令只能在数据库启动的时候导出数据,如果数据库处于关闭状态,这个命令你也是用不了的。你这个问题应该是连接不到数据库,先使用tnsping检查是否能够ping通数据库,再检查一下客户端的tnsname.ora文件里orcl的连接是否配置正确,HOST用的是IP还是主机名称。
In my case, the installation and configuration of the databases put entries in the tnsnames.ora file for the databases I was running. First, I was able to connect to the database by setting the environment variables (Windows): set ORACLE_SID=mydatabase set ORACLE_HOME=C:...