userlogin error in oracle 12c

Posted by Arsalan on Nov 04, 2017; 5:46am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/userlogin-error-in-oracle-12c-tp4262.html


Hello Arsalan,

window 2008 Installed in VM

oracle 12c

when i create user in pluggable database we con not login it give us erorre like below

kindly guide me.

Enter user-name: sys as sysdba
Enter password:
Connected.
SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT

SQL> SELECT name, open_mode FROM v$pdbs;

NAME                           OPEN_MODE
------------------------------ ----------
PDB$SEED                       READ ONLY
PDBORCL                        READ WRITE

SQL> alter session set container=pdborcl;

Session altered.

SQL> CREATE USER ali IDENTIFIED BY ali CONTAINER=CURRENT;

User created.

SQL> GRANT CREATE SESSION TO ali CONTAINER=CURRENT;

Grant succeeded.

SQL> grant dba to ali;

Grant succeeded.

SQL>
SQL> conn
Enter user-name: ali/ali
ERROR:
ORA-01017: invalid username/password; logon denied


Warning: You are no longer connected to ORACLE.
SQL>


C:\Users\Administrator>tnsping pdborcl

TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 04-NOV-2
017 10:14:52

Copyright (c) 1997, 2014, Oracle.  All rights reserved.

Used parameter files:
C:\app\Arsala\product\12.1.0\dbhome_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 192.168.214.128)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = pdborcl)
))
OK (280 msec)

C:\Users\Administrator>