SQL Developer Blocked and is not allowed to connect to database ORA-200001
867856Jun 9 2011 — edited Jun 21 2011SQL Developer Blocked and is not allowed to connect to database gives ORA-200001.
i found on net that DBA can write triggers which can deny connection to database from certain appplication.
so i want a way to change application name so that when it connects to database
the V$SESSION will have different value (other than SQL Developer) in column PROGRAM and/or MODULE (which i think is used by dba to restrict the connection).
one more way is
i am using jdbc url to connect to database
in java we can change properties of connection to change the PROGRAM in V$SESSION.
but i am not java expert so dont know how and where to make the changes
either way my aim is to connect to database such that V$SESSION will have different value (other than "SQL Developer") in column PROGRAM and/or MODULE