Hi,
I see that the following sql is being used to create a PDB.
SQL> create pluggable database newpdb ADMIN User user1 identified by pwd1 roles=(DBA) FILE_NAME_CONVERT = ('F:\APP\SHREEV1\ORADATA\ORCL\PDBSEED\', 'F:\APP\SHREEV1\ORADATA\ORCL\PDB_VS1\');
I'm able to execute this query successfully and the PDB is created. And i can see that it is in 'Mounted' mode in the view v$pdbs. So I used the 'Alter pluggable database ' statement to change the mode to 'Read Write'.
My doubt, where can I use the User1 and Pwd1 for logging into Oracle. I couldn't use it when i start sql*plus.
PS: I logged in '/ as sysdba' and then altered the session to set container newpdb and then tried connecting using the above user and password, It shows error for logon failure.
Thanks,
Snowy.