Connect Oracle Database 12c via SQL Developer when it is in restricted mode I would like to connect to database 12c via SQL Developer(in same VM where db is hosted) when it is in restrict mode. Tried below approaches but nothing worked.
Kindly help !


Added (UR=A) in tnsname.ora as below:
OBIEE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.37)(PORT = 1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.37)(PORT = 1521))
(CONNECT_DATA =
  (UR=A)
  (SERVER = DEDICATED)
  (SERVICE_NAME = OBIEE)
)
)
Also, defined this in sqlnet.ora:
tcp.validnode_checking = YES
tcp.invited_nodes = IP address


*Note: I am able to connect to it via cmd.
The above connection string should work with the addition of (UR=A). Seems like your SQL Developer connection is configured differently.

Alternatively, you can define the connection type as Advanced, and use the below custom JDBC url:

jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.37)(PORT = 1522)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.37)(PORT = 1521)) (CONNECT_DATA = (UR=A) (SERVER = DEDICATED) (SERVICE_NAME = OBIEE) ) )