Home » Server Options » Multitenant » Doubt regarding options in new PDB creation statement (Oracle 12c, Windows)
Doubt regarding options in new PDB creation statement [message #624657] Wed, 24 September 2014 08:23 Go to previous message
nmdivya@gmail.com
Messages: 12
Registered: September 2014
Junior Member
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.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Database Express login as pluggable container
Next Topic: Naming conventions: What do you call your Container DB's?
Goto Forum:
  


Current Time: Thu Mar 28 15:01:27 CDT 2024