Hi Friends,
I have created a pluggable database using below command.
CREATE PLUGGABLE DATABASE ORCLPDB1
ADMIN USER PDB1ADMIN IDENTIFIED BY PASSWORD
ROLE = (CONNECT,DBA)
DEFAULT TABLESPACE USERSPDB1 DATAFILE '/u01/oradata/PDB1/USERSPDB1.dbf' SIZE 200M AUTOEXTEND ON MAXSIZE 500M
FILE_NAME_CONVERT = ('/u01/oradata/ORCLCDB/pdbseed/','/u01/oradata/ORCLPDB1/')
STORAGE (MAXSIZE 2G)
PATH_PREFIX = '/u02/DIRECTORIES/ORCLPDB1/';
I gave a admin user to access this PDB in "create pluggable databse" clause. The pluggable database got created, but when I am trying to login through admin user, I am getting below errors. I have tried using tnsentry and also used set container. Please help me, in case I am missing something.
SQL> select USERNAME, USER_ID, ACCOUNT_STATUS, DEFAULT_TABLESPACE, CREATED, CON_ID from cdb_users where account_status = 'OPEN';
USERNAME USER_ID ACCOUNT_STATUS DEFAULT_TABLESPACE CREATED CON_ID
------------------------- ---------- -------------------------------- ------------------------------ --------- ----------
SYS 0 OPEN SYSTEM 26-JAN-17 1
SYSTEM 9 OPEN SYSTEM 26-JAN-17 1
SYS 0 OPEN SYSTEM 26-JAN-17 3
SYSTEM 9 OPEN SYSTEM 26-JAN-17 3
PDB1ADMIN 106 OPEN USERSPDB1 05-MAY-17 3
SQL> conn PDB1ADMIN/PASSWORD@ORCLPDB1
ERROR:
ORA-01017: invalid username/password; logon denied
SQL> alter session set container = ORCLPDB1;
Session altered.
SQL> conn PDB1ADMIN/PASSWORD
ERROR:
ORA-01017: invalid username/password; logon denied
Thanks for help!!
Regards,
Smruti