服务器 ibm aix7.2
数据库12.2:
12.2 服务器端
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 JLYTXXGL READ WRITE NO
4 IMP MOUNTED
5 SHIZX READ WRITE NO
SQL> conn jlytxxgl/jlytxxgl@JLYTXXGL
Connected.
SQL>
在11g的客户端:
SQL*Plus: Release 11.2.0.1.0 Production on 星期一 8月 21 19:08:10 2017
C:\Users\shilei>tnsping jlytxxgl
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 22-8月 -2017 08:22:24
Copyright (c) 1997, 2010, Oracle. All rights reserved.
已使用的参数文件:
f:\app\shilei\product\11.2.0\client_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
尝试连接 (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 11111111)(PORT = 1521))) (C
ONNECT_DATA = (SERVICE_NAME = jlytxxgl)))
OK (0 毫秒)
C:\Users\shilei>sqlplus jlytxxgl/jlytxxgl@jlytxxgl
SQL*Plus: Release 11.2.0.1.0 Production on 星期二 8月 22 08:23:37 2017
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
请输入用户名:
好像11g的客户端的版本有关