Skip to content

Instantly share code, notes, and snippets.

@souzagab

souzagab/Workaround TNS:Listener - Restricted mode Error

Created August 26, 2020 11:47
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save souzagab/cf41212177f8b9a3ed41d4eca71a6b09 to your computer and use it in GitHub Desktop.
Save souzagab/cf41212177f8b9a3ed41d4eca71a6b09 to your computer and use it in GitHub Desktop.
Download ZIP
Workaround to fix "ORA-12526, TNS:listener: all appropriate instances are in restricted mode."
Raw
Workaround TNS:Listener - Restricted mode Error
`ORA-12526, TNS:listener: all appropriate instances are in restricted mode.`
As a workaround, connect on the docker container
docker exec -it --user=oracle ${oracle_image_name} bash
and disable the restricted sessions setting
sqlplus /nolog
conn sys as sysdba
password: oracle
alter system disable restricted session;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment