Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Developer Blocked and is not allowed to connect to database ORA-200001

867856Jun 9 2011 — edited Jun 21 2011
SQL 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 19 2011
Added on Jun 9 2011
11 comments
2,318 views