While creating repository using content server, I got following error message
"ORA-65049: creation of local user or role is not allowed in CDB$ROOT"
After changing SERVICE_NAME in tnsnames.ora, make it to point at PDB by tnsnames.ora or through netca.
Before:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.62.51.48)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl.test.installer.com)
)
)
After:
PDBORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.62.51.48)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = pdborcl.test.installer.com)
)
)
Then local user and tables got created successfully.
My questions are as follows:
- Till now we are handling data base using local user, Is it recommended way to create local user in PDB, and using that for our application? Is causes any disadvantages?
- Any disadvantages of using PDB to create locale user and table space? Is it causes any security issue?
- Suggest me any other plan if you have for this issue?
Thanks
Vinayak