请问oracle12cR2里面localuser只能使用tns方式连接么？

yueli34

说明：sec_case_sensitive_logon=TRUE
[oracle@h24 admin]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Mon Sep 4 08:06:08 2017
Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> alter session set container=pdb01;
Session altered.

SQL> conn ocp/tiger    //此处就连不进去。
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.


[oracle@h24 admin]$ sqlplus ocp/tiger@192.168.15.24:1522/pdb01  //这样就能连进去.

SQL*Plus: Release 12.2.0.1.0 Production on Mon Sep 4 08:08:02 2017
Copyright (c) 1982, 2016, Oracle.  All rights reserved.
Last Successful login time: Mon Sep 04 2017 08:05:56 +08:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL>

danisyan

没明白你的意思，你写到tnsnames.ora里面就可以conn **/**@pdb01连了

wolfop

启用PDB特性以后，显然你不能简单的通过SID连接啊

yueli34

danisyan 发表于 2017-9-4 08:17
没明白你的意思，你写到tnsnames.ora里面就可以conn **/**@pdb01连了

pdb01是简单连接，没写tns。pdb01是global_name。
[oracle@h24 admin]$ sqlplus ocp/tiger@192.168.15.24:1522/pdb01

SQL*Plus: Release 12.2.0.1.0 Production on 星期二 9月 5 06:09:38 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

上次成功登录时间: 星期一 9月  04 2017 08:39:16 +08:00

连接到:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL>

PDB01是con_name:
[oracle@h24 admin]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue Sep 5 06:17:44 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> show pdbs

    CON_ID CON_NAME                  OPEN MODE   RESTRICTED
---------- ------------------------------  ----------          ----------
         2 PDB$SEED                          READ ONLY     NO
         4 PDB01                                  READ WRITE   NO

danisyan

yueli34 发表于 2017-9-4 22:04
pdb01是简单连接，没写tns。pdb01是global_name。
[oracle@h24 admin]$ sqlplus ocp/tiger@192.168.15.2 ...

这样也是通过连接串连的pdb，没写tns而已