2

I have Oracle 12c installed. I have two schemas installed in the plaggable DB ORCLPDB. I restarted the machine where both oracle and my application exist.

now when I'm trying to open the pluggable database ORCLPDB using the below query : 

alter pluggable database orclpdb open;

I'm getting the following Warning:

Warning: PDB altered with errors.

when I run this query :

SELECT NAME,STATUS,MESSAGE FROM PDB_PLUG_IN_VIOLATIONS;

I get this entry :

Name       Status     MESSAGE
--------------------------------
ORCLPDB    PENDING    Sync PDB failed with ORA-65177 during 'ALTER USER user123 IDENTIFIED BY *'

where user123 is an essential user that I cannot get rid of.

when I restarted the server , there was a hanged database transaction in the application , so I'm suspecting that this is the reason why the pluggable database is not opening correctly.

any suggestion to solve this issue is appreciated.

Barbaros Özhan
  • 59,113
  • 10
  • 31
  • 55
user123
  • 387
  • 1
  • 4
  • 13
  • Hang in transaction will not cause this. By any chance you have the same user created in cdb ROOT and PDB? – bprasanna Apr 04 '18 at 07:32
  • @learningloop no it's only created in PDB. – user123 Apr 04 '18 at 11:57
  • These kind of errors requires the user to be dropped, and PDB to be reopened to resolve it. Any chance to use different username? – bprasanna Apr 05 '18 at 09:44
  • @learningloop the PDB contains two users . I dropped the one I'm suspecting to be the issue .Should I delete all the users in the PDB ? – user123 Apr 05 '18 at 17:48

0 Answers0