Once you get into pluggable database territory, you might need to check your usage of “alter system enable restricted session”, because unless you’ve patched, there’s a little bug which lets you enable restricted session, but wont let you get out of it ! 🙂
SQL> alter session set container = pdb12; Session altered. SQL> alter system enable restricted session; System altered. SQL> select logins from v$instance; LOGINS ---------- RESTRICTED SQL> alter system disable restricted session; alter system disable restricted session * ERROR at line 1: ORA-65144: ALTER SYSTEM DISABLE RESTRICTED SESSION is not permitted
You can get out of the predicament, by force opening the pluggable database as shown below, but probably best to look at the latest 12c PSU, which contains a fix (unverified)
SQL> conn / as sysdba Connected. SQL> alter pluggable database pdb12 open force; Pluggable database altered. SQL> alter session set container = pdb12; Session altered. SQL> select logins from v$instance; LOGINS ---------- ALLOWED
podaaa etoke tetttaneeee
I have noticed you don’t monetize your page, don’t waste your traffic, you can earn additional cash every month because you’ve got high quality content.
If you want to know how to make extra bucks, search for: Boorfe’s tips best adsense alternative